Message from discussion
Errors Running generate_db-mysql.sql
Received: by 10.151.110.9 with SMTP id n9mr747384ybm.24.1238820132533;
Fri, 03 Apr 2009 21:42:12 -0700 (PDT)
Return-Path: <s.mangelsd...@gmail.com>
Received: from mail-gx0-f164.google.com (mail-gx0-f164.google.com [209.85.217.164])
by gmr-mx.google.com with ESMTP id 7si190802yxg.1.2009.04.03.21.42.11;
Fri, 03 Apr 2009 21:42:11 -0700 (PDT)
Received-SPF: pass (google.com: domain of s.mangelsd...@gmail.com designates 209.85.217.164 as permitted sender) client-ip=209.85.217.164;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of s.mangelsd...@gmail.com designates 209.85.217.164 as permitted sender) smtp.mail=s.mangelsd...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by gxk8 with SMTP id 8so3093411gxk.5
for <esoe-users@googlegroups.com>; Fri, 03 Apr 2009 21:42:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:in-reply-to:references
:date:message-id:subject:from:to:content-type;
bh=ax7ZdFcVxAqEYn0ihwPwYPSSIMwa2AcV6e8t02MQXvQ=;
b=qbk9604D0x7mx+wbOEgtthBF7+jmuyC7OkvY/+kZo+NCEJ9Cu053SWVpmyro5sUnid
LTIfyq/EzqAlXTw/pB185Gx+l8+XbLiN8m0AeA/GvLdN9IKs6YkWkuLrkTTldbEvtmbw
ZN1ItBbyyb7eQP7OQAYhofYV19kAcJBCQ2dRQ=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
b=qzht2+fUMj6/i/dK7Z5UH+Z+9kRWXMkEVPENBmN8F8UOUK5XGmIURXNCxb9WVWS/r3
bOql+m7e6b32+eGDt+4UOSlwfctBi610PQmry5C95anAHcne5ALfCGMXsuuQRoKC/2WC
cHWgENTbTDZ8+xgq4RAT9AMA1aamNDSJWGEPA=
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="0015174c1996e054ff0466b34970"
Received: by 10.151.98.11 with SMTP id a11mr3651504ybm.215.1238820131459; Fri,
03 Apr 2009 21:42:11 -0700 (PDT)
In-Reply-To: <577e6376-66f5-4f73-8c59-e3bbbc15fe31@v23g2000pro.googlegroups.com>
References: <577e6376-66f5-4f73-8c59-e3bbbc15fe31@v23g2000pro.googlegroups.com>
Date: Sat, 4 Apr 2009 14:42:11 +1000
Message-ID: <90ad28f40904032142i3ad6079en6c8f1e2d8ec40...@mail.gmail.com>
Subject: Re: [esoe-users] Errors Running generate_db-mysql.sql
From: Shaun Mangelsdorf <s.mangelsd...@gmail.com>
To: esoe-users@googlegroups.com
--0015174c1996e054ff0466b34970
Content-Type: text/plain; charset=ISO-8859-1
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?
> >
>
--0015174c1996e054ff0466b34970
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,<br><br>I have seen this before, though a long time ago. <br><br>Try dro=
pping your database and creating it again with the "latin1" chara=
cter set, i.e.:<br>CREATE DATABASE esoe CHARACTER SET latin1;<br><br>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.<br>
<br>Hope that helps!<br><br>Shaun<br><br><div class=3D"gmail_quote">2009/4/=
4 <a href=3D"mailto:hodg...@gmail.com">hodg...@gmail.com</a> <span dir=3D"l=
tr"><<a href=3D"mailto:hodg...@gmail.com">hodg...@gmail.com</a>></spa=
n><br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
I just attempted to run the script generate_db-mysql.sql and got the<br>
following errors.<br>
<br>
ERROR 1071 (42000): Specified key was too long; max key length is 767<br>
bytes<br>
<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
ERROR 1005 (HY000): Can't create table 'esoe.#sql-228_f' (errno=
: 150)<br>
<br>
I am using MySQL 5.1.31-community. =A0I first created a schema called<br>
esoe and executed with root.<br>
<br>
Has anyone seen this before?<br>
<br>
</blockquote></div><br>
--0015174c1996e054ff0466b34970--
|
