Welcome to Geeklog, Anonymous Friday, November 29 2024 @ 06:53 am EST

Geeklog Forums

Can't Create or edit story as an Admin


brownrc

Anonymous
Versions: Geeklog 1.3.5sr2 mysql 3.23.51 apache 1.3.26 When I try to create a new story or edit a submitted story, I get the following message in the browser: 1064: You have an error in your SQL syntax near '2,'Test','Test 3','TEst 3','TEst 3',0,'2002-07-18 10:44:00','0',' The full line from the error log is as follows: Thu Jul 18 10:45:14 2002 - 1064: You have an error in your SQL syntax near '2,'T est','Test 3','TEst 3','TEst 3',0,'2002-07-18 10:44:00','0','<li><a href=\"h' at line 1 SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,bo dytext,hits,date,comments,related,featured,commentcode,statuscode,postmode,front page,draft_flag,numemails,owner_id,group_id,perm_owner,perm_group,perm_members,p erm_anon,show_topic_icon) VALUES (,2,'Test','Test 3','TEst 3','TEst 3',0,'2002-0 7-18 10:44:00','0','<li><a href=\"http://www.scooterb.net/weblog/search.php?mode =search&amp;type=stories&amp;author=2\">More by Admin</a><li><a href=\"http://ww w.scooterb.net/weblog/search.php?mode=search&amp;type=stories&amp;topic=Test\">M ore from Test Topic</a>',0,'0','0','html','1',0,0,2,3,3,3,2,2,0) From what I can tell from the Error Message, It looks like the Story ID (sid) is not being set. Any help would be appreciated. BTW, Approving a submitted story seems to work OK.
 Quote

brownrc

Anonymous
PHP Version is 4.2.1
 Quote

brownrc

Anonymous
I've tested this in IE6, NN4.78, NN6, Mozilla 1, and Links and it behaves the same in each one. The hidden input value sid is not sent. In Lynx, however, it does work. What gives? Has anyone else seen this?
 Quote

All times are EST. The time is now 06:53 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