Hello,
Location of the problem : On the admin side > posts lisiting > filter by category
When I try to filter by selecting a category I get this DB error message :
WordPress database error : [Not unique table/alias: 'term_relationships']
SELECT SQL_CALC_FOUND_ROWS posts.ID FROM posts LEFT JOIN term_relationships ON (posts.ID = term_relationships.object_id) INNER JOIN term_relationships ON posts.ID = term_relationships.object_id INNER JOIN term_taxonomy ON term_taxonomy.term_taxonomy_id = term_relationships.term_taxonomy_id INNER JOIN terms ON terms.term_id = term_taxonomy.term_id WHERE 1=1 AND ( term_relationships.term_taxonomy_id IN (445) ) AND ((posts.post_type = 'post' AND (posts.post_status = 'publish' OR posts.post_status = 'future' OR posts.post_status = 'draft' OR posts.post_status = 'private'))) OR ( terms.name LIKE ('%%') ) OR ( term_taxonomy.description LIKE ('%%') ) GROUP BY posts.ID ORDER BY posts.post_date DESC LIMIT 0, 30
tagDiv Composer is the culprit as I deactivated all the plugins and reactivated them one by one. The problem arises only when tagdiv composer is activated even when only newspaper theme + tagdiv plugins are activated.
Could you fix this ?
Regards,
Hello @sco!
Can you please provide more information about the issue you’re talking about?
A solution for sending a screenshot/video is this:
Download, capture, and send: https://www.techsmith.com/jing-tool.html
After making the screenshot, you will have a link; paste it here.
Thank you!
Hi,
Yes I mean Dashboard -> Posts -> All Posts -> Filter by a category.
– I have deactivated all the plugins => no error message
– I have reactivated only tagdiv composer => the message appears
– I have reactivated all the plugins and deactivated tagdiv composer => no error message
I have newspaper theme v12.2 installed.
So… the culprit cannot be anything else than tagdiv composer.
Could you please ask the developer.
Thanks for your consideration and help.
Hello @sco!
Please contact us via email at contact@tagdiv.com and provide the following:
– admin url and credentials
– cpanel url and credentials
– a link to this topic in order to identify you
Our team will take a look and help you ASAP!
Thank you!