ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: sarah2 on August 03, 2007, 07:22:33 am

Title: Error inserting example config data
Post by: sarah2 on August 03, 2007, 07:22:33 am

Hi,

I have just copied up ListMailPro to my webserver (IIS 6.0, PHP5, MYSQL 5.0.45-community-nt), and setup config.php.

Immediately after entering the password "install" for the first time, I get taken to the "editconf.php?doinst=1&doinstall=yes" page and present with this error message:

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

It is successfully creating the table lm_config however I get no more information. It is logging in as root.

Has anybody seen this problem before, or know what it might be?

Thanks

Title: Error inserting example config data
Post by: DW on August 06, 2007, 01:48:51 am

Hi Sarah,

Is it possible the MySQL user has permission to create tables but not insert rows?

I am willing to troubleshoot this. Please submit your information (http://listmailpro.com/support?t=other) along with a note about the problem (or a link to this post) if you continue to have troubles.

Regards

Title: Error inserting example config data
Post by: sarah2 on August 06, 2007, 06:33:14 am

The user account being used is root. I logged on as root and successfully inserted a test row from the console.

Title: Error inserting example config data
Post by: DW on August 06, 2007, 09:09:09 pm

Unfortunately it is very difficult for me to troubleshoot this without at least FTP and ListMail access.  Can you forward me your information via the tech support (http://listmailpro.com/support?t=other)?

Regards

Title: Error inserting example config data
Post by: sarah2 on August 07, 2007, 02:57:52 am

I did this shortly after posting this message.

Title: Error inserting example config data
Post by: DW on August 07, 2007, 08:04:36 am

I have added a line to admin.php to fix certain behaviour as per:
http://bugs.mysql.com/bug.php?id=18551

This line was added after the mysql_connect line in admin.php

Code: [Select]

mysql_query("set sql_mode = '';");
Please login with password "install" to start setting up.

Regards, DW