[Digital Jedi]

Supposedly there's a syntax error when trying to access a category.

Invalid SQL:

			SELECT SQL_CALC_FOUND_ROWS *
			FROM vb_vbglossar_entry AS entry
			
			WHERE categoryid = 3
				AND status IN (0,1)
				
				
			ORDER BY entry.name ASC
			LIMIT 0,;

MySQL Error   : 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 9
Error Number  : 1064

I'm not familiar with this error, but these seem to be the offending lines in vbglossar.php:

PHP Code:

    do
    {
        if (!$page)
        {
            $page = 1;
        }

        $limitlower = ($page - 1) * $perpage;

        // fetch all entries of defined category
        $hook_query_fields = $hook_query_joins = $hook_query_where = '';

        ($hook = vBulletinHook::fetch_hook('vbglossar_query_allentriesofcat')) ? eval($hook) : false;

        $entrylist = $db->query_read_slave("
            SELECT SQL_CALC_FOUND_ROWS *
            FROM " . TABLE_PREFIX . "vbglossar_entry AS entry
            $hook_query_joins
            WHERE categoryid = " . intval($catid) . "
                AND status IN (" . (($permissions['groupvbglossar'] & $vbulletin->bf_ugp['groupvbglossar']['canadminvbglossar']) ? "0,1" : "1") . ")
                $condition
                $hook_query_where
            ORDER BY " . $sqlsortfield . " " . $sortorder . "
            LIMIT $limitlower, $perpage
        ");

        $entriestotal = $db->found_rows();
        if ($limitlower >= $entriestotal)
        {
            $page = ceil($entriestotal / $perpage);
        }
    } 


But it seems to check out. Unless there's a deprecated function in here somewhere, I can't find it.