05-15-2013, 04:12 AM
In 1.2.6.5 when using db prefix different from odm, an attempt to view certain category produces error ".. odm_data table missing ..". The reason is a bug in line 229 in category.php which requires 'odm_data' instead of {$GLOBALS['CONFIG']['db_prefix']}data. The bug is fixed by replacing the
WRONG LINE 229
$query = "SELECT id, realname FROM 'odm_data' WHERE category = '$category_id'";
with
CORRECT LINE 229
$query = "SELECT id, realname FROM {$GLOBALS['CONFIG']['db_prefix']}data WHERE category = '$category_id'";
WRONG LINE 229
$query = "SELECT id, realname FROM 'odm_data' WHERE category = '$category_id'";
with
CORRECT LINE 229
$query = "SELECT id, realname FROM {$GLOBALS['CONFIG']['db_prefix']}data WHERE category = '$category_id'";