By ricmcd on Wednesday, 22 February 2017
Replies 2
Likes 1
Views 1.1K
Votes 0
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
Resolved
The error was coming form another plug in that had an issue with the latest joomla release , but I aam also moving the site to a host with a more update php policy
·
Thursday, 23 February 2017 11:37
·
1 Likes
·
0 Votes
·
0 Comments
·
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.
·
Wednesday, 22 February 2017 09:07
·
1 Likes
·
0 Votes
·
0 Comments
·
View Full Post