Home > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.) > Normal Prosper202

Prosper202 suddenly broken... (13)

11-30-2012 04:42 PM #1 dth2290 (Member)
Prosper202 suddenly broken...

My direct links through prosper take me to this error page:

Table '/domain_prosper/202_site_urls' is marked as crashed and should be repaired
INSERT INTO 202_site_urls SET site_domain_id='1', site_url_address="

My lander links through prosper seem to function, but don't register in prosper for tracking anymore.

No idea what caused it.
I've dug for an answer and tried a few things but am still stuck...

Anyone got any ideas?
Any help is greatly appreciated.

11-30-2012 05:16 PM #2 pancakes (Member)

I'm having Prosper issues too... But I think it's due to tracking202.com being down (but I'm using the self-hosted version). I can login to the dashboard just fine, but I can't access any of the internal dashboard links.

11-30-2012 08:11 PM #3 tical (Member)

you just need to repair the table,

load phpmyadmin, select your p202 database and click on the "SQL" tab and run the query:

REPAIR TABLE 202_site_urls;

that should fix it.

12-08-2012 05:51 PM #4 BeyondHosting-Tyler (Member)

Originally Posted by dth2290

This can be caused by a number of things, if your mysql config does not allow enough open files mysql can force close table files and mark the table failed, it can also be caused by a mysql software crash or improper mysql shut down.

A mysql repair of all databases is recommended.

Run this command from root ssh:

mysqlcheck --all-databases -B -e --auto-repair --optimize

You should run this every few weeks, or even weekly if you like. This is good practice and will keep your databases stable.

12-31-2012 04:38 AM #5 thatguy (Member)

My problem with Prosper - can track clicks not leads.

12-31-2012 03:06 PM #6 wdigital (Member)

Originally Posted by thatguy

My problem with Prosper - can track clicks not leads.

Tracks leads just fine, especially with postback URL. How do you mean?

01-01-2013 04:40 AM #7 thatguy (Member)

Originally Posted by wdigital

Tracks leads just fine, especially with postback URL. How do you mean?

Mine just tracking clicks not leads. Maybe I need to go through it again. Happy New Year!

01-01-2013 08:40 AM #8 wdigital (Member)

yeah, let us know if your stuck, prosper its usually pretty decent in my opinion.

01-01-2013 11:29 AM #9 thatguy (Member)

Originally Posted by wdigital

yeah, let us know if your stuck, prosper its usually pretty decent in my opinion.

Thanks man, is there any guide on setting up prosper202? Still getting clicks recorded not leads.

01-01-2013 01:26 PM #10 wdigital (Member)

If you look at the very bottom of your prosper install, there is a link called "documentation", check that out. But you can Google prosper and get a load of info.

If you are not getting leads recorded, can I check something, have you setup a postback or image pixel?

If not, hit the "Setup Tab", then "#8 Get Postback/Pixel" then read the info there.

You basically insert that code into your CPA network (assuming that is what your using).

Hit me up if you still need more info.

All the best.

01-02-2013 12:36 AM #11 thatguy (Member)

I guess that's the part I've missed. I did till step #7 and the link is a direct offer link.

Thanks a lot!

Originally Posted by wdigital

01-04-2013 09:22 AM #12 julien (Member)

Originally Posted by pancakes

Same here, it's impossible for me to work correctly...
Fortunately, Beyond Hosting's support is very good and they tried a couple of things, but my issue is still not fixed.

I just asked the support to have a look at Tyler's solution, I'll keep you updated.

01-04-2013 08:01 PM #13 BeyondHosting-Tyler (Member)

http://stmforum.com/forum/showthread...There-is-a-fix!

Whats the ticket ID ?

PM me or email me: tyler.bishop@beyondhosting.net

Home > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.) > Normal Prosper202