Your message dated Wed, 25 May 2005 04:37:32 +0100
with message-id <[EMAIL PROTECTED]>
and subject line [EMAIL PROTECTED]: Re: [EMAIL PROTECTED]: Bug#310534:
wordpress: does not handle article visibility correctly]]
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 24 May 2005 08:19:32 +0000
>From [EMAIL PROTECTED] Tue May 24 01:19:32 2005
Return-path: <[EMAIL PROTECTED]>
Received: from bartm.dsl.pdx.spiretech.com (po8.org) [207.173.201.99]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DaUdQ-00081z-00; Tue, 24 May 2005 01:19:32 -0700
Received: from bart by po8.org with local (Exim 4.50 #1 (Debian))
id 1DaUdN-0001PB-DE; Tue, 24 May 2005 01:19:29 -0700
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Bart Massey <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: wordpress: does not handle article visibility correctly
X-Mailer: reportbug 3.12
Date: Tue, 24 May 2005 01:19:29 -0700
Message-Id: <[EMAIL PROTECTED]>
Sender: Bart Massey <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Package: wordpress
Version: 1.5.1-1
Severity: normal
Tags: patch
Our wordpress installation (at http://bart-massey.com and
http://bart-massey.com/uplift/) is a bit complex. After
cleaning up some cruft that was probably our fault in
/etc/wordpress and /etc/apache/conf.d/wordpress, the latest
upgrade still didn't work quite right: hitting the front
page (at http://bart-massey.com/uplift/) and/or pushing the
home button (at the same URL) caused an SQL query error
because the CAT_id field was missing. After some onerous
debugging, I found that a couple of fields were misnamed in
visible.php --- renaming them fixed our problem.
No idea whether this is also an upstream problem. A quick
grep through the source found a couple of other places where
the same bug probably occurs, so this patch is not
necessarily exhaustive.
--- wp-content/plugins/visible.php.dist 2005-04-07 11:32:41.000000000 -0700
+++ wp-content/plugins/visible.php 2005-05-24 00:56:38.017837540 -0700
@@ -211,10 +211,10 @@
if($categories = get_the_category($post->ID)) {
foreach ($categories as $category) {
if(isset ($q['feed'])) {
- if($wpdb->query("SELECT cat_ID FROM
cat_visibility WHERE cat_ID=$category->category_id AND feed=1")) {
+ if($wpdb->query("SELECT cat_ID FROM
cat_visibility WHERE cat_ID=$category->cat_ID AND feed=1")) {
$visible = 1;
}
- } elseif ($wpdb->query("SELECT cat_ID FROM
cat_visibility WHERE cat_ID=$category->category_id AND front=1")) {
+ } elseif ($wpdb->query("SELECT cat_ID FROM
cat_visibility WHERE cat_ID=$category->cat_ID AND front=1")) {
$visible = 1;
}
}
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.10
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Versions of packages wordpress depends on:
ii apache [httpd] 1.3.33-6 versatile, high-performance HTTP s
ii mysql-server [virtual-mysql- 4.0.24-10 mysql database server binaries
ii php4 4:4.3.10-15 server-side, HTML-embedded scripti
ii php4-mysql 4:4.3.10-15 MySQL module for php4
-- no debconf information
---------------------------------------
Received: (at 310534-done) by bugs.debian.org; 25 May 2005 03:37:16 +0000
>From [EMAIL PROTECTED] Tue May 24 20:37:16 2005
Return-path: <[EMAIL PROTECTED]>
Received: from host-83-146-8-59.bulldogdsl.com (bible) [83.146.8.59]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Damho-0005J4-00; Tue, 24 May 2005 20:37:16 -0700
Received: from hendry by bible with local (Exim 4.50)
id 1Dami4-00009s-Pg; Wed, 25 May 2005 04:37:32 +0100
Date: Wed, 25 May 2005 04:37:32 +0100
From: Kai Hendry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [EMAIL PROTECTED]: Re: [EMAIL PROTECTED]: Bug#310534: wordpress: does
not handle article visibility correctly]]
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.9i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-4.5 required=4.0 tests=BAYES_10,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Not a bug relating to the Debian package of Wordpress.
Thank you Matt. In future I'll vet these bug reports a bit better. :)
----- Forwarded message from Matthew Mullenweg <[EMAIL PROTECTED]> -----
From: Matthew Mullenweg <[EMAIL PROTECTED]>
To: Kai Hendry <[EMAIL PROTECTED]>
Subject: Re: [EMAIL PROTECTED]: Bug#310534: wordpress: does not handle
article visibility correctly]
Date: Tue, 24 May 2005 20:17:58 -0700
Kai Hendry wrote:
>because the CAT_id field was missing. After some onerous
>debugging, I found that a couple of fields were misnamed in
>visible.php --- renaming them fixed our problem.
There is nothing included with WordPress called visible.php, it must be
an unsupported third-party plugin that was added in.
--
Matt Mullenweg
http://photomatt.net | http://wordpress.org
http://pingomatic.com | http://cnet.com
----- End forwarded message -----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
