Menu

#2423 (ok 2.10.2) deleting records freezes

2.10.1
fixed
1
2013-06-11
2007-05-04
William
No

when i try to delete records the page has the "loading" thing going but it eventualy times out.. yet the records are deleted.

at the moment to delete records i click delete then "yes" then click on the table name on the left bar. the records get deleted but the page somehow doesnt go back to the default. looks like a never ending loop. once again i think this is caused by the fact that i use $cfg['DefaultTabTable'] = 'sql.php'; it probably tried to run the last sql issued again.. and since the last sql was the delete it tries to run that yet the records were already deleted and so goes into the whole loop thing

im using the latest PMA 2.10.1 yet this bug has been in PMA for a while already.

Discussion

  • Jürgen Wind

    Jürgen Wind - 2007-05-04

    Logged In: YES
    user_id=1383652
    Originator: NO

    works well on http://pma.cihar.com/STABLE/
    since nobody else reported this error, it must be your php installation (IMHO)

     
  • Jürgen Wind

    Jürgen Wind - 2007-05-04

    Logged In: YES
    user_id=1383652
    Originator: NO

    Confirmed, sorry for not understanding your problem at first.
    You need to have any character in the textfield to get rid of those four \n.
    There are more important things to fix/improve (jmho).

     
  • Jürgen Wind

    Jürgen Wind - 2007-05-04

    Logged In: YES
    user_id=1383652
    Originator: NO

    sorry, my last comment was for a different thread
    never mind.

     
  • Marc Delisle

    Marc Delisle - 2007-05-06

    Logged In: YES
    user_id=210714
    Originator: NO

    I cannot reproduce this problem. Here is what I do:
    I set $cfg['DefaultTabTable'] = 'sql.php';
    I browse a table then tick 3 records. Then "with selected... delete".
    I get a page listing those records and click Yes.
    Records are deleted and I'm back to the browse table.

    I also tried to delete just one record with the red X: all is fine.

    Which PHP version? Which browser?

     
  • Marc Delisle

    Marc Delisle - 2007-05-06
    • assigned_to: nobody --> lem9
    • milestone: 713394 -->
    • labels: 509096 --> 509108
    • status: open --> pending
     
  • William

    William - 2007-05-06

    Logged In: YES
    user_id=1671112
    Originator: YES

    o ok.. sorry.. i noticed after i posted the bug that i managed to delete and it went back to the records. was planning on further testing it cause it definately hangs on certain occasions.. (finaly back from a hockey match) ive gone into PMA. it hangs if you sellect ALL the records. like if there are 2 left and you check them and click delete (the way you tried to replocate)

    seeing as i doubt anyone would be using PMA to delete ALL the records in a table too often i can now see why there arent any other bug reports with this.

    (i develop application websites so use PMA tomanipulate the data till i have the "admin" side of the site done so i delete all the records quite often)

    browser IE7 and OPERA 9.2.
    php version 5.1.4

     
  • William

    William - 2007-05-06
    • status: pending --> open
     
  • Jürgen Wind

    Jürgen Wind - 2007-05-06

    Logged In: YES
    user_id=1383652
    Originator: NO

    I was able to reproduce when only two records were left
    (opera9, php 5.22, w2k), got this html page (http://127.0.0.1/07PMA/Pma210/tbl_row_action.php):
    ----
    Redirection Status
    The URL was redirected to http://127.0.0.1/07PMA/Pma210/sql.php?db=Dummy&table=meldg&server=9
    &token=3a8df1fea99f5acc4ba797d6921d4008&pos=0
    &sql_query=SELECT+%2A+FROM+%60meldg%60&message=MySQL+returned+an+empty+result+set+%28i.e.+zero+rows%29.+%28Query+took+0.0008+sec%29.
    Please click the link to go there.
    You can enable the automatic redirection in the settings.
    Generated by Opera ©
    ----

     
  • Jürgen Wind

    Jürgen Wind - 2007-05-06

    Logged In: YES
    user_id=1383652
    Originator: NO

    seamonkey (mozilla) tells me this:
    ----
    Redirect Loop

    Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked.

    The browser has stopped trying to retrieve the requested item. The site is redirecting the request in a way that will never complete.

    * Have you disabled or blocked cookies required by this site?
    * NOTE: If accepting the site's cookies does not resolve the problem, it is likely a server configuration issue and not your computer.
    ----
    (cookies are not blocked ;)

     
  • Marc Delisle

    Marc Delisle - 2007-05-07
    • assigned_to: lem9 --> nobody
    • labels: 509108 --> Data insertion/extraction/manipulation
     
  • Marc Delisle

    Marc Delisle - 2007-05-09
    • milestone: --> 2.10.1
     
  • Marc Delisle

    Marc Delisle - 2007-05-09
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-05-09
    • priority: 5 --> 1
    • summary: deleting records freezes --> (ok 2.10.2) deleting records freezes
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-06-15
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed