Solved Autosubscription Plugin

I just installed this with Kunena 2 and got an error similar to:
Table 'tablename_kunena_subscriptions_categories' doesn't exist SQL=INSERT INTO `prefix_kunena_subscriptions_categories` (`catid`, `userid`) SELECT `id`, 473 FROM `prefix_kunena_categories`
any ideas appreciated..I would love to use this

webiedesign wrote: ..... Table 'tablename_kunena_subscriptions_categories' doesn't exist ....

That table no longer exists in 2.0. My quick look shows that subscriptions are now stores in kunena_user_categories and kunena_user_topics, one record for each category/topic subscribed to. The plugin will need to be modified for this change.

It should also be modified to check access levels before subscribing. This is a task I am not qualified to do. Anyone else?

I am willing to contribute funds towards this plugin ....

I'm pretty busy right now, but I'll revise it in the next week or so.

any progress on this ?

I wish I could do more to help with this. I successfully wrote a SQL query to add some users to a category, but I don't know enough to automate it. I did this all manually for an organization that has committee categories set up for just a handful of users each. I tried to get them to subscribe so they could be used like an email list but I couldn't get people to do it, so I just made it happen.

As mentioned in other places it is very easy to destroy your database by manually changing it. I'll offer my SQL query here but don't even look at it if you're not sure what you're doing! It seems to be working with no adverse effects but I take no responsibility for it. My code puts a half dozen users into the "12" category, which corresponds to one of the committees. Obviously you would need to change the query to update your database, your table, and the correct category.