botinventory error

[Expletus]

receiving the following error.

KEY FK_botinventory_1 (BotID),
CONSTRAINT FK_botinventory_1 FOREIGN KEY (BotID) REFERENCES bots (BotID)
) ENGINE=InnoDB;

I've tried to drop the table, re-download the whole sql's and followed several other search threads on the forum. No matter what I do, I can't get past it not creating the botinventory table.

[joligario]

That doesn't look like an error. That looks like partial sql.

[Expletus]

[Err] 1005 - Can't create table '.\peq\botinventory.frm' (errno: 121)
[Err] CREATE TABLE IF NOT EXISTS botinventory (
BotInventoryID integer unsigned NOT NULL auto_increment,
BotID integer unsigned NOT NULL DEFAULT '0',
SlotID integer signed NOT NULL DEFAULT '0',
ItemID integer unsigned NOT NULL DEFAULT '0',
charges tinyint(3) unsigned DEFAULT 0,
color integer unsigned NOT NULL DEFAULT 0,
augslot1 mediumint(7) unsigned NOT NULL DEFAULT 0,
augslot2 mediumint(7) unsigned NOT NULL DEFAULT 0,
augslot3 mediumint(7) unsigned NOT NULL DEFAULT 0,
augslot4 mediumint(7) unsigned NOT NULL DEFAULT 0,
augslot5 mediumint(7) unsigned DEFAULT 0,
instnodrop tinyint(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (BotInventoryID),
KEY FK_botinventory_1 (BotID),
CONSTRAINT FK_botinventory_1 FOREIGN KEY (BotID) REFERENCES bots (BotID)
) ENGINE=InnoDB;
[Msg] Finished - Unsuccessfully
--------------------------------------------------


Sorry this is the navicat error.

[joligario]

Table 'bots' created ok?

[Expletus]

Yea, in the command prompt the only thing that won't create is the botinventory table. In game I can summon bots and everything, they just won't equip items or respond to #bot inventory list. Says bot.inventory table not created or something.

[joligario]

That's a duplicate key error message. It could have been left over in the innodb entries from a previous drop command. Did you previously have the regular database and just modify it with the bots sql?

[Expletus]

Not sure what you mean. It was from a fresh bot server install. Sourced everything in and ran all the update sqls. Everything w/the bot works except the inventory table.

[Expletus]

Still having this issue...

[Expletus]

ERROR 1005 (HY000): Can't create table '.\peq\botinventory.frm (errno:121)

[HimoShifu]

I'm looking for a fix on this myself.

[Congdar]

i just followed these steps and everything sourced in without errors. this will get you a fresh install, but you will lose anything you already have.

from the database svn, download everything. http://projecteqdb.googlecode.com/svn/trunk
go to the peqdatabase folder where you downloaded everything to on your system
extract peqdb_rev2022.sql from peqdb_rev2022.sql.gz
open a command window in the peqdatabase folder
mysql -u root -p
drop schema peq;
create database peq;
\u peq
source peqdb_rev2022.sql;
source load_player.sql;
source load_bots.sql;

[Expletus]

All I know is I swapped some lines in the load_bots.sql and got the error on bot guilds part instead of the inventory. Something along the 3rd or 4th line of that doesn't wanna play nice. Bots work fine now, just can't join a guild. 8)

[Congdar]

All I know is I swapped some lines in the load_bots.sql
so don't do that.

[Expletus]

That is the only way I could get the botinventory table to be created. Where the botinventory is in the load_bots.sql, i just swapped that w/the guild portion and the guild portion now has the error from above.

I can live w/out the bot in a guild, the inventory would be bleh.

[lerxst2112]

If you started from scratch and created the database by sourcing peqdb_rev2022.sql, then load_player.sql, then load_bots.sql you should not be receiving an error. I just tested it again, and if you do the steps in that order it works.

[Congdar]

if you are following the steps to create a fresh db and still getting errors, my guess is that you don't have a clean download from the database svn. delete that and get a clean download. maybe one of the bot sql files in the player_tables folder is corrupted from a previous download.

[Expletus]

More than likely that is the problem. Everything else works except that.. oh well.

[lerxst2112]

Also, check your MySQL settings. This guide has details for the options you should choose in the detailed setup wizard.

http://www.eqemulator.org/forums/showthread.php?t=31783