Ah, apologies. I was a little over-enthusiastic with my deletions.
So I did fake_migrate_all=True, let web2py create the tables, and then
turned off fake_migrations. However, web2py did not create a
web2py_session_runestone table file. All the other tables are there, just
no web2py_session_runestone.table. The sql.log file doesn't refer to it at
all.
~Cory
On Thursday, July 3, 2014 11:06:59 AM UTC-4, Niphlod wrote:
>
> who said "delete everything" ? :P
>
> now, do a fake_migrate_all=True, let web2py recreate table files, then
> turn off fake_migrations, then delete ONLY webp2y_session_runestone and
> retry.
>
> Simone
>
> On Thursday, July 3, 2014 11:30:35 AM UTC+2, Austin Bart wrote:
>>
>> Migrations should be on. I have it enabled through my DAL:
>> db = DAL(settings.database_uri, migrate_enabled=True)
>> And through each individual table:
>> db.define_table('courses', ... migrate='runestone_courses.table')
>> I've emptied the entire databases/ folder of all the .table files.
>>
>> This seems to have made the situation worst, since now I can't read error
>> tickets - clicking the link opens a new ticket. I've tried getting into my
>> application's errors/ files, and I see that this line is still in there:
>> Table \'runestone_dev.web2py_session_runestone\' doesn\'t exist
>> The latest error in the admin application's errors/ folder has this line:
>> can't pickle function objects
>>
>> ~Cory
>>
>> On Thursday, July 3, 2014 4:37:22 AM UTC-4, Niphlod wrote:
>>>
>>> did you turn migrations on ?
>>> if yes, please check that there isn't a *web2py_session_runestone*.table
>>> file into the database/ folder. If there is, delete it and web2py will
>>> recreate it.
>>>
>>> On Thursday, July 3, 2014 1:44:38 AM UTC+2, Austin Bart wrote:
>>>>
>>>> Recently after some updates to some of my models, I got this error in
>>>> web2py.
>>>>
>>>> Traceback (most recent call last):
>>>> File "/Users/acbart/web2py/gluon/main.py", line 457, in wsgibase
>>>> session._try_store_in_db(request, response)
>>>> File "/Users/acbart/web2py/gluon/globals.py", line 1116, in
>>>> _try_store_in_db
>>>> record_id = table.insert(**dd)
>>>> File "/Users/acbart/web2py/gluon/dal.py", line 9114, in insert
>>>> ret = self._db._adapter.insert(self, self._listify(fields))
>>>> File "/Users/acbart/web2py/gluon/dal.py", line 1360, in insert
>>>> raise eProgrammingError: (1146, u"Table
>>>> 'runestone_dev.web2py_session_runestone' doesn't exist")
>>>>
>>>> My web2py application is named runestone, and the database is named
>>>> runestone_dev. I've checked the MySQL database and the table doesn't
>>>> exist. But it is my understanding that this is a table that should be
>>>> automatically generated for me. Anyone know what gives? It doesn't appear
>>>> to be a problem with my code...
>>>>
>>>
--
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.
