id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 15162 syncdb fails when creating super user - Django: v 1.2.4 Python: 2.6 MySQL Server: 5.5 Windows 7 Extra: MySQL-Python v1.2.3 david_heagney nobody "syncdb fails when creating super user - Django: v 1.2.4 Python: 2.6 MySQL Server: 5.5 Windows 7 Extra: MySQL-Python v1.2.3 What steps will reproduce the problem? 1. install the above programs 2. create a project 3. run syncdb Note: I have installed mySQL to support UTF 8. I also create the mysite_db database using CREATE DTABASE mysite_db CHARACTER SET = UTF8; What is the expected output? What do you see instead? syncdb create the required tables as follows: {{{ --------------------------------------------------------------------------------------------------------------------- C:\DjangoProjects\mysite>python manage.py syncdb Creating table auth_permission Creating table auth_group_permissions Creating table auth_group Creating table auth_user_user_permissions Creating table auth_user_groups Creating table auth_user Creating table auth_message Creating table django_content_type Creating table django_session Creating table django_site You just installed Django's auth system, which means you don't have any superuse rs defined. Would you like to create one now? (yes/no): --------------------------------------------------------------------------------------------------------------------- }}} I select 'YES' and get the following error: {{{ --------------------------------------------------------------------------------------------------------------------- Traceback (most recent call last): File ""manage.py"", line 11, in execute_manager(settings) File ""C:\Python26\lib\site-packages\django\core\management \__init__.py"", line 438, in execute_manager utility.execute() File ""C:\Python26\lib\site-packages\django\core\management \__init__.py"", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File ""C:\Python26\lib\site-packages\django\core\management\base.py"", line 191, in run_from_argv self.execute(*args, **options.__dict__) File ""C:\Python26\lib\site-packages\django\core\management\base.py"", line 220, in execute output = self.handle(*args, **options) File ""C:\Python26\lib\site-packages\django\core\management\base.py"", line 351, in handle return self.handle_noargs(**options) File ""C:\Python26\lib\site-packages\django\core\management\commands \syncdb.py"" , line 103, in handle_noargs emit_post_sync_signal(created_models, verbosity, interactive, db) File ""C:\Python26\lib\site-packages\django\core\management\sql.py"", line 182, in emit_post_sync_signal interactive=interactive, db=db) File ""C:\Python26\lib\site-packages\django\dispatch\dispatcher.py"", line 172, in send response = receiver(signal=self, sender=sender, **named) File ""C:\Python26\lib\site-packages\django\contrib\auth\management \__init__.py "", line 44, in create_superuser call_command(""createsuperuser"", interactive=True) File ""C:\Python26\lib\site-packages\django\core\management \__init__.py"", line 166, in call_command return klass.execute(*args, **defaults) File ""C:\Python26\lib\site-packages\django\core\management\base.py"", line 220, in execute output = self.handle(*args, **options) File ""C:\Python26\lib\site-packages\django\contrib\auth\management \commands\cr eatesuperuser.py"", line 71, in handle User.objects.get(username=default_username) File ""C:\Python26\lib\site-packages\django\db\models\manager.py"", line 132, in get return self.get_query_set().get(*args, **kwargs) File ""C:\Python26\lib\site-packages\django\db\models\query.py"", line 342, in g et num = len(clone) File ""C:\Python26\lib\site-packages\django\db\models\query.py"", line 80, in __ len__ self._result_cache = list(self.iterator()) File ""C:\Python26\lib\site-packages\django\db\models\query.py"", line 271, in i terator for row in compiler.results_iter(): File ""C:\Python26\lib\site-packages\django\db\models\sql \compiler.py"", line 67 7, in results_iter for rows in self.execute_sql(MULTI): File ""C:\Python26\lib\site-packages\django\db\models\sql \compiler.py"", line 73 2, in execute_sql cursor.execute(sql, params) File ""C:\Python26\lib\site-packages\django\db\backends\util.py"", line 15, in e xecute return self.cursor.execute(sql, params) File ""C:\Python26\lib\site-packages\django\db\backends\mysql \base.py"", line 86 , in execute return self.cursor.execute(query, args) File ""C:\Python26\lib\site-packages\MySQLdb\cursors.py"", line 175, in execute if not self._defer_warnings: self._warning_check() File ""C:\Python26\lib\site-packages\MySQLdb\cursors.py"", line 89, in _warning_ check warn(w[-1], self.Warning, 3) _mysql_exceptions.Warning: Incorrect string value: '\xED' for column 'username' at row 1 --------------------------------------------------------------------------------------------------------------------- }}} What version of the product are you using? On what operating system? Django: v 1.2.4 Python: 2.6 MySQL Server: 5.5 Windows 7 Extra: MySQL-Python v1.2.3 Please provide any additional information below. I also have mySQL C++ and ODBC database connectors installed. Any help is greatly appreciated." Bug closed Database layer (models, ORM) 1.3 Normal duplicate syncdb mysql Accepted 1 0 0 1