More.. and more errors...

[Mystislav]

Ok I've been on my vb installing hacks for a while. And I noticed a few things..

First of all, when I try to run my sql query I get this

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: Friday 12th of July 2002 08:03:44 AM
Script: http://66.192.45.86/~sjmadho/board/board/admin/query.php
Referer: http://www.sjmadhouse.net/board/admin/query.php


then when I try to ban people, it gives me a error and when I try to change ppls username it is a error.. what do I do?

[scsa20]

if you backed up your database before running that SQL query, then restore the back up copy...if not, try running the restore.php file (I think that's what it's called)...it's found in the extras folder.

[Mystislav]

Hmm, this ++++ is getting worse. Now when I click on a users name to look at their profile, it gives me a error.. theres tons of errors... check it urself http://sjmadhouse.net/board then go to general and click on a users name who started a thread... also my sql wont let me do ++++...what do I do? :(

[Mystislav]

Someone please help me, I'm getting errors everywhere, even when I try to change my avatar...