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