string(2570) "CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION fashion2.SUBSTR_COUNT does not exist. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`max_price` AS `t0_c6`, `t`.`is_active` AS `t0_c7`, `t`.`layout` AS `t0_c8`, `t`.`view` AS `t0_c9`, `t`.`sku` AS `t0_c10`, `t`.`quantity` AS `t0_c11`, `t`.`availability` AS `t0_c12`, `t`.`auto_decrease_quantity` AS `t0_c13`, `t`.`views_count` AS `t0_c14`, `t`.`created` AS `t0_c15`, `t`.`updated` AS `t0_c16`, `t`.`added_to_cart_count` AS `t0_c17`, `t`.`votes` AS `t0_c18`, `t`.`rating` AS `t0_c19`, `t`.`discount` AS `t0_c20`, `t`.`video` AS `t0_c21`, `t`.`size_cnt` AS `t0_c22`, `t`.`setting_bit` AS `t0_c23`, (SELECT index_product_attr.size FROM index_product_attr WHERE index_product_attr.id = t.id) AS sizes, (SELECT SUBSTR_COUNT(sizes, ',') + 1) AS size_amount, `translate`.`id` AS `t1_c0`, `translate`.`object_id` AS `t1_c1`, `translate`.`language_id` AS `t1_c2`, `translate`.`name` AS `t1_c3`, `translate`.`short_description` AS `t1_c4`, `translate`.`full_description` AS `t1_c5`, `translate`.`meta_title` AS `t1_c6`, `translate`.`meta_keywords` AS `t1_c7`, `translate`.`meta_description` AS `t1_c8` FROM `StoreProduct` `t` 
JOIN StoreProductAttributeEAV eavbSex
ON t.id = eavbSex.entity
AND eavbSex.attribute = 'sex'
AND eavbSex.value in (0,1) INNER JOIN `StoreProductAttributeEAV` AS eav ON eav.entity = t.id AND eav.attribute = 'exist' 
JOIN StoreProductAttributeEAV eavbSeller
ON t.id = eavbSeller.entity
AND eavbSeller.attribute = 'seller'
JOIN store_sellers sellertable
ON sellertable.id = eavbSeller.value 
JOIN StoreManufacturer sman ON t.manufacturer_id = sman.id and sman.hidden = ''  INNER JOIN `StoreProductAttributeEAV` AS eav_s ON eav_s.entity = t.id AND eav_s.attribute = 'seller' 
INNER JOIN `store_sellers` AS seller ON seller.id = eav_s.value AND seller.is_active = 1  JOIN `store_product_category_ref` `cat_hid` ON (`cat_hid`.`product`=`t`.`id`)INNER JOIN `StoreCategory` `c` ON (`c`.id = cat_hid.category and (`c`.`setting_bit` & 8 ) != 8  ) LEFT OUTER JOIN `StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`)  WHERE ((`t`.is_active=1) AND (t.created BETWEEN :ycp0 AND :ycp1)) AND (translate.language_id=:language_id) ORDER BY size_amount DESC, t.id DESC. Bound with :ycp0='2022-06-02 23:59:59', :ycp1='2022-10-02 23:59:59', :language_id='1'"
string(1815) "#0 /home/kadmin/sites/getpremium.ru/framework/db/CDbCommand.php(398): CDbCommand->queryInternal()
#1 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(803): CDbCommand->queryAll()
#2 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(437): CJoinElement->runQuery()
#3 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(68): CJoinElement->find()
#4 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveRecord.php(1356): CActiveFinder->query()
#5 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveRecord.php(1470): CActiveRecord->query()
#6 /home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(258): CActiveRecord->findAll()
#7 /home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(467): CategoryController->_getFilterIds()
#8 /home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(232): CategoryController->doNovelty()
#9 /home/kadmin/sites/getpremium.ru/framework/web/actions/CInlineAction.php(49): CategoryController->actionNovelty()
#10 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(308): CInlineAction->runWithParams()
#11 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(286): CController->runAction()
#12 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(265): CController->runActionWithFilters()
#13 /home/kadmin/sites/getpremium.ru/framework/web/CWebApplication.php(283): CController->run()
#14 /home/kadmin/sites/getpremium.ru/framework/web/CWebApplication.php(142): CWebApplication->runController()
#15 /home/kadmin/sites/getpremium.ru/framework/base/CApplication.php(180): CWebApplication->processRequest()
#16 /home/kadmin/sites/getpremium.ru/index.php(57): CApplication->run()
#17 {main}"
Журнал приложения
Время Уровень Категория Сообщение
03:52:38.284487 error system.db.CDbCommand
Не удалось выполнить CDbCommand::fetchAll():
SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION
fashion2.SUBSTR_COUNT does not exist. Выполнявшийся
SQL-запрос: SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS
`t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`,
`t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`max_price` AS `t0_c6`,
`t`.`is_active` AS `t0_c7`, `t`.`layout` AS `t0_c8`, `t`.`view` AS `t0_c9`,
`t`.`sku` AS `t0_c10`, `t`.`quantity` AS `t0_c11`, `t`.`availability` AS
`t0_c12`, `t`.`auto_decrease_quantity` AS `t0_c13`, `t`.`views_count` AS
`t0_c14`, `t`.`created` AS `t0_c15`, `t`.`updated` AS `t0_c16`,
`t`.`added_to_cart_count` AS `t0_c17`, `t`.`votes` AS `t0_c18`,
`t`.`rating` AS `t0_c19`, `t`.`discount` AS `t0_c20`, `t`.`video` AS
`t0_c21`, `t`.`size_cnt` AS `t0_c22`, `t`.`setting_bit` AS `t0_c23`,
(SELECT index_product_attr.size FROM index_product_attr WHERE
index_product_attr.id = t.id) AS sizes, (SELECT SUBSTR_COUNT(sizes, ',') +
1) AS size_amount, `translate`.`id` AS `t1_c0`, `translate`.`object_id` AS
`t1_c1`, `translate`.`language_id` AS `t1_c2`, `translate`.`name` AS
`t1_c3`, `translate`.`short_description` AS `t1_c4`,
`translate`.`full_description` AS `t1_c5`, `translate`.`meta_title` AS
`t1_c6`, `translate`.`meta_keywords` AS `t1_c7`,
`translate`.`meta_description` AS `t1_c8` FROM `StoreProduct` `t` 
JOIN StoreProductAttributeEAV eavbSex
ON t.id = eavbSex.entity
AND eavbSex.attribute = 'sex'
AND eavbSex.value in (0,1) INNER JOIN `StoreProductAttributeEAV` AS eav ON
eav.entity = t.id AND eav.attribute = 'exist' 
JOIN StoreProductAttributeEAV eavbSeller
ON t.id = eavbSeller.entity
AND eavbSeller.attribute = 'seller'
JOIN store_sellers sellertable
ON sellertable.id = eavbSeller.value 
JOIN StoreManufacturer sman ON t.manufacturer_id = sman.id and sman.hidden
= ''  INNER JOIN `StoreProductAttributeEAV` AS eav_s ON eav_s.entity = t.id
AND eav_s.attribute = 'seller' 
INNER JOIN `store_sellers` AS seller ON seller.id = eav_s.value AND
seller.is_active = 1  JOIN `store_product_category_ref` `cat_hid` ON
(`cat_hid`.`product`=`t`.`id`)INNER JOIN `StoreCategory` `c` ON (`c`.id =
cat_hid.category and (`c`.`setting_bit` & 8 ) != 8  ) LEFT OUTER JOIN
`StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) 
WHERE ((`t`.is_active=1) AND (t.created BETWEEN :ycp0 AND :ycp1)) AND
(translate.language_id=:language_id) ORDER BY size_amount DESC, t.id DESC.
Bound with :ycp0='2022-06-02 23:59:59', :ycp1='2022-10-02 23:59:59',
:language_id='1'.
in
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php
(258)
in
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php
(467)
in
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php
(232)
03:52:38.284607 error exception.CDbException
CDbException: CDbCommand не удалось исполнить
SQL-запрос: SQLSTATE[42000]: Syntax error or access violation: 1305
FUNCTION fashion2.SUBSTR_COUNT does not exist. The SQL statement executed
was: SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`,
`t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS
`t0_c4`, `t`.`price` AS `t0_c5`, `t`.`max_price` AS `t0_c6`,
`t`.`is_active` AS `t0_c7`, `t`.`layout` AS `t0_c8`, `t`.`view` AS `t0_c9`,
`t`.`sku` AS `t0_c10`, `t`.`quantity` AS `t0_c11`, `t`.`availability` AS
`t0_c12`, `t`.`auto_decrease_quantity` AS `t0_c13`, `t`.`views_count` AS
`t0_c14`, `t`.`created` AS `t0_c15`, `t`.`updated` AS `t0_c16`,
`t`.`added_to_cart_count` AS `t0_c17`, `t`.`votes` AS `t0_c18`,
`t`.`rating` AS `t0_c19`, `t`.`discount` AS `t0_c20`, `t`.`video` AS
`t0_c21`, `t`.`size_cnt` AS `t0_c22`, `t`.`setting_bit` AS `t0_c23`,
(SELECT index_product_attr.size FROM index_product_attr WHERE
index_product_attr.id = t.id) AS sizes, (SELECT SUBSTR_COUNT(sizes, ',') +
1) AS size_amount, `translate`.`id` AS `t1_c0`, `translate`.`object_id` AS
`t1_c1`, `translate`.`language_id` AS `t1_c2`, `translate`.`name` AS
`t1_c3`, `translate`.`short_description` AS `t1_c4`,
`translate`.`full_description` AS `t1_c5`, `translate`.`meta_title` AS
`t1_c6`, `translate`.`meta_keywords` AS `t1_c7`,
`translate`.`meta_description` AS `t1_c8` FROM `StoreProduct` `t` 
JOIN StoreProductAttributeEAV eavbSex
ON t.id = eavbSex.entity
AND eavbSex.attribute = 'sex'
AND eavbSex.value in (0,1) INNER JOIN `StoreProductAttributeEAV` AS eav ON
eav.entity = t.id AND eav.attribute = 'exist' 
JOIN StoreProductAttributeEAV eavbSeller
ON t.id = eavbSeller.entity
AND eavbSeller.attribute = 'seller'
JOIN store_sellers sellertable
ON sellertable.id = eavbSeller.value 
JOIN StoreManufacturer sman ON t.manufacturer_id = sman.id and sman.hidden
= ''  INNER JOIN `StoreProductAttributeEAV` AS eav_s ON eav_s.entity = t.id
AND eav_s.attribute = 'seller' 
INNER JOIN `store_sellers` AS seller ON seller.id = eav_s.value AND
seller.is_active = 1  JOIN `store_product_category_ref` `cat_hid` ON
(`cat_hid`.`product`=`t`.`id`)INNER JOIN `StoreCategory` `c` ON (`c`.id =
cat_hid.category and (`c`.`setting_bit` & 8 ) != 8  ) LEFT OUTER JOIN
`StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) 
WHERE ((`t`.is_active=1) AND (t.created BETWEEN :ycp0 AND :ycp1)) AND
(translate.language_id=:language_id) ORDER BY size_amount DESC, t.id DESC.
Bound with :ycp0='2022-06-02 23:59:59', :ycp1='2022-10-02 23:59:59',
:language_id='1' in
/home/kadmin/sites/getpremium.ru/framework/db/CDbCommand.php:549
Stack trace:
#0 /home/kadmin/sites/getpremium.ru/framework/db/CDbCommand.php(398):
CDbCommand->queryInternal()
#1 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(803):
CDbCommand->queryAll()
#2 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(437):
CJoinElement->runQuery()
#3 /home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveFinder.php(68):
CJoinElement->find()
#4
/home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveRecord.php(1356):
CActiveFinder->query()
#5
/home/kadmin/sites/getpremium.ru/framework/db/ar/CActiveRecord.php(1470):
CActiveRecord->query()
#6
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(258):
CActiveRecord->findAll()
#7
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(467):
CategoryController->_getFilterIds()
#8
/home/kadmin/sites/getpremium.ru/protected/modules/store/controllers/CategoryController.php(232):
CategoryController->doNovelty()
#9
/home/kadmin/sites/getpremium.ru/framework/web/actions/CInlineAction.php(49):
CategoryController->actionNovelty()
#10 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(308):
CInlineAction->runWithParams()
#11 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(286):
CController->runAction()
#12 /home/kadmin/sites/getpremium.ru/framework/web/CController.php(265):
CController->runActionWithFilters()
#13
/home/kadmin/sites/getpremium.ru/framework/web/CWebApplication.php(283):
CController->run()
#14
/home/kadmin/sites/getpremium.ru/framework/web/CWebApplication.php(142):
CWebApplication->runController()
#15 /home/kadmin/sites/getpremium.ru/framework/base/CApplication.php(180):
CWebApplication->processRequest()
#16 /home/kadmin/sites/getpremium.ru/index.php(57): CApplication->run()
#17 {main}
REQUEST_URI=/novelty
---