What do the file contents look like in the export? Try turning WP_DEBUG on in your wp-config.php and see if you can see any errors. Administrators get full access, they don’t need that capability.
The export file has only a newline character. Nothing else. Also, beneath Export: CSV tab, it says “No items found”.
Anyway, there’s obviously a problem with my db here.
From the plugin Reports screen…
WordPress database error: [Table ‘db9368134344.wp_posts’ doesn’t exist]
SELECT SQL_CALC_FOUND_ROWS ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=’post’ LIMIT 0,25
WordPress database error: [Table ‘db9368134344.wp_posts’ doesn’t exist]
SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=’post’
Success: Your export is ready, the download should begin in a few moments. If it doesn’t, click here to access your CSV export file.
When you are done with your export, click here to remove it, otherwise the export will be deleted within 24 hours of generation.
Please paste your full report SQL query here, use back ticks to surround your SQL query when posting it.
`
SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type='post'
This is from the Example Posts Report, unchanged from plugin download. (Simple blog posts report.)
I am still getting the same Table Not Found db error for wp_posts.
Any idea what’s causing that?
The site is otherwise running fine of course.
Note that this is a new installation of E & R.
jeff
Scott –
I think I may have a conflicting plugin, although E & R seems pretty straightforward. I will investigate my other plugins.
Also, I have the same db table doesn’t exist problem with the same website running on a different site. (This site is not quite live yet and I just switched to a new webhost.
Thx,
Jeff
Is this a multisite installation? Do you have a different $table_prefix value in your wp-config.php file?
Scott –
I’m glad this week is almost over. Total brain-fart on my part. Yes, of course I changed the table prefix! Dangit.
Okay, basically working now.
My apologies.
This is a great plugin and nearly exactly what I need.
Your Paypal account I can donate to?
Jeff
Donations always accepted 🙂
You can donate to my main project http://podsfoundation.org/donate/ and that’d be super useful.