A reader of this blog submitted a question regarding a problem he is currently having with the RSS feed in his WordPress installation:
I am the webmaster of XXX and i am having a problem with my feeds.
When i try to validate them it shows me this:
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 ‘ON ( wp_posts.ID = .object_id ) WHERE 1 = 1 AND .term_taxonomy_id.term_taxonomy_’ at line 1
Do you know what i can do to fix it?
I am using v2.2.1
Kind Regards
My recommendation is to upgrade your WordPress installation to the latest version available: 2.3.2.
Reason? The error message you are receiving refers to a database table called term_taxonomy_id.term_taxonomy.
That database table did not exist in version 2.2.1 - - it was introduced into the WordPress core in version 2.3.2.
I would suspect that you may have attempted an upgrade - but forgot to follow through with all the upgrade requirements. If you have uploaded the files for the new WordPress 2.3.2 version - try visiting http://yourdomain.com/wp-admin/upgrade.php (where ‘yourdomain.com’ is YOUR actual domain)…. it may be that you neglected to perform this vital piece during the upgraded which would mean that your WordPress files are updated… but your WordPress database is not. The upgrade script will also update your database and it may remove that error for you.
I do have detailed instructions on how to upgrade your WordPress blog on this blog. Good luck and let me know how it goes for you! Thanks for writing in.
Dear webmaster.
i am the owner of this blog and it seems the problem that might caused this its a plugin that is compatible with v2.3.x only.
i will check again all the plugins that i have upgraded and i will post again the results.
If i cannot do nothing else i will commit an upgrade to the latest to solve it once for all.
Kind Regards
plimper.
Yea, the plugin is probably making a call to that database table I mentioned… because you’re using 2.2 and not 2.3.x - the term_taxonomy_id.term_taxonomy doesn’t exist in your database.
Hi Lisa again.
I have found the problem that was causing all this.
It was a plugin (Category Access) that i have updated to the new version but it was compatible with the wordpress v2.3.2 but i was using v2.2.1 so after the instalation it was calling the taxonomy table that it was not existing.
I have rolled back to the previous plugin version and everything it’s working great again.
Thanks for your help.
So the only thing that left for me to do when i get some time is to update to the latest build…
Kind Regards
plimper.