EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Load_bots.sql problem 2014-08-11-02_01 (https://www.eqemulator.org/forums/showthread.php?t=38736)

Midgett 09-07-2014 02:15 PM
Load_bots.sql problem 2014-08-11-02_01
 
I set up a server using the setup guide. I am having problems with the load_bots.sql. I sourced in order: peqbeta.sql, player_tables.sql, load_bots.sql.

I used the latest build (2014-08-11-02_01). Any help is appreciated.

Code:
mysql> source load_bots.sql;
Query OK, 0 rows affected (0.06 sec)

Query OK, 2 rows affected (0.03 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.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.03 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, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.06 sec)

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

Query OK, 0 rows affected (0.05 sec)

ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
Query OK, 0 rows affected, 1 warning (0.01 sec)

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

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.12 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)

mysql>

Uleat 09-07-2014 02:32 PM
This is a new database?

Try drop_bots.sql and then reload them.


I haven't seen that before.


EDIT: I just sourced in a new database and had no problems with load_bots.sql.

Midgett 09-07-2014 03:11 PM
I tried the following:

drop database peq;
create database peq;
use peq; (Database Changed)
source peqbeta.sql; (No Errors)
source player_tables.sql; (No Errors)
source load_bots.sql; (Problem - see below)

Code:
mysql> source load_bots.sql
Query OK, 0 rows affected (0.06 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, 8 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.05 sec)

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

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

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.04 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.04 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.07 sec)

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

Query OK, 0 rows affected (0.05 sec)

ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1547 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
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.10 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.07 sec)

Query OK, 0 rows affected (0.06 sec)

mysql>

Midgett 09-07-2014 03:37 PM
I think I may have found the problem.

I think I got a bad Mysql install. I will post an update as soon as I finish re-installing it.

Uleat 09-07-2014 03:38 PM
Don't forget source_views.sql.

Midgett 09-07-2014 05:54 PM
Yep... I had a bad Mysql install.

Thanks for the bread crumb trails, Uleat!

Uleat 09-07-2014 07:52 PM
Np :)

Post back if you're still having issues.


All times are GMT -4. The time now is 04:24 AM.

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