WordPress.org

1. prezmcmahon
   Member
   Posted 5 years ago #

   I have a links page that points to my blogroll to supply the link content.

   It works by the use of a plugin that allows running php in a post. So i run:

   <phpcode><!--p get_links_list();--></phpcode>

   It worked great before 2.1, but now it shows:

   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 'ON (link_category = cat_id)
   WHERE link_visible = "Y" AND li]

   SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit
   FROM wp_links LEFT JOIN ON (link_category = cat_id)
   WHERE link_visible = "Y" AND list_limit <> 0 ORDER BY "cat_name"

   Any ideas?

2. markhealey
   Member
   Posted 5 years ago #

   Hi, I upgraded today and my links aren't working either... I was using "get_links()".

3. markhealey
   Member
   Posted 5 years ago #

   Oops, forgot to include I'm not getting an error message from the server, just a blank page -- nothing in the source where these PHP tags sit.

   Very strange b/c the links are in the DB, and viewable/sortable in the WP Admin!

4. markhealey
   Member
   Posted 5 years ago #

   Ok.... my links weren't showing up. For some reason in this release, the link cats get rolled into the global cats... I had to change my link cat id to global cat id and everything's smooth now.

   get_links() still works.... wp_list_bookmarks is not as easy!

5. prezmcmahon
   Member
   Posted 5 years ago #

   I'm not sure what you mean by:

   "I had to change my link cat id to global cat id and everything's smooth now"

   how/where is this changed?

Topic Closed

This topic has been closed to new replies.