Problem z bazą danych

[tanatos]

Witam,

Przy instalacji Joomla PE, wyskakuje mi błąd:

SQL=Duplicate entry '107' for key 1:
- - - - - - - - - -
INSERT INTO `jos_components` VALUES (107, 'Joomla-Przemo', 'option=com_j-p', 0, 0, 'option=com_j-p', 'Joomla-Przemo', 'com_j-p', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry '108' for key 1:
- - - - - - - - - -
INSERT INTO `jos_components` VALUES (108, 'Ustawienia', '', 0, 107, 'option=com_j-p&task=config', 'Ustawienia', 'com_j-p', 0, 'js/ThemeOffice/component.png', 0, '');
= = = = = = = = = =


Baza danych jest nowa. Co musze zmienić. Prosze o poradę

[tanatos]

Dziś przy ponownej próbie zainstalowaniu joomli, wyrzuciło takie błędy:

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)
)

[nexus246]

Przy wcześniejszej instalacji cześć SQLa się wykonała. Dropnij wszystkie tabelki przed ponowną instalacją.

[tanatos]

Usunełem bazę, założyłem nową, z inną nazwą i hasłem.

Pojawia się teraz taki komunikat:

Podczas importu bazy danych pojawiły się błędy. Nie możesz kontynuować. Usuń przyczynę i spróbuj ponownie.

SQL=Duplicate entry '107' for key 1:
- - - - - - - - - -
INSERT INTO `jos_components` VALUES (107, 'Joomla-Przemo', 'option=com_j-p', 0, 0, 'option=com_j-p', 'Joomla-Przemo', 'com_j-p', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry '108' for key 1:
- - - - - - - - - -
INSERT INTO `jos_components` VALUES (108, 'Ustawienia', '', 0, 107, 'option=com_j-p&task=config', 'Ustawienia', 'com_j-p', 0, 'js/ThemeOffice/component.png', 0, '');
= = = = = = = = = =

Czyżby plik w paczce instalacyjnej był jakiś błąd ??

[nexus246]

Najwyraźniej, pytanie chyba do autora tej wersji powinno być skierowane.