Database errors FROM vb3_infractionban

[Webber]

I am getting this database error after upgrading to 3.6.2 and can't seem to overcome it:

Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT *
FROM vb3_infractionban
ORDER BY method, amount ASC;
MySQL Error : Incorrect information in file: '****/vb3_infractionban.frm'
Error Number : 1033
Date : Tuesday, October 10th 2006 @ 05:25:23 PM
Script : http://**********/admininfraction.php?do=modify
Referrer : http://*********/admin/index.php?do=nav
IP Address : ********
Username : *****
Classname : vB_Database

I have uploaded clean copies of the vb 3.6.2; completed repair and optimize through vb AND through phpmyadmin but I can't get this fixed.

It eventually crashes my mySQL server.

I am running Windows 2003 Server.

Any ideas on how to fix this would be greatly appreciated.

[Steve Machol]

I'm afraid the only way I know to fix this is to delete that table and recreate it. To do that, run these queries.

1. DROP TABLE infractionban;

2. CREATE TABLE infractionban (
infractionbanid int unsigned NOT NULL auto_increment,
usergroupid int NOT NULL DEFAULT '0',
banusergroupid int unsigned NOT NULL DEFAULT '0',
amount int unsigned NOT NULL DEFAULT '0',
period char(5) NOT NULL DEFAULT '',
method enum('points','infractions') NOT NULL default 'infractions',
PRIMARY KEY (infractionbanid),
KEY usergroupid (usergroupid)
);

[Webber]

Thanks Steve I will try this. Ok I completed the queries:

I succesfully dropped the table and created it again with the above queries but I still have the same exact error.

I did notice that the ext was .frm does that matter with the above queries?

Any other suggestions on how to fix this db error?

Thanks in advance.

[Steve Machol]

Honestly the only thing I can think of is that your server is messing upo that file. A new table should not have that problem.

I'll ask the Devs if they have any ideas.

[Steve Machol]

My fault. I forgot to add your table prefix. Run these queries:

1. DROP TABLE vb3_infractionban;

2. CREATE TABLE vb3_infractionban (
infractionbanid int unsigned NOT NULL auto_increment,
usergroupid int NOT NULL DEFAULT '0',
banusergroupid int unsigned NOT NULL DEFAULT '0',
amount int unsigned NOT NULL DEFAULT '0',
period char(5) NOT NULL DEFAULT '',
method enum('points','infractions') NOT NULL default 'infractions',
PRIMARY KEY (infractionbanid),
KEY usergroupid (usergroupid)
);

[Webber]

Awesome, thanks Steve --- that worked like a charm.