when I use offers202 at the tracking202.com site it works properly - however when I want to use it with the selfhosted p202 it doesn't seem to work:

When I copy&paste the Tracking202 API Key below "My Tracking202 Developer Keys" I get the following error:

-

Unknown column 'user_api_key' in 'field list'

UPDATE `202_users` SET `user_api_key`='{myAPI}' WHERE `user_id`='1'

-

Is offers202 supposed to work with prosper202 and if so how can I fix it? I'm considering buying stats202 but this has to work properly first..

thanks!

for some reason your upgrade did not work correctly.

Run this query in your mysql database

1) open up phpmyadmin

2) click on your prosper202 database

3) hit the SQL button, and in the textarea type this query: ALTER TABLE `202_users` ADD `user_api_key` VARCHAR( 255 ) NOT NULL AFTER `user_pass_time` ;

4) After you do that query, run this one too: ALTER TABLE `202_users` ADD `user_stats202_app_key` VARCHAR( 255 ) NOT NULL AFTER `user_api_key` ;

5) see if you can insert your api key now.

thank you Wes - it works!

I had the same problem. Glad I found this straight away.

Using HG BTW