Mysql error: Unknown column 'SortPrice' in 'order clause'

Error code: 1054

Query: SELECT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.Domains,COUNT(shop_orders_models.ID) as num_sales 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 catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY SortPrice DESC, catalog_models.Price desc LIMIT 0, 60

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] => 204
            [function] => try_query
            [class] => DB
            [type] => ->
        )
    [3] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/SqlCreator.php
            [line] => 749
            [function] => fetchAll
            [class] => DB
            [type] => ->
        )
    [4] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruCls.php
            [line] => 2019
            [function] => find
            [class] => SqlCreator
            [type] => ->
        )
    [5] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/LocatorStatic.php
            [line] => 18
            [function] => find
            [class] => GooruCls
            [type] => ::
        )
    [6] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogGroup.php
            [line] => 252
            [function] => __call
            [class] => LocatorStatic
            [type] => ->
        )
    [7] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog.php
            [line] => 20
            [function] => get_models
            [class] => CatalogGroup
            [type] => ->
        )
    [8] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/CatalogCatBrand.php
            [line] => 529
            [function] => get_collection
            [class] => Catalog
            [type] => ->
        )
    [9] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Page/Seo.php
            [line] => 504
            [function] => protect_url
            [class] => CatalogCatBrand
            [type] => ->
        )
    [10] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/modules/Catalog/Catalog_init.php
            [line] => 16
            [function] => protect_url
            [class] => Seo
            [type] => ->
        )
    [11] => 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_init.php
                )
            [function] => include_once
        )
    [12] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruModule.php
            [line] => 134
            [function] => include_file
            [class] => GooruModule
            [type] => ->
        )
    [13] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruModule.php
            [line] => 275
            [function] => run
            [class] => GooruModule
            [type] => ->
        )
    [14] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/gooru/class/GooruModule.php
            [line] => 224
            [function] => do_all
            [class] => GooruModule
            [type] => ::
        )
    [15] => Array
        (
            [file] => /home/a/alkogo2c/pm-store.ru/public_html/index.php
            [line] => 4
            [function] => init_all
            [class] => GooruModule
            [type] => ::
        )
)

Топ товаров

Просмотренные

Избранное

Сравнение

+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
        )
)

Фильтр

Топ товаров

Не найдено товаров