Ah thanks, that saves me some time.
Regarding bots I get this error when I try and run the SQL in required
mysql> source 2015_09_30_bots.sql
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, 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, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.16 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.02 sec)
ERROR 1136 (21S01): Column count doesn't match value count at row 1
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
ERROR 1146 (42S02): Table 'peq.bot_data' doesn't exist
ERROR 1146 (42S02): Table 'peq.bot_groups' doesn't exist
ERROR 1146 (42S02): Table 'peq.bot_data' doesn't exist
ERROR 1146 (42S02): Table 'peq.bot_guild_members' doesn't exist
mysql>
I know it's stating the obvious that the table doesn't exist but I just dropped the bots out of the DB and sourced them back in.
|