0
Undo
Votes
When I click the plugins under extnsion manager i get an error see below and I cannot access any plugins on the site
Error
Reinstalling Jevents I get an php out of date warning but my host will not update past 5.538
Some help would be appreciated please
Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915 Unknown column 'a.id' in 'where clause' SQL=SELECT a.extension_id , a.name, a.element, a.folder, a.checked_out, a.checked_out_time, a.enabled, a.access, a.ordering,uc.name AS editor,ag.title AS access_level FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915
Error
Reinstalling Jevents I get an php out of date warning but my host will not update past 5.538
Some help would be appreciated please
Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915 Unknown column 'a.id' in 'where clause' SQL=SELECT a.extension_id , a.name, a.element, a.folder, a.checked_out, a.checked_out_time, a.enabled, a.access, a.ordering,uc.name AS editor,ag.title AS access_level FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `jos_extensions` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 914 AND a.id != 915
The developers of PHP will not even provide security updates for php 5.5.38 (see http://php.net/eol.php) - you should push your webhost to update to a more secure version.
The error you are seeing is a general Joomla error, not related to JEvents or its addons. The extensions table does't have a column called 'id' it uses 'extension_id'
What version of Joomla are you using? I can find no reference to code like the code in your error in the Joomla com_plugins extension code.
The error you are seeing is a general Joomla error, not related to JEvents or its addons. The extensions table does't have a column called 'id' it uses 'extension_id'
What version of Joomla are you using? I can find no reference to code like the code in your error in the Joomla com_plugins extension code.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.