Prijavite pogrešku

Zahvaljujemo vam na vašoj spremnosti da prijavite pogrešku

Nakon pritiska na tipku prikažite mišem, gdje je greška
Prikaži na zaslonu

( ! ) Warning: Division by zero in /var/www/vhosts/kozmetika.hr/www/web/override/classes/Ingredience.php on line 77
Call Stack
#TimeMemoryFunctionLocation
10.0000415632{main}( ).../ingredience.php:0
20.0083877232IngredienceController->run( ).../ingredience.php:4
31.44263079816IngredienceController->process( ).../FrontController.php:66
41.70473686504IngredienceController->nejprodavanejsi( ).../IngredienceController.php:23
51.70683791680Ingredience::getNejvyssiProcentaIngredienceVproduktu( ).../IngredienceController.php:41
( ! ) Warning: Division by zero in /var/www/vhosts/kozmetika.hr/www/web/override/classes/Ingredience.php on line 77
Call Stack
#TimeMemoryFunctionLocation
10.0000415632{main}( ).../ingredience.php:0
20.0083877232IngredienceController->run( ).../ingredience.php:4
31.44263079816IngredienceController->process( ).../FrontController.php:66
41.70473686504IngredienceController->nejprodavanejsi( ).../IngredienceController.php:23
51.70853758272Ingredience::getNejvyssiProcentaIngredienceVproduktu( ).../IngredienceController.php:41
 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY typ HAVING id_ingredience='140' ORDER BY pocet DESC LIMIT 1' at line 3

SELECT SUM(body) pocet, typ, id_ingredience
            FROM (SELECT * FROM ps_ingredience_body ORDER BY id_ingredience='140' DESC) b
            WHERE id_product= GROUP BY typ HAVING id_ingredience='140' ORDER BY pocet DESC LIMIT 1