TreeSkier

Hi Froman,

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

Have a few beers on me,
– 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 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

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

AH!!!! Thank you very much for the explanation of an entirely reasonable behavior.

I was pretty nervous about the entire thing, because a) I was hacked a while back with another WordPress blog and b) a recent post about the latest hacking opportunity.

Regards,
– TS