Best Way To Locate Offending WP Table

It’s unusual to include/require files based on database values, but if that’s what’s happening — one way to track it down would be to export the DB from production to an SQL file (which maybe you already have), then search through it with a text editor. You should then be able to look at the … Read more

Get all post from table and put it in excel sheet

Here’s the SQL I used to create this view in phpMyAdmin. Since you cannot get the permalink URL out of the database we have to pull the GUID. This link does in fact get you to your post, since it uses the unique ID of the post. SELECT `post_name`, `guid` FROM `YOUR_TABLE` WHERE `post_date` >= … Read more

ExpressionEngine Export/Import Issues

I found the answer. The way the XML file was being rendered, there was no line break between the item closing tag, and the next item’s opening tag (</item><item>). This passed all validation tests, but WP wouldn’t process it properly. I added the line breaks, and everything worked as expected. Thanks to everyone for the … Read more

How to add a timestamp to the exported WXR filename?

I don’t think you need to do that, it’s already there (if I understand the question correctly): In the WXR file we get a timestamp like: that’s generated with: <?php the_generator( ‘export’ ); ?> that calls get_the_generator() where the export case is: $gen = ‘<!– generator=”WordPress/’ . get_bloginfo_rss(‘version’) . ‘” created=”‘. date(‘Y-m-d H:i’) . ‘” … Read more