Step 3 vB_Database_Alter Error on 3.6.8 upgrade to 3.7.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MustangLisa
    Member
    • Apr 2004
    • 43

    Step 3 vB_Database_Alter Error on 3.6.8 upgrade to 3.7.1

    I am running vB 3.6.8 and trying to run the upgrade to 3.7.1 and getting the following error during Step 3 of the process ...

    Step 3) Misc Table Alterations
    • Altering forum Table (1 of 2)
    • Altering forum Table (2 of 2)
    • Altering tachyforumpost Table (1 of 1)
    • Altering rssfeed Table (1 of 1)vB_Database_Alter: fetch_table_info() has not been called successfully.



    I've tried refreshing and restarting the process and haven't been able to get past this step. Any help is greatly appreciated, thanks!
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    Run this query in phpmyadmin :

    Code:
    CREATE TABLE rssfeed (
        rssfeedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
        title VARCHAR(250) NOT NULL,
        url VARCHAR(250) NOT NULL,
        port SMALLINT UNSIGNED NOT NULL DEFAULT '80',
        ttl SMALLINT UNSIGNED NOT NULL DEFAULT '1500',
        maxresults SMALLINT NOT NULL DEFAULT '0',
        userid INT UNSIGNED NOT NULL,
        forumid SMALLINT UNSIGNED NOT NULL,
        iconid SMALLINT UNSIGNED NOT NULL,
        titletemplate MEDIUMTEXT NOT NULL,
        bodytemplate MEDIUMTEXT NOT NULL,
        searchwords MEDIUMTEXT NOT NULL,
        itemtype ENUM('thread','announcement') NOT NULL DEFAULT 'thread',
        threadactiondelay SMALLINT UNSIGNED NOT NULL,
        endannouncement INT UNSIGNED NOT NULL,
        options INT UNSIGNED NOT NULL,
        lastrun INT UNSIGNED NOT NULL,
        PRIMARY KEY  (rssfeedid),
        KEY lastrun (lastrun)
    );
    And if successful,

    then run the upgrade script again and see if it gets through this time.

    Because this error seems to occur when the rssfeed table doesn't exist.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...