rows = db(
(db.recipes.ID_CUISINE==db.cuisines.id) &
(db.recipes.ID_AUTHOR==db.authors.id) &
(db.recipes.ID_CATEGORY==db.categories.id)
).select(db.cuisines.NAME,db.authors.NAME,db.categories.NAME,db.recipes.ALL
)
Ticket ID
127.0.0.1.2019-07-18.22-56-57.1cf3eb52-85aa-418d-b7f9-51ac287014a9
<class 'UnicodeDecodeError'> 'utf-8' codec can't decode byte 0xf0 in
position 0: invalid continuation byteВерсия
web2py™ Version 2.18.5-stable+timestamp.2019.04.08.04.22.03
Python Python 3.7.3: C:\Program Files (x86)\Python37-32\python.exe (prefix:
C:\Program Files (x86)\Python37-32)Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
Traceback (most recent call last):
File "D:\Загрузки\web2py_src\web2py\gluon\restricted.py", line 219, in
restricted
exec(ccode, environment)
File
"D:\Загрузки\web2py_src\web2py\applications\Recipes\controllers/default.py",
line 89, in <module>
File "D:\Загрузки\web2py_src\web2py\gluon\globals.py", line 421, in <lambda>
self._caller = lambda f: f()
File
"D:\Загрузки\web2py_src\web2py\applications\Recipes\controllers/default.py",
line 19, in index
).select(db.cuisines.NAME,db.authors.NAME,db.categories.NAME,db.recipes.ALL)
File "D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\objects.py",
line 2395, in select
return adapter.select(self.query, fields, attributes)
File
"D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py", line
763, in select
return self._select_aux(sql, fields, attributes, colnames)
File
"D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py", line
719, in _select_aux
rows = self._select_aux_execute(sql)
File
"D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py", line
714, in _select_aux_execute
return self.cursor.fetchall()
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 3730, in fetchall
return [row for row in self]
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 3730, in <listcomp>
return [row for row in self]
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 3488, in next
row = self.fetchone()
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 3690, in fetchone
return self._ps._fetchone()
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 3359, in _fetchone
return self.__xsqlda2tuple(self._out_sqlda)
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 2677, in __xsqlda2tuple
value = b2u(value, self.__python_charset)
File "C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py",
line 479, in b2u
return st.decode(charset)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf0 in position 0: invalid
continuation byte
Error snapshot [image: help]
<http://127.0.0.1:8000/admin/default/ticket/Recipes/127.0.0.1.2019-07-18.22-56-57.1cf3eb52-85aa-418d-b7f9-51ac287014a9#>
UnicodeDecodeError('utf-8' codec can't decode byte 0xf0 in position 0:
invalid continuation byte)
inspect attributes
Frames
-
*File D:\Загрузки\web2py_src\web2py\gluon\restricted.py in restricted at
line 219* код аргументы переменные
-
*File
D:\Загрузки\web2py_src\web2py\applications\Recipes\controllers\default.py
in <module> at line 89* код аргументы переменные
-
*File D:\Загрузки\web2py_src\web2py\gluon\globals.py in <lambda> at line
421* код аргументы переменные
-
*File
D:\Загрузки\web2py_src\web2py\applications\Recipes\controllers\default.py
in index at line 19* код аргументы переменные
-
*File D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\objects.py
in select at line 2395* код аргументы переменные
-
*File
D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py in
select at line 763* код аргументы переменные
-
*File
D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py in
_select_aux at line 719* код аргументы переменные
-
*File
D:\Загрузки\web2py_src\web2py\gluon\packages\dal\pydal\adapters\base.py in
_select_aux_execute at line 714* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in fetchall at line 3730* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in <listcomp> at line 3730* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in next at line 3488* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in fetchone at line 3690* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in _fetchone at line 3359* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in __xsqlda2tuple at line 2677* код аргументы переменные
-
*File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py
in b2u at line 479* код аргументы переменные
Function argument list
(st=b'\xf0\xf3\xf1\xf1\xea\xe0\xff', charset='utf_8')
Code listing
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
return isinstance(obj, weakref.ProxyType) and not dir(obj)
def b2u(st, charset):
"Decode to unicode if charset is defined. For conversion of result set
data."
if charset:
return st.decode(charset)
else:
return st
def p3fix(st, charset):
Variables
st b'\xf0\xf3\xf1\xf1\xea\xe0\xff'
st.decode <built-in method decode of bytes object>
charset 'utf_8'
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/7e8da26b-3187-4d1f-bda9-f025d4c2652a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
