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

sarah2

  • Posts: 4
    • View Profile
Error inserting example config data
« 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

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error inserting example config data
« 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

sarah2

  • Posts: 4
    • View Profile
Error inserting example config data
« 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

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error inserting example config data
« 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

sarah2

  • Posts: 4
    • View Profile
Error inserting example config data
« Reply #4 on: August 07, 2007, 02:57:52 am »
I did this shortly after posting this message.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Error inserting example config data
« 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting