Author Topic: Error inserting example config data (Read 2423 times)

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

DW · « **Reply #1 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 along with a note about the problem (or a link to this post) if you continue to have troubles.

Regards

sarah2 · « **Reply #2 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.

DW · « **Reply #3 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?

Regards

sarah2 · « **Reply #4 on:** August 07, 2007, 02:57:52 am »

I did this shortly after posting this message.

DW · « **Reply #5 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