Andy Dustman wrote: > ... [snip] ... > Your original error was: "You have an error in your SQL syntax near > '(DATE_FORMAT(`polls_poll`.`pub_date`, '%Y-01-01 00:00:00') AS > DATETIME) FROM `p' at line 1" I'm going to guess that the bit before > the leading parenthesis is "CAST", and CAST() does not exist prior to > MySQL-4.0. > > http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html > > Solution: I recommend MySQL-4.1 or newer with MySQL-python-1.2.1.
Yeah, you're spot on. I found the query and it is a pre-4.0 MySQL/"CAST" issue. The MySQL documentation (http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html) says: "CAST() and CONVERT() are available as of MySQL 4.0.2." It's entirely possible that I'm a near-sighted dolt, but I don't see any MySQL version requirements notes on the install doc. Might it be a Good Thing to note that "if you want to use date_hierarchy in your models.py Admin classes, use MySQL 4.0.2 and up ... " on http://www.djangoproject.com/documentation/install/ ? John H. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
