Hi all, I'm trying to introspect an old MySQL database (the old software that used the database was written in some nasty mix of Perl and C; it just bit the dust recently). I try an inspectdb on it, and I get an ugly-looking stack trace. Is 'inspectdb' expected to work?; has anyone recently used it on MySQL?
The table that it appears to get stuck on, has fields of an autoincrement int pk, an enum, an int (used as a foreignkey to another table), a text field, and an auto timestamp field. The final error is "1- isn't a valid int()" (see stack trace below); there are no "1-"'s in the table, unless the enum's feeding it one somehow (I've no idea how to check that?). I'm assuming that means a code bug somewhere?; is this a known bug?; anyone know if it's in Django or MySQLdb (or should I go hunting)? I'm running on MacOS X, with Django from svn head, and dependencies from Fink. Thanks, Adam adam$ ./manage.py inspectdb # This is an auto-generated Django model module. # You'll have to do the following manually to clean this up: # * Rearrange models' order # * Make sure each model has one field with primary_key=True # Feel free to rename the models, but don't rename db_table values or field names. # # Also note: You'll have to insert the output of 'django-admin.py sqlinitialdata [appname]' # into your database. from django.db import models class [aseering: Munged Table Name Here](models.Model): Traceback (most recent call last): File "./manage.py", line 11, in ? execute_manager(settings) File "/sw/lib/python2.4/site-packages/django/core/management.py", line 1459, in execute_manager execute_from_command_line(action_mapping, argv) File "/sw/lib/python2.4/site-packages/django/core/management.py", line 1370, in execute_from_command_line for line in action_mapping[action](): File "/sw/lib/python2.4/site-packages/django/core/management.py", line 766, in inspectdb relations = introspection_module.get_relations(cursor, table_name) File "/sw/lib/python2.4/site-packages/django/db/backends/mysql/ introspection.py", line 30, in get_relations my_field_dict = _name_to_index(cursor, table_name) File "/sw/lib/python2.4/site-packages/django/db/backends/mysql/ introspection.py", line 23, in _name_to_index return dict([(d[0], i) for i, d in enumerate (get_table_description(cursor, table_name))]) File "/sw/lib/python2.4/site-packages/django/db/backends/mysql/ introspection.py", line 15, in get_table_description cursor.execute("SELECT * FROM %s LIMIT 1" % quote_name(table_name)) File "/sw/lib/python2.4/site-packages/django/db/backends/util.py", line 12, in execute return self.cursor.execute(sql, params) File "/sw/lib/python2.4/site-packages/django/db/backends/mysql/ base.py", line 42, in execute return self.cursor.execute(sql, params) File "/sw/lib/python2.4/site-packages/MySQLdb/cursors.py", line 95, in execute return self._execute(query, args) File "/sw/lib/python2.4/site-packages/MySQLdb/cursors.py", line 114, in _execute self.errorhandler(self, exc, value) File "/sw/lib/python2.4/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler raise errorclass, errorvalue ValueError: invalid literal for int(): 1- --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---