PDA

Zobacz pełną wersję : Problem z instalacja



Sylwek1_2006
12-07-2007, 16:24
Zaczynam instalować joomla PE 1.0.12a.wpisuje informacje dotyczące bazy danych.Następnie wyskakuje mi błąd(patrz na dole)Prosze o pomoc:(


DB function failed with error number 1050
Table 'phpbb2_users' already exists SQL=CREATE TABLE phpbb2_users ( user_id mediumint(8) NOT NULL, user_active tinyint(1) DEFAULT '1', username varchar(25) NOT NULL, user_password varchar(32) NOT NULL, 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(4) DEFAULT '0', user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_timezone decimal(5,2) DEFAULT '0' NOT NULL, user_style tinyint(4), user_lang varchar(255), user_dateformat varchar(14) DEFAULT 'd M Y H:i' 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_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_last_login_try int(11) DEFAULT '0' NOT NULL, user_emailtime int(11), user_viewemail tinyint(1), user_attachsig tinyint(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_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 '0' NOT NULL, user_popup_pm tinyint(1) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), user_avatar_type tinyint(4) DEFAULT '0' NOT NULL, user_email varchar(255), user_icq varchar(15), user_website varchar(100), user_from varchar(100), user_sig text, user_sig_bbcode_uid char(10), user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), user_occ varchar(100), user_interests varchar(255), user_actkey varchar(32), user_newpasswd varchar(32), PRIMARY KEY (user_id), KEY user_session_time (user_session_time) )
SQL =
CREATE TABLE phpbb2_users (
user_id mediumint(8) NOT NULL,
user_active tinyint(1) DEFAULT '1',
username varchar(25) NOT NULL,
user_password varchar(32) NOT NULL,
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(4) DEFAULT '0',
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
user_style tinyint(4),
user_lang varchar(255),
user_dateformat varchar(14) DEFAULT 'd M Y H:i' 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_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_last_login_try int(11) DEFAULT '0' NOT NULL,
user_emailtime int(11),
user_viewemail tinyint(1),
user_attachsig tinyint(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_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 '0' NOT NULL,
user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
user_rank int(11) DEFAULT '0',
user_avatar varchar(100),
user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
user_email varchar(255),
user_icq varchar(15),
user_website varchar(100),
user_from varchar(100),
user_sig text,
user_sig_bbcode_uid char(10),
user_aim varchar(255),
user_yim varchar(255),
user_msnm varchar(255),
user_occ varchar(100),
user_interests varchar(255),
user_actkey varchar(32),
user_newpasswd varchar(32),
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
)

dkint
22-07-2007, 10:06
Witam

Table 'phpbb2_users' already exists - ten kawałek błędu informuje cię o tym, że masz już taką tabelę w bazie danych ... prawdopodobnie instalujesz już drugi raz z rzędu i poprzednia instalacja zdążyła pozakładać już tabele, jeśli to jest "goła" instalacja to wejdź do bazy najlepiej przy pomocy phpMyAdmin i wyczyść istniejące tabele ... lub wpisz inny prefix bazy przy instalacji - domyślnie masz jos_ możesz wpisać cokolwiek np. strona_

pozdrawiam
Krzysiek

vj_
23-07-2007, 11:35
Wykasuj calosc w bazie najlepiej i wgraj od nowa.