Hi, all i have used the command 'manage.py inspectdb' to generate code of models. then i want to use the code to create dbtable in mysql, and i got errormessage: Traceback (most recent call last): File "C:\vincent\wd\django\mysite\mysite\manage.py", line 11, in <module> execute_manager(settings) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\__init__.py", line 340, in execute_manager utility.execute() File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\__init__.py", line 295, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\base.py", line 192, in run_from_argv self.execute(*args, **options.__dict__) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\base.py", line 219, in execute output = self.handle(*args, **options) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\base.py", line 348, in handle return self.handle_noargs(**options) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\core\m anagement\commands\syncdb.py", line 80, in handle_noargs cursor.execute(statement) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\db\bac kends\util.py", line 19, in execute return self.cursor.execute(sql, params) File "c:\python25\lib\site-packages\django-1.0.2_final-py2.5.egg \django\db\bac kends\mysql\base.py", line 83, in execute return self.cursor.execute(query, args) File "C:\Python25\lib\site-packages\MySQLdb\cursors.py", line 167, in execute self.errorhandler(self, exc, value) File "C:\Python25\Lib\site-packages\MySQLdb\connections.py", line 35, in defau lterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax ; check the manual that corresponds to your MySQL server version for the right s yntax to use near '-127) NULL,\n `MGSYXS` numeric(126, -127) NULL, \n `MGSY KC` numeric(126, -127' at line 17")
the code of models: mgsyxs = models.DecimalField(decimal_places=-127, null=True, max_digits=126, db_column='MGSYXS', blank=True) # Field name made lowercase. i appreciate for your suggestion. --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---