Bug#310534: acknowledged by developer ([m@mullenweg.com: Re: [debian-bugs@po8.org: Bug#310534: wordpress: does not handle article visibility correctly]])

2005-05-25 Thread Bart Massey 
Oops.   That's what I get for sending bug reports in the
middle of the night.  My apologies for the confusion.

Bart Massey
[EMAIL PROTECTED]

References: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
Comments: In-reply-to [EMAIL PROTECTED] (Debian Bug Tracking System)
   message dated Tue, 24 May 2005 20:48:08 -0700.

In message [EMAIL PROTECTED] you wrote:
 This is an automatic notification regarding your Bug report
 #310534: wordpress: does not handle article visibility correctly,
 which was filed against the wordpress package.
 
 It has been closed by one of the developers, namely
 Kai Hendry [EMAIL PROTECTED].
 
 Their explanation is attached below.  If this explanation is
 unsatisfactory and you have not received a better one in a separate
 message then please contact the developer, by replying to this email.
 
 Debian bug tracking system administrator
 (administrator, Debian Bugs database)
 
 Received: (at 310534-done) by bugs.debian.org; 25 May 2005 03:37:16 +
 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-9s-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]

Bug#310534: wordpress: does not handle article visibility correctly

2005-05-24 Thread Bart Massey 
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.0 -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-6versatile, 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


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]