some issue about load_bots.sql
 

I met some issue when I setup EQEmulator. Could anyone help me?

1. There were some errors during sourcing load_bots.sql. I reviewed the scripts and found a line:

INSERT INTO `commands` VALUES ('bot', '0');

but there was no table named commands in database (source by "peqbeta.sql" downloaded on 17 june).


2.about character_ table
There were some lines about a "character_", but it was exist in database.
such as

DROP FUNCTION IF EXISTS `GetMobType` $$
CREATE FUNCTION `GetMobType` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
DECLARE Result CHAR(1);

SET Result = NULL;

IF (select count(*) from character_ where name = mobname) > 0 THEN
SET Result = 'C';
ELSEIF (select count(*) from bots where Name = mobname) > 0 THEN
SET Result = 'B';
END IF;

RETURN Result;
END $$

3. The EQEmulator ran, but quests did not. I can not start any quest, and NPC can not reply my 'Hail'. I had tried to update exe files, quests files, plugins by "eqemu_server.pl", but it still did not worked.

I hope you ended up resolving this. Sorry, I hate seeing posts without responses :)

If you are still having trouble you would be better served by posting in the appropriate forum. ie. Linux or Windows, etc. I recently ran into some issues setting up a new server myself, and found it best to go back through each step one by one. Also, don't bother setting up bots until you are 100% certain the basic server is working properly. Once you start going beyond what is broken and try to power through it, it can get real muddy ;)

Yes, I should post issues in "Windows Servers". Thank you for your advice.
When I configured my first eqemu on my windows desktop, I met some problems. Then I tried to install it on a ubuntu vm, and I was successful. Now the linux eqemu runs almost perfectly.