1054 Error ?!?

  • bujinkanat
  • bujinkanat's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 5 months ago - 2 years 5 months ago #639 by bujinkanat
bujinkanat created the topic: 1054 Error ?!?
Hi, after upgrading from Joomla Version 3.4.1 to 3.4.2 - an 1054 Error in Simplecalendar occured:

Unknown column 'i.language' in 'on clause' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM jos_categories as c LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_simplecalendar' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `jos_simplecalendar` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'de-DE') WHERE (c.extension='com_simplecalendar' OR c.extension='system') AND c.access IN (1,1,5,7) AND c.published = 1 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft


PHP-Version: 5.6.10
DB-Version: 5.5.43

What can i do?
Thank you!

Markus
Last Edit: 2 years 5 months ago by bujinkanat.
The topic has been locked.
More
2 years 5 months ago #640 by peterkaminski
peterkaminski replied the topic: 1054 Error ?!?
Hello, I got exacly the same problem but in an multi-language Joomla system only.
www.proaudio.de/de/kalender.html

In a Joomla system with one language simple calender works without problems:
www.edf-jets.de/kalender.html

Regards
Peter
The topic has been locked.
More
2 years 5 months ago #641 by kjk
kjk replied the topic: 1054 Error ?!?
Hello -
it's a bug in joomla 3.4.2: Multilang-site override a option of JCategories that cause a SQL error
docs.joomla.org/J3.x:Multilang-site_over...at_cause_a_SQL_error


best regards
The topic has been locked.
Time to create page: 0.262 seconds
Powered by Kunena Forum