Errors Running generate_db-mysql.sql - ESOE Users

Message from discussion Errors Running generate_db-mysql.sql

Shaun Mangelsdorf

More options Apr 4, 2:42 pm

From: Shaun Mangelsdorf <s.mangelsd...@gmail.com>

Date: Sat, 4 Apr 2009 14:42:11 +1000

Local: Sat, Apr 4 2009 2:42 pm

Subject: Re: [esoe-users] Errors Running generate_db-mysql.sql

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Hi,

I have seen this before, though a long time ago.

Try dropping your database and creating it again with the "latin1" character
set, i.e.:
CREATE DATABASE esoe CHARACTER SET latin1;

After this, the creation script should work properly. The problem I had was
with the maximum width of a field that can be indexed by MySQL, since
Unicode is (sometimes) stored in more than 1 byte.

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
> 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?

Reply to author Forward