Menu
▾
▴
#2423 (ok 2.10.2) deleting records freezes
fixed
1
2013-06-11
2007-05-04
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.
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)
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).
Logged In: YES
user_id=1383652
Originator: NO
sorry, my last comment was for a different thread
never mind.
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?
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
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 ©
----
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 ;)