Geeklog Forums

Trying to add news feeds to my site, foxnews is the first one I've tried. I get a SQL error when I add it to the portal block, and an error in the error.log file as follows:



In GL 1.3.*, i'm fine...... ideas? I'm convinced it has to be something I'm doing but theres not much to putting in a rss feed.....

Not sure why the INSERT in 1.4.0 would cause an SQL error, while the REPLACE INTO in 1.3.x would not. Which MySQL version are you on?

I guess strictly speaking, Geeklog is doing something wrong here, as it tries to set a DATETIME field to an empty string. Doesn't cause an error for me, though, on MySQL 5.0.18.

I'll put that on the to-do list for 1.4.0rc2.

bye, Dirk

P.S. And please don't double post - I saw your post the first time around.

I was trying to use the rss feed on one of the servers at work (trying to design an intranet page), its a Win2k server box, MySQL 5.0.18-nt....

Also tried it out on my personal website, running MySQL 4.0.25 / linux.....same error.

But it works on the website at work running Geeklog 1.3.11....

And sorry about the double post.....thx for the reply.

It gets better......

Decided "why do I need to run 1.4.0? I'll just use 1.3.11sr3 and be fine."

Suddenly on a different install 1.3.11 shoots the same error. Theres gotta be some pattern going on here.

01/16/2006 02:31:05 PM - 1292: Incorrect datetime value: '' for column 'rdfupdated' at row 1. SQL in question: REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled) VALUES (0,'Foxnews','Foxnews','','portal','0','','all','http://www.foxnews.com/xmlfeed/rss/0,4313,72,00.rss','','',0,4,4,3,2,2,2,1)

Now i'm working with nothing but 1.3.11sr3. Theres gotta be a simple fix for this.

I installed onto MySQL 5.0.18-nt, PHP 5.1.1, Apache 2.0.55 (Windows 2000 Server)

Fresh install of 1.3.11sr3 today, set nothing more then the basics in the config file (Directories/config location/theme directory/mysql info)

Went to put a portal block in.

I typed the block title (FoxNews), the block name (FoxNews), set the block type to portal block, and put in the rss url (http://www.foxnews.com/xmlfeed/rss/0,4313,1,00.rss).

I hit save, and get a sql error. (I've tried other rss feeds, (ex: cnn, etc)

The error.log file shows this: 01/19/2006 10:13:07 AM - 1292: Incorrect datetime value: '' for column 'rdfupdated' at row 1. SQL in question: REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled) VALUES (0,'FoxNews','FoxNews','','portal','0','','all','http://www.foxnews.com/xmlfeed/rss/0,4313,1,00.rss','','',0,2,4,3,2,2,2,1)

If i'm reading this correctly, its trying to send a blank value for the date right???

Tried geeklog 1.4.0 on this server, same thing. Tried saving the same block on my personal geeklog site (on a different server, linux server) running 1.4.0, same thing. Tried on yet a different server running 1.3.11sr1 (yes, bad bad not patching).......it suprisingly works...

A (potential, since I couldn't reproduce it) fix fo this is in CVS now. Update admin/block.php and try again.

bye, Dirk

Reinstalled back to Geeklog 1.4.0rc1 (still had the errors, and also noticed in both versions I couldn't save a story either, blocks and stories were screwed up.)

Grabbed block.php off of the cvs........fixed that.

Stories were still screwed up, grabbed story.php........fixed that.

Thanks for your help Dirk,
you rock.....