phpBB2 by Przemo

[kalqa]

Witam mam taki problem.Obrazek pokazuje wszystko.
Dodam że niedawno instalowałem psychostats na forum.
Co jest nie tak?

[Gadatliwa Kasia]

[Dajaj]

Cytat:

.phpbb_users' doesn't exist

nie masz tabeli phpbb_users

[kalqa]

W takim razie muszę ją dodać ale jak ?

[Dajaj]

zależy jaki skrypt instalowałeś ? ten najnowszy ?

[kalqa]

Tak.Myślę ze podczas instalacji psychostats zamieniłem tabele z phpBB_ na ps_.Da się to jakoś odwrócić?

[Dajaj]

w config.php zmień perfix

a tutaj zapytania do wykonania tabeli :

Kod:

CREATE TABLE phpbb_users (   user_id mediumint(8) NOT NULL default '0',   user_active tinyint(1) DEFAULT '1',   username varchar(25) NOT NULL default '',   user_password varchar(40) NOT NULL default '',   user_session_time int(11) DEFAULT '0' NOT NULL,   user_session_page smallint(5) DEFAULT '0' NOT NULL,   user_lastvisit int(11) DEFAULT '0' NOT NULL,   user_regdate int(11) DEFAULT '0' NOT NULL,   user_level tinyint(1) DEFAULT '0',   user_posts mediumint(6) UNSIGNED DEFAULT '0' NOT NULL,   user_timezone decimal(5,2) DEFAULT '0' NOT NULL,   user_style tinyint(2) default '1' NULL,   user_lang varchar(12) default '' NOT NULL,   user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,   user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,   user_last_privmsg int(11) DEFAULT '0' NOT NULL,   user_emailtime int(11) default '0',   user_viewemail tinyint(1) DEFAULT '1',   user_viewaim tinyint(1) DEFAULT '1',   user_attachsig tinyint(1) DEFAULT '1',   user_allowhtml tinyint(1) DEFAULT '1',   user_allowbbcode tinyint(1) DEFAULT '1',   user_allowsmile tinyint(1) DEFAULT '1',   user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,   user_allowsig tinyint(1) DEFAULT '1' NOT NULL,   user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,   user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,   user_notify tinyint(1) DEFAULT '1' NOT NULL,   user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,   user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,   user_rank int(11) DEFAULT '0',   user_avatar varchar(100) default '',   user_avatar_type tinyint(1) DEFAULT '0' NOT NULL,   user_email varchar(255) default '',   user_icq varchar(15) default '',   user_website varchar(255) default '',   user_from varchar(64) default '',   user_sig text,   user_sig_bbcode_uid char(10) default '',   user_sig_image varchar(100) NOT NULL DEFAULT '',   user_aim varchar(255) default '',   user_yim varchar(255) default '',   user_msnm varchar(255) default '',   user_occ varchar(100) default '',   user_interests varchar(255) default '',   user_actkey varchar(32) default '',   user_newpasswd varchar(40) default '',   user_birthday int(6) DEFAULT '999999' NOT NULL,   user_next_birthday_greeting int(4) DEFAULT '0' NOT NULL,   user_custom_rank varchar(100) default '',   user_photo varchar(100) default '',   user_photo_type tinyint(1) DEFAULT '0' NOT NULL,   user_custom_color varchar(6) default '',   user_badlogin smallint(2) DEFAULT '0' NOT NULL,   user_blocktime int(11) DEFAULT '0' NOT NULL,   user_block_by char(8) default '',   disallow_forums varchar(254) default '',   can_custom_ranks tinyint(1) DEFAULT '1' NOT NULL,   can_custom_color tinyint(1) DEFAULT '1' NOT NULL,   user_gender tinyint(1) NOT NULL DEFAULT '0',   can_topic_color tinyint(1) DEFAULT '1' NOT NULL,   user_notify_gg tinyint(1) DEFAULT '0' NOT NULL,   allowpm tinyint(1) DEFAULT '1',   no_report_popup tinyint(1) DEFAULT '0' NOT NULL,   refresh_report_popup tinyint(1) DEFAULT '0' NOT NULL,   no_report_mail tinyint(1) DEFAULT '0' NOT NULL,   user_avatar_width smallint(3) default NULL,   user_avatar_height smallint(3) default NULL,   special_rank mediumint(8) UNSIGNED DEFAULT NULL,   user_allow_helped tinyint(1) UNSIGNED NOT NULL DEFAULT '1',   user_ip char(8) DEFAULT NULL,   user_ip_login_check tinyint(1) DEFAULT '1' NOT NULL,   user_spend_time int(8) DEFAULT '0' NOT NULL,   user_visit int(7) DEFAULT '0' NOT NULL,   user_session_start  int(11) NOT NULL DEFAULT '0',   read_tracking_last_update int(11) NOT NULL DEFAULT '0',   user_jr tinyint(1) DEFAULT '0',   PRIMARY KEY (user_id),   KEY user_session_time (user_session_time),   KEY user_level (user_level),   KEY user_lastvisit (user_lastvisit),   KEY user_active (user_active) ); INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 1, 1, 1, 1, 0, 1, 1, 0, '', 'polish', 1.00, '', '', 0, 0);

[kalqa]

Zrobilem tak jak napisales i teraz wyskakuj takie coś:

phpBB by Przemo : Critical Error

Could not obtain ban information

DEBUG MODE

SQL Error : 1146 Table 'thcarena_przemo.phpbb_banlist' doesn't exist

SELECT * FROM phpbb_banlist WHERE ban_ip IN ('59e48494', '59e484ff', '59e4ffff', '59ffffff') OR ban_userid = -1

Line : 49
File : sessions.php

[Dajaj]

na moje reinstal forum bo źle zainstalowałeś te "psychostats " powinna być dla nich osobna baza danych

[Gadatliwa Kasia]

[Woytec]

Czy masz jakiekolwiek tabele kończące się na banlist lub users(np. z przedrostkiem ps_)?