phpBB2 by Przemo

[4real]

Gdy wgrałem wszystkie pliki i weszłem na forum w temat coś takiego się pojawiło :

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_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.user_avatar_width, u.user_avatar_height, u.user_field_1, u.user_allow_field_1, u.user_field_2, u.user_allow_field_2, u.user_field_3, u.user_allow_field_3, u.user_field_4, u.user_allow_field_4, u.user_field_5, u.user_allow_field_5, 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.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, u.user_plus, u.user_minus, 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 = 90 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15

Line : 845
File : viewtopic.php może ktoś pomoże ?

[Gadatliwa Kasia]

[szresi]

Zanim zadamy pytanie, używamy opcji szukaj

http://www.przemo.org/php...+unknown+column

[koziolek]

A wykonałeś zapytanie SQL?

[ Dodano: 07-09-2008, 14:15 ]
Za późno ;/

A wszystko przez antyflooda, bo nie wysłałem od razu, a potem zapomniałem o tym.: )

[4real]

ale wywala blad przy zapytaniu

[koziolek]

Podaj treść błędu.

[warna]

A my mamy szklaną kulę i znamy treść błędu... Podaj treść.

[4real]

Błąd

zapytanie SQL:

CREATE TABLE `phpbb_plus_minus` (
`pm_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pm_date` int( 11 ) NOT NULL ,
`pm_type` varchar( 1 ) ,
`pm_post_id` int( 11 ) ,
`pm_topic_id` int( 11 ) ,
`pm_from_id` smallint( 6 ) NOT NULL ,
`pm_to_id` smallint( 6 ) NOT NULL ,
`pm_reason` text,
PRIMARY KEY ( `pm_id` )
) TYPE = MYISAM ALTER TABLE `phpbb_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang` ;

MySQL zwrócił komunikat: Dokumentacja
#1046 - No database selected takie coś

[koziolek]

[4real]

Błąd

zapytanie SQL:

CREATE TABLE `phpbb_plus_minus` (
`pm_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pm_date` int( 11 ) NOT NULL ,
`pm_type` varchar( 1 ) ,
`pm_post_id` int( 11 ) ,
`pm_topic_id` int( 11 ) ,
`pm_from_id` smallint( 6 ) NOT NULL ,
`pm_to_id` smallint( 6 ) NOT NULL ,
`pm_reason` text,
PRIMARY KEY ( `pm_id` )
) TYPE = MYISAM ALTER TABLE `phpbb_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang` ;

MySQL zwrócił komunikat: Dokumentacja
#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 'ALTER TABLE `phpbb_users` ADD `user_plus` smallint(6) NOT NULL AFTER `user_lang`' at line 13 to teraz taki błąd wyskakuje

[koziolek]

Wykonaj te zapytania osobno. Najpierw:

Kod:

CREATE TABLE `phpbb_plus_minus` ( `pm_id` int( 11 ) NOT NULL AUTO_INCREMENT , `pm_date` int( 11 ) NOT NULL , `pm_type` varchar( 1 ) , `pm_post_id` int( 11 ) , `pm_topic_id` int( 11 ) , `pm_from_id` smallint( 6 ) NOT NULL , `pm_to_id` smallint( 6 ) NOT NULL , `pm_reason` text, PRIMARY KEY ( `pm_id` ) ) TYPE = MYISAM;

a potem:

Kod:

ALTER TABLE `phpbb_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang`;

[Gadatliwa Kasia]

[4real]

no pomogło ale czemu w niektórych postach moge tylko dać minusa albo plusa i minusa a nigdy samego plusa ?