Unfortunately, the release of Joomla 3.4.2 last night introduced an unexpected problem in HWDMediaShare. We have already released a new update this morning which fixes the problem, and users can update to version 2.0.1 to resolve this issue.

 

Upgrade to version 2.0.1

To resolve the problem introduced by the release of Joomla 3.4.2, please upgrade your version of HWDMediaShare.

Upgrade

 

The problem was caused by new code added to the JCategories class in Joomla 3.4.2, which was introduced to improve filtering of categories by the active language code. This problem will only affect users who have enabled system language plugins, and would result in the following error message on some category pages.

 

1054 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 o806i_categories as c LEFT JOIN o806i_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM o806i_categories AS cat JOIN o806i_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_hwdmediashare' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `o806i_hwdms_category_map` AS i ON i.`category_id` = c.id AND (i.language = '*' OR i.language = 'en-GB') WHERE (c.extension='com_hwdmediashare' OR c.extension='system') AND c.access IN (1,1,5) AND s.id=9 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

 

Update: 2nd July

The day after the release of Joomla 3.4.2, the Joomla organization released version 3.4.3. Amongst other priority fixes, this release also addressed the problem discussed above which has clearly affected a number of third party developers. Despite the release of Joomla 3.4.3, we still recommend users update to the latest version of HWDMediaShare.