After truncate the table did you db.commit()? On Sunday, 17 August 2014 23:17:29 UTC-5, Giacomo Dorigo wrote: > > I don't know, > for some reason it does not leave me submit the ticket: > > Windows 8 > web2py : > 2.9.5-stable+timestamp.2014.03.16.02.35.39 > (Running on Rocket 1.2.6, Python 2.7.7) > > What steps will reproduce the problem? > 1. run web2py from source code from a .bat file python > path_to_web2py/web2py.py > 2. at same time run an other instance of web2py from terminal so: > path_to_web2py/web2py.py -S myapp -M > 3. start to interact with the db api from the online shell (not from the > command line) > 4. insert some records > 5. truncate the table > 6. insert new records > > =>> check the table, the old inserts had been repeated again > > What is the expected output? > only the new inserts should have been inserted > > > On Sun, Aug 17, 2014 at 6:18 AM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> https://code.google.com/p/web2py/issues/entry >> >> >> On Saturday, 16 August 2014 23:08:36 UTC-5, Giacomo Dorigo wrote: >>> >>> OK, how do I open a ticket? >>> >>> >>> On Wed, Aug 13, 2014 at 8:04 PM, Massimo Di Pierro < >>> massimo.dipie...@gmail.com> wrote: >>> >>>> Please open a ticket about this. This is a major issue. Perhaps we >>>> should remove the web based shell. >>>> >>>> >>>> On Wednesday, 13 August 2014 02:41:17 UTC-5, Giacomo Dorigo wrote: >>>>> >>>>> Today I discovered an other problem with the admin shell. >>>>> If I execute command 1 >>>>> and then command 2, at this point it will re-execute command 1 too. >>>>> If then I execute command 3, it will execute again also 1 and 2. >>>>> >>>>> This is while running web2py from source code on Windows with simple >>>>> python web2py.py >>>>> >>>>> >>>>> >>>>> On Saturday, April 6, 2013 6:09:40 AM UTC+2, Massimo Di Pierro wrote: >>>>>> >>>>>> The admin shell has problems maintaining state. I do not consider it >>>>>> reliable. The terminal shell is rock solid. It is a normal pyhton shell. >>>>>> >>>>>> On Friday, 5 April 2013 16:48:50 UTC-5, Michael Herman wrote: >>>>>>> >>>>>>> yes. so when working with DAL directly from the shell it's better to >>>>>>> work from the web2py shell in the terminal rather than the admin app >>>>>>> shell? any idea why? >>>>>>> >>>>>>> On Fri, Apr 5, 2013 at 2:43 PM, Anthony <abas...@gmail.com> wrote: >>>>>>> > >>>>>>> > By "built-in" shell, do you mean the one in the admin app? I think >>>>>>> there are sometimes problems with that (particularly with database >>>>>>> operations), so I tend to use the web2py shell in the terminal, which >>>>>>> you >>>>>>> can start as follows from the web2py directory: >>>>>>> > >>>>>>> > python web2py.py -S yourapp/[optional controller] -M >>>>>>> > >>>>>>> > But you may fine the admin shell works just fine for you, in which >>>>>>> case, use it. >>>>>>> > >>>>>>> > Anthony >>>>>>> > >>>>>>> > >>>>>>> > On Friday, April 5, 2013 4:57:49 PM UTC-4, Michael Herman wrote: >>>>>>> >> >>>>>>> >> i remember reading somewhere that it's better to use the built-in >>>>>>> shell in web2py, but i can't find the article/post. anyone know (1) if >>>>>>> it >>>>>>> is "better", and, (2) if so, why? >>>>>>> > >>>>>>> > -- >>>>>>> > >>>>>>> > --- >>>>>>> > You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "web2py-users" group. >>>>>>> > To unsubscribe from this topic, visit https://groups.google.com/d/ >>>>>>> topic/web2py/XWMt1Pb_2wk/unsubscribe?hl=en. >>>>>>> > To unsubscribe from this group and all its topics, send an email >>>>>>> to web2py+un...@googlegroups.com. >>>>>>> > For more options, visit https://groups.google.com/groups/opt_out. >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> -- >>>> 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 a topic in the >>>> Google Groups "web2py-users" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>> topic/web2py/XWMt1Pb_2wk/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> web2py+unsubscr...@googlegroups.com. >>>> 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 a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/XWMt1Pb_2wk/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+unsubscr...@googlegroups.com. >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.