TV202 Prosper202 Tracking202 Export202 WorldProxy202 Meetup202 | Blog Forum Newsletter Twitter | Advertise
Login · Register
Home About Docs Scripts Blog Forums Hosting Donate Download
Before Posting, Have You Read the FAQ? And Have You Searched? If Not Please Do!

offers202 not working in p202?

Post new topic Reply to topic Prosper202 Forum Index » Offers202 Support
New Posts Search Forum
Author Message
michaelhimself


Joined: Aug 19th, 2009
Posts: 2

Post Posted: Sep 5th, 2009 at 7:12pm Post subject: offers202 not working in p202? Reply with quote

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!

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 4343

Post Posted: Sep 11th, 2009 at 7:56pm Post subject: Re: offers202 not working in p202? Reply with quote

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.

Back to top
michaelhimself


Joined: Aug 19th, 2009
Posts: 2

Post Posted: Sep 11th, 2009 at 8:53pm Post subject: Re: offers202 not working in p202? Reply with quote

T202Wes wrote:
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!

Back to top
christianfox


Joined: Dec 30th, 2009
Posts: 8

Post Posted: Jan 14th, 2010 at 8:48pm Post subject: Re: offers202 not working in p202? Reply with quote

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

Using HG BTW

Back to top
Post new topic Reply to topic Page 1 of 1

Creative Commons License This work (Prosper202, Tracking202 and Export202) is licensed under a
Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.