ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: franklinfick on December 11, 2014, 07:09:07 am

Title: database install problem
Post by: franklinfick on December 11, 2014, 07:09:07 am

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

Title: Re: database install problem
Post by: DW on December 11, 2014, 12:01:41 pm

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

Title: Re: database install problem
Post by: franklinfick on December 13, 2014, 06:58:51 am

Quote from: DW on December 11, 2014, 12:01:41 pm

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

Title: Re: database install problem
Post by: DW on December 14, 2014, 06:43:25 pm

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

Title: Re: database install problem
Post by: franklinfick on December 16, 2014, 06:30:47 am

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