WordPress 2.5 My First tests - Broken Plugins
March 30, 2008
WordPress database error: [MySQL server has gone away]
SELECT * FROM wp_postmeta WHERE post_id=123 AND meta_key='forumlink';
WordPress database error: [MySQL server has gone away]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('http com script js href visit javascript yimg language wp pack src seo projects wordpress title js2 homepage plugin lib')) as bodyscore, (MATCH (post_title) AGAINST ('plugins broken tests wordpress')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('http com script js href visit javascript yimg language wp pack src seo projects wordpress title js2 homepage plugin lib')) * 1+ (MATCH (post_title) AGAINST ('plugins broken tests wordpress')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 123 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 123 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '123') and post_date <= '2008-11-20 02:44:01' and post_type IN ('post', 'page')
group by id
having score >= 5 order by score DESC limit 5
Alright, my first test post after activating several plugins was a painless experience. All my tabs were open on the post page. This was both good and bad, as All in One SEO Pack was open and ready to use, but so was every other section requiring lots of scrolling.
The plus side is All in One SEO Pack, AutoMeta, WordPress Database Backup, Twitter Tools, Technorati Tags 
and ShareThis seems to work.
Bad News: LiveJournal CrossPoster, and Adhesive don’t work.
I guess it will be a while before I bother upgrading…
No related posts.
Comments
WordPress database error: [MySQL server has gone away]
SELECT * FROM wp_comments WHERE comment_post_ID = 123 AND comment_approved = '1' ORDER BY comment_dateGot something to say?