Veateade : Error no: 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 !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4' at line 14
SELECT
t1.*,
epood__grupp_copy.sisu_id,
(SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne,
(SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja,
(SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus,
(SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind
FROM epood__indeks_uus as t1
INNER JOIN epood__grupp_copy
ON epood__grupp_copy.epood_id = t1.epood_id
INNER JOIN cms__sisu_current
ON cms__sisu_current.id = epood__grupp_copy.sisu_id
WHERE epood__grupp_copy.sisu_id =
AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4
Asukohad :
Rida: 0009 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_debug.php
Rida: 0137 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0210 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0245 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0270 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0199 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/include/shop_class.php
Rida: 0016 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/include/shop_class.php
Rida: 0035 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/functions/core_functions.php(65) : eval()'d code
Rida: 0632 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/include/index_class.php
Rida: 0269 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/index.php
Funktsioonid :
Debug::log(
„Error no: 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 !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4' at line 14 SELECT t1.*, epood__grupp_copy.sisu_id, (SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne, (SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja, (SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus, (SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind FROM epood__indeks_uus as t1 INNER JOIN epood__grupp_copy ON epood__grupp_copy.epood_id = t1.epood_id INNER JOIN cms__sisu_current ON cms__sisu_current.id = epood__grupp_copy.sisu_id WHERE epood__grupp_copy.sisu_id = AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4 ”
, Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[10] => 10
)
, „r5f30aac299”
)
Debug::call(
„Error no: 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 !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4' at line 14 SELECT t1.*, epood__grupp_copy.sisu_id, (SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne, (SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja, (SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus, (SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind FROM epood__indeks_uus as t1 INNER JOIN epood__grupp_copy ON epood__grupp_copy.epood_id = t1.epood_id INNER JOIN cms__sisu_current ON cms__sisu_current.id = epood__grupp_copy.sisu_id WHERE epood__grupp_copy.sisu_id = AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4 ”
, Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[10] => 10
)
)
MySqlDB->error(
Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
[8] => 8
[9] => 9
[10] => 10
)
)
MySqlDB->query(
„ SELECT t1.*, epood__grupp_copy.sisu_id, (SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne, (SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja, (SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus, (SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind FROM epood__indeks_uus as t1 INNER JOIN epood__grupp_copy ON epood__grupp_copy.epood_id = t1.epood_id INNER JOIN cms__sisu_current ON cms__sisu_current.id = epood__grupp_copy.sisu_id WHERE epood__grupp_copy.sisu_id = AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4 ”
, 5
, FALSE
)
MySqlDB->handleResult(
„ SELECT t1.*, epood__grupp_copy.sisu_id, (SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne, (SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja, (SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus, (SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind FROM epood__indeks_uus as t1 INNER JOIN epood__grupp_copy ON epood__grupp_copy.epood_id = t1.epood_id INNER JOIN cms__sisu_current ON cms__sisu_current.id = epood__grupp_copy.sisu_id WHERE epood__grupp_copy.sisu_id = AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4 ”
, FALSE
)
MySqlDB->fetch_assoc(
„ SELECT t1.*, epood__grupp_copy.sisu_id, (SELECT AVG(hinne) FROM epood__hinne WHERE epood_id = t1.epood_id) as hinne, (SELECT kasutaja FROM kasutaja__indeks where kasutaja_id = t1.kasutaja_id) as kasutaja, (SELECT nimetus FROM epood__sisu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as nimetus, (SELECT hind FROM epood__ladu_uus WHERE epood_id = t1.epood_id AND keel_id = '7') as hind FROM epood__indeks_uus as t1 INNER JOIN epood__grupp_copy ON epood__grupp_copy.epood_id = t1.epood_id INNER JOIN cms__sisu_current ON cms__sisu_current.id = epood__grupp_copy.sisu_id WHERE epood__grupp_copy.sisu_id = AND !t1.peidetud AND t1.epood_id != 16523 ORDER BY RAND() LIMIT 0,4 ”
)
shop_class->products(
Array
(
[epood_id] => 16523
[epood_kood_bint] => 1307835780
[epood_kood] => 051204
[kasutaja_id] => 164770
[kuup] => 1676891752
[peidetud] => 0
[toptoode] => 0
[uustoode] => 1
[date_created] =>
)
)
shop_class->start(
)
FRONT->__call(
„start”
, Array
(
)
)
index_class->sisu(
)