Hello,
After recent upgrade of my Pylons app I have been seeing the errors
like this one:
sqlalchemy.exceptions.SQLError: (UnicodeDecodeError)
'utf8' codec can't decode byte 0x96 in position 718: unexpected
code byte u'SELECT jobad_posts.post_status AS
jobad_posts_post_status,
jobad_posts.post_title AS jobad_posts_post_title,
jobad_posts.post_content AS jobad_posts_post_content,
jobad_posts.last_modified AS jobad_posts_last_modified,
jobad_posts.published_date AS jobad_posts_published_date,
jobad_posts.duration AS jobad_posts_duration,
jobad_posts.post_author AS jobad_posts_post_author,
jobad_posts.`ID` AS `jobad_posts_ID`,
jobad_posts.expires_on AS jobad_posts_expires_on \nFROM jobad_posts
\nWHERE (jobad_posts.post_status = %s AND
jobad_posts.expires_on >= %s) ORDER BY
jobad_posts.published_date DESC' ['publish',
datetime.datetime(2007, 6, 7, 16, 35, 1, 409021)]
The strange thing is how they occur. For some time after application
starts (if may be a few days) it runs these queries just fine but
after awhile all queries fail with the exception like above. If
application is restarted it runs fine again.
Any ideas?
Btw, here is the traceback I see:
Module doupy.models:152 in select_active_job_postings
<< now = datetime.datetime.now()
return self.select_some_job_postings(expdate=now,
limit=limit, show_expired=False,
post_status='publish')
def select_some_job_postings(self, expdate=None, >>
limit=limit, show_expired=False, post_status='publish')
Module doupy.models:200 in select_some_job_postings
<< if limit:
posts = posts[:limit]
return posts.list()
def auth_user_by_credentials(self, username, password):>>
return posts.list()
Module sqlalchemy.orm.query:809 in list
Module sqlalchemy.orm.query:818 in __iter__
Module sqlalchemy.orm.query:326 in select_whereclause
Module sqlalchemy.orm.query:927 in _select_statement
Module sqlalchemy.orm.query:831 in execute
Module sqlalchemy.orm.session:183 in execute
Module sqlalchemy.engine.base:509 in execute
Module sqlalchemy.engine.base:549 in execute_clauseelement
Module sqlalchemy.engine.base:560 in execute_compiled
Module sqlalchemy.engine.base:573 in _execute_raw
Module sqlalchemy.engine.base:591 in _execute
Max.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
