hi ppl,
After my unsuccessfull atempt of deploying my TG site on a
postgreSQL7.3.9 database on the production server, because of problems
with BLOBCol colums and Binary data (i posted 1 day before about this
prob but apparently no one else had this problem, and am no expert in
postgres and TG) i decided to switch the MySQL4.1 db that runs on the
production server. Before trying to do anything on the server i
created a schema on the MySQL 5 database that i have at home to start
testing. On my first attempt to add a file on the db from a form of
the site i got :
Page handler: <function _wrapper at 0x8ba187c>
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/
cherrypy/_cphttptools.py", line 105, in _run
self.main()
File "/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/
cherrypy/_cphttptools.py", line 254, in main
body = page_handler(*virtual_path, **self.params)
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/identity/conditions.py", line 275, in _wrapper
return fn( *args, **kw )
File "<string>", line 3, in savephoto
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/controllers.py", line 334, in expose output =
database.run_with_transaction(
File "<string>", line 5, in run_with_transaction
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/database.py", line 302, in so_rwt
retval = func(*args, **kw)
File "<string>", line 5, in _expose
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/controllers.py", line 351, in <lambda>
mapping, fragment, args, kw)))
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/controllers.py", line 378, in _execute_func
output = errorhandling.try_call(func, *args, **kw)
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/errorhandling.py", line 73, in try_call
return func(self, *args, **kw)
File "<string>", line 3, in savephoto
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/controllers.py", line 173, in validate
return errorhandling.run_with_errors(errors, func, *args, **kw)
File "/usr/lib/python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/
turbogears/errorhandling.py", line 113, in run_with_errors
return func(self, *args, **kw)
File "/home/lokki/TurboGears/Yfanet/yfanet/subcontrollers/
controlpanel.py", line 450, in savephoto
p =
Photo(p_title=kwargs['photo_title'],p_descr=kwargs['photo_descr'],p_photo=image)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/declarative.py", line 93, in _wrapper
return fn(self, *args, **kwargs)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/main.py", line 1205, in __init__
self._create(id, **kw)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/main.py", line 1232, in _create
self._SO_finishCreate(id)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/main.py", line 1256, in _SO_finishCreate
id, names, values)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/dbconnection.py", line 765, in queryInsertID
return self._dbConnection._queryInsertID(
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/mysql/mysqlconnection.py", line 98, in _queryInsertID
self._executeRetry(conn, c, q)
File "/usr/lib/python2.4/site-packages/SQLObject-0.7.3-py2.4.egg/
sqlobject/mysql/mysqlconnection.py", line 77, in _executeRetry
myquery = unicode(query, self.encoding)
File "encodings/utf_8.py", line 16, in decode
UnicodeDecodeError: 'utf8' codec can't decode byte 0xff in position
94: unexpected code byte
I am using :
on my dev.cfg:
sqlobject.dburi="mysql://user:[EMAIL PROTECTED]/database?
charset=utf8&sqlobject_encoding=utf8"
and
decodingFilter.on = True
decodingFilter.encoding = "utf8"
and in MySQL conficuration
on tag [mysqld]:
default-character-set = utf8
Is this problem solved? i have seen lots of posts but none of them is
like clear about what needs to be done.
PS. Counting this day i am working on deployment as long as i was
developing the app itself
PS2. I really think that these kinds of problem should be mentioned on
the TurboGears site, at least newbies have lots of hard time
understasnding whats going on(newbies like me)
PS3. The lesson i have learned is that i wont be developing again on
sqllite. I prefer to see these problems when am inside development and
not when i am supposed to deploy the site.
(am sorry if u see an attitude in my words, but in every step on
deployment i have hit on problems)
PS4. Sorry for my english
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
