My table now looks like this:



Subscriptions have been made, as you can see here:



But no e-mails containing subscription notifications seem to be arriving...
Another thing is that clicking the "return to the post" link after subscribing takes you to an invalid URL. Waiting takes you to your own profile...

Your category values are all NULL or blank, so no subscriptions have been made. Your category column should have type int(11) like the others. Also you need to allow your thread value to be null as well.

Thank you for your help, cosworth. It now looks as follows:




However, no notification mail seems to arrive when renewing subscriptions and creating new posts in the categories or topics which have a value in the 2nd screenshot. Any ideas on what I am doing wrong?

You are the second person to report this problem. I wonder if there is a cut an paste problem (last time when i cut from my editor it took returns and pasted them as -CRLF- so perhaps there is a rogue character.

I will get onto the case today and reply later.

I've been through the code with a fine tooth comb and I don't see any problem!

The only difference is line 270 of post.php - which would be the most likely target... FB 'code' elements don't like you including "slash n" so I deleted them from the start of the lines but as far as I know they are cosmetic.

you could try adding forward slash n at the start of line 271 and 272 inside the double quote for good measure.

Can you also try this SQL SELECT QUERY and tell me if you get a result with a valid email address...

[code:1]
SELECT DISTINCT * FROM jos_fb_subscriptions AS a LEFT JOIN jos_users as u ON a.userid=u.id WHERE a.thread= '39' OR a.category='20'
[/code:1]
This mimicks a new post to thread 39 and cat 20 (doesn't matter if thread 39 isn't in cat 20!) - from your table you should get the email address from user 115 and 75 (subscribed to the thread and the category).

Are you testing it right?
If user 115 subscribes to category 20 and then posts in category 20 - they don't get an email... they know they posted. However if user 75 posts in category 20 then user 115 gets an email.

Do users who are subscribed to a thread (not a category) get email?

Finally I notice you have some (?old) data in the table where userid is subscribed to thread 0 and cat 0 - don't think FB has thread 0 or cat 0 (I may be wrong) don't think that is the coz of your troubles but if you can check if there is a thread 0 or a cat 0 and if not I'd delete them.

polc1410, thank you for all the efforts. I started out by looking for any _CRLF_ and actually found two in post.php (line 270 +). After deleting those, the notification was working! Terrific.

About the category instead of just the forum subscription: maybe the button can be placed next to the category title in the category overview? i.e.: next to "Test forum" in the following screenshot:



The same sort of subscription should be possible for the forum as a whole, i.e. next to the "Mark all forums as read" button at the end of the forum.

Boo-Ya! I was having the same problem, found it based on your comments, and now mine works wonderful too. Thanks guys!

-Danny

Sweet nector of the gods! Thanks. I didn't think I had any CRLF and didn't check the post.php well enough. Thanks for bringing this to light guys. I have a meeting in 8 hours to explain how great this is to a group - this fix is just in time.

Mich wrote:
polc1410, thank you for all the efforts. I started out by looking for any _CRLF_ and actually found two in post.php (line 270 +). After deleting those, the notification was working! Terrific.

About the category instead of just the forum subscription: maybe the button can be placed next to the category title in the category overview? i.e.: next to "Test forum" in the following screenshot:


That's straighforward to do if you can find the bit that created the HTML then you'd need to paste the bit in the file that gets attached because it contains html into there...


The same sort of subscription should be possible for the forum as a whole, i.e. next to the "Mark all forums as read" button at the end of the forum.
You are certainly not the first to make such a request. Logistically its more complex! For the sake of future proofing the porting of data to any future addition of this by the dev's I'm gonna suggest we dont do that for now - sorry - but there are so many ways to achieve it and it could make converting existing subs over in the future very risky...

Just got it working on (released) fireboard 1.0.3!

After a bit of head scratching, I found the lines that need changing.

There is no "templates", the directory is called "template"

In showcat.php, block of text goes BEFORE the curly bracket in line 309
post.php is OK, but do the change on line 1004 first, then do the change on line 270. Otherwise you might make old line 1004 shift.
userprofile.php is OK too, change line 579

That's it. Thanks again for this hack!