Uncaught exception:
Chyba v dotazu query:
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND
zbozi.id_vyrobci= AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
AND
ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
1064 - 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 'AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
' at line 12
-
include
File: /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/ws_katalog.php (line: 52)
Args:
- /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/vyrobce.php
-
Model\Filter\FilterHelper :: fetchAvailableSizes
File: /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/vyrobce.php (line: 94)
Args:
Weto\Db\AdapterMdb Object
(
[vypnoutDetekciGetteruVGetValueFromObject] =>
[use_nulls] => 1
[link:protected] => Resource id #15
[last_query:protected] =>
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND zbozi.id_vyrobci= AND ((cena>'0' AND cenik.akce!='1') OR (cena_akce>'0' AND cenik.akce='1'))
AND ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
[resultset:protected] =>
[db_name:protected] => moda-velkoobchod_cz
[sql:protected] =>
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND zbozi.id_vyrobci= AND ((cena>'0' AND cenik.akce!='1') OR (cena_akce>'0' AND cenik.akce='1'))
AND ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
[transaction:protected] =>
[logger:protected] =>
)
- 1
- zbozi.nabizet = '1' AND
zbozi.id_vyrobci= AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
-
Weto\Db\Selecta -> selectIndexValue
File: /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/lib/Model/Filter/FilterHelper.php (line: 26)
Args:
-
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND
zbozi.id_vyrobci= AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
AND
ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
-
Weto\Db\AdapterMdb -> query
File: /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/lib/Db/Selecta.php (line: 217)
Args:
-
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND
zbozi.id_vyrobci= AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
AND
ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
Array
(
)
- 1
-
Weto\Db\MySQL -> query
File: /var/www/moda-velkoobchod/data/www/moda-velkoobchod.cz/lib/Db/AdapterMdb.php (line: 72)
Args:
-
SELECT ph.id_parametr_hodnota, ph.hodnota
FROM zbozi
LEFT JOIN cenik
ON(zbozi.id_zbozi = cenik.id_zbozi)
LEFT JOIN sekce_has_zbozi mn
ON (mn.id_zbozi = zbozi.id_zbozi)
LEFT JOIN volitelny_parametr vp
ON (vp.id_cenik = cenik.id_cenik)
LEFT JOIN parametr_hodnota ph
ON ph.id_parametr_hodnota=vp.id_parametr_hodnota
WHERE
zbozi.nabizet = '1' AND
zbozi.id_vyrobci= AND
((cena>'0' AND
cenik.akce!='1') OR (cena_akce>'0' AND
cenik.akce='1'))
AND
ph.id_parametr=1
GROUP BY ph.id_parametr_hodnota
ORDER BY ph.hodnota
Array
(
)
- 1