**Error inserting example config data.

[chrisingram]

**Error inserting example config data.

Has anyone seen this error before on typing "install" as the password when first installing listmail?

I have the latest version of mysql and running in isapi on iis... windows server 2003 sbs.

I would be interested in your findings!

Thanks...

[DW]

Greetings,

I would be willing to investigate this so you can start using ListMail ASAP.  You can securely submit your info here.  Please include a link back to this post along with your request.

Regards

[chrisingram]

Done,

Let me know if you find anything... i'll continue on in the meantime...

Thanks in advance!!

[DW]

This appeared to be due to a rare problem on some server configurations. I had to add the following near the bottom of admin.php after the MySQL connection:

Code: [Select]

mysql_query("SET sql_mode = '';",$link);
Once I added that the installation process was able to continue. I expect to add this line to a future update.

Regards

[chrisingram]

Hi,

Looks like that may* of sort-of solved the issue, however after restalling the applications on the live server i have run into the same issues as above, except after applying the same solution it seems i have run into yet more issues, as i am unable to login...

It at first, allows me to configure the initial options after which chucks me out of listmail back to the login page where i am unable to log back in... and without the fix i get the ****error...

Any further idea's DW?

Thanks

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PS, i wasn't sure if you would spot this so i started a new thread here:
http://listmailpro.com/forum/index.php?topic=2204.0

[DW]

There may be an issue clearing the cookies in which case you need to login again.  If the password is still blank, try "install".

Regards

[dave.graham]

Please could you help me, i have the exact same problem

**Error inserting example config data, please you could help us as we are trying to do a mailshot this weekend

Cheers

Craig

craig.dean@j-media.com

[DW]

Craig, Did you try the suggestion further up in the post, here?

Regards

[dave.graham]

Hi,

Before we enetered the code mentioned in the above thread it created the first table then it errored when it tried to insert data into that table.  After inserting the recommended code all the tables seemed to be propergated with the data, but then when we tried to relog in we get the error: Error in my_thread_global_end(): 1 threads didn't exit

Thanks

Craig

[scott.naylor]

Hi

I also have this problem.

I am running Listmail on a Windows 2003 server with IIS6.

I created a blank database in mysql, and then logged into listmail using the "install" password. It attempted to create the tables, however errored with this:

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

I added the recommended line to admin.php which did allow it to create the tables, however now I can't log in?? It accepts the password "install" as valid, but continues to ask for it.

I have also cleared all cookies as suggested above, but still the problem persists.

Please help!!

[DW]

Another thing to try is to search for "function getdomain" in admin.php and try changing "SERVER_NAME" to "HTTP_HOST".

Regards

[scott.naylor]

that hasn't made any difference at all I'm afraid.

[DW]

Please submit a request for an investigation here.  Please include a link back to your post.

Regards

[scott.naylor]

Hi Dean

I've submitted a support request, and also emailed, but have had no response. This really has become quite urgent to resolve. Could you advise please.

[DW]

This has been fixed.  Every instance of the PHP setcookie() function in login.php had to be shortened to it's first three parameters.  This is because you are hosting ListMail locally, without using a true domain name, which ListMail expects.  Regards, DW