On Mon, 2007-02-26 at 15:28 -0800, Chris Brand wrote: [...] > OperationalError: (1054, "Unknown column 'camps_board_time_block.start_time' > in 'order clause'") > > I've tried substituting fields of other related tables, and they work fine. > > Going directly into the db, I think I have everything spelled correctly : > mysql> describe camps_board_time_block; > +------------+---------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +------------+---------+------+-----+---------+----------------+ > | id | int(11) | NO | PRI | NULL | auto_increment | > | board_id | int(11) | NO | MUL | | | > | start_time | time | NO | | | | > | end_time | time | NO | | | | > | _order | int(11) | YES | | NULL | | > +------------+---------+------+-----+---------+----------------+ > > Is there a way to get at the actual SQL that's being executed ?
Providing you have DEBUG=True in your settings file, you can do this. If you import django.db.connection and then have a look inside connection.queries, you will see the SQL that is being executed. It is a list of dictionaries, each dictionary contains the time the query took and the query itself. The query should be included in that list even if it raises an exception. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
