database install problem

[franklinfick]

installing on a new server and am running into a problem with the database

on a new install I get this error message:

Creating config database table lm_config - Inserting example config data.
**Error inserting example config data.


and when trying a different way--
uninstalled the database and imported the the tables from my old install
I could see all the data in listmail
but I could not add any lists, users, etc
and was getting an error message:

admin-42-You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',, from lm_lists where listnum = ''' at line 1




thanks
Franklin

[DW]

Hi Franklin,

Your server may have a special MySQL configuration that isn't compatible with LMP. For me to assist further please submit your hosting information at http://listmailpro.com/support under the type Other/Bug Investigation.

Regards

[franklinfick]

Hi Franklin,

Your server may have a special MySQL configuration that isn't compatible with LMP. For me to assist further please submit your hosting information at http://listmailpro.com/support under the type Other/Bug Investigation.

Regards

thanks

[DW]

Hi Franklin,

It appears your server has some strict MySQL modes enabled that can interfere with certain LMP database insertions. I added the following near the bottom of admin.php after the database connection is established to clear the modes:

Code: [Select]

mysql_query("SET SESSION sql_mode=''");
Please let me know if you continue to have troubles.

Regards

[franklinfick]

Big thanks to Dean

I had to move my install..  again..
this is the 3rd server I have had my LMP installed at
the first 2 servers gave me no problem..

but this 3rd..  had a small issue


thanks for helping me fix it

everything is running great now


Franklin