Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
Thanks for letting me know. I did not try that yet. On Monday, 22 June 2015 01:20:33 UTC-5, 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 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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
+1 -- 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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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 javascript:: 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 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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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 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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
+1 -- 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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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 asalaza...@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+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.
Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)
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 asalaza...@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+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.