Or just sudo apt-get install python-psycopg2 as Massimo said, web2py will use psycopg2 before looking for pg8000 :-) great!!
On Monday, June 22, 2015 at 10:13:15 PM UTC-7, Paolo Valleri wrote: > > 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 <benla...@gmail.com <javascript:>>: > >> 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+un...@googlegroups.com <javascript:>. >> >> 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.