Phoca Forum

The component installs fine. If I try to go to any of the Phoca Download buttons I get the following error. Can someone please tell me how to fix this?

500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'joomla.jos_phocadownload' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `jos_phocadownload` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.name asc

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() C:\xampp\htdocs\Joomla\administrator\index.php:47
2 JComponentHelper::renderComponent() C:\xampp\htdocs\Joomla\administrator\includes\application.php:154
3 require_once() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\helper.php:152
4 JController->execute() C:\xampp\htdocs\Joomla\administrator\components\com_phocadownload\phocadownload.php:26
5 PhocadownloadCpController->display() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\controller.php:649
6 JController->display() C:\xampp\htdocs\Joomla\administrator\components\com_phocadownload\controller.php:85
7 PhocaDownloadCpViewPhocaDownloadFiles->display() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\controller.php:616
8 JView->get() C:\xampp\htdocs\Joomla\administrator\components\com_phocadownload\views\phocadownloadfiles\view.html.php:25
9 JModelList->getItems() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\view.php:365
10 JModelList->getstart() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\modellist.php:118
11 JModelList->getTotal() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\modellist.php:244
12 JModel->_getListCount() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\modellist.php:213
13 JDatabaseMySQL->query() C:\xampp\htdocs\Joomla\libraries\joomla\application\component\model.php:252
14 JError::raiseError() C:\xampp\htdocs\Joomla\libraries\joomla\database\database\mysql.php:208
15 JError::raise() C:\xampp\htdocs\Joomla\libraries\joomla\error\error.php:179

Hi,

Table 'joomla.jos_phocadownload'

means, the tables were not added into database while installing, try to see:
https://www.phoca.cz/documents/17-phoca- ... em-solving

Jan

For me the problem was with SEF. Found the way to solve it here: https://www.phoca.cz/documents/16-joomla ... -in-joomla
I hope it helps.

same here, and i replaced the #__ with my allabout.cue85_ but still the same error comes up.

this is from myphpadmin


Database

allabout (103)

+ # (1)
Structure allabout.cue85_phocadownload
Structure allabout.cue85_phocadownload_categories
Structure allabout.cue85_phocadownload_file_votes
Structure allabout.cue85_phocadownload_file_votes_statistics
Structure allabout.cue85_phocadownload_layout
Structure allabout.cue85_phocadownload_licenses
Structure allabout.cue85_phocadownload_tags
Structure allabout.cue85_phocadownload_tags_ref
Structure allabout.cue85_phocadownload_user_stat
Structure cue85_assets

and this is the error

JDatabaseMySQLi::query: 1146 - Table 'allabout.cue85_phocadownload_categories' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `cue85_phocadownload_categories` AS a LEFT JOIN `cue85_languages` AS l ON l.lang_code = a.language LEFT JOIN cue85_users AS uc ON uc.id=a.checked_out LEFT JOIN cue85_viewlevels AS ag ON ag.id = a.access LEFT JOIN cue85_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM cue85_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Hi, really no idea what can be wrong, if you are sure, there is table: phocadownload_categories, really no idea how Joomla! can return error with missing such table - check if you are working in right database, check the cache settings

Jan