Message from discussion
Errors Running generate_db-mysql.sql
MIME-Version: 1.0
Received: by 10.100.252.18 with SMTP id z18mr264941anh.8.1238810888969; Fri,
03 Apr 2009 19:08:08 -0700 (PDT)
Date: Fri, 3 Apr 2009 19:08:08 -0700 (PDT)
X-IP: 76.25.41.116
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US)
AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.53 Safari/525.19,gzip(gfe),gzip(gfe)
Message-ID: <577e6376-66f5-4f73-8c59-e3bbbc15fe31@v23g2000pro.googlegroups.com>
Subject: Errors Running generate_db-mysql.sql
From: "hodg...@gmail.com" <hodg...@gmail.com>
To: ESOE Users <esoe-users@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
I just attempted to run the script generate_db-mysql.sql and got the
following errors.
ERROR 1071 (42000): Specified key was too long; max key length is 767
bytes
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno: 150)
I am using MySQL 5.1.31-community. I first created a schema called
esoe and executed with root.
|
