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!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.