Found 1 bug. Need help w/2nd.

Um, this forum ate the code that I pasted in to example what is still being thrown as an error. Here is it entered again with line returns as it seems like it is just not showing it past the right side margin:

SELECT * FROM wp_categories
WHERE cat_ID > 0
AND link_count > 0
ORDER BY name ASC

This was solved.

In the theme “Blog Oh Blog” it had a line just below categories that read:

<?php wp_list_bookmarks(); ?>

That is what was throwing the error. I’m sure it’s a bug that needs fixing, but for my purposes, just taking the line of code out works for me.

If it’s a bug, it is in your theme.
Actually, the line you have deleted should be the correct template tag to be used with version 2.2.2 – if you updated to the latest.
See the deprecated and newly introduced template tags:
https://codex.www.ads-software.com/Template_Tags

We encountered this error and isolated the problem.

This is due to a bug in older versions of PHP.

parse_str() advertises that it will store variables in an array if an array is passed as the optional second parameter, INSTEAD of creating the variables in the current scope.

What we actually observed was that it created the array AS WELL AS creating the variables in the current scope.

This behavior causes the extract() call (with EXTR_SKIP) to NOT create the orderby variable because, due to the bug in parse_str() it already exists, and because EXTR_SKIP is specified, extract WILL NOT overwrite the value in the orderby variable.

Here is some code that exposes the problem:

<pre>
<?
$args = "type=link&orderby=name&order=ASC&hierarchical=0";
echo "Test string \$args = \"$args\"\n";
echo "\$orderby before call to parse_str() = $orderby\n";
echo "Calling parse_str(\"$args\", \$arr)\n";
parse_str($args, $arr);
echo "\$orderby after call to parse_str() = $orderby\n";
echo "\$arr = "; print_r ($arr); echo "\n\nAdd prefix to a value in \$arr array\n";
$arr['orderby'] = "cat_" . $arr['orderby'];
echo "\$arr = "; print_r ($arr); echo "\n\nCall extract(\$arr, EXTR_SKIP)\n";
extract($arr, EXTR_SKIP);
echo "\$arr = "; print_r ($arr); echo "\n";
echo "orderby after call to extract(\$arr, EXTR_SKIP) = $orderby\n";
?>
</pre>

NOTE: This bug has been fixed in later versions of PHP, so depending upon the version you are running, the code above may execute correctly (meaning parse_str() won’t create variables in scope)

If you are seeing this error:

[Unknown column ‘name’ in ‘order clause’]
SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY name ASC

then more than likely this is the problem. There are a few simple ways to work around this. We will post a fix later.

It might be informative to mention that we found the problem in the function get_categories() in wp-includes/category.php