Posted on: 01/13/06 01:04am
By: Anonymous (BDUB)
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:
01/11/06 13:07:29 - 1292: Incorrect datetime value: '' for column 'rdfupdated' at row 1. SQL in question: INSERT INTO gl_blocks (name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled) VALUES ('FoxNews','FoxNews','','portal','0','','all','http://www.foxnews.com/xmlfeed/rss/0,4313,1,00.rss','','0','',0,4,4,3,2,2,2,1)
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.....
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/13/06 03:11pm
By: Dirk
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.
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/13/06 08:21pm
By: Anonymous (BDUB)
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.
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/16/06 02:44pm
By: Anonymous (BDUB)
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)
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/19/06 10:34am
By: Anonymous (BDUB)
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...
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/19/06 01:49pm
By: Dirk
A (potential, since I couldn't reproduce it) fix fo this is in CVS now. Update admin/block.php and try again.
bye, Dirk
SQL error in 1.4.0 not in 1.3.* when using RSS feed
Posted on: 01/20/06 09:16am
By: Anonymous (BDUB)
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.....