[email protected]

#1064 – 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 a.post_date < ‘2010-06-01” at line 6
DELETE a,
b,
c FROM wp_posts a LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id ) LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id ) WHERE a.post_type = ‘revision’;

AND a.post_date < ‘2010-06-01’;

$table_prefix = ‘wp_’;

above is what is in my PHP file

And When I paste:

“DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = ‘revision’;
AND a.post_date < ‘2010-06-01’;”

…into my WP-dbmanager RunSQL query and send it come back query 0/0 completed

I’m also open to trying any other ideas you may have for fixing the problem.

$table_prefix = ‘wp_’;

above is what is in my PHP file

And When I paste:

“DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = ‘revision’;
AND a.post_date < ‘2010-06-01’;”

…into my WP-dbmanager RunSQL query and send it come back query 0/0 completed

I’m also open to trying any other ideas you may have for fixing the problem.

Okay So I understnad where to put the define.. TY

I don’t know how to find the table prefix

Its a problem with the whole WP edit page section no matter what page. I tried removing all plugins..no help

I copy and pasted into WP DBmanager SQL scripting and it errored out.

“DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = ‘revision’;
AND a.post_date < ‘2010-06-01’;”

And I have no idea where to add

define(‘WP_POST_REVISIONS’, 9);

MY problem with my site is that the front end of my website runsfine, but the admin pages editing section crawls….??

I tried running that in MYSQL and it came up with an error : No DB selected. Also Where do i save “define(‘WP_POST_REVISIONS’, 9);”?