phpBB2 by Przemo

[lotos]

Witam.zainstalowałem na swoim forum ten mod:link.Gdy włączam jakis post do wyskakuje mi ten błąd:

Kod:

Could not obtain post/user information. DEBUG MODE SQL Error : 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 '.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewem' at line 1 SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.user_agent, p.post_attachment, p.post_expire, p.post_marked, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.special_rank, u.user_allow_helped, u.can_custom_color, u.user_custom_color, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.karma_plus, u.karma_minus, u.karma_time u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 25 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15 Line : 901 File : viewtopic.php

Proszę o pomoc

[Gadatliwa Kasia]

[xlesiu]

Kod:

u.karma_time u.user_avatar_type

nie ma przecinka między tymi dwoma kodami

[lotos]

to pomogło ale teraz jest jeszcze 1 błąd

Kod:

Could not obtain post/user information. DEBUG MODE SQL Error : 1054 Unknown column 'u.karma_plus' in 'field list' SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.user_agent, p.post_attachment, p.post_expire, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.can_custom_color, u.user_custom_color, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.karma_plus, u.karma_minus, u.karma_time, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 26 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15 Line : 901 File : viewtopic.php

prosze O POMOC

[Majkelo]

Wykonaj zapytanie w PHPMYADMIN:

Kod:

ALTER TABLE `phpbb_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL ;

[lotos]

3 błąd

Kod:

Could not obtain post/user information. DEBUG MODE SQL Error : 1054 Unknown column 'u.karma_time' in 'field list' SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.user_agent, p.post_attachment, p.post_expire, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.can_custom_color, u.user_custom_color, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.karma_plus, u.karma_minus, u.karma_time, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 26 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15 Line : 901 File : viewtopic.php

[Majkelo]

Wrzuć na FTP ten plik db_update.php z paczki z modem i go odpal:

http://twojeforum.pl/db_update.php

[lotos]

mom 3 Errory a mianowicie

Kod:

ALTER TABLE `phpbb_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL +++ Error: Duplicate column name 'karma_plus' ALTER TABLE `phpbb_users` ADD `karma_minus` MEDIUMINT DEFAULT '0' NOT NULL +++ Error: Duplicate column name 'karma_minus' ALTER TABLE `phpbb_users` ADD `karma_time` BIGINT DEFAULT '0' NOT NULL +++ Error: Duplicate column name 'karma_time'

co robic?

[Woytec]

Sprawdź jaki błąd masz teraz

[lotos]

ale jak sprawdzić jaki błąd mam ?

[Gadatliwa Kasia]

[xlesiu]

Wejdź tam gdzie wyskakiwał błąd i zobacz czy pojawia się dalej.