arkadaşlar siteme pafiledb kurdum.kategorileri oluşturdum fakat dosya yüklemeye gelince böle bi hata aldım.nasıl düzeltebilirim.
- Kod: Tümünü seç
Couldnot Quary File İnfo
Sql Error:1064 you have an error in your SQL syntax;check the manuel corresponds to your MYSQL server version for the right syntax to use near 'GROUP BY f.file_id' at line 7
SELECT f.* , AVG(r.rate_point)AS rating,COUNT(r.votes_file) AS total votes,u.user_id,u.username,Count(c.commend_id)as total comments FROM phpbb_pa_files AS f LEFT join phpbb_pa_votes AS r ON f.file_id=r.votes_file LEFT JOİN phpbb_users as u ON f.user_id LEFT JOİN phpbb_command AS c ON f.file_id=c.file_id WHERE f.file_id=GROUP BY f.file_id
line=1308
file=functions.php