WordPress Plugin – My Link Order Archived

502 Replies to “WordPress Plugin – My Link Order Archived”

1. When I saw your comment above — “My Category Order is in the works!” — I realized that I installed this plugin under a complete misunderstanding — I though it would help me change the order of the categories themselves, not the links within categories. Just wanted to say that I do hope you find time to make that plugin — it is sorely needed!

   But thanks for your work.

2. Checked compatibility with WP 2.0.3, just use the 2.0.2 version. It’s funny that the links and link categories pages haven’t been touched by the developers in about 6 months.

   Checkout what’s going on in trunk and you’ll see things much much different.

3. It seen no body have the anwer for this problem

   WordPress database error: [Unknown column ‘link_manual’ in ‘order clause’]
   SELECT link_url, link_name, link_image, link_target, link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links WHERE link_visible = ‘Y’ AND link_category = 8 ORDER BY link_manual ASC

   and i seen some people having this problem
   i upgrade to wordpress 2.0.3 and puff the problem came in

   any one with a real Anwer BTW Great Plugin…

4. When you upgraded core files I had to modify were overwritten. You’ll need to copy link-categories.php to /wp-admin/ and links.php to /wp-includes/ again. This is one of the downsides to my plugin but sadly it is necessary to get this kind of functionality from WP.

5. Hi,
   It’s a great plugin!

   My link categories are now sorted manually, but my links are not. But even I sorted my links manually as well, the are still completely unsorted.
   Do you have any idea to solve it?

6. For each link category you have to go in and change the “Sort Order”. Go to the Links -> Links Categories admin page, and click edit on a category, there will be a dropdown for sorting methods, choose manual. Links in that category will now display in the order you set in the plugin. Hope that helps.

7. Listen everyone!
   This is what you have to do to get rid of that database error:

   WordPress database error: [Unknown column ‘link_manual’ in ‘order clause’]
   SELECT link_url, link_name, link_image, link_target, link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links WHERE link_visible = ‘Y’ AND link_category = 8 ORDER BY link_manual ASC

   .. or something simillar
   Just go to the admin section ‘Links->My link order’ and set a link list order..any other than the one you have now. Save and… it works.
   Cheers

8. Hi Andrew,

   Just a small note – your plugin still says version 1.0 on my WP Plugins page, even though it’s MyLinkOrder 2.02 that I have installed. Just a tiny oversight I assume, but I figured you’d want to know. I actually came back here and re-dowloaded 2.02 and was in the process of re-installing it when I realized that’s what I already had installed. :-\ No big whoop though. It’s an easy install. :-)

   BTW, RoQ (@ comment #51) was being a jerk. Kudos for being so courteous in your reply to him.

9. I am having the same problem as above

   WordPress database error: [Unknown column ‘link_manual’ in ‘order clause’]
   SELECT link_url, link_name, link_image, link_target, link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links WHERE link_visible = ‘Y’ AND link_category = 8 ORDER BY link_manual ASC

   I’ve tried everything that was suggested in the comments above,
   I am running wp2.03 and downloaded the latest plugin

   thanks

10. Hello all,

    I just installed Mylinkorder, unfortunately it doesn’t work. Oviously the plugin tries to read something from the wrong database. I receive the error message “Table ‘db1051044-cpg.wp_linkcategories’ doesn’t exist”. db1051044-cpg is my Coppermine database.

    How can I fix that?

    Regards,
    Dominik

11. I’m also getting the same database error as so many others have reported. This only happened when I upgraded WP to 2.0.3, so apparently there is some sort of compatibility issue involved here.

    I did try to reset the link order in My Link Order, as suggested above, but this had no effect.

    Is there any chance that a fix will be forthcoming? Your plugin is great, and we’d really like to be able to keep using it.

12. As a follow-up, I just deleted link-categories.php and links.php from the latest download, and replaced them with the files from the 2.0.1 download. That corrected the problem immediately. I’m wondering if possibly one of those files has something out of place in the latest download?

13. When you upgrade to a new WP version you have to re-install those two files since they get overwritten during the upgrade process. It isn’t the ideal situation but it is what I have to work with. I have to modify those files to accomplish the ordering. I could possibly create a function that could be included in the template files so that it won’t break on upgrading, but I don’t see the advantage of deviating away from the core files. Glad you got it figured out and I’ll make it clearer up top that you have to re-upload those files when upgrading.

14. I just found thid and was wondering if th is would help me make a links page without the blogroll?
    I’ve sccumulated quite a few nice links over the years and would like to list them on a links page
    Thanks!

15. My sidebar is built dynamically and uses the wp_get_links function. I was able to use your plugin and the extra database column the plugin utilizes by changing my database query from:
    $link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories");
    to this:
    $link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories ORDER BY `my_cat_order` ASC");

    Thanks for the great plugin, it is exactly what I was looking for.

16. I think this tool messed up my internal permalink system.
    There are no more internal incoming links since I installed it 6 days ago.
    Using wordpress 2.0.3. and the template “greening”

17. Is your “internal permalink system” just the standard stuff built into wp or something custom that you have installed? You are the first person to report any problems with permalinks.

18. Thanks so much for this. Exactly what I was looking for.

19. ok
    Now the first time it never worked despite me doing that get links thing.

    I am going to try to delete it from my plugin file and do a new install.

    Which version for 2.0?

    And just i case where would I have to change that get links thing ?
    How do I back up files in the wp administration thing? I seemed to have caused some parse problem last time I did anything in there so I want to be careful

20. Great plugin.

    I would love to have a similar feature to organize page order. Any idea how to do that? Or can you create one?

21. N/M I found on your site where you explain it. Thanks!

22. Is the latest version of MyLinkOrder (2.0.2 & 2.0.3) also work on WP 2.0.4?

23. I’ll have to check it out to be sure, but it looks like they haven’t done anything that would affect the plugin, which has been the case since 2.0. If you want to go ahead and try it (just backup the files I point out in the instructions) there isn’t much harm (if something does blow up just restore the backed up files). Either way I’ll upgrade and test it within the next couple days to be sure.

24. Yep, works just fine in 2.0.4 – no adverse affects that I can see.

25. Fantastic plugin, exactly what I was looking for. Install was a breeze and worked first time with no tweaking – many thanks!

26. thanks – exactly what I was looking for also. Much apprecaited.

27. Great! Plugin worked first time. Clear instructions, everything was straight forward. I’ve been looking for this for a while.

28. Andrew, thanks for this plugin. I was hoping you could point me in the right direction for fixing a problem that I’m having. I installed the plugin with 0 problems, and I can order links withing categories. I cannot, however, order how the categories get displayed. I make the change in the plugin, but there’s no effect on the live site.

    Please steer me in the right direction.

29. Hi,

    Thankyou for the plugin. However, there is a conflict with the “coppermine” plugin. I suspect the two plug use the same variable to store the database name, as a reasult when I turn on the coppermine plugin, it try to look for album.wp_linkcategories.

    Any idea how can I fix it? Thanks.

30. I just got your plugin installed without any problems(except the links.php and link-categories.php files were not included in the download, so I got them from the mylinkorder-1-5-2.zip file)

    I have set all the categories to Manual now but when I go to the “My Link Order” tab the two arrows are not there so I cannot change the order.

    Any ideas???

31. Hi, I installed, and when I switch to Link order “Manual” I get the following error:

    WordPress database error: [Unknown column ‘link_manual’ in ‘order clause’]
    SELECT link_url, link_name, link_image, link_target, link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated , UNIX_TIMESTAMP(link_updated) AS link_updated_f FROM wp_links WHERE link_visible = ‘Y’ AND link_category = 1 ORDER BY link_manual ASC

    Any Hints?

32. Looks like your links.php didn’t get updated or you aren’t using get_links_list() in your sidebar template. Check those out and let me know, but those are the most common reasons for an error like that.

33. on my 2.02 install category order works and link order shows correctly on plugin page, but not in sidebar..? please help! thx!

34. I have the same problem as “eyetag” (post no 86). The plugin page shows exactly how I would like the link order, but it still sort it alphabetically in the sidebar.

35. I found the trouble; the sidebar.php didn’t used get_links_list(). Just as you pointed out in another reply here.

36. err…

    Do not use hardcoded database table adresses… (in alter “alter table”…)

    Use ie “$wpdb->linkcategories”, ’cause “wp_” is only default table prefix… not, the only possible.

37. An updated zip file is available using the wordpress database object. This plugin was the first code I had written for WP so I guess it shows.

38. Thanks for a great plugin, I have been attempting to fix that by looking into the source files without any luck…But now it works exactly as wanted just after a few clicks:)

    Thank you!

39. Hi Andrew,

    Hope you can help. I’ve downloaded and installed your plugin as instructed. However my link categories do not appear in the order I chose. I think this might be something to do with the Tiga (with sidebar widgets) theme I’m using. I don’t really know much about this but I’m assuming the problem would be with sidebar.php? In the Tiga theme folder I’ve opened sidebar.php and have isolated the following section which I assume refers to the links/categories.
    

get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories");
foreach ($link_cats as $link_cat) {
if (get_links($link_cat->cat_id, '', '', '', FALSE, '', FALSE, FALSE, -1, FALSE, FALSE)) {
?>
cat_id; ?>">
cat_name; ?>

    cat_id); ?>

    


    Any ideas what is going wrong and which pieces of code I would need to change?
    Thanks in advance. Greg.

40. oh, that code didn’t all appear. I’ll try emailing it to you instead.

    Thanks.

41. The following code will do the trick. Slightly annoying that the Tiga theme doesn’t use the standard method of getting the categories. Doing a query like that in the theme template is usually a big no-no. Watch out if you upgrade to WP 2.1 coming out some time soon, your theme will most likely break.

    <!-- Begin - Links from the 'Links Manager'-->
<?php
$link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM
$wpdb->linkcategories ORDER BY my_cat_order asc");
foreach ($link_cats as $link_cat) {
if (get_links($link_cat->cat_id, '', '', '', FALSE, '', FALSE,
FALSE, -1, FALSE, FALSE)) {
?>
<div class="left-widget-title"
id="linkcat-<?php echo $link_cat->cat_id; ?>">
<?php echo $link_cat->cat_name; ?>
</div>
<div class="left-widget">
<ul>
<?php wp_get_links("category=$link_cat->cat_id&orderby=manual"); ?>
</ul>
</div>
<?php
}
}
?>
<!-- End - Links from the 'Links Manager'-->

    
    Andrew

42. Great plugin, thanks!

43. Had some problems in the beginning but got it finally. Works great. I suppose you have to do those installation steps IN ORDER to get it going…
    didnt set “order links” to manual before i started reordering them. that messed it all up i guess.
    just reset everything and do the steps again it should work fine then.

    Thanks a bunch for that plugin!

44. oh, and the same plugin for sections would be awesome.
    hope you spoil us with that one kinda soon!

45. I just saw that 2.0.5 is out (one day after I took the time to update to 2.0.4, ‘doh)
    Could you look if this plugin works as it should with 2.0.5 and tell me before I dare to install this =P

46. Thanks for the notification about 2.0.5 Soilheart, I thought I signed up to be notified by email. Anyways, updated the plugin to include changes to link-categories.php.

47. I just used your plugin on a client site and you SAVED my life. I’m bookmarking you and using you for all of my client blog sites in the future. I’ll get a link to you up on my site asap. Thank you! You can see it here: artsyfran.com

48. THANK YOU for this elegant and handy plug in. A very nice piece of work!

49. Phew! Just great. Had headaches trying to sort my links the way i wanted. Well done! Thanks!

50. For some reason the up and down arrows arent showing up so i can’t organise my links :/

Comments are closed.