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&type=stories&author=2\">More by Admin</a><li><a href=\"http://ww
w.scooterb.net/weblog/search.php?mode=search&type=stories&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.
4
4
Quote
brownrc
Anonymous
PHP Version is 4.2.1
4
4
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?
4
3
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