Вопросы, ответы и примеры решений
Не работают новинки в портале после обновления трекера
Sxaker
Посторонний
Посторонний
Сообщения: 116
Зарегистрирован: 06 окт 2010, 20:23
Зарегистрирован: 06 окт 2010, 20:23
Сообщение
У меня така беда обнавил с 34 до 35.1 все норм но решил включить новинки трекера в портале. После включения заходя в портал Ошибка вот така
Помогите решить проблему
SQL ERROR [ mysql4 ]
Unknown column 'tr.tsl_speed' in 'field list' [1054]
SQL
SELECT SQL_CALC_FOUND_ROWS t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_time, t.topic_title, t.topic_attachment, t.topic_views, t.topic_replies, t.forum_id, t.topic_poster, u.username, u.user_id, u.user_type, u.user_colour, tr.size, tr.free, tr.upload, tr.seeders, tr.leechers, tr.req_upload, tr.req_ratio, tr.tsl_speed, tr.times_completed, tr.info_hash, tr.forb, p.post_id, p.post_text, p.post_attachment, p.enable_smilies, p.enable_bbcode, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid FROM phpbb_topics AS t, phpbb_users AS u, phpbb_tracker_torrents AS tr, phpbb_posts AS p WHERE ( t.topic_type != 3 ) AND t.forum_id IN ('49', '48', '7', '66', '8', '11', '13', '33', '69', '15', '67', '21', '68', '46', '26', '65', '28', '54', '50', '53', '51', '52', '55', '59', '60', '61', '58', '70', '113', '71', '73', '74', '75', '76', '77', '78', '79', '91', '81', '80', '82', '83', '84', '86', '87', '88', '89', '90', '114', '93', '94', '95', '96', '100', '115', '118', '116', '119', '122', '120') AND t.topic_poster = u.user_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 AND tr.topic_id = p.topic_id AND tr.forb < 1 AND p.post_attachment = 1 AND t.topic_approved = 1 ORDER BY tr.added DESC LIMIT 0, 10
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: portal/block/ppkBB3cker_ltorrents.php
LINE: 377
CALL: dbal_mysql->sql_query()
FILE: portal/block/ppkBB3cker_ltorrents.php
LINE: 81
CALL: ppkbb_fetch_posts()
FILE: portal.php
LINE: 257
CALL: include('portal/block/ppkBB3cker_ltorrents.php')
Помогите решить проблему
SQL ERROR [ mysql4 ]
Unknown column 'tr.tsl_speed' in 'field list' [1054]
SQL
SELECT SQL_CALC_FOUND_ROWS t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_time, t.topic_title, t.topic_attachment, t.topic_views, t.topic_replies, t.forum_id, t.topic_poster, u.username, u.user_id, u.user_type, u.user_colour, tr.size, tr.free, tr.upload, tr.seeders, tr.leechers, tr.req_upload, tr.req_ratio, tr.tsl_speed, tr.times_completed, tr.info_hash, tr.forb, p.post_id, p.post_text, p.post_attachment, p.enable_smilies, p.enable_bbcode, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid FROM phpbb_topics AS t, phpbb_users AS u, phpbb_tracker_torrents AS tr, phpbb_posts AS p WHERE ( t.topic_type != 3 ) AND t.forum_id IN ('49', '48', '7', '66', '8', '11', '13', '33', '69', '15', '67', '21', '68', '46', '26', '65', '28', '54', '50', '53', '51', '52', '55', '59', '60', '61', '58', '70', '113', '71', '73', '74', '75', '76', '77', '78', '79', '91', '81', '80', '82', '83', '84', '86', '87', '88', '89', '90', '114', '93', '94', '95', '96', '100', '115', '118', '116', '119', '122', '120') AND t.topic_poster = u.user_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 AND tr.topic_id = p.topic_id AND tr.forb < 1 AND p.post_attachment = 1 AND t.topic_approved = 1 ORDER BY tr.added DESC LIMIT 0, 10
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: portal/block/ppkBB3cker_ltorrents.php
LINE: 377
CALL: dbal_mysql->sql_query()
FILE: portal/block/ppkBB3cker_ltorrents.php
LINE: 81
CALL: ppkbb_fetch_posts()
FILE: portal.php
LINE: 257
CALL: include('portal/block/ppkBB3cker_ltorrents.php')