What is the file that locally stores the databases/tables contents when using GAE devserver? I would like to delete it (without re-installing) and start from scratch to see if this is due to a local issue.
-Miguel On Fri, Feb 26, 2010 at 11:58 AM, Miguel Goncalves < [email protected]> wrote: > Hi > > I just downloaded the new version (1.75.5) and it is still happening :( > > -Miguel > > > > On Fri, Feb 26, 2010 at 12:12 AM, mdipierro <[email protected]>wrote: > >> I am a bit confused myself and I have low bandwidth to search the >> thread. Please let me know if there is a problem still. >> >> On Feb 26, 2:03 am, Miguel Goncalves <[email protected]> >> wrote: >> > I just saw that 1.75.5 is out. >> > Since it has : "fixed problem with GAE deleted by id (thanks what_ho)" >> > >> > Do you think it is related or is this to fix the count vs len issue? >> > >> > In any case I will try it tomorrow morning. >> > >> > Thanks >> > Miguel >> > >> > On Thu, Feb 25, 2010 at 3:33 PM, Miguel Goncalves < >> [email protected] >> > >> > > wrote: >> > > Hi >> > >> > > I attached a modified "welcome" application that reproduces the >> problem. >> > >> > > To repro: >> > > - create a user >> > > - login >> > > - click on the "list Stats" link (top left of the page) >> > > - add few stats. You will see the stats you add get listed on the same >> > > page. >> > > - click on the link "Delete stat" >> > > You should now see the error. >> > >> > > Thanks >> > > Miguel >> > >> > > On Tue, Feb 23, 2010 at 8:32 PM, mdipierro <[email protected] >> >wrote: >> > >> > >> I think: >> > >> > >> 1. Run "appcfg.py vacuum_indexes your_app_dir/" >> > >> 2. Run "appcfg.py update_indexes your_app_dir/" >> > >> > >> On Feb 23, 10:23 pm, Miguel Goncalves <[email protected]> >> > >> wrote: >> > >> > How do I do that? >> > >> > >> > On Tue, Feb 23, 2010 at 7:09 PM, mdipierro < >> [email protected]> >> > >> wrote: >> > >> > > I would try delete and rebuild indices. >> > >> > >> > > On Feb 23, 7:54 pm, Miguel Goncalves <[email protected]> >> > >> > > wrote: >> > >> > > > Yes I tried to upload it to GAE but I ran into the missing >> indexes >> > >> issue. >> > >> > > So >> > >> > > > I was trying to run the app locally to generate the required >> indexes >> > >> and >> > >> > > be >> > >> > > > able to run on the live GAE. :( >> > >> > >> > > > I have the issue on the dev server. This used to work and I >> have no >> > >> clue >> > >> > > > what could have broken it. I believe the only thing I did was >> to >> > >> update >> > >> > > GAE >> > >> > > > to the latest sdk. >> > >> > >> > > > Debugging the app a little bit further I found the place where >> the >> > >> > > exception >> > >> > > > is raised: >> > >> > >> > > > class Table >> > >> > > > def __delitem__(self, key): >> > >> > > > if not str(key).isdigit() or not self._db(self.id == >> > >> > > key).delete(): >> > >> > > > raise SyntaxError, 'No such record: %s' % key >> > >> > >> > > > However the table does contain a record equal to key. >> > >> > > > What gives? >> > >> > >> > > > Thanks >> > >> > > > Miguel >> > >> > >> > > > On Tue, Feb 23, 2010 at 11:04 AM, Wes James < >> [email protected]> >> > >> wrote: >> > >> > > > > Have you uploaded your app to gae and tested it there? >> > >> > >> > > > > -wes >> > >> > >> > > > > On Tue, Feb 23, 2010 at 10:57 AM, Miguel Goncalves >> > >> > > > > <[email protected]> wrote: >> > >> > > > > > Anybody run into a similar issue? >> > >> > > > > > I cannot seem to figure it out. :( >> > >> > >> > > > > > Thanks >> > >> > > > > > -Miguel >> > >> > >> > > > > > On Mon, Feb 22, 2010 at 6:09 PM, Miguel < >> > >> [email protected]> >> > >> > > > > wrote: >> > >> > >> > > > > >> Hi >> > >> > >> > > > > >> I implemented the following function to delete an entry in >> a >> > >> db: >> > >> > >> > > > > >> @auth.requires_login() >> > >> > > > > >> def DeleteSite(): >> > >> > > > > >> msg = T("Cannot delete specified record.") >> > >> > > > > >> try: >> > >> > > > > >> record_id = request.vars['id'] >> > >> > > > > >> next_page = request.vars['next'] >> > >> > > > > >> except: >> > >> > > > > >> response.flash = msg >> > >> > > > > >> return dict( message=msg) >> > >> > >> > > > > >> if record_id is None or next_page is None or >> > >> len(next_page) >> > >> > > == 0: >> > >> > > > > >> response.flash = msg >> > >> > > > > >> return dict( message=msg) >> > >> > >> > > > > >> crud.delete(db.sites,record_id, >> > >> > > next=URL(r=request,f=next_page)) >> > >> > >> > > > > >> It gets invoked like this (local server on GAE): >> > >> > >>http://127.0.0.1:8081/mlinks/default/DeleteSite?id=388&next=MySites >> > >> > >> > > > > >> This used to work nicely however now when this gets >> invoked, >> > >> the >> > >> > > item >> > >> > > > > >> gets deleted from the database BUT I get a ticket error: >> > >> > >> > > > > >> Error traceback >> > >> > >> > > > > >> Traceback (most recent call last): >> > >> > > > > >> File "C:\web2py\gluon\restricted.py", line 173, in >> restricted >> > >> > > > > >> exec ccode in environment >> > >> > > > > >> File "C:\web2py\applications\mlinks/controllers/ >> > >> > > > > >> default.py:DeleteSite", line 164, in <module> >> > >> > > > > >> File "C:\web2py\gluon\globals.py", line 96, in <lambda> >> > >> > > > > >> self._caller = lambda f: f() >> > >> > > > > >> File "C:\web2py\gluon\tools.py", line 1848, in f >> > >> > > > > >> return action(*a, **b) >> > >> > > > > >> File "C:\web2py\applications\mlinks/controllers/ >> > >> > > > > >> default.py:DeleteSite", line 130, in DeleteSite >> > >> > > > > >> File "C:\web2py\gluon\tools.py", line 2377, in delete >> > >> > > > > >> del table[record_id] >> > >> > > > > >> File "C:\web2py\gluon\sql.py", line 1545, in __delitem__ >> > >> > > > > >> raise SyntaxError, 'No such record: %s' % key >> > >> > > > > >> SyntaxError: No such record: 388 >> > >> > >> > > > > >> Before invoking the delete I made sure the entry I wanted >> to >> > >> delete >> > >> > > > > >> was indeed in the DB. >> > >> > > > > >> After the error the correct entry has been deleted. >> > >> > >> > > > > >> It is like the delete is being called twice! >> > >> > > > > >> Any idea of what might be causing this? >> > >> > >> > > > > >> thanks >> > >> > > > > >> Miguel >> > >> > >> > > > > >> -- >> > >> > > > > >> You received this message because you are subscribed to >> the >> > >> Google >> > >> > > > > Groups >> > >> > > > > >> "web2py-users" group. >> > >> > > > > >> To post to this group, send email to >> [email protected]. >> > >> > > > > >> To unsubscribe from this group, send email to >> > >> > > > > >> [email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > > > . >> > >> > > > > >> For more options, visit this group at >> > >> > > > > >>http://groups.google.com/group/web2py?hl=en. >> > >> > >> > > > > > -- >> > >> > > > > > You received this message because you are subscribed to the >> > >> Google >> > >> > > Groups >> > >> > > > > > "web2py-users" group. >> > >> > > > > > To post to this group, send email to >> [email protected]. >> > >> > > > > > To unsubscribe from this group, send email to >> > >> > > > > > [email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > > > . >> > >> > > > > > For more options, visit this group at >> > >> > > > > >http://groups.google.com/group/web2py?hl=en. >> > >> > >> > > > > -- >> > >> > > > > You received this message because you are subscribed to the >> Google >> > >> > > Groups >> > >> > > > > "web2py-users" group. >> > >> > > > > To post to this group, send email to [email protected] >> . >> > >> > > > > To unsubscribe from this group, send email to >> > >> > > > > [email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > > > . >> > >> > > > > For more options, visit this group at >> > >> > > > >http://groups.google.com/group/web2py?hl=en. >> > >> > >> > > -- >> > >> > > You received this message because you are subscribed to the >> Google >> > >> Groups >> > >> > > "web2py-users" group. >> > >> > > To post to this group, send email to [email protected]. >> > >> > > To unsubscribe from this group, send email to >> > >> > > [email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> <web2py%[email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> > >> > > . >> > >> > > For more options, visit this group at >> > >> > >http://groups.google.com/group/web2py?hl=en. >> > >> > >> -- >> > >> You received this message because you are subscribed to the Google >> Groups >> > >> "web2py-users" group. >> > >> To post to this group, send email to [email protected]. >> > >> To unsubscribe from this group, send email to >> > >> [email protected]<web2py%[email protected]> >> <web2py%[email protected]<web2py%[email protected]> >> > >> > >> . >> > >> For more options, visit this group at >> > >>http://groups.google.com/group/web2py?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<web2py%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/web2py?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
