Geeklog Forums

Fri 27 Jun 2008 02:39:34 GMT+6 - 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 '), 'html', '0', '1', '1', '', '3', '3', '2', '2', '2')' at line 1. SQL in question: REPLACE INTO gl_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 ('20080627023934835', '3', '0', 'Trash', FROM_UNIXTIME(1214555974), 'test', 'http://test.com', 'test', '0', '0', '0', '0', '', '', '1', '0', '0', '', FROM_UNIXTIME(), 'html', '0', '1', '1', '', '3', '3', '2', '2', '2')

Fri 27 Jun 2008 02:39:40 GMT+6 - 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 '), 'html', '0', '1', '1', '', '3', '3', '2', '2', '2')' at line 1. SQL in question: REPLACE INTO gl_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 ('20080627023940519', '3', '0', 'Trash', FROM_UNIXTIME(1214555980), 'test', 'http://test.com', 'test', '0', '0', '0', '0', '', '', '1', '0', '0', '', FROM_UNIXTIME(), 'html', '0', '1', '1', '', '3', '3', '2', '2', '2')
 

 
   /**
     * Loads a submitted story from postdata
     */
    function loadSubmission()
    {
        $array = $_POST;
 

        $this->_expire = time();
        $this->_expiredate = 0;
 

    /**
     * Loads a submitted story from postdata
     */
    function loadSubmission()
    {
        $array = $_POST;
       
        $this->_expire = time();
        $this->_expiredate = 0;

        // Handle Magic GPC Garbage:
        while (list($key, $value) = each($array))
        {
            $array[$key] = COM_stripslashes($value);
        }

        $this->_postmode = COM_applyFilter($array['postmode']);
        $this->_sid = COM_applyFilter($array['sid']);
        $this->_uid = COM_applyFilter($array['uid'], true);
        $this->_unixdate = COM_applyFilter($array['date'], true);

        if (!isset($array['bodytext'])) {
            $array['bodytext'] = '';
        }

        /* Then load the title, intro and body */
        if (($array['postmode'] == 'html') || ($array['postmode'] == 'adveditor')) {
            $this->_htmlLoadStory($array['title'], $array['introtext'], $array['bodytext']);

            if ($this->_postmode == 'adveditor') {
                $this->_advanced_editor_mode = 1;
                $this->_postmode = 'html';
            } else {
                $this->_advanced_editor_mode = 0;
            }
        } else {
            $this->_advanced_editor_mode = 0;
            $this->_plainTextLoadStory($array['title'], $array['introtext'], $array['bodytext']);
        }

        $this->_tid = COM_applyFilter($array['tid']);

        if (empty($this->_title) || empty($this->_introtext)) {
            return STORY_EMPTY_REQUIRED_FIELDS;
        }

        return STORY_LOADED_OK;
    }