Hi,
Thanks for this. The autosubscribe as such seems to work well in my environment (J1.5.7, FB 1.0.5 RC2) as the jos_fb_subscriptions table gets populated fine and the categories show up in the CB user profile as well.
However, there was a difference in the latest post.php file and I obtain an error upon submitting a post (and nobody gets notified).
in post.php, lines 631ff reads:
$resubject = base64_decode(strtr($resubject, "()", "+/"

);
$resubject = str_replace("%20", " ", $resubject);
$resubject = preg_replace('/%32/', '&', $resubject);
$resubject = preg_replace('/%33/', ';', $resubject);
$resubject = preg_replace("/'/", ''', $resubject);
$resubject = preg_replace("/"/", '"', $resubject);
so there was no $resubject = preg_replace("/'/", ''', $resubject); to comment out, as suggested in the post above.
The error I get is (and it throws the template):
Fatal error: Unable to load subscriptions.nDB function failed with error number 1064
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 'n WHERE a.thread= 443 OR a.category='2'' at line 1 SQL=SELECT DISTINCT * FROM jos_fb_subscriptions AS an LEFT JOIN jos_users as u ON a.userid=u.id n WHERE a.thread= 443 OR a.category='2'
SQL =
SELECT DISTINCT * FROM jos_fb_subscriptions AS an LEFT JOIN jos_users as u ON a.userid=u.id n WHERE a.thread= 443 OR a.category='2'
in .../components/com_fireboard/sources/fb_debug.php on line 37
The server is on MySQL 5.0.67-community; I restored from a JoomlaPack 1.2.2.b2 backup, my localhost is on 5.0.51b-community-nt (Wampserver). The whole thing worked fine with FB 1.0.4.
Can someone help please?
BW, Erik (ejw)
EDIT:
I have of course commented out $resubject = preg_replace("/'/", ''', $resubject);
but the error remains