Loggued as admin
on this page : /forum/admin/categories
I have this
Question2Answer query failed:
(SELECT '0' AS selectkey, qa_categories.categoryid, qa_categories.parentid, BINARY qa_categories.title AS title, BINARY qa_categories.tags AS tags, qa_categories.qcount, qa_categories.position, COUNT(child.categoryid) AS childcount, BINARY qa_categories.content AS content, BINARY qa_categories.backpath AS backpath, NULL AS pageid, NULL AS flags, NULL AS nav, NULL AS widgetid, NULL AS place FROM qa_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid JOIN qa_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE qa_categories.categoryid=NULL UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.categoryid=NULL UNION SELECT parentid FROM qa_categories WHERE categoryid=NULL UNION SELECT categoryid FROM qa_categories WHERE categoryid=NULL) y ON parentid<=>parentkey LEFT JOIN qa_categories AS child ON child.parentid=qa_categories.categoryid GROUP BY qa_categories.categoryid ORDER BY qa_categories.position) UNION ALL (SELECT '_options', NULL, NULL, title, NULL, NULL, NULL, NULL, BINARY content, NULL, NULL, NULL, NULL, NULL, NULL FROM qa_options) UNION ALL (SELECT '_time', NULL, NULL, NULL, NULL, NULL, NULL, NULL, UNIX_TIMESTAMP(NOW()), NULL, NULL, NULL, NULL, NULL, NULL) UNION ALL (SELECT '_navpages', NULL, NULL, BINARY title, BINARY tags, NULL, position, NULL, NULL, NULL, pageid, flags, nav, NULL, NULL FROM qa_pages WHERE nav IN (_utf8 'B',_utf8 'M',_utf8 'O',_utf8 'F') ORDER BY position) UNION ALL (SELECT '_widgets', NULL, NULL, BINARY title, tags, NULL, position, NULL, NULL, NULL, NULL, NULL, NULL, widgetid, place FROM qa_widgets ORDER BY position)
Error 1052: Column 'parentid' in on clause is ambiguous
