Load_bots.sql problem 2014-08-11-02_01 [Archive]

View Full Version : Load_bots.sql problem 2014-08-11-02_01

Midgett

09-07-2014, 02:15 PM

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

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)

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.