[jgommel]

I did a brand new installation, but I too received the database error that I was missing the mindesticgcms_game table. I checked the database and sure enough, that was the only table missing.

Database error in vBulletin 3.6.8:

Invalid SQL:


        SELECT COUNT(*) AS games
        FROM vb_mindesticgcms_game AS game
        WHERE 1=1;

MySQL Error  : Table 'neosmutc_neosmutdb.vb_mindesticgcms_game' doesn't exist
Error Number : 1146
Date         : Sunday, August 26th 2007 @ 04:11:08 PM
Script       : http://www.neosmut.com/vb/games.php
Referrer     : 
IP Address   : 76.188.204.236
Username     : RodentX
Classname    : vb_database

I ended up having to add the missing table and rows manually... so far so good.

$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game (
    gameid int(11) NOT NULL auto_increment,
    gamename varchar(255) NOT NULL default '',
    gameusername varchar(50) default NULL,
    gameuserid int(10) unsigned NOT NULL default '0',
    gamelastupdate int(10) unsigned NOT NULL default '0',
    gamedateline int(10) unsigned NOT NULL default '0',
    gamereleasedate int(10) unsigned NOT NULL default '0',
    gameplatformid smallint(5) unsigned NOT NULL default '0',
    gamevalid int(10) NOT NULL default '1',
    gameviews int(10 NOT NULL default '0',
    gamedescription text NOT NULL,
    gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gameeditusername VARCHAR( 50 ) DEFAULT '' NULL,
    gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
    gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gamegenreid smallint(5) unsigned NOT NULL default '0',
    gamemediumid smallint(5) unsigned NOT NULL default '0',
    gameorginid smallint(5) unsigned NOT NULL default '0',
    gameplayerid smallint(5) unsigned NOT NULL default '0',
    gamedeveloperid smallint(5) unsigned NOT NULL default '0',
    gamepublisherid smallint(5) unsigned NOT NULL default '0',
    gameesrbid smallint(5) unsigned NOT NULL default '0',
    gamemultiplayid smallint(5) unsigned NOT NULL default '0',
    PRIMARY KEY  (gameid)
) TYPE=MyISAM");