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 != 16504 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 != 16504 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: 0209 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0244 @ /var/www/vhosts/horecaseadmed.ee/httpdocs/admin/code/core/core_mysql_database.php
Rida: 0269 @ /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 != 16504 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 != 16504 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
)
,
„r554ce5d442”

)


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 != 16504 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 != 16504 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 != 16504 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 != 16504 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 != 16504 ORDER BY RAND() LIMIT 0,4 ”

)


shop_class->products(

Array
(
    [epood_id] => 16504
    [epood_kood_bint] => 200512314
    [epood_kood] => HKN-RTG-12/0405
    [kasutaja_id] => 164770
    [kuup] => 1674642922
    [peidetud] => 0
    [toptoode] => 0
    [uustoode] => 1
    [date_created] => 
)

)


shop_class->start(

)


FRONT->__call(

„start”
,
Array
(
)

)


index_class->sisu(

)