According to my tests, the current PG adapter works only with psycopg2 and python2.7 It is broken with both pg8000 and psycopg2 on python 3.x
A possible fix for pg8000 and python2.7 is here https://github.com/ilvalle/pydal/commit/d5450938ae606a3e85deffa831899a35146f5e64 I've posted an issue for psycopg2 with python3.x here https://github.com/psycopg/psycopg2/issues/331#issuecomment-111909256 Paolo On Saturday, June 13, 2015 at 5:22:07 AM UTC+2, Massimo Di Pierro wrote: > > It is a bug in pg8000. You need to install psycopg2 > > On Friday, 12 June 2015 13:51:55 UTC-5, Antonio Salazar wrote: >> >> I have the same problem. PostgreSQL database, web2py >> 2.11.2-stable+timestamp.2015.05.30.16.33.24 >> source install. >> >> Now any field update which has non-ASCII characters fails with "<type >> 'exceptions.UnicodeDecodeError'> 'ascii' codec can't decode byte 0xc3 in >> position X: ordinal not in range(128)" >> By any field update, I mean custom forms, form grids, and even database >> administration. >> >> This is the traceback after failing to change a user's name to "José" >> with database administration: >> >> Traceback (most recent call last): >> File "S:\Extranet\Website\Fuentes\web2py\gluon\restricted.py", line 227, >> in restricted >> exec ccode in environment >> File >> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, line >> 704, in <module> >> File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, in >> <lambda> >> self._caller = lambda f: f() >> File >> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, line >> 343, in update >> if form.accepts(request.vars, session): >> File "S:\Extranet\Website\Fuentes\web2py\gluon\sqlhtml.py", line 1686, in >> accepts >> self.id_field_name]).update(**fields) >> File >> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\objects.py", >> line 2020, in update >> ret = db._adapter.update("%s" % table._tablename,self.query,fields) >> File >> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\adapters\base.py", >> line 996, in update >> raise e >> UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 57: >> ordinal not in range(128) >> >> >> I don't recall having this problem with pre 2.10 versions >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
