[Plugin: AZIndex] [AZ Index plugin] how to EXCLUDE categories

Hi. Sorry for the slow reply. I haven’t been logging on for the past month or so, what with vacations and other stuff, so I have a bit of a backlog of requests and comments to go through.

I will take a look at the possibility of adding exclusions to the search. It all depends on how easy it would be to add them to the current SQL query without slowing it down too much. It might be feasible.

I will add it to my list of things to look at for a future release. (The list is getting quite long).

Thanks for the feedback.

Mike
https://englishmike.net

Update — the code for excluding cats and tags is written! Look for a new version this week!

Great!

Mike, I’m trying out 0.6, but I’m getting nowhere. I had an older version installed and got an error about the database that was not up to date. I deactivated and deleted the old version, installed the new one, but I still get database errors when I try to create a new index:

WordPress database error: [Table ‘xxx.wp_term_relationships’ doesn’t exist]
SELECT DISTINCT ID, post_title, post_excerpt, post_author FROM tst_posts INNER JOIN tst_term_relationships AS rel2 ON (tst_posts.ID = rel2.object_id AND tst_posts.ID NOT IN (SELECT DISTINCT object_id FROM wp_term_relationships INNER JOIN wp_term_taxonomy AS tax3 ON (wp_term_relationships.term_taxonomy_id = tax3.term_taxonomy_id AND tax3.taxonomy = ‘category’ AND tax3.term_id IN(3)))) WHERE post_status = ‘publish’ AND post_type IN (‘post’) AND ID IN (577)

[edit] This only happens on category exclude using the ~.

Hey, yeah. Can you check to see which version of MySQL you are using. I tested this on MySQL 5.x and MySQL 4.1.x, but hadn’t realized that some WordPress installations are still using 4.0.x (which is over 4 years old!) and the support I added for excludes depends on subqueries which was added in back in MySQL 4.1.

You are the second person to report this, but I would like to confirm the the level of MySQL you are using before I do anything. If it’s 4.0.x then do you have an option to upgrade to 4.1.x or 5.0.x? My web host provides a painless upgrade path, so yours might too.

Sorry about the hassle. I do try not to use features that are not supported on all platforms WordPress runs on, but this one slipped through the cracks.

Mike

D’oh — could be another problem. Silly me, I hard-coded the table names when I should have used the $wpdb prefix (like I did with the rest of the SQL query). I will update the plugin 0.6.2 — please try that version to see if it fixes your issues. If not, then it still could be an old version of MySQL.

Sorry first time back online. I got 0.6.2 up and running perfectly in the test, great!
Just one request for a future release (no hurry), an ? should come out under a, not under ?, same goes for ?, é, etc. Minor things, most of what I write is in English, so the problem is rare, just a request. For the rest the plugin now is going to replace my stone age “GunnArt AlphaIndex”.