Просмотренные
Избранное
Сравнение
+7 (495) 748-96-97
Обратный звонок
Наш адрес
г. Москва, Бумажный проезд, д. 19, стр. 5 карта
Режим работы
пн-пт 9-19

Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT CatID FROM catalog_models LEFT JOIN shop_orders_models ON shop_orders_models.ModelID = catalog_models.ID WHERE catalog_models.Status != 200 AND catalog_models.Source != 'ad' AND (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND CatID > 0 AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY num_sales DESC
Params: 
Array
(
    [0] => 
)


Array
(
    [1] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/DB.php
            [line] => 134
            [function] => display_error
            [class] => DB
            [type] => ->
        )
    [2] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/DB.php
            [line] => 232
            [function] => try_query
            [class] => DB
            [type] => ->
        )
    [3] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/SqlCreator.php
            [line] => 691
            [function] => fetchArray
            [class] => DB
            [type] => ->
        )
    [4] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruCls.php
            [line] => 1993
            [function] => select
            [class] => SqlCreator
            [type] => ->
        )
    [5] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogPropFilterCats.php
            [line] => 108
            [function] => select
            [class] => GooruCls
            [type] => ::
        )
    [6] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogPropFilterCatsBrands.php
            [line] => 17
            [function] => get_values
            [class] => CatalogPropFilterCats
            [type] => ->
        )
    [7] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 599
            [function] => is_empty
            [class] => CatalogPropFilterCatsBrands
            [type] => ->
        )
    [8] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 648
            [function] => get_filters_special
            [class] => CatalogFilter
            [type] => ->
        )
    [9] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 539
            [function] => get_filters
            [class] => CatalogFilter
            [type] => ->
        )
    [10] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 567
            [function] => is_empty
            [class] => CatalogFilter
            [type] => ->
        )
    [11] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/SingletonsRaw.php
            [line] => 19
            [function] => display
            [class] => CatalogFilter
            [type] => ->
        )
    [12] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog_filter.php
            [line] => 6
            [function] => __toString
            [class] => SingletonsRaw
            [type] => ->
        )
    [13] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruModule.php
            [line] => 102
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog_filter.php
                )
            [function] => include_once
        )
    [14] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop_left.php
            [line] => 6
            [function] => include_file
            [class] => GooruModule
            [type] => ->
        )
    [15] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop.php
            [line] => 21
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop_left.php
                )
            [function] => require_once
        )
    [16] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/index.php
            [line] => 7
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop.php
                )
            [function] => require_once
        )
)

Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT TopBrandID FROM catalog_models LEFT JOIN shop_orders_models ON shop_orders_models.ModelID = catalog_models.ID WHERE catalog_models.Status != 200 AND catalog_models.Source != 'ad' AND (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND TopBrandID > 0 AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY num_sales DESC
Params: 
Array
(
    [0] => 
)


Array
(
    [1] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/DB.php
            [line] => 134
            [function] => display_error
            [class] => DB
            [type] => ->
        )
    [2] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/DB.php
            [line] => 232
            [function] => try_query
            [class] => DB
            [type] => ->
        )
    [3] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/SqlCreator.php
            [line] => 691
            [function] => fetchArray
            [class] => DB
            [type] => ->
        )
    [4] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruCls.php
            [line] => 1993
            [function] => select
            [class] => SqlCreator
            [type] => ->
        )
    [5] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogPropFilterBrands.php
            [line] => 246
            [function] => select
            [class] => GooruCls
            [type] => ::
        )
    [6] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogPropFilterCatsBrands.php
            [line] => 17
            [function] => get_values
            [class] => CatalogPropFilterBrands
            [type] => ->
        )
    [7] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 599
            [function] => is_empty
            [class] => CatalogPropFilterCatsBrands
            [type] => ->
        )
    [8] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 648
            [function] => get_filters_special
            [class] => CatalogFilter
            [type] => ->
        )
    [9] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 539
            [function] => get_filters
            [class] => CatalogFilter
            [type] => ->
        )
    [10] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogFilter.php
            [line] => 567
            [function] => is_empty
            [class] => CatalogFilter
            [type] => ->
        )
    [11] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/SingletonsRaw.php
            [line] => 19
            [function] => display
            [class] => CatalogFilter
            [type] => ->
        )
    [12] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog_filter.php
            [line] => 6
            [function] => __toString
            [class] => SingletonsRaw
            [type] => ->
        )
    [13] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruModule.php
            [line] => 102
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog_filter.php
                )
            [function] => include_once
        )
    [14] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop_left.php
            [line] => 6
            [function] => include_file
            [class] => GooruModule
            [type] => ->
        )
    [15] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop.php
            [line] => 21
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop_left.php
                )
            [function] => require_once
        )
    [16] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/index.php
            [line] => 7
            [args] => Array
                (
                    [0] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/general/index_desktop.php
                )
            [function] => require_once
        )
)
Фильтр
  • Тип устройства

Топ товаров

Фильтр
+7 (495) 748-96-97
Обратный звонок
Наш адрес
г. Москва, Бумажный проезд, д. 19, стр. 5 карта
Режим работы
пн-пт 9-19