Issues with Joomla 1.7

[Milian]

Thanks Jan for the fast bug fix.
It works! Best regards, Milian

[Milian]

Thanks Jan for the fast reply and fix,
It works! Regards, Milian

[ltempest]

I've applied the patch from this thread but get this error message repeated three time when clicking on the Files option:

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

Any idea of how to fix. Nothing is displayed underneath the errors, but files are available in the frontend.

Hope you can help

Lee

When I turn on debug I get this screed of text when clicking on the files button:

Code: Select all

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 `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_users AS uua ON uua.id=a.userid 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 a.title asc

Return to Control Panel

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

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 `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_users AS uua ON uua.id=a.userid 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 a.title asc
    Information


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

Profile Information
Application 0.002 seconds (+0.002); 0.57 MB (+0.574) - afterLoad
Application 0.090 seconds (+0.088); 5.96 MB (+5.389) - afterInitialise
Application 0.118 seconds (+0.028); 6.54 MB (+0.581) - afterRoute
Memory Usage
9.07 MB (9,512,776 Bytes)
9 Queries Logged

    SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '6093db26d136e9e829b0acbeeff5f9a4'
    DELETE
      FROM `jos_session`
      WHERE `time` < 1311857697
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT folder AS type, element AS name, params
      FROM jos_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 jos_template_styles as s
      LEFT JOIN jos_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 jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_advancedmodules'
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_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 `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_users AS uua
      ON uua.id=a.userid
      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 a.title asc
    UPDATE `jos_session`
      SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:83:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0.1) Gecko/20100101 Firefox/5.0.1\";s:15:\"session.counter\";i:36;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:9:\"com_menus\";O:8:\"stdClass\":1:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}}s:19:\"com_advancedmodules\";O:8:\"stdClass\":3:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:10:\"mod_custom\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}s:3:\"add\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":1:{s:12:\"extension_id\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
      limit\";s:2:\"20\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"
      group\";}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:11:\"Lee Tempest\";s:8:\"username\";s:12:\"gloscicadmin\";s:5:\"email\";s:26:\"lee@litchfieldmorris.co.uk\";s:8:\"password\";s:65:\"bb0b5703ff6af7ec76de48c7f91e8b99:MihayTwY1qv0vXx7F3i4K2NBIeyNq8SP\";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-03-29 15:58:13\";s:13:\"lastvisitDate\";s:19:\"2011-07-28 10:47:19\";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:\"432b428a2f53ded0c374b91964b9bbe5\";s:19:\"session.timer.start\";i:1311851819;s:18:\"session.timer.last\";i:1311858590;s:17:\"session.timer.now\";i:1311858597;}__wf|a:1:{s:13:\"session.token\";s:32:\"b7712f330c8d1167fb08b7034845c086\";}', `time` = 1311858597
      WHERE `session_id` = '6093db26d136e9e829b0acbeeff5f9a4'

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

    3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_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 `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_users AS uua ON uua.id=a.userid 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
    1 × SELECT template, s.params FROM jos_template_styles as s LEFT JOIN jos_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 jos_extensions
    1 × SELECT `data` FROM `jos_session`

OTHER Tables:

    1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:83:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0.1) Gecko/20100101 Firefox/5.0.1\";s:15:\"session.counter\";i:36;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:9:\"com_menus\";O:8:\"stdClass\":1:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}}s:19:\"com_advancedmodules\";O:8:\"stdClass\":3:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:10:\"mod_custom\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}s:3:\"add\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":1:{s:12:\"extension_id\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"group\";}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:11:\"Lee Tempest\";s:8:\"username\";s:12:\"gloscicadmin\";s:5:\"email\";s:26:\"lee@litchfieldmorris.co.uk\";s:8:\"password\";s:65:\"bb0b5703ff6af7ec76de48c7f91e8b99:MihayTwY1qv0vXx7F3i4K2NBIeyNq8SP\";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-03-29 15:58:13\";s:13:\"lastvisitDate\";s:19:\"2011-07-28 10:47:19\";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:\"432b428a2f53ded0c374b91964b9bbe5\";s:19:\"session.timer.start\";i:1311851819;s:18:\"session.timer.last\";i:1311858590;s:17:\"session.timer.now\";i:1311858597;}__wf|a:1:{s:13:\"session.token\";s:32:\"b7712f330c8d1167fb08b7034845c086\";}', `time` = 1311858597
    1 × DELETE FROM `jos_session`

[Jan]

Hi, you should install Phoca Download 2.0.0,not upgrade or you need to run the latest row in install.sql.bak file in your database to add the missing column.

Search other post regarding missing a.userid column.

Jan