Hata Kodu:99
Hata: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 'order by if( (Stok>0 or VStok>0),1,0) DESC , urun_sira ASC, urun.ID DESC...' at line 1
Sorgu:SELECT SQL_CALC_FOUND_ROWS if(urun.Sira=0,999999999,urun.Sira) as urun_sira, ( SELECT sum(if(SurekliStok=1,999,Stok)) FROM urunvaryasyon WHERE urunvaryasyon.Aktif>0 and UrunID=urun.ID ) as VStok, urun.* FROM urun WHERE ( urun.KATEGORILER like '%"23"%' or urun.KategoriID=23 ) AND urun.Aktif>0 AND urun.dil = order by if( (Stok>0 or VStok>0),1,0) DESC , urun_sira ASC, urun.ID DESC LIMIT 0 , 21
99
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 'order by if( (Stok>0 or VStok>0),1,0) DESC , urun_sira ASC, urun.ID DESC...' at line 1
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on null in /var/www/vhosts/spoturun.net/berrakhayat.com/system/inc.function.php:8322
Stack trace:
#0 /var/www/vhosts/spoturun.net/berrakhayat.com/inc.server.php(1268): sql_fetch_array()
#1 /var/www/vhosts/spoturun.net/berrakhayat.com/inc/urunkategori/standart.php(195): UrunGosterSQL()
#2 /var/www/vhosts/spoturun.net/berrakhayat.com/urun.php(536): require_once('/var/www/vhosts...')
#3 {main}
thrown in
/var/www/vhosts/spoturun.net/berrakhayat.com/system/inc.function.php on line
8322