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]> 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]. > 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.
