Results 1 to 6 of 6

Thread: Install Error...

  1. #1
    Junior Member
    Join Date
    Apr 2009
    Posts
    1

    Default Install Error...

    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..

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,467

    Default

    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.

  3. #3
    Junior Member
    Join Date
    May 2009
    Posts
    7

    Default

    still dosent work
    Last edited by Dark182; 05-26-2009 at 09:21 PM.

  4. #4
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,467

    Default

    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.

  5. #5
    Junior Member
    Join Date
    Nov 2008
    Posts
    2

    Default

    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.

  6. #6
    Junior Member
    Join Date
    Nov 2008
    Posts
    2

    Default

    Yay, that worked.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error on install
    By threat in forum Troubleshooting & Problems
    Replies: 3
    Last Post: 06-30-2008, 11:12 PM
  2. Install error
    By attroll in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-10-2005, 11:32 AM
  3. Error on install
    By RogueDOC in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 09-25-2005, 05:51 PM
  4. Install error
    By Spoky in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 08-01-2005, 02:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •