Query Error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wasite.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT p.type_id,p.id
FROM shop_product p
JOIN shop_category_products cp1
ON p.id = cp1.product_id
WHERE cp1.category_id = 1
GROUP BY type_id
ORDER BY cp1.sort ASC
LIMIT 50 code 1055
## wa-system/database/waModel.class.php(257)
#0 wa-system/database/waModel.class.php(357): waModel->run('SELECT p.type_i...')
#1 wa-apps/shop/lib/classes/shopProductsCollection.class.php(1560): waModel->query('SELECT p.type_i...')
#2 wa-apps/shop/lib/actions/category/shopCategoryEdit.action.php(291): shopProductsCollection->getProducts('type_id')
#3 wa-apps/shop/lib/actions/category/shopCategoryEdit.action.php(144): shopCategoryEditAction->getTypesId(1)
#4 wa-apps/shop/lib/actions/category/shopCategoryEdit.action.php(24): shopCategoryEditAction->getCategorySettings(1)
#5 wa-system/controller/waViewAction.class.php(160): shopCategoryEditAction->execute()
#6 wa-system/controller/waViewController.class.php(86): waViewAction->display()
#7 wa-system/controller/waDefaultViewController.class.php(48): waViewController->executeAction(Object(shopCategoryEditAction))
#8 wa-system/controller/waController.class.php(21): waDefaultViewController->execute()
#9 wa-system/controller/waViewController.class.php(46): waController->run(NULL)
#10 wa-system/controller/waFrontController.class.php(254): waViewController->run(NULL)
#11 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(waDefaultViewController), NULL)
#12 wa-system/controller/waFrontController.class.php(83): waFrontController->execute(NULL, 'category', 'Edit')
#13 wa-system/waSystem.class.php(582): waFrontController->dispatch()
#14 wa-system/waSystem.class.php(501): waSystem->dispatchBackend('webasyst/shop/')
#15 index.php(7): waSystem->dispatch()
#16 {main}
4 комментария
Попробуйте использовать этот комментарий.
вообще не понял ни слова их него. я не Програмист
Вряд ли прямо "ни слова". Например, слово "файл" вам понятно?
Раз вам не понравился мой комментарий - судя по оценке, расскажите подробнее, что именно вам непонятно. Так будет проще вам помочь.