|
|
ESOE Users |
Hi,
I have seen this before, though a long time ago.
Try dropping your database and creating it again with the "latin1" character
After this, the creation script should work properly. The problem I had was
Hope that helps!
Shaun
2009/4/4 hodg...@gmail.com <hodg...@gmail.com>
> I just attempted to run the script generate_db-mysql.sql and got the
> ERROR 1071 (42000): Specified key was too long; max key length is 767
> 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
> Has anyone seen this before?
set, i.e.:
CREATE DATABASE esoe CHARACTER SET latin1;
with the maximum width of a field that can be indexed by MySQL, since
Unicode is (sometimes) stored in more than 1 byte.
> following errors.
> 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)
> esoe and executed with root.