By default, MySql 5.6 and higher ships with strict mode turned on. Unfortunately this causes problems for Prosper202.

You may see error messages such as the following:

Incorrect integer value: '' for column 'aff_campaign_rotate' at row 1

To disable strict mode open up you "my.cnf" file and serach for the line that starts with "sql-mode"

#Set the SQL mode to strict

Change it to

#Disable Strict Mode 

Once you've saved and closed the file, you can restart the MySQL service.

Here are commands to try

systemctl restart mysql (Centos/Redhat)
service mysqld restart (Centos/Redhat)
/etc/init.d/mysql restart (Debian/Ubunto)

After this, the error should be gone

Did this answer your question?