zzanna

Hi Oz,
it’s strange cause i’m using your plugin right now.
I need to do some refresh or wait?

Hi Alex
added uam_db-version with 1.5.1 in wp_option
Now no more “update database” alert but i lost all connection between UAM and Users

plus i have this error in the log:

[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 6
AND (general_object_type = ‘_user_’ OR object_type = ‘_user_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\AccessHandler\AccessHandler->getUserGroupsForUser, UserAccessManager\AccessHandler\AccessHandler->getUserGroupsForObject, UserAccessManager\UserGroup\UserGroup->isObjectMember, UserAccessManager\UserGroup\UserGroup->isUserMember, UserAccessManager\UserGroup\UserGroup->isObjectAssignedToGroup, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults
[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 7
AND (general_object_type = ‘_user_’ OR object_type = ‘_user_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\AccessHandler\AccessHandler->getUserGroupsForUser, UserAccessManager\AccessHandler\AccessHandler->getUserGroupsForObject, UserAccessManager\UserGroup\UserGroup->isObjectMember, UserAccessManager\UserGroup\UserGroup->isUserMember, UserAccessManager\UserGroup\UserGroup->isObjectAssignedToGroup, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults
[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 6
AND (general_object_type = ‘_post_’ OR object_type = ‘_post_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\UserGroup\UserGroup->getFullPosts, UserAccessManager\UserGroup\UserGroup->getFullObjects, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults
[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 6
AND (general_object_type = ‘_term_’ OR object_type = ‘_term_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\UserGroup\UserGroup->getFullPosts, UserAccessManager\UserGroup\UserGroup->getFullTerms, UserAccessManager\UserGroup\UserGroup->getFullObjects, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults
[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 7
AND (general_object_type = ‘_post_’ OR object_type = ‘_post_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\UserGroup\UserGroup->getFullPosts, UserAccessManager\UserGroup\UserGroup->getFullObjects, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults
[11-May-2017 10:29:30 UTC] WordPress errore sul database Unknown column ‘general_object_type’ in ‘where clause’ per la query SELECT object_id AS id, object_type AS objectType
FROM zz_uam_accessgroup_to_object
WHERE group_id = 7
AND (general_object_type = ‘_term_’ OR object_type = ‘_term_’) fatta da require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce->init, WooCommerce->load_webhooks, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, UserAccessManager\Controller\FrontendController->parseQuery, UserAccessManager\AccessHandler\AccessHandler->getExcludedPosts, UserAccessManager\UserGroup\UserGroup->getFullPosts, UserAccessManager\UserGroup\UserGroup->getFullTerms, UserAccessManager\UserGroup\UserGroup->getFullObjects, UserAccessManager\UserGroup\UserGroup->getAssignedObjects, UserAccessManager\Database\Database->getResults

Same problem here, keep asking to update database.
Can’t reset the plugin cause is too much work if i lost all the setting, maybe you can consider a function to export/import setting

Hi Sayontan,
thanks for the quick replay!
i’ve done as you said and it seems the plugin works fine with PHP7.X, no problem so far.