| User | Post |
|
1:54 pm
16 Jul 2008
|
Bacon
Guest
| | | |
|
| |
|
|
I'm getting this error above each post on my homepage:
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 'wp_posts.ID DESC LIMIT 0, 1' at line 1]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 672 AND (post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'inherit') ORDER BY ,wp_posts.ID DESC LIMIT 0, 1
Website is http://www.barrhq.com
I've looked around the forums for help and only found one topic that was somewhat similar. I checked in wp_sfposts for any topics without a topic_id or user_id and deleted one that had a NULL author. Still not working. Thanks in advance.
|
|
|
2:02 pm
16 Jul 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
Bacon,
That is not an error generated by simple press forum… note the wp_posts table issue… thats not ours… something to do with images as attachments to a wp blog post…
does the error go away if you deactivate the forum plugin? if so, you likely have a conflict between plugins… if this is the case, deactivate all plugins except for simple press forum… does it work? then start activating plugins one by one until it stops working… you will now have the conflict and perhaps we can provide some help…
|
|
|
2:58 pm
16 Jul 2008
|
Bacon
Guest
| | | |
|
| |
|
|
The error does go away when I deactivate the plugin.
I've tried deactivating all the plugins except SF, but I still get the same error. Could it be a conflict with my theme?
|
|
|
|
|
Well as stated this is not a piece of forum SQL. it is missing the first ORDER BY column at the end there.
I've done a quick scan (VEY QUICK) through the WP code and I can't locate this query either although I need to take a little longer to look for it. Which version of WP is this?
|
|
|
3:24 pm
16 Jul 2008
|
Bacon
Guest
| | | |
|
| |
|
|
This is a very strange error indeed. This error didn't start until I upgraded to the newest SF this morning.
I'm running the latest WP 2.6 using the Options theme by Justin Tadlock.
I appreciate the help!
|
|
|
|
|
It probably IS a WP query but I can't find it in the WP code.
if you have definitely discounted plugins (and remember it is worth emptying your browser cache between deactivating each one) then it might be worth swapping your theme temporarily to the 'default' and seeing if you still have the problem…
|
|
This forum is currently locked - access is read only
Forums
