julpero

I add collation to the function getExcludedPosts:

$sObjectQuery = “SELECT DISTINCT gp.object_id AS id, gp.object_type collate utf8mb4_bin AS type
$sPostQuery = “SELECT DISTINCT p.ID AS id, post_type collate utf8mb4_bin AS type

But I’m not really sure is that correct to use hard coded collations…

No it didn’t work.

I tried to debug that version with query monitor and if I use regular user (editor) query monitor shows an error.

Query:
SELECT DISTINCT p.ID AS id, post_type AS type
FROM wp_posts AS p
INNER JOIN wp_term_relationships AS tr
ON p.ID = tr.object_id
INNER JOIN wp_term_taxonomy AS tt
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE p.post_type != ‘revision’
AND tt.taxonomy = ‘category’
AND tt.term_id IN (SELECT gc.object_id
FROM wp_uam_accessgroups iag
INNER JOIN wp_uam_accessgroup_to_object AS gc
ON iag.id = gc.group_id
WHERE gc.object_type = ‘term’
AND iag.write_access != ‘all’)
AND p.ID NOT IN (16968, 7)
UNION SELECT DISTINCT gp.object_id AS id, gp.object_type AS type
FROM wp_uam_accessgroups AS ag
INNER JOIN wp_uam_accessgroup_to_object AS gp
ON ag.id = gp.group_id
LEFT JOIN wp_term_relationships AS tr
ON gp.object_id = tr.object_id
LEFT JOIN wp_term_taxonomy tt
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE gp.object_type IN (‘post’,’page’,’attachment’)
AND ag.write_access != ‘all’AND gp.object_id NOT IN (16968, 7)

Call Stack:
UamAccessHandler->getExcludedPosts()
wp-content/plugins/user-access-manager/class/UamAccessHandler.php:664
UserAccessManager->showPostCount()
wp-content/plugins/user-access-manager/class/UserAccessManager.php:1610
apply_filters(‘wp_count_posts’)
wp-includes/plugin.php:203
wp_count_posts()
wp-includes/post.php:2234
get_available_post_statuses()
wp-admin/includes/post.php:984
wp_edit_posts_query()
wp-admin/includes/post.php:1009
WP_Posts_List_Table->prepare_items()
wp-admin/includes/class-wp-posts-list-table.php:142

Plugin: user-access-manager

Error: Illegal mix of collations for operation ‘UNION’

Those linenumbers may not be accurate because I have wrote some error_log -degug rows into them.

It didn’t fix my issue.

My groups are usually:
Read access: all
Write access: only group users

And as I said in Posts -admin page shows to user only those pages on which user has write access but in Pages -admin page the user sees always all pages.

Hide complete posts / Hide complete pages doesn’t have any effect to those admin pages.

Well it didn’t fix the issue either. Not the newest version 1.2.7.6 nor disabling all other plugins.

I just noticed that posts admin page works. It show’s only those posts user has rights. The pages admin page shows all pages to everyone.

And one thing I don’t have said earlier, I have multisite installation.

How I can contact you so I can give you access to my test site and send database?

Hi, I disabled all other plugins when I tested 1.2.7.4. I will try that again when it’s morning here in Finland…

What do you exactly need if I create access to you? Or how I could send my db?

Yes – sorry if I was a bit inaccurate…

I have site that has about 150 pages and 10 user groups 15 pages each. Now each user see 150 pages in admin pages which is little frustrating.

• This reply was modified 9 years, 5 months ago by julpero.