Problems with umlaut äöü and db query (Column %s not found)
(1.)
Problems with umlaute ä ö ü, if a function with a view called inside a Wiki
page.
Only with new created application on version 2.15.3.
Function in Wiki Page:
- @{component:activity/list_a.load}
View:
{{if count == 0:}}
{{=str(count)+' Datensätze gefunden...'}}
{{pass}}
Result:
0 Datensätze gefunden...
The same if I sue SQLFORM.grid.
Id Vorname Nachname E-mail
1 Wiki Administrator äöü [email protected]
(2.)
Problems with a query from database.
On all applications after upgrade to 2.15.3. I tried also a scratch
installation from git.
Error:
Traceback (most recent call last):
File "/opt/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
File "<string>", line 10, in <module>
File "/opt/web2py/gluon/sqlhtml.py", line 3411, in __init__
"Column %s not found (SQLTABLE)" % colname)
KeyError: 'Column anmeldung.device not found (SQLTABLE)'
Query:
def liste_scout_manage():
response.subtitle = 'IP Liste Scout Manage'
rows = db(db.ipliste1.gruppe=='Scout
Manage').select(orderby=db.ipliste1.device|db.ipliste1.adresse)
response.view = 'ipliste1/liste_ip.html'
return locals()
DB:
db.define_table('ipliste1',
Field('device',
requires=IS_IN_SET(['bck01','mgr01'],zero=None)),
Field('hostname', requires=IS_NOT_EMPTY()),
Field('adresse', unique=True),
Field('gruppe', requires=IS_IN_SET(['Scout Data','Scout
Backup','Scout Manage'],zero=None)),
Field('service'),
Field('info'),
Field('bemerkungen'),
)
Any solutions or need I go back with the web2py version?
Thanks, Daniel
Am Montag, 7. August 2017 16:33:55 UTC+2 schrieb Massimo Di Pierro:
>
> Contains lots of small fixes.
> Many thanks to Leonel for taking care of many urgent issues in a hurry.
>
> \
> Massimo
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
