I got this error while installing....
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
CREATE TABLE `sf_rpg_monster_battles`
(
`monsterbattleid` int(10) UNSIGNED NOT NULL auto_increment,
`owner` int(10) UNSIGNED NOT NULL DEFAULT '0',
`opponent` int(10) UNSIGNED NOT NULL DEFAULT '0',
`battlestate` int(10) UNSIGNED NOT NULL DEFAULT '0',
`turnid` int(10) NOT NULL DEFAULT '0',
`lastactive` int(10) UNSIGNED NOT NULL DEFAULT '0',
`wager` int(10) UNSIGNED NOT NULL DEFAULT '0',
`winnerid` int(10) UNSIGNED NOT NULL DEFAULT '0',
`winstatus` int(10) UNSIGNED NOT NULL DEFAULT '0',
`sceneid` int(10) UNSIGNED NOT NULL DEFAULT '0',
`shield` int(10) UNSIGNED NOT NULL DEFAULT '0',
`midi` int(10) NOT NULL DEFAULT '-1',
`battlelost` int(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`battleid`)
) TYPE=InnoDB;
MySQL Error : Key column 'battleid' doesn't exist in table
Error Number : 1072
Date : Friday, March 24th 2006 @ 03:04:05 PM
Script : http://***.******.***/installer/index.php
Referrer : http://***.******.***/installer/index.php
IP Address : **.**.***.***
Username : Replicators
Classname : vb_database