We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

Sql Pomocy


Guzik17
12-03-2006, 01:13
Chodzi mi o instalacje " BANNED AND WARNING USERS" na forum phpbb2 2.0.19 zrobilem wszystko wedlug instrukcji oprucz tego:

#
#-----[ SQL ]---------------------------------------------
#

ALTER TABLE `phpbb_users` ADD `user_warn` VARCHAR( 3 ) DEFAULT '0' NOT NULL AFTER `user_active` ;
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('warn_limit', '10');


Poniewaz nie wiemm o co chodzi co to jest to SQL nic takiego nie moglem znalesc co tam zmienic i gdzie.
Reszte instrukcji wykonalem prawidlowo. A bez tego wyskakuje mi blad kiedy chce wejsc na forum w jakis temat:

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_warn' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_warn, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 15 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 399
File : viewtopic.php



Prosze o pomoc. Pozdro