Prompts to update database after it has been updated

Please check if there is a entry uam_db_version at the wp_options (wp_BLOGID_options) table for an other blog than the one where the UAM is installed. If yes delete the entry.

None of PREFIX_options and PREFIX_BLOGID_options tables have a uam_db_version entry. There were various PREFIX_BLOGID_uam_accessgroups and PREFIX_BLOGID_uam_accessgroup_to_object tables with the ids of blogs that do not have UAM installed.

Even for the db where the plugin is installed?!?

It certainly appears to be that way.

Could you please reset the plugin via the setup page at the backend. But keep in mind that this step will erase all your data related to the UAM. So make a backup.

Done. Just so you know, though, resetting the plugin deleted the backups that I had made through UAM as well. This is fine since recreating our settings was easy, but might have been a problem for folks with a more complex use case.

Did this solved the problem?

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

Please add an entry uam_db_version with 1.5.1 at your wp_options table.

Hi, @gm_alex. I don’t know how to tell if it solved the problem. I’m not getting prompts to update the database, but since I just reset the plugin I presumably wouldn’t get any such notices until the next update that required a database update.

• This reply was modified 7 years, 10 months ago by bkalish. Reason: fixed typo
• This reply was modified 7 years, 10 months ago by bkalish. Reason: used proper @username syntax

@gm_alex, are your instructions to modify the wp_options table directed at @zzanna or myself?

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

@zzanna Ok I should had asked if you have preformed the database update, because it look like you didn’t so the update promt had a good reason, do the update. ?? So just change the number of the uam_db_version entry to the previous value.

Closed since there isn’t any feedback since several days. If this one isn’t resolved please don’t hesitate to write and mark it unresolved again.