Hey, thanks :-)
This is the Error:
Database query error
Query:
SELECT COUNT(*) FROM `bx_files_main`
left JOIN `Profiles` ON `Profiles`.`ID`=`bx_files_main`.`Owner` left
JOIN `bx_files_types` ON `bx_files_types`.`Type`=`bx_files_main`.`Type`
left JOIN `sys_albums_objects` ON
`sys_albums_objects`.`id_object`=`bx_files_main`.`ID` left JOIN
`sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left
JOIN `sys_categories` ON `sys_categories`.`ID`=`bx_files_main`.`ID`
WHERE 1 AND `bx_files_main`.`Status` ='approved' AND
`sys_categories`.`Category` ='Events' AND `sys_albums`.`Status`
='active' AND `sys_albums`.`Type` ='bx_files' AND
`bx_files_main`.`Owner` ='1' AND `sys_categories`.`Type` ='bx_files'
Mysql
error:
Table 'usr_web0_1.bx_files_main' doesn't exist
Found error in the file '/var/www/web0/html/inc/classes/BxDolSearch.php'
at line 511.
Called 'db_value' function with erroneous argument #0.
----------------------------------------------------------------------------------------------------------------------------------
function getCount () {
$aJoins = $this->getJoins(false);
$sqlQuery = "SELECT COUNT(*) FROM `{$this->aCurrent['table']}` {$aJoins['join']} " . $this->getRestriction() . " {$aJoins['groupBy']}";
return (int)db_value($sqlQuery);
}
--------------------------------------------------------------------------------------------------------------------------------------
This is Line 511: return (int)db_value($sqlQuery);