Re: [web2py] Cannot Create Table Named "Items" - Already Exists

2016-09-01 Thread Yoel Benitez Fonseca
i don't know of "items" but "item" is not a keyword for Python or Web2py ... i'm using it right now in one of my projects: db.define_table('item', # item metadata Field('provider', 'string', length=100, default=''), Field('provider_service', 'string'), Field('pubstatus', 'string',

Re: [web2py] Cannot Create Table Named "Items" - Already Exists

2016-09-01 Thread Niphlod
items isn't a roblem for check_reserved. On Thursday, September 1, 2016 at 10:14:47 PM UTC+2, Richard wrote: > > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=reserved+word#Reserved-keywords > > Do you have it in your connection string? > > You should be

Re: [web2py] Cannot Create Table Named "Items" - Already Exists

2016-09-01 Thread Richard Vézina
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=reserved+word#Reserved-keywords Do you have it in your connection string? You should be notified that it a mysql reserved word... If not... Have you change database? New empty database sound like you restart

[web2py] Cannot Create Table Named "Items" - Already Exists

2016-09-01 Thread Brian Boatright
Is "items" a keyword for Python or Web2py? I'm using mysql and having web2py models file define a new table named "items" but it gives me an error that says the table already exists. If I change the name of the table to something like "items2" in the models.py file it works. The mysql