Hi guys,
I want to use oracle (11g) with web2py and changed the DAL to the
following:
db =
DAL(configuration.get('oracle://USERNAME:PASSWORD@localhost/SCHEMA_NAME'),
pool_size=configuration.get('db.pool_size'),
migrate_enabled=configuration.get('db.migrate'),
check_reserved=['all'])
I've also re-created the default tables in oracle. However, whenever I try
something like creating an account on the default/users page, I get the
following error
Traceback (most recent call last):
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 1866, in
_validate
(value, errors) = validator(value)
File "C:\Users\Michael\Documents\web2py\gluon\validators.py", line 735, in
__call__
subset = self.dbset(field == value,
File "C:\Users\Michael\Documents\web2py\gluon\packages\dal\pydal\objects.py",
line 1401, in __eq__
return Query(self.db, self._dialect.eq, self, value)
AttributeError: 'CommonDialect' object has no attribute 'eq'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\Michael\Documents\web2py\gluon\restricted.py", line 219, in
restricted
exec(ccode, environment)
File
"C:/Users/Michael/Documents/web2py/applications/MADRN/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/MADRN/controllers/default.py>, line
60, in <module>
File "C:\Users\Michael\Documents\web2py\gluon\globals.py", line 421, in
<lambda>
self._caller = lambda f: f()
File
"C:/Users/Michael/Documents/web2py/applications/MADRN/controllers/default.py"
<http://127.0.0.1:8000/admin/default/edit/MADRN/controllers/default.py>, line
49, in user
return dict(form=auth())
File "C:\Users\Michael\Documents\web2py\gluon\tools.py", line 1800, in
__call__
return getattr(self, args[0])()
File "C:\Users\Michael\Documents\web2py\gluon\tools.py", line 2976, in
register
hideerror=self.settings.hideerror):
File "C:\Users\Michael\Documents\web2py\gluon\sqlhtml.py", line 1758, in
accepts
**kwargs
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 2125, in accepts
status = self._traverse(status, hideerror)
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 886, in _traverse
newstatus = c._traverse(status, hideerror) and newstatus
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 886, in _traverse
newstatus = c._traverse(status, hideerror) and newstatus
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 886, in _traverse
newstatus = c._traverse(status, hideerror) and newstatus
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 893, in _traverse
newstatus = self._validate()
File "C:\Users\Michael\Documents\web2py\gluon\html.py", line 1871, in
_validate
raise Exception(msg)
Exception: Validation error, field:email <gluon.validators.IS_NOT_IN_DB object
at 0x000001DDB3CDBE80>
Help would be very much appreciated
--
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.
