Quote Originally Posted by torvista View Post
There is a small error in the category query, using an undefined variable. It does not cause a problem, but does raise a php notice if you have that level of reporting enabled.

in
\includes\functions\extra_functions\categories_select.php

change

PHP Code:
$categories_query "select c.parent_id, c.categories_id, cd.categories_name, c.categories_status
                         from " 
TABLE_CATEGORIES " c, " TABLE_CATEGORIES_DESCRIPTION " cd
                         where " 
$zc_status "
                         parent_id = '" 
. (int)$parent_id "'
                         and c.categories_id = cd.categories_id
                         and c.categories_status=1
                         and cd.language_id = '" 
. (int)$_SESSION['languages_id'] . "'
                         order by sort_order, cd.categories_name"

to

PHP Code:
    $categories_query "select c.parent_id, c.categories_id, cd.categories_name, c.categories_status
                         from " 
TABLE_CATEGORIES " c, " TABLE_CATEGORIES_DESCRIPTION " cd
                         where parent_id = '" 
. (int)$parent_id "'
                         and c.categories_id = cd.categories_id
                         and c.categories_status=1
                         and cd.language_id = '" 
. (int)$_SESSION['languages_id'] . "'
                         order by sort_order, cd.categories_name"

Perhaps you should upload it again with this fix? I've got people emailing me about the error filling up their log files. :)