I get this traceback error:
Traceback (most recent call last):
File "/home/manuele/web2py/gluon/restricted.py", line 224, in restricted
exec ccode in environment
File
"/home/manuele/web2py.trunk/applications/theseus2/models/dashboard/dashboard.py",
line 158, in <module>
requires = IS_EMPTY_OR(IS_IN_SET(toposet(), multiple=True)),
File
"/home/manuele/web2py.trunk/applications/theseus2/models/dashboard/dashboard.py",
line 74, in toposet
orderby = ora.municipio.cod
File "/home/manuele/web2py/gluon/dal/objects.py", line 2064, in select
return adapter.select(self.query,fields,attributes)
File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1231, in select
return self._select_aux(sql,fields,attributes)
File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1196, in
_select_aux
self.execute(sql)
File "/home/manuele/web2py/gluon/dal/adapters/oracle.py", line 136, in execute
return self.log_execute(command, args)
File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1312, in
log_execute
ret = self.cursor.execute(command, *a[1:], **b)
DatabaseError: ORA-00923: FROM keyword not found where expected
and near line 74 of file I got this select definition:
mres = ora(ora.municipio.id>0).select(
ora.municipio.ALL,
"""municipio AS "table" """,
"""Municipio AS "group" """,
orderby = ora.municipio.cod
).as_list()
and it generates the subsequent raw query code:
"SELECT municipio.id, municipio.cod, municipio.roman_cod,
municipio.odonimo, 'municipio' AS table, 'Municipio' AS group FROM
municipio WHERE (municipio.id > 0) ORDER BY municipio.cod;"
Unfortunately I got no experience with Oracle db. I developed my
application till now using PostgreSQL but now I need to switch to Oracle.
Can some body help me to debug this problem?
Thank you very mutch
Manuele
--
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.
