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', length=10, default='usable'),
Field('embargoed', 'datetime', default=None),
....
2016-09-01 17:11 GMT-04:00 Niphlod <[email protected]>:
> 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 notified that it a mysql reserved word...
>>
>> If not... Have you change database? New empty database sound like you
>> restart database from scratch... web2py keep track of migration of models
>> you have to migrate=false fake_migrate=true then back to migrate=true to
>> allow web2py to sync with the database...
>>
>>
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=fake_migrate#migrate--fake_migrate
>>
>> Richard
>>
>> On Thu, Sep 1, 2016 at 3:52 PM, Brian Boatright <[email protected]> wrote:
>>>
>>> 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 database is empty of tables before this is run and I've
>>> confirmed there is no items table before it tries to run the models.py file.
>>> I can create a table manually named items so it isn't specific to MySQL
>>> database.
>>>
>>> Thanks for any help.
>>>
>>> --
>>> 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 [email protected].
>>> For more options, visit https://groups.google.com/d/optout.
>>
>>
> --
> 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 [email protected].
> For more options, visit https://groups.google.com/d/optout.
--
Yoel Benítez Fonseca
http://redevil.cubava.cu/
$ python -c "import this"
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
