We currently own RSForm Pro and are setting up the ability to have a multiple value selection when completing a Paypal purchase. We followed these instructions to do so. www.rsjoomla.com/support/documentation/r...ign=rsformpro-paypal

After completing this when trying to access the plugins section of the admin page we receive the following error:

Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `qy2io_extensions` AS a LEFT JOIN qy2io_users AS uc ON uc.id=a.checked_out LEFT JOIN qy2io_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 1320 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 `qy2io_extensions` AS a LEFT JOIN qy2io_users AS uc ON uc.id=a.checked_out LEFT JOIN qy2io_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 1320 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `qy2io_extensions` AS a LEFT JOIN qy2io_users AS uc ON uc.id=a.checked_out LEFT JOIN qy2io_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 1320



Please advise as what to do to get rid of this error message.

Thanks

Hello,

The article that you have linked provides instructions on how to add a quantity functionality to the RSForm!Pro payment plugin through Javascript. This will not affect the functionality of the Joomla! installation's Plugins manager.

The Plugins area is part of the Joomla! administration and it seems you have an issue with a recent Joomla! update. I'm sure the same issue shows up in the Templates section as this forum post suggests:
forum.joomla.org/viewtopic.php?f=708&t=907218

You can try and follow this forum post for advice as it seems the only one with the solution (if you search on Google for "unknown column 'a.id' in 'where clause' sql=select count(*) from" lots of results show up but few contain anything useful):
forum.joomla.org/viewtopic.php?f=708&t=895697