[Snowy] Issues with MySQL

[Og Maciel <ogmaciel gnome org>]

When I tried to run snowy against a mysql db:

python manage.py syncdb --noinput
Creating table django_admin_log
Creating table auth_permission
Creating table auth_group
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table registration_registrationprofile
Creating table django_project_version
Creating table django_evolution
Creating table reversion_revision
Creating table reversion_version
Creating table notes_note
Traceback (most recent call last):
  File "manage.py", line 11, in ?
    execute_manager(settings)
  File "/usr/lib/python2.4/site-packages/django/core/management/__init__.py",
line 362, in execute_manager
    utility.execute()
  File "/usr/lib/python2.4/site-packages/django/core/management/__init__.py",
line 303, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/python2.4/site-packages/django/core/management/base.py",
line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/python2.4/site-packages/django/core/management/base.py",
line 222, in execute
    output = self.handle(*args, **options)
  File "/usr/lib/python2.4/site-packages/django/core/management/base.py",
line 351, in handle
    return self.handle_noargs(**options)
  File "/usr/lib/python2.4/site-packages/django/core/management/commands/syncdb.py",
line 78, in handle_noargs
    cursor.execute(statement)
  File "/usr/lib/python2.4/site-packages/django/db/backends/mysql/base.py",
line 84, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line
166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'title'
used in key specification without a key length")

The problem seems to be know (look at
http://code.djangoproject.com/ticket/2495) but I need to do more
research to fix it and come up with a patch.

Also, we should include a default 500.html so that people don't get an
ISE (and scared that they've broken something) when something blows
up. :)

-- 
Og B. Maciel

omaciel foresightlinux org
ogmaciel gnome org
ogmaciel ubuntu com

GPG Keys: D5CFC202

http://www.ogmaciel.com (en_US)
http://blog.ogmaciel.com (pt_BR)