Welcome to Geeklog, Anonymous Saturday, November 30 2024 @ 07:37 am EST

Geeklog Forums

SQL error when submitting story


Antiqueone

Anonymous
On one of my websites using Geeklog 4.1.5 everyone except for one Group can submit stories. However, with one group I get the following error when a story is submitted.
Sun 21 Sep 2008 22:24:18 BST - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Wink, 'html', '0', '1', '1', '', '6', '3', '2', '2', '2'Wink' at line 1. SQL in question: REPLACE INTO geek_stories (sid, uid, draft_flag, tid, date, title, introtext, bodytext, hits, numemails, comments, trackbacks, related, featured, show_topic_icon, commentcode, trackbackcode, statuscode, expire, postmode, advanced_editor_mode, frontpage, in_transit, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('20080921222418177', '122', '0', 'Bunting_Queries', FROM_UNIXTIME(1222032258), 'Test', 'This is a test to resolve a problem reported by a user!', '', '0', '0', '0', '0', '', '', '1', '0', '1', '', FROM_UNIXTIME(), 'html', '0', '1', '1', '', '6', '3', '2', '2', '2'Wink

The group that has these problems has no special privileges other than if a story belongs to that group others can't read, but this should not affect story submission.
Can anyone help?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: Antiqueone

On one of my websites using Geeklog 4.1.5


I assume you mean Geeklog 1.5.0?

1.5.0 has 2 or 3 bugs in the story submission. Those are fixed in 1.5.1, which we will release later today. Stay tuned ...

bye, Dirk
 Quote

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