Newsgroups: php.internals,php.internals Path: news.php.net Xref: news.php.net php.internals:37906 php.internals:37907 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 85384 invoked from network); 26 May 2008 20:40:19 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 26 May 2008 20:40:19 -0000 Authentication-Results: pb1.pair.com smtp.mail=jani.taskinen@sci.fi; spf=permerror; sender-id=unknown Authentication-Results: pb1.pair.com header.from=jani.taskinen@sci.fi; sender-id=unknown Received-SPF: error (pb1.pair.com: domain sci.fi from 63.208.196.178 cause and error) X-PHP-List-Original-Sender: jani.taskinen@sci.fi X-Host-Fingerprint: 63.208.196.178 mho-01-bos.mailhop.org Received: from [63.208.196.178] ([63.208.196.178:63973] helo=mho-01-bos.mailhop.org) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 8B/20-18531-1302B384 for ; Mon, 26 May 2008 16:40:18 -0400 Received: from cs78255253.pp.htv.fi ([62.78.255.253] helo=[127.0.0.1]) by mho-01-bos.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.68) (envelope-from ) id 1K0jDT-0000sw-DD; Mon, 26 May 2008 20:22:47 +0000 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 62.78.255.253 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: U2FsdGVkX18wmS1c/PvUdyVvnfqtPpM0SMoGeR0YlKQ= Message-ID: <483B1C19.6000205@sci.fi> Date: Mon, 26 May 2008 23:22:49 +0300 Reply-To: jani.taskinen@iki.fi User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Rasmus Lerdorf CC: internals Mailing List References: <483B16C1.7050907@sci.fi> <483B178E.9010106@lerdorf.com> <483B18A4.7010401@sci.fi> <483B19DD.4060800@lerdorf.com> In-Reply-To: <483B19DD.4060800@lerdorf.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Can not delete comments in bug reports From: jani.taskinen@sci.fi (Jani Taskinen) Rasmus Lerdorf kirjoitti: > Jani Taskinen wrote: >> Rasmus Lerdorf kirjoitti: >>> 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?) > > I upgraded and repaired all the tables, but I'll run it again. It is > reporting back: > > | 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? Got another one: "Some sort of database error has happened. Maybe this will be illuminating: Incorrect key file for table './phpbugdb/bugdb.MYI'; try to repair it This was the last query attempted: UPDATE bugdb SET sdesc='wddx_add_vars() does not convert variable names to UTF8', status='Open', bug_type='WDDX related', assign='', php_version='5.2.6', php_os='Windows', ts2=NOW() WHERE id=45037" While updating a report..the other query (deleting comment) that didn't work, worked now. :) --Jani