[mtha]

Originally Posted by ChrisBaktis

Tried and same error - I removed that line as you said and now get this error.

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE award (
              award_id smallint(5) unsigned NOT NULL auto_increment,
              award_cat_id smallint(5) NOT NULL default '1',
              award_name varchar(50) NOT NULL default '',
              award_desc varchar(250) NOT NULL default '',
              award_icon_url varchar(250) NOT NULL default '',
              award_img_url varchar(225) NOT NULL default '',
              award_displayorder smallint(5) NOT NULL default '0',
              PRIMARY KEY  (award_id)
            ) TYPE=MyISAM;
        
mysql error: You have an error in your SQL syntax near ';
        ' at line 10

mysql error number: 1064 


Not sure why im the only one getting this error.

Please try to execute the query in phpMyAdmin or in AdminCP

[sql]
CREATE TABLE award (
award_id smallint(5) unsigned NOT NULL auto_increment,
award_cat_id smallint(5) NOT NULL default '1',
award_name varchar(50) NOT NULL default '',
award_desc varchar(250) NOT NULL default '',
award_icon_url varchar(250) NOT NULL default '',
award_img_url varchar(225) NOT NULL default '',
award_displayorder smallint(5) NOT NULL default '0',
PRIMARY KEY (award_id)
) TYPE=MyISAM;
[/sql]

there's a list of SQL queries in my "Notes.txt", could you try that manually, and see if you can do it.
BTW, do you have the right to CREATE TABLE in the database?