This comes from another thread but I'm sure that PHP 5 must either be missing a setting or has something set that PHP 4.x.x didn't have. I just installed a fresh install of GL 1.4 tried to submit a storie and received
An SQL error has occurred. Please see error.log for details.
Checking the GL 1.4 error log I find.
Text Formatted Code
2/23/05 15:45:24 - 1366: Incorrect integer value: '' for column 'statuscode' at row 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,bodytext,hits,date,comments,related,featured,commentcode,trackbackcode,statuscode,expire,postmode,frontpage,draft_flag,numemails,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,show_topic_icon,in_transit) VALUES ('20051223154507351',2,'GeekLog','test','test','',0,FROM_UNIXTIME(1135370707),'0','',0,'0','-1','',FROM_UNIXTIME(943981207),'plaintext','1',0,0,2,3,3,2,2,2,1,1)