 Can't Install Component for Keyword Image block
I am trying to install the component for the Keyword Image Component but I keep recieving this error:
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'exists (select 1 from `g2_item_viewed` where `g2_item_viewed`.`g_itemId` =`g2_It' at line 7 SQL=insert into `g2_item_viewed` SELECT DISTINCT `g2_ItemAttributesMap`.`g_itemId`, `g2_ItemAttributesMap`.`g_viewCount` FROM `g2_ItemAttributesMap` WHERE not exists (select 1 from `g2_item_viewed` where `g2_item_viewed`.`g_itemId` =`g2_ItemAttributesMap`.`g_itemId`);
SQL =
insert into `g2_item_viewed`
SELECT DISTINCT
`g2_ItemAttributesMap`.`g_itemId`,
`g2_ItemAttributesMap`.`g_viewCount`
FROM
`g2_ItemAttributesMap`
WHERE not exists (select 1 from `g2_item_viewed` where `g2_item_viewed`.`g_itemId` =`g2_ItemAttributesMap`.`g_itemId`);
The module and mambot have installed just fine but without the component they are useless. Any help is greatly appreciated. Thanks |