Cannot create database in MySQL (Connector...Raw.Script.sql)

Jan 21, 2010 at 2:02 AM

I'm having trouble getting the database created for MySQL (I'm using version 5.1) using the standard CLI admin interface. I run "source MySQL.Connector.KiGG.Schema.Raw.Script.sql" and I receive a ton of errors. I haven't seen any other complaints, so I'm guessing it's something I'm doing wrong. Here's the output I get:

 

mysql> source MySQL.Connector.KiGG.Schema.Raw.Script.sql
Query OK, 1 row affected (0.00 sec)

Database changed
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)

ERROR 1005 (HY000): Can't create table 'kigg.commentsubscribtion' (errno: 150)
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

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

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

ERROR 1005 (HY000): Can't create table 'kigg.story' (errno: 150)
ERROR 1146 (42S02): Table 'kigg.story' doesn't exist
ERROR 1146 (42S02): Table 'kigg.story' doesn't exist
ERROR 1146 (42S02): Table 'kigg.story' doesn't exist
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1005 (HY000): Can't create table 'kigg.storycomment' (errno: 150)
ERROR 1146 (42S02): Table 'kigg.storycomment' doesn't exist
ERROR 1146 (42S02): Table 'kigg.storycomment' doesn't exist
ERROR 1146 (42S02): Table 'kigg.storycomment' doesn't exist
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1005 (HY000): Can't create table 'kigg.storymarkasspam' (errno: 150)
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1005 (HY000): Can't create table 'kigg.storytag' (errno: 150)
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1005 (HY000): Can't create table 'kigg.storyview' (errno: 150)
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1005 (HY000): Can't create table 'kigg.storyvote' (errno: 150)
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 (0.04 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 (0.04 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 6
ERROR 1327 (42000): Undeclared variable: rows_count
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'if ro
ws_count > 0 then
     return 1' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'end i
f' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'retur
n 0' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'END'
at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 6
ERROR 1327 (42000): Undeclared variable: rows_count
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'if ro
ws_count > 0 then
     return 1' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'end i
f' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'retur
n 0' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'END'
at line 1