Comments Posted By Robert@PNG
Displaying 1 To 10 Of 10 Comments
I thought you were meant to be on holidays!!
» Posted By Robert@PNG On 2nd December 2009 @ 16:43
Keep up the good work bro!!
» Posted By Robert@PNG On 20th August 2008 @ 04:22
Interestingly when I do a browse in PHPmyadmin of the postmeta table – I cannot find any rows with “post_id” set to NULL.
NB: Everything back to normal since I did the restore earlier this afternoon. So it’s not an urgent situation and it’s not even one of your plugins that’s playing up. So, unless you are really keen Lester – just leave it for now.
NB2: Have you ever come across a good diagram that outlines the relationships between the different tables in WordPress? If I had one of these I could study the entity relationships and in the process gain a better understanding of the database aspects of WP.
» Posted By Robert@PNG On 19th August 2008 @ 18:00
I want to run an SQL SELECT just to see what it comes back with before running the actual SQL DELETE.
SELECT b, c
FROM term_relationships b
LEFT JOIN postmeta c ON ( c.post_id = b.object_id )
WHERE post_id IS NULL
I get the following error:
#1054 – Unknown column ‘b’ in ‘field list’
» Posted By Robert@PNG On 19th August 2008 @ 16:21
I’m with Bluehost and they run V5.0.51a
» Posted By Robert@PNG On 19th August 2008 @ 13:45
I just ran a restore using WP-DBManager (with fingers crossed) and all seems like its back to normal.
Want to have another go at the SQL delete or do we leave it for now?
» Posted By Robert@PNG On 19th August 2008 @ 10:52
I spoke up too soon.
My tags and categories seem to have screwed up!
Yep – I run a backup with your WP-DBManager plugin every night.
Important question: Is it possible to restore both those tables: term_relationships and postmeta individually or do I have to restore the entire DB?
» Posted By Robert@PNG On 19th August 2008 @ 10:37
You are definitely the man!!
Touch wood but it seemed to work OK. It deleted over 6000 rows – which means there must have been a lot of “dead wood” in the DB (or I’m totally screwed). Will run a repair followed by an optimise.
Thanks a million bro.
» Posted By Robert@PNG On 19th August 2008 @ 09:40
Thanks for responding so quickly.
I ran the code you noted above and got the following response:
#1054 – Unknown column ‘a’ in ‘field list’
Just as an aside and an added benefit to turning of post revisioning and also the automatically saving of posts is the CPU savings. Since turning off both – I am no longer getting penalised by my Hosting Provider for chewing up CPU cycles. A big plus!!
NB: I have been using your WP-DBManager and WP-PluginsUsed and they are tops!!
» Posted By Robert@PNG On 18th August 2008 @ 17:41
«« Back To Stats Page
Those of us that ran the original “Delete” as recommended by Andrei Neculau would now have orphaned records in the term_relationships and postmeta tables.
» Posted By Robert@PNG On 18th August 2008 @ 13:14