alexz31

$sql = "SELECT SET SQL_BIG_SELECTS=1 c.*,

$sql = "SELECT c.*,

/* ==================================================================================================== */
 
/* ==================================================================================================== */
 
 
 
    public function getComments($target, $target_id, $cfg){
 
 
 
        $comments = array();
 
 
 
        if (!$cfg['edit_minutes']) { $cfg['edit_minutes'] = 0; }
 
 
 
        $sql = "SELECT $sql = "SELECT SET SQL_BIG_SELECTS=1 c.*, c.*,
 
                       IFNULL(v.total_rating, 0) as votes,
 
					   IFNULL(u.nickname, 0) as nickname,
 
					   IFNULL(u.login, 0) as login,
 
					   IFNULL(u.is_deleted, 0) as is_deleted,
 
					   IFNULL(p.imageurl, 0) as imageurl,
 
                       (NOW() < DATE_ADD(c.pubdate, INTERVAL {$cfg['edit_minutes']} MINUTE)) as is_editable
 
                FROM cms_comments c
 
                LEFT JOIN cms_ratings_total v ON v.item_id = c.id AND v.target = 'comment'
 
				LEFT JOIN cms_users u ON u.id = c.user_id
 
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
 
                WHERE c.target='$target' AND c.target_id=$target_id AND c.published=1
 
                ORDER BY c.pubdate ASC";
 
 
 
        $result = $this->inDB->query($sql);
 
 
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
 
 
        while($comment = $this->inDB->fetch_assoc($result)){
 
			$comment['fpubdate'] = cmsCore::dateFormat($comment['pubdate'], true, true);
 
            $comments[] = $comment;
 
        }
 
 
 
        $comments = cmsCore::callEvent('GET_COMMENTS', $comments);
 
 
 
        return $comments;
 
 
 
    }
 
 
 
    public function getComment($id, $cfg) {
 
 

DATABASE ERROR:
SELECT c.*,
                       IFNULL(v.total_rating, 0) as votes,
					   IFNULL(u.nickname, 0) as nickname,
					   IFNULL(u.login, 0) as login,
					   IFNULL(u.is_deleted, 0) as is_deleted,
					   IFNULL(p.imageurl, 0) as imageurl,
                       (NOW() < DATE_ADD(c.pubdate, INTERVAL 30 MINUTE)) as is_editable
                FROM cms_comments c
                LEFT JOIN cms_ratings_total v ON v.item_id = c.id AND v.target = 'comment'
				LEFT JOIN cms_users u ON u.id = c.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE c.target='photo' AND c.target_id=26 AND c.published=1
                ORDER BY c.pubdate ASC
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay