db error at step 5, upgrading 4.0.2 -> 4.0.8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cbiweb
    Senior Member
    • Apr 2004
    • 2658
    • 4.1.x

    [Forum] db error at step 5, upgrading 4.0.2 -> 4.0.8

    Step 5) Install/Upgrade Blog

    Installing product file...

    Code:
    Database error in vBulletin 4.0.8:
    
    Invalid SQL:
    
    	CREATE TABLE test_blog_sitemapconf(
    	name VARCHAR(50) NOT NULL,
    	value VARCHAR(100),
    	weight DECIMAL(5,3) NOT NULL DEFAULT 0,
    	UNIQUE KEY (name, value) );
    
    MySQL Error   : Table 'test_blog_sitemapconf' already exists
    Error Number  : 1050
    Request Date  : Saturday, October 23rd 2010 @ 10:14:15 AM
    Error Date    : Saturday, October 23rd 2010 @ 10:14:15 AM
    Script        : http://sitename.com/vbtest/install/finalupgrade.php?step=5
    Referrer      : http://sitename.com/vbtest/install/finalupgrade.php?step=4&startat=60
    IP Address    : xxx.xxx.xxx.xx
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.0.67-community
    ~ Life isn't always fair, but you can be. ~
  • cbiweb
    Senior Member
    • Apr 2004
    • 2658
    • 4.1.x

    #2
    Actually, nevermind. I'm starting over with it. It's a test board and I've been trying all week to get it running; multiple issues with FTP and vBulletin bugs.... I no longer have the time nor patience to wait for replies (no offense, just tired of delays). I cleared the db and will run the install script rather than upgrade, and re-style the board.....
    ~ Life isn't always fair, but you can be. ~

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎