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.

Reply via email to