Feedwordpress errors in wp 2.1

Baxter · 2007-01-28, 04:45 PM

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?

walrus · 2007-01-29, 03:23 PM

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.

zack2004 · 2007-01-29, 03:34 PM

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|

Baxter · 2007-01-29, 10:28 PM

Quote:

Originally Posted by walrus

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 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

hony · 2007-01-30, 03:19 AM

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.

tsanko · 2007-01-30, 04:09 AM

Which version of feedwordpress you use?

Baxter · 2007-01-30, 09:36 AM

Quote:

Originally Posted by tsanko

Which version of feedwordpress you use?

im using 0.98 version of FWP

Baxter · 2007-01-30, 09:52 AM

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

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

walrus · 2007-01-30, 12:19 PM

Quote:

Originally Posted by Baxter

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

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.

hony · 2007-01-30, 11:25 PM

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

walrus · 2007-01-31, 01:08 PM

Quote:

Originally Posted by hony

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.

hony · 2007-01-31, 08:17 PM

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

Baxter · 2007-02-03, 01:01 AM

anyone have any ideas on this yet?

oast · 2007-02-04, 09:07 PM

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

Baxter · 2007-02-04, 09:27 PM

Quote:

Originally Posted by oast

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

oast · 2007-02-04, 09:44 PM

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

2007-01-28, 04:45 PM	#1
Baxter Trying is the first step towards failure Join Date: Aug 2003 Location: Michigan Posts: 123	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? __________________ Baxter's Network - My Network Of Porn Sites!!!

2007-01-29, 03:23 PM	#2
walrus Oh no, I'm sweating like Roger Ebert Join Date: May 2005 Location: Los Angeles Posts: 1,773	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. __________________ Naked Girlfriend Porn TGP free partner account

2007-01-29, 03:34 PM	#3
zack2004 Ahhh ... sweet pity. Where would my love life be without it? Join Date: Apr 2004 Location: New Jersey, USA Posts: 209	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\| __________________ Zack Free XXX Twat Porn Links Twat Porn Blog

2007-01-30, 03:19 AM	#5
hony If something's hard to do, then it's not worth doing Join Date: Dec 2004 Posts: 249	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. __________________ $$$ Webcam programs that earn for me -- YMMV $$$

2007-01-30, 04:09 AM	#6
tsanko I'm going to the backseat of my car with the woman I love, and I won't be back for TEN MINUTES Join Date: Nov 2006 Posts: 84	Which version of feedwordpress you use? __________________ Stop hair loss Free sex blog Sex Toys

2007-01-30, 09:52 AM	#8
Baxter Trying is the first step towards failure Join Date: Aug 2003 Location: Michigan Posts: 123	and i have tried this patch with no luck as well.. http://wordpress.org/support/topic/5...=8#post-499823 __________________ Baxter's Network - My Network Of Porn Sites!!!

2007-01-30, 11:25 PM	#10
hony If something's hard to do, then it's not worth doing Join Date: Dec 2004 Posts: 249	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 __________________ $$$ Webcam programs that earn for me -- YMMV $$$

2007-01-31, 08:17 PM	#12
hony If something's hard to do, then it's not worth doing Join Date: Dec 2004 Posts: 249	Ok timeout is a good thought, thanks. I'll have to look into the code and stick in some debugging statements and see. __________________ $$$ Webcam programs that earn for me -- YMMV $$$

2007-02-03, 01:01 AM	#13
Baxter Trying is the first step towards failure Join Date: Aug 2003 Location: Michigan Posts: 123	anyone have any ideas on this yet? __________________ Baxter's Network - My Network Of Porn Sites!!!

2007-02-04, 09:07 PM	#14
oast With $10,000, we'd be millionaires! We could buy all kinds of useful things like ... love! Join Date: May 2004 Location: UK Posts: 316	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 __________________ Playboy Webmasters - The name says it all! $35 per signup or 60% revshare.

2007-02-04, 09:44 PM	#16
oast With $10,000, we'd be millionaires! We could buy all kinds of useful things like ... love! Join Date: May 2004 Location: UK Posts: 316	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 __________________ Playboy Webmasters - The name says it all! $35 per signup or 60% revshare.