SpaVoda - аппаратная косметология | Результаты поиска Полезно знать Статьи Журналы Доска объявлений Контакты | ||
|
Статьи
|
Exception: Query error 1054: Unknown column 'shop_items_catalog_table.shop_currency_id' in 'field list'. Query: SELECT DISTINCT SQL_CALC_FOUND_ROWS `shop_items`.`id`, `shop_items`.`shortcut_id` AS `shop_items_catalog_shortcut_id`, `shop_items`.`shop_tax_id`, `shop_items`.`shop_seller_id` AS `shop_sallers_id`, `shop_items`.`shop_group_id` AS `shop_groups_id`, `shop_items`.`shop_currency_id`, `shop_items`.`shop_id` AS `shop_shops_id`, `shop_items`.`shop_producer_id` AS `shop_producers_list_id`, `shop_items`.`shop_measure_id` AS `shop_mesures_id`, `shop_items`.`type` AS `shop_items_catalog_type`, `shop_items`.`name` AS `shop_items_catalog_name`, `shop_items`.`marking` AS `shop_items_catalog_marking`, `shop_items`.`vendorcode` AS `shop_vendorcode`, `shop_items`.`description` AS `shop_items_catalog_description`, `shop_items`.`text` AS `shop_items_catalog_text`, `shop_items`.`image_large` AS `shop_items_catalog_image`, `shop_items`.`image_small` AS `shop_items_catalog_small_image`, `shop_items`.`weight` AS `shop_items_catalog_weight`, `shop_items`.`price` AS `shop_items_catalog_price`, `shop_items`.`active` AS `shop_items_catalog_is_active`, `shop_items`.`siteuser_group_id` AS `shop_items_catalog_access`, `shop_items`.`sorting` AS `shop_items_catalog_order`, `shop_items`.`path` AS `shop_items_catalog_path`, `shop_items`.`seo_title` AS `shop_items_catalog_seo_title`, `shop_items`.`seo_description` AS `shop_items_catalog_seo_description`, `shop_items`.`seo_keywords` AS `shop_items_catalog_seo_keywords`, `shop_items`.`indexing` AS `shop_items_catalog_indexation`, `shop_items`.`image_small_height` AS `shop_items_catalog_small_image_height`, `shop_items`.`image_small_width` AS `shop_items_catalog_small_image_width`, `shop_items`.`image_large_height` AS `shop_items_catalog_big_image_height`, `shop_items`.`image_large_width` AS `shop_items_catalog_big_image_width`, `shop_items`.`yandex_market` AS `shop_items_catalog_yandex_market_allow`, `shop_items`.`yandex_market_bid` AS `shop_items_catalog_yandex_market_bid`, `shop_items`.`yandex_market_cid` AS `shop_items_catalog_yandex_market_cid`, `shop_items`.`yandex_market_sales_notes` AS `shop_items_catalog_yandex_market_sales_notes`, `shop_items`.`siteuser_id` AS `site_users_id`, `shop_items`.`datetime` AS `shop_items_catalog_date_time`, `shop_items`.`modification_id` AS `shop_items_catalog_modification_id`, `shop_items`.`guid` AS `shop_items_cml_id`, `shop_items`.`start_datetime` AS `shop_items_catalog_putoff_date`, `shop_items`.`end_datetime` AS `shop_items_catalog_putend_date`, `shop_items`.`showed` AS `shop_items_catalog_show_count`, IF (shop_items_catalog_table.shop_currency_id = 3, shop_items_catalog_table.shop_items_catalog_price * 32, IF (shop_items_catalog_table.shop_currency_id = 2, shop_items_catalog_table.shop_items_catalog_price * 40.5, IF (shop_items_catalog_table.shop_currency_id = 4, shop_items_catalog_table.shop_items_catalog_price * 1, IF (shop_items_catalog_table.shop_currency_id = 1, shop_items_catalog_table.shop_items_catalog_price * 1, shop_items_catalog_price)))) AS item_price_absolute FROM `shop_items` WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_id` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` = 601 AND `shop_items`.`shop_id` = '1' AND ( `shop_items`.`end_datetime` >= '2016-07-09 00:02:48' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`start_datetime` <= '2016-07-09 00:02:48' AND `shop_items`.`modification_id` = 0 HAVING 1 ORDER BY `item_price_absolute` ASC LIMIT 10 OFFSET 0 35 modules/core/exception.php 636 modules/core/database/mysql.php 60 modules/core/querybuilder/statement.php 4872 modules/hostcms5/shop/shop.class.php 14958 modules/hostcms5/shop/shop.class.php 17561 modules/hostcms5/shop/shop.class.php 797 hostcmsfiles/lib/lib_6/lib_6.php 271 modules/lib/model.php 138 modules/core/page.php 1088 modules/hostcms5/Kernel/Kernel.class.php 213 templates/template1/template.htm 86 modules/template/model.php 138 modules/core/page.php 417 modules/core/command/controller/default.php 108 modules/core/command/controller/hostcms5/default.php 190 modules/core/router/route.php 217 index.php |