On certain posts, I get this long error after submission but the post is submitted either way.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20' at line 1' in /home/admin/web/website.com/public_html/forum/sys/CODOF/Forum/Post.php:53 Stack trace: #0 /home/admin/web/website.com/public_html/forum/sys/CODOF/Forum/Post.php(53): PDO->query('SELECT u.id, r....') #1 /home/admin/web/website.com/public_html/forum/sys/Controller/Ajax/forum/topic.php(84): CODOF\Forum\Post->get_posts(22, -1) #2 /home/admin/web/website.com/public_html/forum/sys/Controller/forum.php(373): Controller\Ajax\forum\topic->get_posts(22, -1, Array) #3 /home/admin/web/website.com/public_html/forum/routes.php(904): Controller\forum->topic(22, 'Before 19 Octob...') #4 [internal function]: {closure}('22', 'Created cPanel ...', 'Before 19 Octob...') #5 /home/admin/web/website.com/public_html/forum/sys/Ext/limonade/limonade.php(42 in /home/admin/web/website.com/public_html/forum/sys/CODOF/Forum/Post.php on line 53

This was an old problem which was fixed. Which version of codoforum are you using ?

I'm using codoforum.v.3.5.1. Upgraded to it from the backend.

hi guys

Getting the same error and I've just upgraded.

Error comes from trying to edit a post - then as soon as I click 'Save' I get the error

thanks

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20' at line 1' in /var/www/vhosts/ophm.org/httpdocs/forum/sys/CODOF/Forum/Post.php:53 Stack trace: #0 /var/www/vhosts/ophm.org/httpdocs/forum/sys/CODOF/Forum/Post.php(53): PDO->query('SELECT u.id, r....' #1 /var/www/vhosts/ophm.org/httpdocs/forum/sys/Controller/Ajax/forum/topic.php(84): CODOF\Forum\Post->get_posts(3, -1) #2 /var/www/vhosts/ophm.org/httpdocs/forum/sys/Controller/forum.php(373): Controller\Ajax\forum\topic->get_posts(3, -1, Array) #3 /var/www/vhosts/ophm.org/httpdocs/forum/routes.php(879): Controller\forum->topic(3, 'Nov 2016' #4 [internal function]: {closure}('3', 'The Osteopath m...', 'Nov 2016' #5 /var/www/vhosts/ophm.org/httpdocs/forum/sys/Ext/limonade/limonade.php(429): call_user_func_array(Object(Closure), Array) #6 /var/www/vhosts/ophm.org/httpdoc in /var/www/vhosts/ophm.org/httpdocs/forum/sys/CODOF/Forum/Post.php on line 53

This error was fixed.

Can you install v3.6 : https://bitbucket.org/evnix/codoforum_downloads/downloads/codoforum.v.3.6.build-10.zip ?

Thanks - is there a way to patch this ?

I can't contact him - tried clicking on the link and I get a fatal error !

I suppose I could dump the database, install the new version then just upload the dumped file ?

Just installed 3.6 and get the same error !

Can you post the content of sys/Forum/Topic.php ?

hi

That path doesn't exist...

In sys all I have is:

Sorry, it is sys/CODOF/Forum/Topic.php

thank you - attached

<?php

/*
 * @CODOLICENSE
 *  
 * 
 * issue system
 * 
 *    users can view own content
 *    users cannot view others content
 * 
 *    moderators/admin -> full priveleges
 * 
 * 
 * premium member system
 * 
 *   role A can access forum B
 * 
 * 
 * 
 * 
 */

namespace CODOF\Forum;

class Topic extends Forum {

    //put your code here

    protected $db;
    public $ajax = false;
    public $new_topic_ids = array();
    public $new_replies = array();
    public $tags = array();

    public function __construct($db) {

        $this->db = $db;
    }

    //TODO: make this a little more reusable
    public function get_topics($cat_id, $page = 1) {

        //$t = microtime(true);
        $cat_id = (int) $cat_id;
        $topics = array();
        $num_posts = \CODOF\Util::get_opt("num_posts_cat_topics");
        $from = ($page - 1) * $num_posts;
        //username , title, topic created, no of replies,
        $qry = 'SELECT p.post_id,p.omessage AS message, p.post_created, r.rid, u.id, u.name AS name, u.avatar, '
                . 't.topic_id, t.uid, t.no_posts, t.no_views, t.title, t.topic_created,last_post_id, '
                . 't.last_post_name AS lname, t.last_post_uid AS luid, t.last_post_time AS lpost_time,'
                . 't.topic_status '
                . 'FROM ' . PREFIX . 'codo_topics AS t '
                . 'LEFT JOIN ' . PREFIX . 'codo_posts AS p ON (t.post_id=p.post_id AND p.post_status=1) '
                . 'LEFT JOIN ' . PREFIX . 'codo_users AS u ON u.id=p.uid '
                . 'LEFT JOIN ' . PREFIX . 'codo_user_roles AS r ON u.id=r.uid AND r.is_primary=1 '
                . 'WHERE t.cat_id=' . $cat_id
                . ' AND ('
                . ' t.topic_status=' . Forum::APPROVED . ' OR'
                . ' t.topic_status=' . Forum::APPROVED_CLOSED . ' OR'
                . ' t.topic_status=' . Forum::STICKY . ' OR'
                . ' t.topic_status=' . Forum::STICKY_CLOSED . ' OR'
                . ' t.topic_status=' . Forum::STICKY_ONLY_CATEGORY . ' OR'
                . ' t.topic_status=' . Forum::STICKY_ONLY_CATEGORY_CLOSED . '  ) AND '
                . $this->getViewTopicPermissionConditions()
                . 'ORDER BY t.topic_status DESC, t.last_post_time DESC LIMIT ' . $num_posts . ' OFFSET ' . $from;

        $stmt = $this->db->query($qry);
        if ($stmt) {

            return $stmt->fetchAll();
        }

        return $topics;
    }

    public function getTaggedTopics($tag, $from = 0) {

        $_topics = array();
        //$t = microtime(true);
        $num_posts = \CODOF\Util::get_opt("num_posts_all_topics");
        //username , title, topic created, no of replies,
        $qry = 'SELECT p.post_id, p.omessage AS message, p.post_created, r.rid, u.id, u.name as name, u.avatar, c.cat_img, c.cat_alias,'
                . 't.topic_id, t.uid, t.title, t.no_posts, t.no_views, t.last_post_time, t.last_post_uid, '
                . 't.last_post_name AS last_post_name, t.topic_created, t.cat_id, last_post_id,t.topic_status '
                . 'FROM codo_topics AS t INNER JOIN codo_tags as g ON g.topic_id=t.topic_id '
                . 'LEFT JOIN codo_posts AS p ON (t.post_id=p.post_id AND p.post_status=1)'
                . 'LEFT JOIN codo_users AS u ON u.id=p.uid '
                . 'LEFT JOIN codo_categories AS c ON c.cat_id=t.cat_id '
                . 'LEFT JOIN ' . PREFIX . 'codo_user_roles AS r ON u.id=r.uid AND r.is_primary=1 '                
                . ' WHERE ('
                . ' t.topic_status=' . Forum::APPROVED . ' OR'
                . ' t.topic_status=' . Forum::APPROVED_CLOSED . ' OR'
                . ' t.topic_status=' . Forum::STICKY . ' OR'
                . ' t.topic_status=' . Forum::STICKY_CLOSED . ' OR'
                . ' t.topic_status=' . Forum::STICKY_ONLY_CATEGORY . ' OR'
                . ' t.topic_status=' . Forum::STICKY_ONLY_CATEGORY_CLOSED . '  ) AND '
                . $this->getViewTopicPermissionConditions()
                . ' AND g.tag_name=' . $this->db->quote($tag)
                . ' ORDER BY t.last_post_time DESC LIMIT  ' . $num_posts . ' OFFSET ' . $from;

        $ans = $this->db->query($qry);
        //echo $qry;
        if ($ans) {

            $topics = $ans->fetchAll();
            $_topics = $this->gen_topic_arr_all_topics($topics);
        }
        //echo " <br/>get_all_topics() ";
        //echo microtime(true) - $t;

        return $_topics;
    }

Can you email me that file and sys/CODOF/Forum/Post.php ? (admin[@]codologic.com)

As its difficult to tell all the changes here.

Files have been emailed now, thank you