Welcome to Geeklog, Anonymous Monday, November 28 2022 @ 06:54 am EST

Geeklog Forums

SQL error in 1.4.0 not in 1.3.* when using RSS feed


BDUB

Anonymous
confused
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:
Text Formatted Code
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.....
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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.
 Quote

BDUB

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

 Quote

BDUB

Anonymous
confused
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)
 Quote

BDUB

Anonymous
determined
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...
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
A (potential, since I couldn't reproduce it) fix fo this is in CVS now. Update admin/block.php and try again.

bye, Dirk
 Quote

BDUB

Anonymous
happy
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.....
 Quote

All times are EST. The time is now 06:54 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content