Prosper 202 Install not working and getting an error

Posted September 3, 2016 3.6k views
NginxUbuntu 16.04

Hi guys.. i´m trying to install Prosper 202 on Ubuntu 16.04 64 bits with… 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=’[[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!

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.

Submit an Answer
3 answers

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.