Exactly what do you want explained?
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….??
What error did you get from the SQL? Is your WordPress table prefix ‘wp_’? If not, you will need to change the SQL to the correct prefix.
Put the define in wp-config.php ahead of the line that says “That’s all, Stop editing!”.
Okay So I understnad where to put the define.. TY
I don’t know how to find the table prefix
The table prefix is defined in wp-config.php, but the error may not be caused by an incorrect prefix – that was only a guess.
What was the error?
$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.
#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’;
Try removing the semicolon just after a.post_type = ‘revision’;
