500 - An error has occured

More
11 years 11 months ago #28864 by kingston.clinton
Hi Ivan

Can you tell me what the following error means. I found it when clicking on language manager/content tab.
Could this be the reason why my booking calendar is displaying incorrectly..see JPEG



500 - An error has occurred.

Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `hspw8_languages` AS a LEFT JOIN hspw8_viewlevels AS ag ON ag.id = a.access LEFT JOIN `hspw8_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `hspw8_languages` AS a LEFT JOIN hspw8_viewlevels AS ag ON ag.id = a.access LEFT JOIN `hspw8_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `hspw8_languages` AS a LEFT JOIN hspw8_viewlevels AS ag ON ag.id = a.access LEFT JOIN `hspw8_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc
Attachments:

Please Log in to join the conversation.

More
11 years 11 months ago #28872 by ivan.milic
Database error, try going to extension manager, "Database" tab , then see if there is some button saying click here to repair database, if yes click on it.

But i would rather say booking component has query build for older joomla database version.

Please Log in to join the conversation.

More
11 years 11 months ago #28889 by kingston.clinton
Hi

I clicked on the tab and repaired it but still it does not show correctly.
I will check with the vendor to see what joomla database its compatible with

Please Log in to join the conversation.

Time to create page: 0.163 seconds
Powered by Kunena Forum