[vrwired]

Originally Posted by vrwired

Cyricx? This is the same problem that i'm having with auto subscriptions... haven't found a way to fix it yet.. any insight from you?

Regarding the problem with "Auto Subscriptions", if you know enough about working 'under the hood', here's a hack to get this working:

The problem when trying to load auto subscriptions is:
Invalid SQL:
SELECT title FROM forum WHERE forumid =;

Here's what I did to 'fix' it so it would at least function...

1) Open up file admin_ei.php in the admincp folder.
Around line 52, it reads: $getforuminfo = $db->query_read("SELECT title FROM " . TABLE_PREFIX . "forum WHERE forumid = $forumupdateid");
-- just hardcode (i.e. replace) $forumupdateid with the actual # of the forum you want to subscribe all users to (I had 7 different forums, so had to do one at a time )

2) You also need to update the table 'usergroup' in your forum's dB... if you have phpmyadmin you can use this query to pull up the info you need to update:

SELECT usergroupid, title, ei_forumid
FROM usergroup
WHERE ei_auto =1
ORDER BY `usergroupid`

Find the row that has 'registered users' in the title column Now change the value for 'ei_forumid' in that row to be the forum # that you are subscribing all users to (same # as in the first step)....

Now you should be able to subscribe all users by going to admincp and clicking "Auto Subscription" again, but will still need to repeat steps 1 and 2 until you get all forums subscribed...