I get this:
File"/home/jason/Desktop/InterestID_4/Development_Environment/gluon/dal.py",line1386,inlog_execute
ret=self.cursor.execute(*a, **b)
ProgrammingError:syntax error atornear"user"
LINE4:user INTEGER REFERENCES auth_user(id)ON DELETE CASCADE,
When web2py tries creating it's mode in this file:
# -*- coding: utf-8 -*-
db.define_table('attender_appointment',
Field <http://127.0.0.1:8000/examples/global/vars/Field>('event',db.event,label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Event")),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('user',db.auth_user,label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Creator")),
Field <http://127.0.0.1:8000/examples/global/vars/Field>('pos_x','integer',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("X Position")),
Field <http://127.0.0.1:8000/examples/global/vars/Field>('pos_y','integer',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Y Position")),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('floor_plan',db.floor_plan,label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Floor Plan")),
Field <http://127.0.0.1:8000/examples/global/vars/Field>('title','string',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Title")),
Field <http://127.0.0.1:8000/examples/global/vars/Field>('details','text',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Details")),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('start_time','datetime',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Start Time")),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('end_time','datetime',label=T
<http://127.0.0.1:8000/examples/global/vars/T>("End Time")),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('with_who',db.auth_user,label=T
<http://127.0.0.1:8000/examples/global/vars/T>("Guest"))
)
db.attender_appointment.title.requires=IS_NOT_EMPTY
<http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>()
db.attender_appointment.start_time.requires=IS_NOT_EMPTY
<http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>()
db.attender_appointment.event.requires=IS_IN_DB
<http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db,db.event.id,'%(name)s')
db.attender_appointment.floor_plan.requires=IS_IN_DB
<http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db,db.floor_plan.id,'%(name)s')
db.attender_appointment.user.requires=IS_IN_DB
<http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db,db.auth_user.id,'%(nickname)s')
db.attender_appointment.with_who.requires=IS_IN_DB
<http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db,db.auth_user.id,'%(nickname)s')
db.attender_appointment.details.widget=lambdafield,value:\
SQLFORM
<http://127.0.0.1:8000/examples/global/vars/SQLFORM>.widgets.text.widget(field,value,_class='text
nicedit',_style="color:red")
This is not the first one in the system to be created so it seems to
work for many other objects. I wonder if there is a reserved word or
something that is cause the problem.
Any ideas why this would happen?
BR,
Jason
