When I run the Queries this is the error message I get..
----
Database error in vBulletin Control Panel 2.2.6:
Invalid SQL: CREATE TABLE user_rate (
userrateid int(10) unsigned NOT NULL auto_increment,
rateduser int(10) unsigned DEFAULT '0' NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
userrating smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD ratetotal SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD allowrate SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL;
mysql error: You have an error in your SQL syntax near ';
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALT' at line 8
mysql error number: 1064
Date: Monday 15th of July 2002 02:20:09 PM
Script:
http://66.192.45.86/~sjmadho/board/b...dmin/query.php
Referer:
http://www.sjmadhouse.net/board/admin/query.php
------
Can someone help me out