This could be a small EE bug / ehm… feature.
I just checked and the problem is as follows:
When selecting category groups for a weblog it is possible to select multiple groups, but also select the first item “none”.
If you do this the database is actually updated with the category group id’s as well as one empty item, the first one.
You can correct this now by visiting the group settings for your weblog and clicking ‘submit’ again (without selecting the ‘none’ item in the list)
I will add a workaround for this problem tomorrow.
When a weblog DOES NOT have a category_group assigned and you visit the edit/publish form you will get this error:
MySQL ERROR:
Error Number: 1064
Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Query: SELECT group_name FROM exp_category_groups WHERE group_id IN ()
The error disappears when you assign a category_group to the weblog.
Maybe let the extension check if it has a cat group assigned…if no cat group..STOP
Works nicely for me. Thanks for doing this, it’s much more usable!
Hopefully, this will be standard or configurable in future versions of EE.
Amen. Multi-select boxes are a huge pain to deal with. At least give us the option built-in. Also, I love that this extension utilises labels. EE is by far the most accessible CMS I’ve toyed with. Of course, I’m not a CMS guru but EE requires very little tweaking on my part but when I do it’s relatively easy and straightforward.
sneers, I’m finding that the missing Edit Categories link happens with the extension - but eventually after the whole thing loads, the link magically shows up.