well, it will be fine until it can't find the file, creates it again blank.
http://stackoverflow.com/questions/14262771/why-am-i-suddenly-getting-operationalerror-no-such-table On Monday, May 5, 2014 3:12:31 PM UTC-7, Marin Pranjić wrote: > > default DAL configuration that is shipped with welcome app. > I also searched for solution but didn't find anything. > > sqlite path is fine. There are at least 10 queries in the same transaction > before this one breaks. > i have no idea what's wrong... > > > On Mon, May 5, 2014 at 11:40 PM, Derek <[email protected] <javascript:>>wrote: > >> What I've read says that you need to specify the full path to the sqlite >> data file or you will get this error. What's your db.py look like? >> >> >> On Monday, May 5, 2014 12:31:35 AM UTC-7, Marin Pranjić wrote: >> >>> I copied "broken" database locally so I can test it. >>> I also added print >>> here<https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1353>to get >>> actual queries. >>> >>> Queries are fine. Actually if I just c/p those queries into SQLite >>> Database Browser, it works (on the same database file). >>> >>> So it's not web2py, it's not sqlite, but it doesn't work. >>> >>> -__- >>> >>> >>> >>> On Mon, May 5, 2014 at 9:05 AM, Marin Pranjić <[email protected]>wrote: >>> >>>> Well, nothing unusual with my table definitions. Everything by the >>>> specs. >>>> I just removed all .table files and started with new sqlite file, and >>>> that problem is gone. >>>> (i still have copies) >>>> >>>> Seems that files were stuck in some state. >>>> >>>> However, main.message error still confuses me, because sql query that's >>>> created by DAL is valid. >>>> And this happens even after migrations are fixed. >>>> >>>> So it's probably SQLite that's broken/corrupted and I'm not sure if >>>> those issues are somehow related. >>>> >>>> Marin >>>> >>>> >>>> >>>> >>>> On Sun, May 4, 2014 at 8:58 PM, Niphlod <[email protected]> wrote: >>>> >>>>> how are your table defined ? the fact that 'main.message' gets into >>>>> the error seems a little weird for a table named "message_receiver". >>>>> Also, >>>>> that "success" repeated into sql.log means that something really strange >>>>> is >>>>> going on with your migrations. >>>>> >>>>> >>>>> On Sunday, May 4, 2014 3:22:19 PM UTC+2, Marin Pranjić wrote: >>>>> >>>>>> To confirm... >>>>>> https://github.com/web2py/web2py/blob/master/gluon/dal.py#L1262 >>>>>> >>>>>> This gets executed on every request. >>>>>> >>>>>> However I still don't understand why sqlite fails on insert. >>>>>> >>>>>> It fails on testing server but it works on my local instance. >>>>>> >>>>>> Marin >>>>>> >>>>>> >>>>>> On Sun, May 4, 2014 at 3:13 PM, Marin Pranjić >>>>>> <[email protected]>wrote: >>>>>> >>>>>>> Hi. >>>>>>> >>>>>>> I have application hosted on EC2. It is a testing server. It's like >>>>>>> production environment except it uses SQLite. >>>>>>> >>>>>>> I have a table called message_receiver. When I fetch records (for >>>>>>> ex. in appadmin) it works, but when I try to insert something (appadmin >>>>>>> or >>>>>>> in-app) i get the following error: >>>>>>> >>>>>>> OperationalError: no such table: main.message >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> I got the actual SQL query from the error ticket: >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> INSERT INTO message_receiver(time_seen,user_id,message_id) VALUES >>>>>>> (NULL,93,1); >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> That seems correct. >>>>>>> >>>>>>> However, I noticed that my sql.log is bigger than sqlite database file. >>>>>>> It has lots of "success!" messages inside. >>>>>>> And it seems that migration for some tables is triggered on every >>>>>>> request but nothing changes in .table files. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> There are 6 tables that are affected by migration but I don't see a >>>>>>> pattern. >>>>>>> >>>>>>> Can someone suggest how to trace/debug 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. >>>>>>> >>>>>> >>>>>> -- >>>>> 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] <javascript:>. >> 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.
