I have this issue after getting all installed using HostGator… Table ‘nomonies_track.202_delayed_sqls’ doesn’t exist SELECT delayed_sql FROM 202_delayed_sqls WHERE delayed_time <=1263551760
Rating: +0
I typically see this on HostGator in one of two situations.
The first is you use the regular Prosper202 package for the install. There is a special Prosper202 package available just for HostGator installs. You can find it here:
Modded Prosper202 Install Package
If you use the above special Prosper202 package and my install video here:
You should be good to go. Now, if you have already installed Prosper202 with the regular package, you'll need to create a new database and do a fresh install using the special package.
The second situation I see this error is when you have already installed Prosper202 and you try to use the same database to do a new install or an install with the special package.
You'll definitely want to do a fresh install with a new database and using the special package, that should solve your problem.
Thanks,
Derek
Hello Derek,
I’m having this exact issue today and the link to the package no longer works. Can you help? This is setting me back big time.
Thanks,
H
Hey Hannibal,
Yeah, I’ve been getting quite a few comments about the site being down. I’m sorry about that. I just don’t want to take away from others hard work by putting a direct download link on my blog, but share it with my visitors and customers so that everybody wins.
I’ve setup a temp link to the download until their blog is working again.
Here it is:
Prosper202 Special Package – Temp Link
What I’ll do is try to get a hold of BlueLayerMedia and get permission to put a permanent link on my blog, giving them full credit of course and a link back to their blog as well.
It’ll save my visitors from having to jump around. I think that is still a win-win scenario, hopefully they will too.
Thanks for the comment, it’s really appreciated.
Derek
Thank u so much. I didn’t realise to delete the database and start again, which explains why the Blue Layer Media version would not work.
I had been trying to get it to work for hrs.
Thank u
Natasha
Hey Natasha,
You’re so welcome… I’m glad you got it fixed.
Thank you for the comment, it’s most appreciated.
Derek
Hi Derek.
Thanks so much for the help here. I was really struggling installing 202. had no clue that there was aspecial install for Hostgator.
Found this post through Google Search and have now booked marked as I’m sure I’ll be back for more help
Thanks again.
Ian.
Hey Ian,
You’re welcome… I’m glad you got it all fixed.
If you have any questions just ask…
Thank you for leaving a comment, I really appreciate it.
Derek
Hi Derek,
Thank you for being conscientious enough to simply not hosting our file without giving us any credit. You’re more than welcome to host the file here if you’d like, as long as you give some indication as to where it came from. We changed our format recently and moved our blog around. The file is hosted on our site, but again we don’t mind if you choose to host it here.
Thanks,
Jason Craig
BlueLayerMedia
Hey Jason,
Thanks for leaving a comment. I really appreciate it.
You’re very welcome… I believe in giving credit where credit is due. You did a great job finding a fix, you deserve total credit for it.
Thanks, I appreciate the fact that I can host the file here, but I don’t mind linking back to your site. I only put up a temporary link to help out my customers and Prosper202 customers looking for the solution. All the links are now back to your new blog pages.
It only took me a few minutes to find the new blog and change the links.
Thanks again,
Derek
Derek,
When I click on the link for the Complete Prosper202 Install Package it gives me a 404 page not found error. At any rate, I have my website on Hostgator that I want to track using various campaigns. Do I need to setup a throw away domain and place the Prosper202 install files in the root or a subdomain for this install. I don’t want to mess around with my website domain. I tried to install Prosper there but got messed up. I would like to keep my website and tracking in separate domains if at all possible. Thanks.
Don
Hey Don,
I’m sorry, they must have taken the page down. I have a modded version available for download. I’ll change the link over to it. It works on HostGator.
You can check it out here: http://www.ad-trackr.com/1068/prosper202-1-6-1-modded-version-download/
Prosper202 definitely needs to be installed in the root of a domain or you can install it in a subdomain. Either way, it needs to be in the root and run by itself.
I like to run a totally separate tracking domain where all my tracking scripts reside. Prosper202 runs in a couple of subdomain’s and all my others run in subdirectories with the root a blank index.php page.
You’ll want to delete and recreate your MySQL database before you install Prosper202 again. That way it’s a clean install.
Thanks for leaving a comment… I really appreciate it.
Derek