WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: User Access Manager] DB_ACCESSGROUP_TO_POST doesnt exist (4 posts)

  1. Jeff Sterup
    Member
    Posted 3 years ago #

    My error logs are getting filled with this error that is coming from the User Access Manager plugin and I can't figure out what is causing it.

    [07-Jul-2011 19:20:38] WordPress database error Table 'dbname.DB_ACCESSGROUP_TO_POST' doesn't exist for query DELETE FROM DB_ACCESSGROUP_TO_POST
    WHERE post_id = 1132769 made by wp_delete_attachment, do_action, call_user_func_array, UserAccessManager->removePostData

  2. Jeff Sterup
    Member
    Posted 3 years ago #

    Looking around the web I see this popping up in error_log's on a lot of sites. Just search google for DB_ACCESSGROUP_TO_POST and you will get servers that have their error_log files indexed by google. So it looks like a bug in the plugin. I looked through the code and can't find a place where the constant DB_ACCESSGROUP_TO_POST is set. That is why DB_ACCESSGROUP_TO_POST is being placed in the query string.

  3. Jeff Sterup
    Member
    Posted 2 years ago #

    Hello? Anybody supporting this plugin anymore? I've found a few more constants that are used for deleting from the database that are never defined.

    -- undefined constants --
    DB_ACCESSGROUP_TO_POST
    DB_ACCESSGROUP_TO_USER
    DB_ACCESSGROUP_TO_CATEGORY

    -- defined constants --
    DB_ACCESSGROUP_TO_OBJECT
    DB_ACCESSGROUP

    I could fix the code myself if I knew what the tables looked like but there are no create statements for these tables. Should they just point to the same table as DB_ACCESSGROUP_TO_OBJECT? Anybody have any ideas what is going on here?

  4. reimund
    Member
    Posted 2 years ago #

    I think DB_ACCESSGROUP_TO_POST and the others are old constants that the developer forgot to update with the more generic DB_ACCESSGROUP_TO_OBJECT constant. So I changed them into using DB_ACCESSGROUP_TO_OBJECT instead.

    For example:

    public function removePostData($postId)
        {
            global $wpdb;
            $wpdb->query(
            	"DELETE FROM " . DB_ACCESSGROUP_TO_OBJECT . "
            	WHERE object_id = ".$postId . " AND (object_type='post' OR object_type='page')"
            );
        }

Topic Closed

This topic has been closed to new replies.

About this Topic