Install Error...

[DanielN24]

Database error The Total Sports Heaven database has encountered a problem. Please try the following:

• Load the page again by clicking the Refresh button in your web browser.
• Open the tsh.com home page, then try to open another page.
• Click the Back button to try another link.

The totalsportsheaven.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.8.2:

Invalid SQL:

CREATE TABLE adv_pages_user (
pageid int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
layout text NOT NULL,
UNIQUE KEY pageid (pageid,userid)
) TYPE=MyISAM;

MySQL Error : Table 'adv_pages_user' already exists
Error Number : 1050
Request Date : Sunday, May 24th 2009 @ 04:21:53 PM
Error Date : Sunday, May 24th 2009 @ 04:21:53 PM

Everything was fine until I tried to upgrade to the next version, then I uninstalled and installed, then re-installed like 10 times but I kept getting the same error..

[Brian]

The 'adv_pages_user' table was accidentally left out of the uninstall part, so that's what's creating the error. You can correct that by either downloading the files from here again and updating the admincp/vbacmps_install.php file on your server, or you can drop that table manually using phpMyAdmin and then re-install.

[Dark182]

still dosent work

[Brian]

The query to remove the table is definitely in the install file now. If it's not working the only thing I can suggest would be to delete the current admincp/vbacmps_install.php file from your server and then re-upload the new version you just downloaded.

[saudades]

I am having the same trouble trying to upgrade from 3.0.1 to 3.2.2. I've uploaded everything, but the admincp still shows version as being 3.0.1. When I try to upgrade, it gives me that same error. I will try dropping that table to see if that works.

[saudades]

Yay, that worked.

[sugerlove]

Thank you