Posted on: 01/22/04 01:15pm
By: Anonymous (cybersnac)
I get this error when I try to submit a story even when logged in with full rights.
Thu Jan 22 08:46:18 2004 - User cybersnac tried to illegally submit or edit story 20040122084550338
Thu Jan 22 08:47:32 2004 - User Admin tried to illegally submit or edit story 2004012208472599
Thu Jan 22 08:48:10 2004 - User Admin tried to illegally submit or edit story 20040122084804322
Thu Jan 22 08:53:22 2004 - 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 ',,,)' at line 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,related,date,commentcode,postmode,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon) VALUES (20040122085212296,1,'','Hello','Just saying hello.','
<li><a href="http://www.cybersnac.com/search.php?mode=search&amp;type=stories&amp;author=1">More by Anonymous</a></li>
<li><a href="http://www.cybersnac.com/search.php?mode=search&amp;type=stories&amp;topic=">More from </a></li>
','2004-01-22 08:52:12',0,'plaintext',1,,,,,)
Thu Jan 22 09:12:46 2004 - 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 ',,,)' at line 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,related,date,commentcode,postmode,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon) VALUES (20040122085212296,1,'','Hello','Just saying hello.','
<li><a href="http://www.cybersnac.com/search.php?mode=search&amp;type=stories&amp;author=1">More by Anonymous</a></li>
<li><a href="http://www.cybersnac.com/search.php?mode=search&amp;type=stories&amp;topic=">More from </a></li>
','2004-01-22 08:52:12',0,'plaintext',1,,,,,)
Can anyone help me please?
Re:Error submitting stories
Posted on: 01/22/04 04:55pm
By: Tony
What do you mean by 'with full rights'? First I assume you are a root user, right? Also what permissions does the story in question have? Also on a whim, is this by any chance a custom theme you are using? If so try switching to one of the stock themes and see if it works.
Re:Error submitting stories
Posted on: 01/22/04 05:12pm
By: Anonymous (cybersnac)
the access rights is set to all users. The message that I don't have access to the story administrator page is still coming up but I double checked and the user I'm logged in as has all rights boxes checked including root.
Also, I've tried it with one of the standard themes as well as the theme I'm using at the moment
http://www.cybersnac.com is the URL if you would like to take a look at it, maybe try registering and give it a shot, I would be very grateful.