2.0.1 Data Base Issues

[kriegerog]

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

[Jan]

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

Jan

[kriegerog]

Your reply does not help me at all

[Jan]

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

[kriegerog]

How do you enable debuging mode in phoca downloads

[cash]

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

Cash

[kriegerog]

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

[kriegerog]

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

[kriegerog]

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

[kriegerog]

Can I get some help please.