ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: vrinfo on January 30, 2008, 08:35:57 am

Title: Adding follow ups fails # 1
Post by: vrinfo on January 30, 2008, 08:35:57 am

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 ?

Title: Another field with no default
Post by: vrinfo on January 30, 2008, 08:38:37 am

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.

Title: Adding follow ups fails # 1
Post by: DW on February 05, 2008, 03:07:40 am

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