proble with bot creation and other newbie server running woes

[eski2]

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.

[eski2]

I tried the bot sourcing again just in case:

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?