ok, so. I tried adding a user record and now im getting this: Traceback (most recent call last): File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/opt/www-data/web2py/applications/test/controllers/appadmin.py" <https://xnvbase00245.corp.costco.com/admin/default/edit/test/controllers/appadmin.py>, line 703, in <module> File "/opt/www-data/web2py/gluon/globals.py", line 412, in <lambda> self._caller = lambda f: f() File "/opt/www-data/web2py/applications/test/controllers/appadmin.py" <https://xnvbase00245.corp.costco.com/admin/default/edit/test/controllers/appadmin.py>, line 151, in insert if form.accepts(request.vars, session): File "/opt/www-data/web2py/gluon/sqlhtml.py", line 1725, in accepts self.vars.id = self.table.insert(**fields) File "/opt/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 728, in insert ret = self._db._adapter.insert(self, self._listify(fields)) File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line 233, in insert rid = Reference(id) NameError: global name 'Reference' is not defined
Any Ideas? On Monday, December 28, 2015 at 10:17:46 AM UTC-8, Michael Messmer wrote: > > MAGIC: > > cursor.execute("DROP SEQUENCE AUTH_USER_SEQUENCE") > cursor.execute("DROP SEQUENCE AUTH_GROUP_SEQUENCE") > cursor.execute("DROP SEQUENCE AUTH_MEMBERSHIP_SEQUENCE") > cursor.execute("DROP SEQUENCE AUTH_PERMISSION_SEQUENCE") > cursor.execute("DROP SEQUENCE AUTH_EVENT_SEQUENCE") > cursor.execute("DROP SEQUENCE AUTH_CAS_SEQUENCE") > > and now I have: > > Welcome to web2py! > > How did you get here? > -My answer: > --Gray Hairs and not giving up and asking for help until I figured this > stuff out!!!!!! > > Thank-you Everyone!!!!! > > Next life lesson. Understanding Linux Permissions and global variables. > > Ill post my install script after I test on a totally blank non-prod > provisioned server in my env. > > On Monday, December 28, 2015 at 10:11:53 AM UTC-8, Michael Messmer wrote: >> >> Alright it worked for blah: >> >> cursor.execute("DROP SEQUENCE BLAH_SEQUENCE") >> >> Going for the rest now. >> >> On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer wrote: >>> >>> Ahh, I am ULTRA-Newb to db's: >>> >>> here is what it returned: >>> >>> >>> for row in cursor: >>> ... print row >>> ... >>> ('SYS_C0012098', 'INDEX') >>> ('SYS_LOB0000092306C00003$$', 'LOB') >>> ('AUTH_CAS_SEQUENCE', 'SEQUENCE') >>> ('AUTH_EVENT_SEQUENCE', 'SEQUENCE') >>> ('AUTH_GROUP_SEQUENCE', 'SEQUENCE') >>> ('AUTH_MEMBERSHIP_SEQUENCE', 'SEQUENCE') >>> ('AUTH_PERMISSION_SEQUENCE', 'SEQUENCE') >>> ('AUTH_USER_SEQUENCE', 'SEQUENCE') >>> ('BLAH_SEQUENCE', 'SEQUENCE') >>> ('AUTH_USER', 'TABLE') >>> >>> >>> I just googled dropping Objects. Wish me luck. ill report back. >>> >>> >>> On Monday, December 28, 2015 at 9:59:18 AM UTC-8, Dan Feeney wrote: >>>> >>>> You can view tables owned by the current user with: >>>> >>>> SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; >>>> >>>> >>>> >>>> You can view all objects owned by the current user with: >>>> >>>> SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1; >>>> >>>> >>>> >>>> HTH, >>>> -Dan >>>> >>> -- 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. For more options, visit https://groups.google.com/d/optout.