Feedwordpress errors in wp 2.1
 

I have found that new blogs im making with the new version of wp have errors with feedwordpress....and i tried auto blog...and it doesnt have the options that feedwordpress has...


here is the errors im getting

WordPress database error: [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 'WHERE cat_name='Contributors'' at line 2]
SELECT cat_id FROM WHERE cat_name='Contributors'

WordPress database error: [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 'SET cat_id = 0, cat_name='Contributors', show_images='N', sh' at line 2]
INSERT INTO SET cat_id = 0, cat_name='Contributors', show_images='N', show_description='N', show_rating='N', show_updated='N', sort_order='name'

WordPress database error: [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 'ORDER BY cat_id' at line 1]
SELECT cat_id, cat_name, auto_toggle FROM ORDER BY cat_id


what are you guys using for feeds with the new wp version?

I don't have an answer to your problem and I really dont mean to hijack your thread but....

Someday, we'll have to have a little discussion about feedwordpress and autoblog. What options is it in feedwordpress is it that your missing in autoblog?

I originally switched to WP-Autoblog because I was having a problem where FeedWordPress was reading in the whole feed whether it was updated or not. The specific feed only updated once a week...so I would end up with something like 70 copies of the same post.

If you want to be on the "Bleeding Edge" of any program, you should know the risks. Try the Wordpress forum which has info about 2.1 |shocking|

I like the options it had to be able to choose the catagory the feeds went into...i dont like the idea it makes new catagorys...so of the feed catagorys i dont want

Glad I saw this warning! I was thinking of upgrading my feedwordpress driven site to 2.1 but now I'll wait a bit.

And maybe try autoblog, not tried that yet. I don't mind feeds making new categories.

What I would like though is to be able to map different categories together -- I have multiple feeds and they use different terms for basically the same thing.

Which version of feedwordpress you use?

im using 0.98 version of FWP

and i have tried this patch with no luck as well..:(

http://wordpress.org/support/topic/5...=8#post-499823

That explains it...since my categories are all over the place anyway...that just doesn't matter and I like the simplicity of Auto Blog.

Actually feedwordpress seems to have stopped working for me, partially at least.

I just realized that this site isn't getting any new posts from several feeds. When I try to run update-feeds.php manually it tells me that there are no new posts -- but if I open the rss direclty I can see posts dated today.

How does it tell they are "new"? Maybe they duplicate old posts already in the database. I'm using feeds here from cam sites so it's all about the girls, and there are a finite number of girls who are actaully active anyway.

Maybe I've sucked up everything they have -- that'd be sad.

I could assign a writer to do more stuff on this site but that'd spoil the whole idea of trying to see if a purely feed driven site will make money.

Hony

My guess is that it's timing out for some reason before it gets a complete response. I saw somewhere how to modify the code to increase the time. I'll see if I can't remember where...unless someone who hasn't burnt as many brain cells as myself can come along first.

Ok timeout is a good thought, thanks. I'll have to look into the code and stick in some debugging statements and see.

anyone have any ideas on this yet?

I haven't tried, but I imagine you will need to change the database calls, specifically the category calls.
http://codex.wordpress.org/Database_..._wp_categories is the new format
http://codex.wordpress.org/Database_Description/2.0 is the old

There are a number of differences. That will get you up and running again :)

As far as generating new categories on your site.. you can set aliases in your existing categories so FWP inserts them into these if the spelling is slighly different. I look at feeds first to see what categories it is using, update my alias to conform then import the feed

Look at the 'Categories' section of the docs of FWP for more info. Same can be done if you utilise author links

i have no problem with feedwordpress its working on 30 of my blogs but the newest ones have the newest version of WP .. 2.1 ..and FWP does not work with it...thats my problem

Look in the script and change the database calls to reflect the change of table and field names as I pointed out in my post