Trouble setting up website with mysql as backend

Hello All,

I was developing a website and the development was all done using sqlite database. Now the development is almost complete so i need to test the site using mysql. When i did a syncdb on a fresh database i got the following error:

Traceback (most recent call last):

  File "./manage.py", line 19, in <module>

    execute_manager(settings)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager

    utility.execute()

  File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 379, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv

    self.execute(*args, **options.__dict__)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute

    output = self.handle(*args, **options)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle

    return self.handle_noargs(**options)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 109, in handle_noargs

    emit_post_sync_signal(created_models, verbosity, interactive, db)

  File "/usr/local/lib/python2.7/site-packages/django/core/management/sql.py", line 190, in emit_post_sync_signal

    interactive=interactive, db=db)

  File "/usr/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 172, in send

    response = receiver(signal=self, sender=sender, **named)

  File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/management/__init__.py", line 51, in create_permissions

    content_type=ctype

  File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py", line 138, in create

    return self.get_query_set().create(**kwargs)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 360, in create

    obj.save(force_insert=True, using=self.db)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save

    self.save_base(using=using, force_insert=force_insert, force_update=force_update)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py", line 553, in save_base

    result = manager._insert(values, return_id=update_pk, using=using)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py", line 195, in _insert

    return insert_query(self.model, values, **kwargs)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 1436, in insert_query

    return query.get_compiler(using=using).execute_sql(return_id)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql

    cursor = super(SQLInsertCompiler, self).execute_sql(None)

  File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql

    cursor.execute(sql, params)

  File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 86, in execute

    return self.cursor.execute(query, args)

  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 176, in execute

    if not self._defer_warnings: self._warning_check()

  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 92, in _warning_check

    warn(w[-1], self.Warning, 3)

_mysql_exceptions.Warning: Data truncated for column 'name' at row 1

As you can see its a mysql warning since i had changed mysql mode to non strict. The error from the traceback looks to be from the file "/usr/local/lib/python2.7/site-packages/django/contrib/auth/management/__init__.py" which is django contrib application. What should i do to fix this issue. Am using django version 1.3.1. Please help. 

Thanks and Regards,

Swaroop Shankar V

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.