Lynx
Пользователь
php_err.log:
[16-Apr-2015 15:13:02 Europe/Moscow] PHP Fatal error: DB Error [portal.php(133)] in /var/www/lynx/data/www/***/library/includes/core/mysql.php on line 804
portal.php(133):
весь запрос:
sql_error_bb.log:
Весь лог в таких ошибках:
[16-Apr-2015 15:13:02 Europe/Moscow] PHP Fatal error: DB Error [portal.php(133)] in /var/www/lynx/data/www/***/library/includes/core/mysql.php on line 804
portal.php(133):
);
весь запрос:
PHP:
if (!$row = CACHE('portal')->get('portal_count_'.$mode.$search))
{
$row = DB()->fetch_row("SELECT COUNT(t.topic_id) AS topic_count
FROM " . BB_TOPICS . " AS t
JOIN " . BB_USERS . " AS u ON u.user_id = t.topic_poster
JOIN " . BB_POSTS_HTML . " AS pt ON pt.post_id = t.topic_first_post_id
LEFT JOIN " . BB_BT_TORRENTS . " AS tor ON tor.topic_id = t.topic_id
JOIN " . BB_FORUMS . " AS f ON f.forum_id = t.forum_id
WHERE t.topic_dl_type = 1
$not_auth_forums_sql
$and"
);
CACHE('portal')->set('portal_count_'.$mode.$search, $row, 3600);
}
sql_error_bb.log:
Весь лог в таких ошибках:
PHP:
#001054 Unknown column 'search' in 'where clause'
SELECT COUNT(t.topic_id) AS topic_count FROM bb_topics AS t JOIN bb_users AS u ON u.user_id = t.topic_poster JOIN bb_posts_html AS pt ON pt.post_id = t.topic_first_post_id LEFT JOIN bb_bt_torrents AS tor ON tor.topic_id = t.topic_id JOIN bb_forums AS f ON f.forum_id = t.forum_id WHERE t.topic_dl_type = 1 AND f.forum_id NOT IN(306,203,262,279,280,261,266,311,319,322,124,231,200,281,125,331,336,305,292,335,337,338,294,295,126,282,286,283,285,284,290,287,288,289,317) AND f.cat_id = search
Source : portal.php(133) :: db1.***
IP : ***
Date : 2015-04-16 15:13:02
Agent : ***
Req_URI : /portal.php?mode=c&search=16&start=165
Referer :
Method : GET
PID : ***
Request : Array
(
[mode] => c
[amp;search] => 16
[amp;start] => 165
)