Wednesday, 22 February 2017
  2 Replies
  1K Visits
0
Votes
Undo
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
8 years ago
·
#184066
Accepted Answer
0
Votes
Undo
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
8 years ago
·
#183996
0
Votes
Undo
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.

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!

8 years ago
·
#184066
Accepted Answer
0
Votes
Undo
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
  • Page :
  • 1
There are no replies made for this post yet.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.