Community Forum

If you have questions about my software, chances are this forum has the answers.

You'll need to register before you can post on the forum to ask your question or to answer another one. A reply will be posted to each and every question that is asked so there is no need to double post or bump your post. I do my best to answer promptly but in some cases it may take a day or two. If you bump your post, it may be removed. Bear with me and I`ll get your question answered quickly.

Here are a few tips to help you to get your questions answered more rapidly.

IMPORTANT: Posts in English only. I don't have a translator and I'll be unable to understand your message properly and will probably delete it.
SEARCH: Use the search option to see if your question has been answered on the forum before now or if there is an answer in the documentation of your software.
PERSONAL SUPPORT: If you have purchased a commercial version of any software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
LINKS: Any links posted are not clickable and must be copied / pasted into your browser address bar.

You are not logged in.

#1 samthewildone 20-04-2021 12:54:41

I get the following message when trying to install Maian Responder on a LAMP (Ubuntu) VPS on Vultr:

System Error
One or more database tables could not be installed. Enable error logging in "install/control/config.php" and run again. Check the error log in the "logs" folder.

Output of log

Script: Maian Responder
Script Version: 2.2
PHP Version: 7.3.27-9+ubuntu18.04.1+deb.sury.org+1
DB Version: 5.7.33-0ubuntu0.18.04.1
Server Software: Apache/2.4.29 (Ubuntu)
Platform: Other
=================================================================================
Table: mr_broadcasts
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'senddate'
On Line: 148
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_messages
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'rdate'
On Line: 319
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_msgcache
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'stopdate'
On Line: 344
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_broadcasts
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'senddate'
On Line: 148
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_messages
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'rdate'
On Line: 319
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_msgcache
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'stopdate'
On Line: 344
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_broadcasts
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'senddate'
On Line: 148
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_messages
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'rdate'
On Line: 319
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
Table: mr_msgcache
Operation: Create
Error Code: 1067
Error Msg: Invalid default value for 'stopdate'
On Line: 344
In File: /var/www/html/install/control/tables.php
- - - - - - - - - - - - - - - - - - - - - 
 

Any help would be greatly appreciated, I wanted to test this out sad

#2 msworld 20-04-2021 14:41:56

It's because your server is running MySQL in strict mode. The new version will fix this.

Open the 'control/classes/class.db.php' file and find the following around line 38:

db::db_query("SET `sql_mode` = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))");

Change to:

db::db_query("SET `sql_mode` = ''");

I think that should fix it.

#3 samthewildone 20-04-2021 15:20:40

Thank you!

That worked and I'm able to install/login to the admin panel.

Time for me to take a look smile

#4 msworld 20-04-2021 17:05:13

Cool, hope you like it. smile

Board footer

Maian Script World - Free PHP Software for Personal or Business Use.
© 2003-2021 Maian Script World & David Ian Bennett.

2Checkout.com is an authorized reseller of goods and services provided by Maian Script World

Free PHP Software / Responsive PHP Scripts / Lightweight PHP Software / White Label PHP Software