my-link-order broken in 2.8.4

I also have a problem. I’ve used the “enhanced link” plugin, to put the links together by categories. Now, this doesn’t work anymore, although it’s installed and under widgets. Every link is now showing in a row, but not enhanced under the related category as it was before.

artnoir, My Category Order or My Category Order aren’t going to be compatible with “Enhanced Links” as far as I can tell. The widget from the plugin would have to be modified to use the correct sort order.

i installed My Link Order after installing WP 2.8.4 and i’ve tried everything to get this plug happening. i deactivated My Category Order and tried it. after “ordering” links i get a message saying links have been ordered but i go to my page and they are the same. is there another option or can i edit one of the php files??

bugnut, did you switch to the My Link Order widget or modify your theme to use wp_list_bookmarks('orderby=order&category_orderby=order'); or something similar.

widget!!!! thanks froman!

the only other thing is i have a left and a right sidebar and i would like to place the my links order widget near the top on one side and near the bottom on the other. at first glance it appears i can only use one instance…

Yup, that’s on my list of things to do. Time is pretty scarce so it’ll happen eventually.

Hi froman,

I will gladly buy you a beer (or several) if you can help me through
this post-installation problem. I see these errors when I go to the “My Link Order” page from my toolbar.

I’m familiar with MySQL and permissions… is user ‘yscr_bb51Iz’ a new user that you’re trying to add for this widget?

WordPress database error: [Access denied for user ‘yscr_bb51Iz’@’localhost’ to database ‘blog’]
ALTER TABLE wp_terms ADD term_order INT( 4 ) NULL DEFAULT ‘0’

WordPress database error: [Access denied for user ‘yscr_bb51Iz’@’localhost’ to database ‘blog’]
ALTER TABLE wp_links ADD link_order INT( 4 ) NULL DEFAULT ‘0’

WordPress database error: [Unknown column ‘t.term_order’ in ‘order clause’]
SELECT DISTINCT t.term_id, name FROM wp_term_taxonomy tt inner join wp_term_relationships tr on tt.term_taxonomy_id = tr.term_taxonomy_id inner join wp_terms t on t.term_id = tt.term_id where taxonomy = ‘link_category’ ORDER BY t.term_order ASC

Thanks,
– TS

Hi Froman,

I got into my db and executed those ‘alter table’ statements manually. That did the trick. Nice widget — I’m off to send you some beer.

– TS

Actually, I haven’t actually seen the link order change on the published site. They’re still displaying in the order in which they were created. I tried forcing my main page to republish and that did not help.

Browsing around in MySQL, this command:

‘SELECT link_name,link_order from wp_links order by link_order’

will produce the correct names in the order as I specified with the widget. However, they’re just not showing up in that order on the site.

What’s up?

Hi TreeSkier,

That MySQL user is what your WordPress install is setup to use, if it doesn’t have ALTER permission it can’t add the needed columns (99.9% of the time it does).

The last step to get things going is to either modify your theme (if you aren’t using widgets) with wp_list_bookmarks('orderby=order&category_orderby=order'); or swap the built in Link widget with the replacement My Link Order widget.

Hi Froman,

Very cool…. I got the widget running and everything’s working great.

Have a few beers on me,
– TS

Froman,

Can you help me? I added the patch to the taxonomy.php file. This seemed to take care of the error on the “link ordering page”. However, the links still are not showing up on my blog.

I have the “My Link Order” widget placed in my sidebar.

Right now, the only way I can get my links to show up on my blog is to use the regular “Links” widget in my sidebar, but obviously my link ordering doesn’t work.

Can you provide some assistance?

Lou

Ok…I fixed it. Here is what fixed it for me…

On this page; https://www.hyperarts.com/blog/wordpress-blogroll-ordering-my-link-order-patch-2-8/

It says the following;

At line 683, after this code:

elseif ( empty($_orderby) || ‘id’ == $_orderby )
$orderby = ‘t.term_id’;

you paste the following code:

else if ( ‘order’ == $orderby )
$orderby = ‘t.term_order’;

It’s actually the other way around.

The Code:

else if ( ‘order’ == $orderby )
$orderby = ‘t.term_order’;

should be above this code;

elseif ( empty($_orderby) || 'id' == $_orderby )
$orderby = 't.term_id';

My taxonomy.php (with MyLinkOrder plugin working) looks like this (starting at line 683);

else if ( 'order' == $_orderby )
		$orderby = 't.term_order';
	elseif ( empty($_orderby) || 'id' == $_orderby )
		$orderby = 't.term_id';

It’s finally working after a few hours of frustration…

That’s really weird, mine was patched correctly after the 2.8.4 upgrade. I see the ‘order’ line at line 683 and I haven’t heard of any other cases of this happening. I’m stumped, I don’t know why it would insert at the wrong lines.

I’ve been trying to find time to work on a complete overhaul of the plugin that would end dependency on taxonomy.php. Too much of a pain to keep things working as it is. Back in the 1.5 and 2.0 days you use to be able to pass in any sort parameter you wanted, but I never got away from that design.