lynnelil

OK, I think I’m fine with disabling plugins and switching to the default template, in thinking about it. If it would make things easier. People can live with the site as “basic” for a few weeks. What I am trying to do is to get the system to the point to where it can export via that WXR format, as that seems the simplest way to do what I need to do in the next phase of this project.

The only thing I’m really worried about now is exporting the PodPress elements from that plugin – I want to be able to export that data (where the audio files I’ve linked to some posts reside) so I can import that with the posts into a new system. I’m transferring the website into ExpressionEngine because I’ve become an EE guru and there’s functionality I want that I can get easier in EE (not that I don’t love WP, but for this site, I need more control to do some really custom things, and I know how I can accomplish that in EE, but not WP). So, if I go back to the basic template, disable the plugins (including PodPress), upgrade, then install the newest PodPress, then do the WXR export, will that work?

(And yeah, I’d rather not do a local install to test, not that I can’t – I used to do it all the time, but not in the last few years LOL. And the site didn’t get updated because, well, I got lazy, and then several versions went by and it got to be too much of a pain. I don’t get paid for this website, it’s my blog, and I spend enough time writing it, never mind maintaining it. Heh.)

Arg, reset the thread to “not resolved” – hopefully that helps it show up where it can be looked at. Sorry about that – still sorta a newbie (but I did stay at a Holiday Inn Express last night – and read the sticky thread about “resolved” and “not resolved” statuses). 😉

FYI, the SQL generated by the plugin is as follows:

SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)
AND ( category_id = 4) WHERE wp_posts.post_date <= '2007-07-18 09:16:42'
AND ( wp_posts.post_status = 'publish' ) AND wp_posts.post_password = ''
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

This is using the c2c_get_recent_posts() function of the plugin.

It has “AND ( category_id = 4)” but the plugin then goes on and lists all categories of recent posts anyway.

Seriously, is there someone who’s going to be able to help me?

FYI, I did find something – the code wasn’t using wp_posts and wp_comments and wp_categories for the sql table calls. I changed that but it still isn’t working.

Here’s the SQL generated by the code:

SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)  AND ( category_id = 4) WHERE wp_posts.post_date <= '2007-07-16 13:15:53' AND ( wp_posts.post_status = 'publish' ) AND ( wp_posts.post_type = 'post' )

I’m still newish to the table/db structure, can anyone else find something wrong with that SQL right off the bat that would cause an issue?

Scratch that, I even tried Limit Categories in php4.x (downgraded my server temporarily, since it’s pretty easy to do that with my host) and THAT didn’t even work. When I went to look at/edit categories in the admin panel (logged in as admin), all categories are missing, and you can’t add new ones. You get the category headers, but nothing else.

I really need Limit Categories to work in order to implement the new version of my site.