C1b055d4a9ddeea4868eb1a7386e1e44cff4c255
By:
federiconicolas

Prosper 202 Install not working and getting an error

September 3, 2016 935 views
Nginx Ubuntu 16.04

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 'affcampaignrotate' 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!

Log In to Comment
3 Answers
ryanpq MOD September 9, 2016

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 affcampaignrotate 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.

Reply
Cardoza November 23, 2017

Here is the fix provided by Nana (Prosper202 Founder):
http://support.tracking202.com/disabling-strict-mode-for-mysql

Reply
Cardoza January 21, 2018
Reply
Have another answer? Share your knowledge.

Related Questions