1. make sure you installed InnoDB using your perl client
2. double check your database table's
I)Database changes
-- Table "botinventory" DDL
CREATE TABLE `botinventory` (
`npctypeid` int(11) NOT NULL default '0',
`botslotid` int(11) default NULL,
`itemid` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Table "botleader" DDL
CREATE TABLE `botleader` (
`botid` int(11) NOT NULL default '0',
`leaderid` int(11) default NULL,
PRIMARY KEY (`botid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-----> Table "botsowners" DDL <-------- double check this one and the one below
CREATE TABLE `botsowners` (
`botnpctypeid` int(11) NOT NULL default '0',
`botleadercharacterid` int(11) NOT NULL default '0',
PRIMARY KEY (`botnpctypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--- The table npc_types must have a new field:
ALTER TABLE npc_types add `isbot` tinyint(4) NOT NULL;
|