Re: Can not delete comments in bug reports
| From: | Rasmus Lerdorf | Date: | Mon, 26 May 2008 20:13:17 +0000 |
| Subject: | Re: Can not delete comments in bug reports | ||
| References: | 1 2 3 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-37905@lists.php.net to get a copy of this message | ||
Jani Taskinen wrote:
Rasmus Lerdorf kirjoitti:I upgraded and repaired all the tables, but I'll run it again. It is reporting back:Jani Taskinen wrote::)So who broke the deleting of comments in bug reports? It used to work fine, now nothing happens..Is that your way of filing a bug report?I upgraded from MySQL 4.1.x to 5.1.x because 4.1 was very unstable for some reason. It seems more stable now, but perhaps the delete query is doing something weird that 5.1 doesn't like.Actually I just noticed that this only happens with some comments, not all..maybe that table needs some loving care of "REPAIR TABLE"..? (or even all the tables?)
| phpbugdb.bugdb_comments | repair | status | OK |The code is:
$query = "DELETE FROM bugdb_comments WHERE bug=$id AND id=$com_id";
$res = @mysql_query($query);
I've removed the @ there. Could you try again on one that didn't work before and let me know what error you see?
-R