Hi guys… i´m trying to install Prosper 202 on Ubuntu 16.04 64 bits with ServerPilot.io… everything seems to be right but when i´m seting up my campaign (step 3) shows this error
INSERT INTO 202_aff_campaigns
SETaff_network_id
=‘1’, user_id
=‘1’, aff_campaign_name
=‘PeerFly’, aff_campaign_url
=‘http://trkur.com/207539/11823?s1=[[subid]]
‘, aff_campaign_url_2
=’’, aff_campaign_url_3
=‘’, aff_campaign_url_4
=‘’, aff_campaign_url_5
=‘’, aff_campaign_rotate
=‘’, aff_campaign_payout
=‘4’, aff_campaign_cloaking
=‘0’, aff_campaign_time
=‘1472842560’
Incorrect integer value: ‘’ for column ‘aff_campaign_rotate’ at row 1
By the way Prosper only allowed my to setup an only aff campaign url not 5 and not configured to rotate the urls… someone knows what i need to do? i hope so… thanks!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!
Effective tutorial to solve the problem: https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7.html
Here is the fix provided by Nana (Prosper202 Founder): http://support.tracking202.com/disabling-strict-mode-for-mysql
While this may not solve the problem itself it does look like the underlying issue in that MySQL query is this
aff_campaign_rotate=''
which is attempting to set aff_campaign_rotate to NULL. It appears that this field requires an integer (number) so it can likely be set to 0 but not to NULL.Prosper202 appears to be a paid product. Their own support would likely be best prepared to assist you in troubleshooting this issue. Unfortunately it does not appear that they provide a lot of documentation publicly that would assist in tracking down this issue.