bbPress Plugin Browser »

Subscribe To Topic (0.0.6)

Download

Version: 0.0.6

Last Updated: 2009-6-7

Requires bbPress Version: 0.9 or higher

Compatible up to: 0.9

Author Homepage »

Plugin Homepage »

Donate to this plugin »

Average Rating

5 stars
4 stars
3 stars
2 stars
1 star
(7)

Your Rating

Author: _ck_


1234…6

  1. bedbugger

    Member

    "If you have an active site, it is important to consider that some ISPs may decide to block your forum's emails simply based on the volume of emails when you use a plugin like this. Make sure your website has proper SPF, Sender ID and DomainKeys to help delay blocking but if it's a very large site you'll probably have to pay a whitelisting service to stop blocks eventually."

    Hi _ck_,

    Thanks for this plugin. Can you please suggest how we go about setting proper SPF, Sender ID and DomainKeys?

    Thanks!

    Posted: 2 years ago #

  2. _ck_

    Moderator

    Unfortunately that's way outside the scope that I can help anyone.

    Usually your web host will be very familiar with how to do SPF, however sender id and domainkeys are more complex. You can also google for articles on it and testing sites.

    Posted: 2 years ago #

  3. jonkemp

    Member

    I'm getting this error.

    bbPress database error: [Table 'wordpress_db_name.subscribe_to_topic' doesn't exist]
    SELECT DISTINCT user_id,user_email FROM wp_users as t1 LEFT JOIN wp_usermeta as t2 on t1.ID=t2.user_id LEFT JOIN subscribe_to_topic as t3 on t1.ID=t3.user WHERE user!=178 AND user_status=0 AND topic=9 AND type=2 AND time<1242510419 and post>last AND (meta_key='bb_capabilities' AND NOT (meta_value LIKE '%inactive%' OR meta_value LIKE '%blocked%'))

    wordpress_db_name is the name of my WordPress database. I am using bbPress 0.9.0.4 and 0.0.4 of this plugin. I am using WordPress integration where the WordPress install and the bbPress install are on the same domain. Registered users on WordPress can login into bbPress with the same account.

    I checked and subscribe_to_topic does exist in the bbPress database, but it obviously wouldn't exist in the WordPress database. The error seems to indicate it is looking for that table in the WordPress database. Do you have a fix or can you issue an update? Thanks!

    Posted: 2 years ago #

  4. _ck_

    Moderator

    That doesn't make any sense because the same general type of query is being used to create the database table as to access it. So it should find it in the same place it creates it.

    Unless of course you changed something along the way and moved tables?

    Easiest way to fix this is to move the table from the bbpress database to your wordpress database, use phpmyadmin.

    Posted: 2 years ago #

  5. jonkemp

    Member

    No I didn't change anything. I've had this problem with another install as well. I'm using GoDaddy as a host.

    I'll probably just deactivate the plugin rather than move the database table. It's a shame though I really like the functionality.

    Posted: 2 years ago #

  6. baardvidar

    5 stars
    4 stars
    3 stars
    2 stars
    1 star

    Member

    Hi there. Nice plugin!

    A couple for your wishlist:
    - a POT-file. It's not easy to find all the pieces that needs translating in your file, and I guess that by the next update, I'll have to do it again. A language-file would be greatly appreciated.
    - CSS IDs and classes. Most importantly your own CSS ID on the table listing the themes, and perhaps a CSS class instead of inline styles.

    Again, nice work!

    Posted: 2 years ago #

  7. bdpicha

    Member

    When I click on 'Subscribed Topics' under the 'Views' section from the front page I get this error:

    bbPress database error: [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 'ON topic_id=topic WHERE topic_status=0 AND user=1 AND topic_last_post_id>post' at line 1]
    SELECT count(*) FROM bb_topics LEFT JOIN ON topic_id=topic WHERE topic_status=0 AND user=1 AND topic_last_post_id>post

    bbPress database error: [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 'ON topic_id=topic WHERE topic_status=0 AND user=1 AND topic_last_post_id>post ' at line 1]
    SELECT * FROM bb_topics LEFT JOIN ON topic_id=topic WHERE topic_status=0 AND user=1 AND topic_last_post_id>post ORDER BY topic_last_post_id DESC LIMIT 30 OFFSET 0

    Any thoughts?

    Posted: 2 years ago #

  8. _ck_

    Moderator

    bdpicha, what version of bbPress are you using and does the rest of the plugin
    happen to still work (ie. you get emails on subscribed topics).

    Posted: 2 years ago #

  9. bdpicha

    Member

    Just downloaded bbpress last night so the latest version 9.0.5. Otherwise the plugin works, including receiving emails.

    Posted: 2 years ago #

  10. _ck_

    Moderator

    Oh wow, I missed another global when I made the database table name adjustable, sorry.

    Please download 0.0.6 again and it should be fixed:
    http://plugins-svn.bbpress.org/subscribe-to-topic/trunk/subscribe-to-topic.php

    Don't forget to adjust your settings again if you changed them inside the plugin.

    Thanks for reporting the problem!

    Posted: 2 years ago #

  11. bdpicha

    Member

    Sweet, working perfectly! Thank you.

    Posted: 2 years ago #

  12. signature16

    Member

    How can I set "Subscribe To Topic via Email" to be checked automatically?

    Posted: 2 years ago #

  13. Pump

    Member

    CREATE TABLE IF NOT EXISTS subscribe_to_topic (
    user int(10) UNSIGNED NOT NULL default '0',
    topic int(10) UNSIGNED NOT NULL default '0',
    post int(10) UNSIGNED NOT NULL default '0',
    last int(10) UNSIGNED NOT NULL default '0',
    time int(10) UNSIGNED NOT NULL default '0',
    type tinyint UNSIGNED NOT NULL default '0',
    PRIMARY KEY (user,topic),
    INDEX (user),
    INDEX (topic)
    ) CHARSET utf8 COLLATE utf8_general_ci

    go into your phpMyAdmin push the button "SQL"
    and there you go...
    Thats it Thanks!

    Posted: 2 years ago #

  14. Chip Bennett

    Member

    Hey _ck_, can you take the explicit style declarations out of the plugin? They make it incredibly difficult to fit the dropdown into a given theme, stylistically.

    Otherwise, great plugin; I love it!

    Posted: 2 years ago #

  15. Chip Bennett

    Member

    Hmm... wait; looks like maybe you did already...

    Posted: 2 years ago #

  16. jamie_d

    Member

    First, of course, thanks VERY much for the plugin.

    Quick note to let you know I had the same error message as jonkemp:

    bbPress database error: [Table 'wordpress_db_name.subscribe_to_topic' doesn't exist]
    SELECT DISTINCT user_id,user_email FROM wp_users as t1 LEFT JOIN wp_usermeta as t2 on t1.ID=t2.user_id LEFT JOIN subscribe_to_topic as t3 on t1.ID=t3.user WHERE user!=178 AND user_status=0 AND topic=9 AND type=2 AND time<1242510419 and post>last AND (meta_key='bb_capabilities' AND NOT (meta_value LIKE '%inactive%' OR meta_value LIKE '%blocked%'))

    Same situation, integrating WP with BBPress using GoDaddy as host. I tried your solution of moving the database table and worked like a charm. Thanks a lot!

    Posted: 2 years ago #

  17. improva

    Member

    Is there a chance that this plugin will be made compatible with 1.0+?

    Posted: 2 years ago #

  18. _ck_

    Moderator

    I'll attempt to make many of my plugins 1.0 compatible starting in December.

    Posted: 2 years ago #

  19. aberrantphoto

    Member

    This plugin has errors in 1.0. It breaks user registration page and when you try to logout from the admin, a number of errors pop up. Although I like this plugin, I had to deactivate it after upgrading to 1.0. Hope to see this compatible in the near future!

    Posted: 2 years ago #

  20. circulartrend

    Member

    Thanks for this!

    Posted: 2 years ago #

RSS feed for this topic

1234…6

Add a Comment »

You must log in to post.