“Categorical Links Page” plugin not working!? Not working in 2.1, or…?

Thanks for your response, but I get an error. I deactivated the plugin, changed the text and re-uploaded the file (was worried about line breaks in the plugin editor), and activated the plugin. Now I get the following error at http://growandknow.com/learning/?page_id=12:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .te]
SELECT DISTINCT .term_id AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .term_id AND .taxonomy = ‘link_category’

I re-pasted it in, but still just an error. Here is the error:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .te]
SELECT DISTINCT .term_id AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .term_id AND .taxonomy = ‘link_category’

Here is what the plugin has now:

<?php
/*
Plugin Name: Categorical Links Page
Plugin URI: http://www.alucinari.net/wordpress
Description:  Output links seperated by categories onto a static page (Based on Links Page (http://www.asymptomatic.net/wp-hacks) by Owen Winkler.)
Version: 1.1
Author: Jeremy Albrecht
Author URI: http://www.alucinari.net/
*/
?>
<?php
/*

INSTRUCTIONS
------------
1. Upload this file into your wp-content/plugins directory.
2. Activate the Links Page with Categories plugin in your WordPress admin panel.
3. Create a new static page.
4. Add <!--catlinkspage--> to the static page content where you want the links
to appear.

Enjoy!

*/
?>
<?php

define('LINK_USE_UL', false);

function catlinks_page_callback()
{
	global $wpdb;
	$output = '';
	$linkcats = $wpdb->get_results("SELECT DISTINCT $wpdb->terms.term_id AS cat_id, name AS cat_name FROM $wpdb->terms INNER JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id AND $wpdb->term_taxonomy.taxonomy = 'link_category'");
	$output .= '<div class="catlinkspage">';
	foreach($linkcats as $cat)
	{
    $links = get_links($cat->cat_id, '<li class="clplink">', '</li>', '<br /> >> ', true, 'name', true, false, -1, true, false);
    if($links)
    {
      $output .= '<h2 class="clplinkcategory">' . $cat->cat_name . '</h2> ';
      $output .= '<ul class="clplinklist"> ';
      $output .= $links;
      $output .= '</ul> ';
    }
    else
    {
      $output .= '';
    }
	}
  $output .= '</div>';
	return $output;
}

function catlinks_page($content)
{
  if ( strpos($content, '<!--catlinkspage-->') !== false ) $content = catlinks_page_callback();
  return $content;
}

add_filter('the_content', 'catlinks_page');

?>

I appreciate your help. I downloaded your version of the file and replaced it — tried deactivating other plugins, etc. I’m sorry but I continue getting the error:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .te]
SELECT DISTINCT .term_id AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .term_id AND .taxonomy = ‘link_category’

Any ideas on what can be done?

Thank you for your response Kafkaesqui. I still get the error at http://growandknow.com/learning/?page_id=12:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .te]
SELECT DISTINCT .term_id AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .term_id AND .taxonomy = 'link_category'

Is it possible there is something wrong with my databases or install? The site seems to work well otherwise.

nouman6, thanks for the code(poetry). I replaced the previous file with the code above, yet still got the following (located at http://growandknow.com/learning/?page_id=12 :

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .te]
SELECT DISTINCT .term_id AS cat_id, name AS cat_name FROM INNER JOIN ON .term_id = .term_id AND .taxonomy = 'link_category'

I upgraded to 2.3.1. With the different versions, here’s what I get at http://growandknow.com/learning/?page_id=12 :

– With nouman6’s version, no content appears (including text).
– With Kafkaesqui’s downloadable version, again no content appears.
– Kaf’s fix that MichaelH posted, no content either.
– With the original plugin, available for download from the WordPress site, I get the error:

WordPress database error: [Table 'anyth1n6.wp_categories' doesn't exist]
SELECT DISTINCT cat_id, cat_name FROM wp_categories

FWIW, the “Code” view of the page’s entry actually reads:

This: "<!--catlinkspage-->" is pasted in the Code content below.

<!--catlinkspage-->

<code><!--catlinkspage--></code>

I’m sorry, I feel completely idiotic at this point. Is there another plugin that does the same/similar?