• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: 500 Unknown column 'a.id' in 'where clause' SQL=SE

500 Unknown column 'a.id' in 'where clause' SQL=SE 9 years 1 month ago #34552

  • joern71
  • joern71's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
Hello!
After installing RS Form Pro component i get this error:

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

Now it´s not possible to create new modules and i don´t see my plugins in admin area..
Please help me...
The administrator has disabled public write access.

500 Unknown column 'a.id' in 'where clause' SQL=SE 9 years 1 month ago #34585

  • andreic
  • andreic's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 745
  • Thank you received: 66
Hello,

This is not something that is caused by the RSForm!Pro component, but a general issue with your specific Joomla! installation. Performing a Google search on this matter provided several results:

forum.joomla.org/viewtopic.php?f=708&t=907218
forum.joomla.org/viewtopic.php?f=615&t=775779
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
Last Edit: 9 years 1 month ago by andreic.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!