Link Library
NOTICE:I recently published a book on plugin development with Packt Publishing.
I have accumulated a lot of user questions while I was working on that project and am slowly catching up answer them. Before asking a new question, I recommend that you read through all comments here, through the forum on the wordpress.org and through the FAQ before asking questions. I will try to get back to you as soon as possible. Thank you for your understanding.
Donations
If you feel generous and really like this plugin, here is a donation link on Paypal:
Example Configurations
The Freeware DB and Favorite Links section of this site uses Link Library to generate the contents of the page. To help you get similar results, here are snapshots of my configuration for the examples that are available on the site:
- Freeware DB (Config)
- Favorite Links (Config)
- Favorite Links with RSS Feed Icons and Pagination (Config)
- Freeware DB only showing one category at a time (Config)
- Links with inline RSS Feed Items (Config)
Usage Examples
Click here for more usage examples of Link Library.
Author
I'm a tech enthusiast working in the modeling and simulation software industry. I'm also married and the father of two very energetic little girls.Order my book!
Find me on
AJAX Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Apr | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
I installed LInk Library again and set up some simple test. I received the following error in my php error log. Do you have any suggestions about what went wrong?
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 ” at line 1 for query SELECT distinct *, l.link_id as proper_link_id, UNIX_TIMESTAMP(l.link_updated) as link_date, IF (DATE_ADD(l.link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_terms t LEFT JOIN wp_term_taxonomy tt ON (t.term_id = tt.term_id) LEFT JOIN wp_term_relationships tr ON (tt.term_taxonomy_id = tr.term_taxonomy_id) LEFT JOIN wp_links l ON (tr.object_id = l.link_id) LEFT JOIN wp_links_extrainfo le ON (l.link_id = le.link_id) WHERE tt.taxonomy = ‘link_category’ AND l.link_visible != ‘N’ ORDER by made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/cakifo-thm/page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, link_library_plugin->link_library_func, link_library_plugin->PrivateLinkLibrary
Hi Jim. Thanks for giving the plugin another shot. There is something really strange happening in the construction of this SQL query. Which option did you select in the Library Settings panel for “Link Results Order” field?
For Library 1 I only changed the name.
I created Library 2 and set it’s results sort order to “Order of Categories base on included category list.” That list has three numbers in this order: 249,70,237
BTW I was using version 5.7.3 when the error happened; I just got an update notice so I installed 5.7.4
Actually now that I’ve looked more closely, my link library does not present the categories in the order I put the category IDs.
Sorry, cancel that. They are in the order I put the category IDs.
Hi Jim, Could you turn on debug mode on the Link Library General Settings page and give me a link to where the library is running. I want to check and see which SQL statement is acting up to give you that error in the log.
I was unable to connect to your site for several days.
I’ve not been able to repeat this error. Your plugin has been working without errors for several days now, so I think we can forget this issue.
Thanks for the feedback. Yes, my site was down for a few days. Still not quite sure what happened.
Hi Yannick,
Still love the plugin. When going through my local files, I noticed that I made a number of bug fixes (undefined variable notices etc) to your plugin. I’d love to submit these as a contribution to the plugin.
How would you like to receive them ? A diff file ? Complete file with fixes ? All fixes detailed in a support forum post ?
Smile,
Juliette
Hi Juliette, A complete file with fixes would be easiest for me. Then I can easily diff it against my current version and merge in changes. Thanks!
Hi Yannick, files are on their way to you via email
Hope this helps!
I have pending moderation links available but they wont show when I go to approve them?
What do I need to do with this?
Hi Orgna, Please make sure you are on the latest version of the plugin, then deactivate and reactivate it and your links to moderate should appear correctly.
How do I get the search results to show?
How do I make the “go” button work on the category drop down list?
Can the user submitted links can they select more than one category?
Hi Tim, The go button uses javascript to work. If you have javascript errors on your site, that would prevent that go button from working. To see if you have javascript errors, the easiest way is using the Firebug plugin for Firefox. For the search results, did you put the search form on the same page as a library? If so, then the results should appear in the location of your library. If they are on different page, you need to indicate the address of the page containing the library in the search configuration section so that the request gets sent to the proper page.
Hi, I like Link Library very much, but I have a suggestion: can you make it to display the category name in the Widgets page? I have many widgets with links, for various pages, and all I see in the Widgets lista is many Links widgets, so I have to explore each of them to find the one I want to modify.
Hi AdiM, Hmm… Link Library does not offer a widget. So whatever widget you use to display categories of widgets in your sidebar comes from another WordPress plugin, or perhaps you are using the stock widget.