• 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: ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 2 months ago #33922

  • adadear
  • adadear's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
Good day, i installed rsmediagallery on my joomla 3.4.8 website, but when i try to uninstall it, if i click on the manage i get error code (500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM te46d_extensions WHERE state=0 AND type='component' AND a.id != 842 AND a.id != 843 Unknown column 'a.id' in 'where clause' SQL=SELECT *,2*protected+(1-protected)*enabled as status FROM te46d_extensions WHERE state=0 AND type='component' AND a.id != 842 AND a.id != 843 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM te46d_extensions WHERE state=0 AND type='component' AND a.id != 842 AND a.id != 843)

2.
if i click on module and click new to add new module i also get error (500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `te46d_extensions` AS a WHERE a.type = 'module' AND a.client_id = 0 AND a.enabled = 1 AND a.id != 842 AND a.id != 843 Unknown column 'a.id' in 'where clause' SQL=SELECT a.extension_id, a.name, a.element AS module FROM `te46d_extensions` AS a WHERE a.type = 'module' AND a.client_id = 0 AND a.enabled = 1 AND a.id != 842 AND a.id != 843 ORDER BY a.name ASC)

3.
if i click on plugin manager i also get error (500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `te46d_extensions` AS a LEFT JOIN te46d_users AS uc ON uc.id=a.checked_out LEFT JOIN te46d_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 842 AND a.id != 843 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 `te46d_extensions` AS a LEFT JOIN te46d_users AS uc ON uc.id=a.checked_out LEFT JOIN te46d_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 842 AND a.id != 843 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `te46d_extensions` AS a LEFT JOIN te46d_users AS uc ON uc.id=a.checked_out LEFT JOIN te46d_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 842 AND a.id != 843)

plz how do i fix it, plz help me out
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 1 month ago #34271

Hi,

Why do you think this a RSMediaGallery! Problem?
The error states a certain column can't be found in your database
Regards
Wilco Alsemgeest

Please note: my help is not official customer support. To receive your support, submit a ticket by clicking www.rsjoomla.com/my-support-tickets.html
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34423

  • adadear
  • adadear's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
please how do i locate the error from the database and fix it.
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34428

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
adadear wrote:
please how do i locate the error from the database and fix it.

If this was a first time installation, i would recommend manually uninstalling the extension and try to install it again. Prior to doing this, please make sure that your Joomla! meets the extension minimum requirements.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34431

  • adadear
  • adadear's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
HOW DO I DELETE IT MANUALLY
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34432

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34433

  • adadear
  • adadear's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
i have done all that but am still have the same error code

500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM te46d_extensions WHERE state=0 AND a.id != 842 AND a.id != 843 Unknown column 'a.id' in 'where clause' SQL=SELECT *,2*protected+(1-protected)*enabled as status FROM te46d_extensions WHERE state=0 AND a.id != 842 AND a.id != 843 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM te46d_extensions WHERE state=0 AND a.id != 842 AND a.id != 843
The administrator has disabled public write access.

ERROR MESSAGES AFTER INSTALLING RSMEDIAGALLERY 8 years 3 weeks ago #34442

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Have you tried installing other extensions ? Are you getting errors for these as well ?

You are more then welcome to submit a support ticket about this so our staff members can have a closer look.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
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!