A friend of mine pointed out Prosper202 for managing all my affiliate marketing projects. So i decided to give it a shot. I started to install it on one of my shared HostGator accounts and ran into a couple problems.
First off was an issue with HostGator shared accounts not supporting SQL partitioning. Found this fix for the issue. Just download the file they provide and replace it with the file contained in the source of the latest version of Prosper.
Once this issue was fixed all seemed good, but it wasn’t. I am now unable to enter my API key for prosper tracking. I was getting a SQL error, concerning the users table. Ran these two queries in Mysql and everything is good.
ALTER TABLE `202_users` ADD `user_api_key` VARCHAR( 255 ) NOT NULL AFTER `user_pass_time` ;
ALTER TABLE `202_users` ADD `user_stats202_app_key` VARCHAR( 255 ) NOT NULL AFTER `user_api_key` ;
Have not ran into any other issues, but if I do I’ll be sure to post the fixes.
Edit: Ran into another problem when in the setup tab under tab #8 (Get Postback/Pixel). Looks like another table is missing some columns. Ran this SQL and fixed the issue.
ALTER TABLE 202_users_pref ADD COLUMN `user_tracking_domain` varchar(255) NOT NULL DEFAULT '';
- http://www.bluelayermedia.com/installing-prosper202-on-hostgator
- http://prosper.tracking202.com/apps/download/
- http://www.hostgator.com
Tags: affiliate marketing, host gator, ppc, prosper, Tutorials