Adding follow ups fails # 1

[vrinfo]

Trying to add follow ups fails with incorrect integer value for active...

Searching the code reveals that the $ftable ( lm_follow ) has the column defined as active tinyint(1) NOT NULL,

but the code in addfup has "insert into $ftable... with a blank value for active.

I have put a value of 1 in as I can't see anywhere that active is actually referred to... can you confirm whether this is a bug ?

[vrinfo]

Having worked around the problem with the active field; the logic then failed as it had no value for sset !

I inserted code to set this to 1 - presuming that if no sets existed the first set would be number 1..

I am starting to wonder whether regression tests from a clean install were carried out for this release... as these errors have nothing to do with platform etc.

[DW]

Greetings,

The "active" field for followups is not currently in use.

The auto-increment insert problem is a rare one dealing with servers that do not have a certain setting.

Please visit the following URL for a fix:
http://listmailpro.com/forum/index.php?topic=2140.0

I believe I have located some details about the server configuration option in question.  It's not a bug, but appears in a MySQL bug report:
http://bugs.mysql.com/bug.php?id=17660

From that post it seems a simple:

Code: [Select]

mysql_query("set sql_mode= '';");
After the initial database connection in admin.php could solve this script-wide.

Regards