EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   bots not setup ? (https://www.eqemulator.org/forums/showthread.php?t=30173)

eski2 12-27-2009 01:43 AM

bots not setup ?
 
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 12-27-2009 01:44 AM

Is it a bug with MySQL perhaps?

erde 12-27-2009 06:23 AM

Not a bug ;) You have missed a SQL update 1039_botguilds.sql
with a little search http://www.eqemulator.net/forums/sho...ght=LastZoneId

eski2 12-27-2009 07:35 AM

Ok, giving that a go? I'm using peqdb_rev1052.sql and when i read http://www.eqemulator.net/forums/sho...003#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!

Code:

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 12-27-2009 07:55 AM

Looks good. Should work now!

eski2 12-27-2009 09:51 AM

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?


All times are GMT -4. The time now is 02:25 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.