Hi Ben, the latest web2py download doesn't include the fix yet. You have to either manually update pydal or wait for a newer release of web2py
Paolo 2015-06-23 6:12 GMT+02:00 Ben Lawrence <benlawr...@gmail.com>: > Hi Paolo, I get the error "<type 'exceptions.UnicodeDecodeError'> 'ascii' > codec can't decode" using the latest web2py download > (2.10.4-stable+timestamp.2015.04.26.15.11.54 (Running on Apache/2.4.7 > (Ubuntu), Python 2.7.6)). This occurs even with “” characters in the > on-board wiki. > Could you tell me the steps of the easiest way to fix this? (I don't mind > which i use pg8000 or psycopg2) Is it a simple matter of > > sudo apt-get install python-psycopg2 > > ? > > > On Sunday, June 21, 2015 at 11:20:33 PM UTC-7, Paolo Valleri wrote: >> >> Massimo the mentioned issue has been fixed in pydal. Have you found other >> different issues? >> >> Paolo >> >> On Sunday, June 21, 2015 at 6:14:29 PM UTC+2, Massimo Di Pierro wrote: >>> >>> I think we should remove pg8000 unless this unicode problem is fixed. It >>> just causes problem to new pgsql users. psycopg2 is solid. >>> >>> On Thursday, 18 June 2015 12:59:44 UTC-5, Paolo Valleri wrote: >>>> >>>> In general the best choice is psycopg2 however, the issue with pg8000 >>>> has been fixed >>>> I've written an initial basic unittest >>>> https://github.com/web2py/pydal/blob/master/tests/base.py#L72 to check >>>> possible issues with unicode >>>> >>>> >>>> Paolo >>>> >>>> 2015-06-18 19:47 GMT+02:00 Antonio Salazar <asala...@gmail.com>: >>>> >>>>> Is it still recommended to use psycopg2 instead of pg8000 after this >>>>> fix? >>>>> >>>>> El lunes, 15 de junio de 2015, 5:28:09 (UTC-5), Paolo Valleri escribió: >>>>> >>>>>> 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 a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/web2py/AE6NVmLPCwk/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> web2py+un...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/AE6NVmLPCwk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
