PHP Scripts Development » bbpress plugins and modifications

Moderator New Post Notify , DB error w/ WordPress Integration

(6 posts)

Great offers not only for geeks!


  1. twincascos

    twincascos
    Member

    Hello, I've just been trying your plugin Moderator New Post Notification with a wordpress - bbpress Integrated install and I get the following error `database error:

    [Table 'bbpress.bb_users' doesn't exist]
    SELECT um.meta_value AS role FROM bb_users AS u, bb_usermeta AS um WHERE u.ID = um.user_id AND um.meta_key = 'bb_capabilities' AND u.user_status = 0 AND u.ID = 2`

    Posted 2 months ago #
  2. Yes right, the plugin needs an update if the prefix is different from "bb_".

    replace the SQL statement within the function "is_moderator":

    $row = $bbdb->get_row("SELECT um.meta_value AS role
    		FROM $bbdb->users AS u, $bbdb->usermeta AS um
    		WHERE u.ID = um.user_id
    		AND um.meta_key = 'bb_capabilities'
    		AND u.user_status = 0
    		AND u.ID = $user_id
    	");
    Posted 2 months ago #
  3. User has not uploaded an avatar

    facelikebambi
    Member

    Hiya,

    I'm trying to use the plugin with Wordpress and BBPress 0.9.0.2 integrated. I had the same error, and the fix mentioned above does indeed remove the SQL error.

    However, I'm still not getting the activate checkbox when I edit my (keymaster) profile.

    As a test, I installed a local, non-WP-integrated version of 0.9.0.2 to see if it was a problem with the latest BBpress... and the plugin works fine!

    Any suggestions welcomed - thanks!

    Posted 2 months ago #
  4. hm... I think that some variable is replaced by the code which is written for WP.

    what error do you get if you access the plugin-file via the browser?

    Posted 2 months ago #
  5. User has not uploaded an avatar

    facelikebambi
    Member

    Ah I fixed it!

    Just had to change the two references to bb_capabilities to bbpress_capabilities

    Also, the notification emails had no sender, so I just changed the $header = 'From: '.bb_get_option('admin_email')."\n"; line to hard code the from address.

    Thanks!

    Posted 2 months ago #
  6. Ok, cool that it works now (will add this to the next version)

    Posted 2 months ago #

RSS feed for this topic

Reply

You must log in to post.