|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum) |
|
|
|
10-05-2014, 10:38 AM
|
Fire Beetle
|
|
Join Date: Nov 2009
Location: Belgium
Posts: 2
|
|
Load_bots.sql error - Database Conversion
Hi,
Since the database conversion sourcing load_bots.sql gives the following error:
Code:
mysql> source load_bots.sql;
Query OK, 0 rows affected (0.05 sec)
Query OK, 2 rows affected (0.02 sec)
Rows matched: 2 Changed: 2 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 7 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.06 sec)
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)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1146 (42S02): Table 'peq.character_' doesn't exist
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.06 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.13 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
ERROR 1146 (42S02): Table 'peq.character_' doesn't exist
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.04 sec)
Query OK, 0 rows affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1146 (42S02): Table 'peq.character_' doesn't exist
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected (0.05 sec)
When trying to create a bot this results in the following error message: "Name is already in use" and no data is added in the bot table in the database.
I tried changing "character" to "character_data" in the sql file to follow the new database folders but this led to some different errors (I didn't think it would have been that easy but tried anyway just to see the result)
Code:
mysql> source load_bots.sql;
Query OK, 0 rows affected (0.03 sec)
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2 Changed: 2 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 7 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.05 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)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1054 (42S22): Unknown column 'c.timelaston' in 'field list'
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.02 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (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, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.05 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.03 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.06 sec)
Could anyone look into updating the load_bots.sql to make it with the new layout or lacking that where would I find older source code that doesn't use the new system yet ? I looked in old threads but couldn't find a version anymore.
Thanks in advance!
Kind regards,
Ian
|
|
|
|
10-05-2014, 03:25 PM
|
|
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
|
10-06-2014, 01:16 AM
|
Fire Beetle
|
|
Join Date: Nov 2009
Location: Belgium
Posts: 2
|
|
Works like a charm
Much appreciated!
|
10-06-2014, 06:52 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
We'll have to figure something out for this since there's a run-time change.
Virgin servers will still be set to look for 'character_,' while first-run+ should look for 'character_data.'
This makes adding bots a non-trivial matter..we'll figure something out, though.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:48 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|