Prosper 202 Install not working and getting an error

September 3, 2016 275 views
Nginx Ubuntu 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!

1 Answer

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.

Have another answer? Share your knowledge.