Phoca Forum

I have the newest version of Joomla 1.7 installed and just installed the newest version of phoca download. When in the "Files" tab I get this error

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/jimham4/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/jimham4/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/jimham4/public_html/libraries/joomla/database/database/mysqli.php on line 305

I need this fixed asap. Thanks

Hi, search this forum for similar posts - enable debug mode to get information from the database.

Jan

Your reply does not help me at all

What do you not understand?

- search this forum: this is commonly asked problem ... this is why the solution can be easily found in forum
- enable debug mode: debug mode says which error you have in database, it is the only one method to find the error in database

Jan

How do you enable debuging mode in phoca downloads

You must enabled the Debug Mode in Joomla not in Phoca.

Cash

Again I do not know how to enable debugging mode so I need you to tell me how to do it not that it needs to be done. I have three sites all currently updated to the newest joomla and newest phoca download. I need this issue fixed.

This error only shows up when I click on the files tab

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/expediti/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/expediti/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/expediti/public_html/libraries/joomla/database/database/mysqli.php on line 305

Hopefully this answers your question;

500 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,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 `js_phocadownload` AS a LEFT JOIN `js_languages` AS l ON l.lang_code = a.language LEFT JOIN js_users AS uc ON uc.id=a.checked_out LEFT JOIN js_users AS uua ON uua.id=a.userid LEFT JOIN js_viewlevels AS ag ON ag.id = a.access LEFT JOIN js_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN js_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /home/expediti/public_html/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/expediti/public_html/administrator/includes/application.php:153
3 require_once() /home/expediti/public_html/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/expediti/public_html/administrator/components/com_phocadownload/phocadownload.php:29
5 PhocadownloadCpController->display() /home/expediti/public_html/libraries/joomla/application/component/controller.php:684
6 JController->display() /home/expediti/public_html/administrator/components/com_phocadownload/controller.php:47
7 PhocaDownloadCpViewPhocaDownloadFiles->display() /home/expediti/public_html/libraries/joomla/application/component/controller.php:650
8 JView->get() /home/expediti/public_html/administrator/components/com_phocadownload/views/phocadownloadfiles/view.html.php:25
9 JModelList->getItems() /home/expediti/public_html/libraries/joomla/application/component/view.php:348
10 JModelList->getstart() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:126
11 JModelList->getTotal() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:258
12 JModel->_getListCount() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:226
13 JDatabaseMySQLi->query() /home/expediti/public_html/libraries/joomla/application/component/model.php:292
14 JError::raiseError() /home/expediti/public_html/libraries/joomla/database/database/mysqli.php:535
15 JError::raise() /home/expediti/public_html/libraries/joomla/error/error.php:250

Errors

JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,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 `js_phocadownload` AS a LEFT JOIN `js_languages` AS l ON l.lang_code = a.language LEFT JOIN js_users AS uc ON uc.id=a.checked_out LEFT JOIN js_users AS uua ON uua.id=a.userid LEFT JOIN js_viewlevels AS ag ON ag.id = a.access LEFT JOIN js_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN js_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
Information


Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home/expediti/public_html/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/expediti/public_html/administrator/includes/application.php:153
3 require_once() /home/expediti/public_html/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/expediti/public_html/administrator/components/com_phocadownload/phocadownload.php:29
5 PhocadownloadCpController->display() /home/expediti/public_html/libraries/joomla/application/component/controller.php:684
6 JController->display() /home/expediti/public_html/administrator/components/com_phocadownload/controller.php:47
7 PhocaDownloadCpViewPhocaDownloadFiles->display() /home/expediti/public_html/libraries/joomla/application/component/controller.php:650
8 JView->get() /home/expediti/public_html/administrator/components/com_phocadownload/views/phocadownloadfiles/view.html.php:25
9 JModelList->getItems() /home/expediti/public_html/libraries/joomla/application/component/view.php:348
10 JModelList->getstart() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:126
11 JModelList->getTotal() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:258
12 JModel->_getListCount() /home/expediti/public_html/libraries/joomla/application/component/modellist.php:226
13 JDatabaseMySQLi->query() /home/expediti/public_html/libraries/joomla/application/component/model.php:292
14 JError::raiseError() /home/expediti/public_html/libraries/joomla/database/database/mysqli.php:535
15 JError::raise() /home/expediti/public_html/libraries/joomla/error/error.php:250

Profile Information
Application 0.002 seconds (+0.002); 0.51 MB (+0.514) - afterLoad
Application 0.061 seconds (+0.060); 3.41 MB (+2.895) - afterInitialise
Application 0.065 seconds (+0.004); 3.49 MB (+0.081) - afterRoute
Memory Usage
5.34 MB (5,597,068 Bytes)
9 Queries Logged

SELECT `data`
FROM `js_session`
WHERE `session_id` = 'e3a6539ee00020ab80f8ed4afbc6cca3'
DELETE
FROM `js_session`
WHERE `time` < 1320763335
DELETE
FROM `js_session`
WHERE `time` < 1320763335
SELECT extension_id AS "id", element AS "option", params, enabled
FROM js_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM js_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM js_template_styles as s
LEFT JOIN js_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT extension_id AS "id", element AS "option", params, enabled
FROM js_extensions
WHERE `type` = 'component'
AND `element` = 'com_phocadownload'
SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,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 `js_phocadownload` AS a
LEFT JOIN `js_languages` AS l
ON l.lang_code = a.language
LEFT JOIN js_users AS uc
ON uc.id=a.checked_out
LEFT JOIN js_users AS uua
ON uua.id=a.userid
LEFT JOIN js_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN js_phocadownload_categories AS c
ON c.id = a.catid
LEFT JOIN js_users AS ua
ON ua.id = a.owner_id
WHERE (a.published IN (0, 1))
GROUP BY a.id
ORDER BY a.title asc
UPDATE `js_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:37;s:19:\"session.timer.start\";i:1320769431;s:18:\"session.timer.last\";i:1320770533;s:17:\"session.timer.now\";i:1320770535;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_content\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"article\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:17:\"com_phocadownload\";O:8:\"stdClass\":4:{s:17:\"phocadownloadstat\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:7:\"uc.name\";}s:18:\"phocadownloadusers\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:11:\"uc.username\";}s:19:\"phocadownloadrafile\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:11:\"uc.username\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:19:\"phocadownloadlayout\";O:8:\"stdClass\":2:{s:2:\"id\";a:1:{i:0;i:1;}s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:27:\"webmaster@expeditionman.com\";s:8:\"password\";s:65:\"ecd05aa88e4eede53e8ecaf511710649:aJyVYQDGuI1t88yN0XGPAZVXkPEdSX3N\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-25 19:32:44\";s:13:\"lastvisitDate\";s:19:\"2011-11-08 03:36:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"58ec14463136c33d5f6165b469bf5f5d\";}', `time` = 1320770535
WHERE `session_id` = 'e3a6539ee00020ab80f8ed4afbc6cca3'

7 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM js_extensions
1 × SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,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 `js_phocadownload` AS a LEFT JOIN `js_languages` AS l ON l.lang_code = a.language LEFT JOIN js_users AS uc ON uc.id=a.checked_out LEFT JOIN js_users AS uua ON uua.id=a.userid LEFT JOIN js_viewlevels AS ag ON ag.id = a.access LEFT JOIN js_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN js_users AS ua ON ua.id = a.owner_id
1 × SELECT template, s.params FROM js_template_styles as s LEFT JOIN js_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params FROM js_extensions
1 × SELECT `data` FROM `js_session`

OTHER Tables:

2 × DELETE FROM `js_session`
1 × UPDATE `js_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:37;s:19:\"session.timer.start\";i:1320769431;s:18:\"session.timer.last\";i:1320770533;s:17:\"session.timer.now\";i:1320770535;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_content\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"article\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:17:\"com_phocadownload\";O:8:\"stdClass\":4:{s:17:\"phocadownloadstat\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:7:\"uc.name\";}s:18:\"phocadownloadusers\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:11:\"uc.username\";}s:19:\"phocadownloadrafile\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:11:\"uc.username\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:19:\"phocadownloadlayout\";O:8:\"stdClass\":2:{s:2:\"id\";a:1:{i:0;i:1;}s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:27:\"webmaster@expeditionman.com\";s:8:\"password\";s:65:\"ecd05aa88e4eede53e8ecaf511710649:aJyVYQDGuI1t88yN0XGPAZVXkPEdSX3N\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-25 19:32:44\";s:13:\"lastvisitDate\";s:19:\"2011-11-08 03:36:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"58ec14463136c33d5f6165b469bf5f5d\";}', `time` = 1320770535

Come on I need to know how to fix this. Please help me out

Can I get some help please.