Author Topic: Server Migration  (Read 7737 times)

mike_mac

  • Posts: 17
    • View Profile
Server Migration
« on: November 23, 2016, 03:17:18 am »
Hi

My server has recently migrated and this has thrown up several issues;

Message content not loading - to which i found the PHP htmlspecialchars function fix and it seems to have worked
New messages not saving
New links not saving
New follow ups not saved
New hits not registering

So it seems Listmail can not now add new records to the DB, although I can edit existing messages links etc.

thanks

Mike

mike_mac

  • Posts: 17
    • View Profile
Re: Server Migration
« Reply #1 on: November 23, 2016, 03:26:38 am »
Cannot send message either, "Incorrect integer value: '' for column 'id' at row 1"

mike_mac

  • Posts: 17
    • View Profile
Re: Server Migration
« Reply #2 on: November 23, 2016, 04:40:15 am »
everything seems to give the same error (this while trying to manually run dailymail:
Incorrect integer value: '' for column 'id' at row 1

mike_mac

  • Posts: 17
    • View Profile
Re: Server Migration
« Reply #3 on: November 23, 2016, 08:58:28 am »
isp support have now resolved the issue, this was their reply for reference:

This is an sql-mode issue, the mode defines what SQL syntax should be supported and what kind of data validation should be performed. In this situation, what is happening is that the script is attempting to insert or update a row with the integer entry taking on either the default value (e.g., of 0 or NULL) or the next AUTO_INCREMENT value.
But MySQL is not interpreting this action as valid due to its SQL_MODE being in STRICT mode, so we have disabled it and restarted the MySQL service.

they also rolled it back to MySQL 5.55 (from 5.6)