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.
