subject:"\"Re\\\: \\\[web2py\\\] Re\\\: UnicodeDecodeError\\\: 'ascii' codec can't decode byte 0xc3 in position 1145\\\: ordinal not in range\\\(128\\\)\""

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-07-11 Thread Ben Lawrence

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 >:
>
>> Hi Paolo,  I get the error " 
>> '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 :
>
>> 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 
> " '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"
>  , 
> line 704, in 
>   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 
> 412, in 
> self._caller = lambda f: f()
>   File 
> "S:/Extranet/Website/Fuentes/web2py/applications/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)
>>>

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-22 Thread Paolo Valleri

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 :

> Hi Paolo,  I get the error " '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 :

> 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
 " '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"
  , 
 line 704, in 
   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 
 412, in 
 self._caller = lambda f: f()
   File 
 "S:/Extranet/Website/Fuentes/web2py/applications/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

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-22 Thread Ben Lawrence

Hi Paolo,  I get the error " '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 :
>>>
 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 
>>> " '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"
>>>  , 
>>> line 704, in 
>>>   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, 
>>> in 
>>> self._caller = lambda f: f()
>>>   File 
>>> "S:/Extranet/Website/Fuentes/web2py/applications/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 I

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-21 Thread Massimo Di Pierro

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 :
>>>
 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 
>>> " '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"
>>>  , 
>>> line 704, in 
>>>   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, 
>>> in 
>>> self._caller = lambda f: f()
>>>   File 
>>> "S:/Extranet/Website/Fuentes/web2py/applications/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)

2015-06-21 Thread Paolo Valleri

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 > >:
>>
>>> 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 "> '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"
>>  , 
>> line 704, in 
>>   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, 
>> in 
>> self._caller = lambda f: f()
>>   File 
>> "S:/Extranet/Website/Fuentes/web2py/applications/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)

2015-06-21 Thread Annet

+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)

2015-06-21 Thread 黄祥

+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)

2015-06-21 Thread Massimo Di Pierro

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 :
>
>> 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 " '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"
>  , 
> line 704, in 
>   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, 
> in 
> self._caller = lambda f: f()
>   File 
> "S:/Extranet/Website/Fuentes/web2py/applications/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)

2015-06-18 Thread Paolo Valleri

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 :

> 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 ">>> '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"
  , line 
 704, in 
   File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, in 
 
 self._caller = lambda f: f()
   File 
 "S:/Extranet/Website/Fuentes/web2py/applications/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)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

9 matches

Site Navigation

Mail list logo

Footer information