Go to Google Groups Home    ESOE Users
Errors Running generate_db-mysql.sql

hodgesz@gmail.com <hodg...@gmail.com>

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.

Has anyone seen this before?