Here is the dump:
[EMAIL PROTECTED] percious]$ tg-admin sql create
Creating tables at mysql://percious:[EMAIL PROTECTED]:3306/percious
Traceback (most recent call last):
File "/home2/percious/bin/tg-admin", line 7, in ?
sys.exit(
File "/home2/percious/lib/python2.4/TurboGears-1.0-py2.4.egg/
turbogears/command/base.py", line 389, in main
command.run()
File "/home2/percious/lib/python2.4/TurboGears-1.0-py2.4.egg/
turbogears/command/base.py", line 115, in run
sacommand(command, sys.argv)
File "<string>", line 5, in sacommand
File "/home2/percious/lib/python2.4/TurboGears-1.0-py2.4.egg/
turbogears/command/base.py", line 70, in sacreate
metadata.create_all()
File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 891, in
create_all
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
434, in create
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
458, in _run_visitor
File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 911, in
accept_schema_visitor
File "build/bdist.linux-i686/egg/sqlalchemy/ansisql.py", line 682,
in visit_metadata
File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 266, in
accept_schema_visitor
File "build/bdist.linux-i686/egg/sqlalchemy/ansisql.py", line 717,
in visit_table
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
854, in execute
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
386, in proxy
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
350, in _execute_raw
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
369, in _execute
sqlalchemy.exceptions.SQLError: (OperationalError) (1071, 'Specified
key was too long; max key length is 999 bytes') '\nCREATE TABLE
`Album` (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname
VARCHAR(128), \n\tdirectory VARCHAR(512), \n\t`imageOrder`
VARCHAR(512), \n\t`coverImage` INTEGER, \n\tPRIMARY KEY (id), \n\t
UNIQUE (directory), \n\t FOREIGN KEY(`coverImage`) REFERENCES `Image`
(id)\n)\n\n' ()
Here is the table code:
AlbumTable = Table('Album', metadata,
Column('id', Integer, primary_key=True),
Column('name', Unicode(128)),
Column('directory', Unicode(512), unique=True),
Column('imageOrder', Unicode(512)),
Column('coverImage', Integer, ForeignKey('Image.id')),
)
Mysql version 5.0.27
TIA
-chris
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
