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
16613	manage.py test fails on database creation (MySQL)	Stan <stanislas.guerra@…>	nobody	"Hi,

Running ''python manage.py test'' with Django-trunk/Debian-Lenny/Python2.5/MySQL-5.0 give me this :


{{{
Traceback (most recent call last):
  File ""manage.py"", line 14, in <module>
    execute_manager(settings)
  File ""/home/pages/lib/python/django/core/management/__init__.py"", line 442, in execute_manager
    utility.execute()
  File ""/home/pages/lib/python/django/core/management/__init__.py"", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""/home/pages/lib/python/django/core/management/commands/test.py"", line 34, in run_from_argv
    super(Command, self).run_from_argv(argv)
  File ""/home/pages/lib/python/django/core/management/base.py"", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File ""/home/pages/lib/python/django/core/management/base.py"", line 220, in execute
    output = self.handle(*args, **options)
  File ""/home/pages/lib/python/django/core/management/commands/test.py"", line 54, in handle
    failures = test_runner.run_tests(test_labels)
  File ""/home/pages/lib/python/django/test/simple.py"", line 354, in run_tests
    old_config = self.setup_databases()
  File ""/home/pages/lib/python/django/test/simple.py"", line 291, in setup_databases
    test_db_name = connection.creation.create_test_db(self.verbosity, autoclobber=not self.interactive)
  File ""/home/pages/lib/python/django/db/backends/creation.py"", line 230, in create_test_db
    self.connection.features.confirm()
  File ""/home/pages/lib/python/django/db/backends/__init__.py"", line 382, in confirm
    self.can_introspect_foreign_keys = self._can_introspect_foreign_keys()
  File ""/home/pages/lib/python/django/db/backends/mysql/base.py"", line 146, in _can_introspect_foreign_keys
    cursor.execute('SHOW TABLE STATUS WHERE Name=""INTROSPECT_TEST""')
  File ""/home/pages/lib/python/django/db/backends/mysql/base.py"", line 86, in execute
    return self.cursor.execute(query, args)
  File ""/var/lib/python-support/python2.5/MySQLdb/cursors.py"", line 166, in execute
    self.errorhandler(self, exc, value)
  File ""/var/lib/python-support/python2.5/MySQLdb/connections.py"", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, ""Unknown column 'INTROSPECT_TEST' in 'where clause'"")

}}}

I just swapped the quote line 146 and everything works fine.



"	Bug	closed	Uncategorized	dev	Normal	fixed			Accepted	1	0	0	0	0	0