Re: Issues with Joomla 1.7
Posted: 27 Jul 2011, 09:19
Thanks Jan for the fast bug fix.
It works! Best regards, Milian
It works! Best regards, Milian
Thanks Jan for the fast reply and fix,
It works! Regards, Milian
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`