Hi I started a noticeboard quite a while ago, but it had to be put on hold. At the time everything worked fine, however now when I click on the Comments RSS, on all the inner pages, such as this page below for example (it's a clients site and don't want it picked up by the SE, hense why I am not posting it as a link "http://www.locumocean.com/Noticeboard/?page_id=19" This is the error message WordPress database error: [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 'AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 10' at line 1] SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 10 However the Comments RSS on the homepage works fine. I need to get this sorted asap, so would be greatful of any help. Thanks Dee
Has it just happened? Do you mess about with the MYSQL? I think you maybe have updated or a plugin gone wrong? Try disabling plugins see if anything changes. Also revert to classic theme for a moment and see if anything changes. It seems to be something to do with page setups rather than posts,will the client even have comments open on pages.
Hi, well to be honest as I said it was done over a year ago and the client had to put everything on hold, therefore it is something that I have just recently gone back to, so when it happened I don't know. I tried deactivating all the plugins, but it didn't make any difference, also if I switch to classic mode, I will lose all the custom work I have done, so I can't do that. The client does want comments to appear on the pages yes. Please can anyone help Dee
which theme are you using? I guess the theme is causing the problem. Get another free wordpress theme and see whether the same problem happens. You can find good wordpress themes in www.top-best-themes.com/category/wordpress
Well changing the theme isn't an option, as I have totally customised it to match the clients site , and there isn't the time to redo it all again
Are you sure changing the theme loses anything? I'm sure you can just change between themes without problem afaik? I meant just switch to classic theme temporarliy and see if the problem still exsists then. Also upgrade to the latest version 2.6.2, you are vunerable to hackers easily not sure your client would be happy with this. This may also solve the problem, in fact it's a good possibility, there is no harm in upgrading only takes 5 minutes.
Since I installed the template, I have totally customised it to match the clients site, therefore if I switch to classic mode, won't I lose all the changes I made and when I revert back it will revert back to the template before all the customisation? Also if I upgrade, won't I lose all the changes I made and have to basically start over??
no you wont lose the changes if you change the template. If that worries you copy and paste your customized theme to a backup place and then try. Upgrades have nothing to do with templates.
Yes as said above, changing from theme to theme does not modify anything, unless you can think of something specifically that runs on your theme when activated or something special like that. The same goes with upgrading you should do this, it won't change anything, unless you have edited the WP Core files which I highly doubt (files inside the wp-content folder for example). Just follow the instructions carefully and make sure you don't wipe over your wp-content folder, and if you are highly protective then make a backup as it suggests.
Thanks Guys Well I upgraded and now that works fine I have one more problem, the trackback url, when you click on it it says this This XML file does not appear to have any style information associated with it. The document tree is shown below. − <response> <error>1</error> <message>I really need an ID for this to work.</message> </response> Anyone know how to set this up correctly? Thanks again for all your help so far Dee