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