Reserved SQL keyword in use

rif / web2admin

web2py administration plugin

26 stars 10 forks source link

Closed rochacbruno closed 12 years ago

rochacbruno commented 12 years ago

if you turn DAL(..., check_reserved=['all'])

<type 'exceptions.SyntaxError'> invalid table/column name "action" is a "ALL" reserved SQL keyword

File /home/bcr/projects/web2py210/applications/smtc/models/plugin_web2admin/plugin_web2admin.py in at line 71

Code listing

w2a_db = cdb() w2a_def_db = cdb(0)

w2a_def_db.define_table('plugin_web2admin_history', Field('action'), auth.signature

) w2a_history = w2a_def_db.plugin_web2admin_history

def action_dispatch(table, ids, action):

rif commented 12 years ago

Renamed it to w2a_action, thank you for detailed description.

Please Close the issue if it works for you.

rif commented 12 years ago

Hopefully is fixed.