[cgfuse]

Originally Posted by 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");

I get the same problem as you, and i tried your fix and this is what it says.

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 4
STR: ->
SQL: $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")


SQL query:

$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")

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_gam' at line 1

I dont know if im doing it wrong or not, any help is greatly appreciated