bots not setup ?

[eski2]

As far as i can tell, the bots should be working in my setup but if i type the example using #bot create help, i get #1054: unknown column 'LastZoneId' in 'field list'. Has anyone heard of this or have any suggestions as to what might fix it?

[eski2]

Is it a bug with MySQL perhaps?

[erde]

Not a bug ;) You have missed a SQL update 1039_botguilds.sql
with a little search http://www.eqemulator.net/forums/showthread.php?t=29886&highlight=LastZoneId

[eski2]

Ok, giving that a go? I'm using peqdb_rev1052.sql and when i read http://www.eqemulator.net/forums/showthread.php?p=182003#post182003 I thought i was supposed to use trunk\EQEmuServer\utils\sql\svn\bots.sql ... it can be quite confusing with all these different start guides!

Does this look like healthy output? I don't know if the warning message here is relevant. I swear I'll start to try digging through SQL tomorrow but it's been a tiring Xmas!

mysql> source 1039_botguilds.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

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

Query OK, 0 rows affected (0.00 sec)

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

Query OK, 0 rows affected (0.03 sec)

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

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

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

Query OK, 0 rows affected (0.02 sec)

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

Query OK, 0 rows affected (0.03 sec)

[erde]

Looks good. Should work now!

[eski2]

Seems fine although i noticed #bot group summon doesn't summon them to your position if they have gotten stuck somewhere, not sure if it's supposed to?