phpBB2 by Przemo

[MaKoV]

Moje forum http://cs-makov.pl/index.php
Bład od razu widać i nie mam pojecia jak go naprawic .
Silnik forum aktualizowalem wg instrukcji i niestety widac co sie stalo
Macie jakieś pomysly jak to naprawic czy lepiej juz od nowa wgrywac silnik i tylko uaktualnic baze? , baze skopiowalem jakby cos.

Kod:

Couldn't access list of Forums DEBUG MODE SQL Error : 1054 Unknown column 't.topic_accept' in 'field list' SELECT f.*, p.post_time, p.post_username, p.post_approve, u.username, u.user_id, u.user_level, u.user_jr, t.topic_last_post_id, t.topic_title, t.topic_poster, t.topic_accept FROM phpbb_forums f LEFT JOIN phpbb_posts p ON (p.post_id = f.forum_last_post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) LEFT JOIN phpbb_topics t ON (t.topic_last_post_id = p.post_id AND t.forum_id = f.forum_id) ORDER BY f.forum_order, f.forum_id Line : 233 File : functions.php Jeśli nie potrafisz znaleźć rozwiązania tego problemu, możesz spróbować poszukać, lub zadać pytanie na forum: http://www.przemo.org/phpBB2/

[Gadatliwa Kasia]

[.::Trac3r::.]

MaKoV, wykonaj zapytania do bazy danych dostępna w manualnej aktualizacji skryptu.

Edit:
Dokładnie poniższe zapytania:

Kod:

TRUNCATE TABLE phpbb_shoutbox; TRUNCATE TABLE phpbb_sessions_keys; ALTER TABLE phpbb_search_results ADD search_time int NOT NULL; ALTER TABLE phpbb_search_results CHANGE search_id search_id int(11) NOT NULL auto_increment; ALTER TABLE phpbb_topics ADD topic_accept TINYINT( 1 ) NOT NULL DEFAULT '1'; ALTER TABLE phpbb_users CHANGE user_password user_password VARCHAR( 40 ) NOT NULL DEFAULT  ''; ALTER TABLE phpbb_users CHANGE user_newpasswd user_newpasswd VARCHAR( 40 ) NOT NULL DEFAULT  ''; UPDATE phpbb_config SET config_value = '1.12.7' WHERE  config_name = 'version'; UPDATE phpbb_shoutbox_config SET config_value = 'd.m.y, H:i:s' WHERE config_name = 'date_format'; UPDATE phpbb_shoutbox_config SET config_value = '30' WHERE config_name = 'count_msg'; INSERT INTO phpbb_shoutbox_config (config_name, config_value) values ('shout_refresh', '5'); INSERT INTO phpbb_shoutbox_config (config_name, config_value) values ('sb_group_sel', 'all'); INSERT INTO phpbb_shoutbox_config (config_name, config_value) values ('usercall', '0'); INSERT INTO phpbb_shoutbox_config (config_name, config_value) values ('shoutbox_smilies', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('last_visitors_time_count', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_keywords_max', '5'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('protection_get', '1'); INSERT INTO phpbb_config (config_name, config_value) value ('rand_seed_last_update', '0'); INSERT INTO phpbb_config (config_name, config_value) value ('rand_seed', '0');