recent_posts is trying to read pub_date as a DOUBLE instead of DATETIME.

[WolfeWLU]

Hi,

I'm really befuddled. Got Blogmaker installed, all the pages looked
good. Went into the admin site and added a blog entry. However, now
when I try to view the blog, I get the Traceback below. It looks like
it's trying to read the DATETIME as a DOUBLE...or key it that way. Any
pointers or help is greatly appreciated.

Django is 0.96.2 pulled from SVN rev 7541.

Best Regards,
Jason

Environment:

Request Method: GET
Request URL: http://localhost/devel/blog/
Django Version: 0.97-pre-SVN-7541
Python Version: 2.5.1
Installed Applications:
['django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.humanize',
'django.contrib.sites',
'django.contrib.markup',
'django.contrib.admin',
'blogmaker.blog',
'blogmaker.comments',
'blogmaker.util']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.middleware.doc.XViewMiddleware')


Template error:
In template /Users/jasonjwwilliams/Documents/Subversion Repositories/
timp/branches/devel/timp/templates/blog/includes/recent_posts.html,
error at line 12
Caught an exception while rendering: Truncated incorrect DOUBLE
value: '2008-07-31 03:15:14.687881'
2 :


3 :


4 : {% load blog_extras %}


5 :


6 : {% if object.id %}


7 : {% get_recent_posts 5 as post_list object.id %}


8 : {% endif %}


9 : {% if not object.id %}


10 : {% get_recent_posts 5 as post_list %}


11 : {% endif %}


12 : {% if post_list %}


13 : <!-- recent posts begin -->


14 : <div class="menu">


15 : <div class="menu_header">Recent Posts</div>


16 : <div class="menu_content">


17 : <ul class='recent'>


18 : {% for p in post_list %}


19 : <li class='recent'>


20 : <a href="{{ p.get_absolute_url }}" title="{{ p.headline }}"
class='menu{% if not p.current_post %}_content{% endif %}{% if
p.current_post %}_current{% endif %}'>{{ p.headline }}


21 : </a>


22 : </li>


Traceback:
File "/Library/Python/2.5/site-packages/django/template/debug.py" in
render_node
71. result = node.render(context)
File "/Library/Python/2.5/site-packages/django/template/
defaulttags.py" in render
242. if (value and not ifnot) or (ifnot and not
value):
File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
__nonzero__
84. iter(self).next()
File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
_result_iter
78. self._fill_cache()
File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
_fill_cache
490.
self._result_cache.append(self._iter.next())
File "/Library/Python/2.5/site-packages/django/db/models/query.py" in
iterator
162. for row in self.query.results_iter():
File "/Library/Python/2.5/site-packages/django/db/models/sql/query.py"
in results_iter
200. for rows in self.execute_sql(MULTI):
File "/Library/Python/2.5/site-packages/django/db/models/sql/query.py"
in execute_sql
1466. cursor.execute(sql, params)
File "/Library/Python/2.5/site-packages/django/db/backends/util.py" in
execute
18. return self.cursor.execute(sql, params)
File "/Library/Python/2.5/site-packages/MySQL_python-1.2.2-py2.5-
macosx-10.5-i386.egg/MySQLdb/cursors.py" in execute
168. if not self._defer_warnings: self._warning_check()
File "/Library/Python/2.5/site-packages/MySQL_python-1.2.2-py2.5-
macosx-10.5-i386.egg/MySQLdb/cursors.py" in _warning_check
82. warn(w[-1], self.Warning, 3)
File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/warnings.py" in warn
62. globals)
File "/System/Library/Frameworks/Python.framework/Versions/2.5/lib/
python2.5/warnings.py" in warn_explicit
102. raise message

Exception Type: Warning at /devel/blog/
Exception Value: Truncated incorrect DOUBLE value: '2008-07-31
03:15:14.687881'