dbEx / error ocurred in:zbozicz-xmlFeed
Given input type: string
error ocurred [Unknown column 'ext.archived' in 'where clause'] [SELECT `item`.`id` ,`item`.`timestamp` ,`item`.`label` ,`item`.`description` ,`item`.`expirationDateTime` ,`item`.`releaseDateTime` ,`ext`.`stock` ,`ext`.`location` ,REPLACE(FORMAT(ROUND(`price`.`price` * (100/(100+`price`.`tax`)),2),2),',',' ') AS `priceWithTax`,ROUND(`price`.`price`,2) AS priceWithoutTax ,REPLACE(FORMAT(ROUND(`price`.`priceAlternative` * (100/(100+`price`.`tax`)),2),2),',',' ') AS `priceAlternativeWithTax`,ROUND(`price`.`priceAlternative`,2) AS priceAlternativeWithoutTax ,REPLACE(FORMAT(ROUND(`price`.`price` * (1+(`price`.`tax`/100)) * (`price`.`tax`/100)),0),',',' ') AS `priceTax` ,REPLACE(FORMAT(ROUND( `price`.`priceAlternative` * (1+(`price`.`tax`/100)) * (`price`.`tax`/100)),0),',',' ') AS `alternativePriceTax` ,`price`.`tax` ,`stru`.`wiseUrl` FROM `udssDataItem` `item` LEFT JOIN `udssItemProductExtension` `ext` ON `item`.`id`=`ext`.`itemId` LEFT JOIN `udssItemProductPrice` `price` ON `price`.`itemId`=`item`.`id` AND `price`.`currency`='CZK' LEFT JOIN `udssDataItemRel` `rel` ON `item`.`id`=`rel`.`itemId` LEFT JOIN (`udssItemRelStructure` `relStru`, `udssStructure` `stru`,`udssStructureGroup` `struGr`) ON (`item`.`id`=`relStru`.`itemId` AND `item`.`timestamp`=`relStru`.`itemTimestamp` AND `relStru`.`structureId`=`stru`.`id` AND `stru`.`structureGroupId`=`struGr`.`id`) WHERE `item`.`dataTypeId` = 46 AND (`item`.`releaseDateTime`<'2018-12-12 15:14:29' OR `item`.`releaseDateTime` IS NULL OR `item`.`releaseDateTime`='') AND (`item`.`expirationDateTime`>'2018-12-12 15:14:29' OR `item`.`expirationDateTime` IS NULL OR `item`.`expirationDateTime`='') AND (item.id, item.timestamp) IN(select `item`.`id` AS `id`, `item`.`timestamp` AS `timestamp` FROM `udssDataItem` `item` LEFT JOIN `aclGroupDataItem` `aclGroup` ON `item`.`id` = `aclGroup`.`itemId` AND `item`.`timestamp` = `aclGroup`.`itemTimestamp` WHERE `aclGroup`.`permission` IN('read','write') AND `aclGroup`.`groupHash` = '4c9184f37cff01bcdc32dc486ec36961') # archivovane jsou skryte AND `ext`.`archived` = '0' GROUP BY `item`.`id`] [at:%DOC_ROOT%/_contentGenerator/feeds/zbozicz-xmlFeed.php:76]
zavřít

Zpracovávám...