Hmm I appear to have solved this problem by reinstalling the Web2Py Framework and creating a new Oracle account. My issue now is with the AUTH_GROUP and AUTH_EVENT tables. It gives me the strangest error whenever I try to create a new user there.
On Tue, Oct 23, 2018 at 7:15 AM Michael Buchler <[email protected]> wrote: > 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. > -- 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.
