EQEmulator Forums - proble with bot creation and other newbie server running woes

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - proble with bot creation and other newbie server running woes (https://www.eqemulator.org/forums/showthread.php?t=30163)

proble with bot creation and other newbie server running woes

I've followed the guide at http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5 and so far have had a few problems

1) it would work not with perl 5.10 so i had to find 5.8, error kept coming up about "perl58.dll" not found maybe i have the wrong version of something? was using Activestate 5.10 perl.

2) I couldn't get the CVS thingie working which was frustrating as i used to be able to use it many years ago. I was using http://eqemulator.net/forums/showthread.php?t=23536
and getting cvs checkout: warning: unrecognized response `'ssh' is not recognized as an internal or external command,
' from cvs server
cvs checkout: warning: unrecognized response `operable program or batch file.
' from cvs server
cvs [checkout aborted]: end of file from server (consult above messages if any)

Is that guide outdated? Should i start again with the guide from the forums? (*shudder*) Took me hours so far but i have a char standing in the newbie zone (woohoo!) and i am scared to go back and try again in case i can't even get that

3) I thought i sourced the bot file correctly but i get #1054: Unknown column 'LastZoneId' in 'field list' when i use #bot help create to get the sample of "#bot create Jesuschrist 9 6 male" (i have no idea if that's blasphemous for christians but i'd change that sample name if i know how, don't want to get a jihad out agin me.)

4) (phew, lotta questions) can i safely update things without wiping out characters?

If anyone can answer any of these, i'd gladly appreciate it! I'll try the new guide i saw in these forums and risk wiping the one char i have (oh nose!) but i hope someone else isn't annoyed with me if they've created a char there. 8)

I tried the bot sourcing again just in case:

Code:

C:\Program Files\MySQL\MySQL Server 5.1\bin\projecteqdb\peqdatabase>mysql -u roo

t -p

Enter password: *******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 19

Server version: 5.1.41-community MySQL Community Server (GPL)



Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



mysql> \u PEQ

Database changed

mysql> source load_bots.sql;

Query OK, 0 rows affected (0.00 sec)



Query OK, 0 rows affected (0.00 sec)



Query OK, 0 rows affected (0.00 sec)



Query OK, 0 rows affected (0.02 sec)



Query OK, 0 rows affected (0.01 sec)



Query OK, 0 rows affected (0.02 sec)



Query OK, 0 rows affected (0.02 sec)



Query OK, 0 rows affected (0.03 sec)



Query OK, 0 rows affected (0.00 sec)



Query OK, 0 rows affected (0.06 sec)



Query OK, 0 rows affected (0.11 sec)



Query OK, 0 rows affected (0.09 sec)



Query OK, 0 rows affected, 1 warning (0.00 sec)



Query OK, 0 rows affected, 1 warning (0.00 sec)



Query OK, 0 rows affected, 1 warning (0.00 sec)



Query OK, 0 rows affected (0.09 sec)

Rows matched: 1  Changed: 0  Warnings: 0



Query OK, 0 rows affected (0.14 sec)

Rows matched: 1  Changed: 0  Warnings: 0



ERROR 1062 (23000): Duplicate entry '1-Bots:BotManaRegen' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:BotFinishBuffing' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:CreateBotCount' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:SpawnBotCount' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:BotQuest' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:BotGroupBuffing' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry '1-Bots:BotSpellQuest' for key 'PRIMARY'

ERROR 1062 (23000): Duplicate entry 'bot' for key 'PRIMARY'

ERROR 1050 (42S01): Table 'bots' already exists

Query OK, 0 rows affected (0.03 sec)

Records: 0  Duplicates: 0  Warnings: 0



ERROR 1091 (42000): Can't DROP 'PRIMARY'; check that column/key exists

Query OK, 0 rows affected, 1 warning (0.00 sec)



ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'IF NO

T EXISTS `vwGuildMembers` AS

  select 'C' as mobtype,

cm.char_id,

cm.guild_' at line 1

Query OK, 0 rows affected, 1 warning (0.00 sec)



ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'IF NO

T EXISTS `vwBotCharacterMobs` AS

  select 'C' as mobtype,

c.id,

c.name,

c.c' at line 1

mysql>

Does this mean that Bots should work? Do i need to change some flag?