Load_bots.sql problem 2014-08-11-02_01

[Midgett]

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.

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]

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]

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)

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]

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]

Don't forget source_views.sql.

[Midgett]

Yep... I had a bad Mysql install.

Thanks for the bread crumb trails, Uleat!

[Uleat]

Np

Post back if you're still having issues.