Intellect Board — cистема управления сайтом

и еше

---

GLOBAL FORUM ERROR: SELECT t.*, dl.*, p1.p_uname AS u__name, p1.p__time AS posttime, t__ratingsum/NULLIF(t__ratingcount,0) AS trating, tv.tid AS visited, t__pcount AS pcount, p2.p__time AS lastpost FROM ib_Download dl, ib_Post p1, ib_Post p2, ib_Topic t LEFT JOIN ib_TopicView tv ON (tv.tid=t.t_id AND tv.uid=12) WHERE t.t_fid=52 AND t.t_id=dl.dl_tid AND t.t__lastpostid=p1.p_id AND t.t__startpostid=p2.p_id ORDER BY t__sticky DESC, posttime DESC LIMIT 0,15<br>1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(t__ratingcount,0) AS trating, tv.tid AS visited, t__pcount AS pcount, p2.p__tim' at line 1

---

GLOBAL FORUM ERROR: SELECT t.*, pl.*, t__ratingsum/NULLIF(t__ratingcount,0) AS trating, t__pcount AS pcount, p.p__time AS lasttime, p2.p_uid AS t_author, bm.tid>0 AS bmk, sb.tid>0 AS subscr, v.pvid>0 AS voted, tv.tid AS visited FROM ib_Post p, ib_Post p2, ib_Topic t LEFT JOIN ib_Poll pl ON (pl_tid=t_id) LEFT JOIN ib_Bookmark bm ON (bm.uid=12 AND bm.tid=t.t_id) LEFT JOIN ib_Subscription sb ON (t.t_id=sb.tid AND sb.uid=12) LEFT JOIN ib_TopicView tv ON (tv.tid=t.t_id AND tv.uid=12) LEFT JOIN ib_Vote v ON (v.tid=767 AND v.uid=12) WHERE t_id="767" AND p.p_id=t.t__lastpostid AND p2.p_id=t.t__startpostid<br>1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(t__ratingcount,0) AS trating, t__pcount AS pcount, p.p__time AS lasttime, p2.p_' at line 1

админ не сообщал о таком. тем не менее как поймаю спрошу

Самый простой вариант — это удалить конструкцию NULLIF везде, где она встречается (по-моему, она есть только в index.php при извлечении информации о теме). Она нужна для защиты от ошибки "деление на ноль" при подсчете рейтинга темы, но MySQL (если выключен strict-режим) сам возвращает NULL при попытке такого деления.