I see what you mean. The error is:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT cat_id, cat_name FROM
but the problem is, that the cause of the error is not shown.
Check your admin section to see if your categories are ok (if you have them) (I’m guessing you have them since the query asks for cat_id and cat_name)
Same goes for some titles that have ‘or " in them, same for categories that have 'or ” in them.
That’s it for now 🙂
This is what I found as the sql query when I went into admin.
EXPLAIN SELECT COUNT( * ) AS Rows , cat_ID
FROM wp_categories
GROUP BY cat_ID
ORDER BY cat_ID
The Host is using myPHPadmin
So what SHOULD it be?
It’s difficult to know what it should be because we don’t know what that bit of the page is meant to be showing.
More than likely though you don’t need the word EXPLAIN at the front of the query, because EXPLAIN is used to get information about a query, not to run one. (The query is otherwise valid.)
Even with the explain though, you shouldn’t be getting a mysql error. It’s valid either way.
What version of mysql do you have?
