Page-categories – Database error
-
Hi
Trying to setup my page-categories for my user role.
Here, im getting a database-error when assigning this page-category for my user-role.Generel setting:
Pages: Restrict all pages (assign access for pages on the specific user-role)Following error is thrown:
WordPress databasefejl: [Unknown column ‘wp_term_relationships.term_taxonomy_id’ in ‘where clause’]
SELECT wp_posts.*, GROUP_CONCAT(DISTINCT t_page_category.term_id SEPARATOR ‘,’) AS ‘page_category’ FROM wp_posts LEFT JOINwp_term_relationships
AS tr_page_category ON tr_page_category.object_id = wp_posts.ID LEFT JOINwp_term_taxonomy
AS tt_page_category ON tt_page_category.term_taxonomy_id = tr_page_category.term_taxonomy_id AND tt_page_category.taxonomy = ‘page_category’ LEFT JOINwp_terms
AS t_page_category ON t_page_category.term_id = tt_page_category.term_id WHERE 1=1 AND wp_posts.post_type IN (‘page’, ‘np-redirect’) AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘trash’ OR wp_posts.post_status = ‘private’)) AND ((((wp_posts.post_type = ‘page’ AND wp_posts.ID = 0) OR (wp_term_relationships.term_taxonomy_id IN (109) OR wp_posts.ID IN (56,6731)))) OR (wp_posts.post_type = ‘np-redirect’)) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASCAny of you who has experiences the same?
- The topic ‘Page-categories – Database error’ is closed to new replies.