Hallo,
bin gerade dabei das Smart-Guestbook einzubauen, scheitere aber an der guestbook.sql. Beim Hochladen auf dem Server bekomme ich (nach dem ich Type=mysiam in Engine=mysiam geändert habe) folgende Fehlermedung:
SQL-Befehl: Dokumentation
# --------------------------------------------------------
#
# TABLE STRUCTURE FOR TABLE `configuration`
#
INSERT INTO configuration( configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES (
'', 'GUESTBOOK_SHOW', 'true', 50, 1, NULL , NOW( ) , NULL , 'xtc_cfg_select_option(array(\'true\', \'false\'),'
);
MySQL meldet: Dokumentation
#1062 - Duplicate entry '0' FOR KEY 'PRIMARY'
Wo liegt verdamt nochmal liegt der Fehler???
![icon_datz :datz:](https://www.modified-shop.org/forum/Smileys/greensmilies/icon_datz.gif.pagespeed.ce.seceWfT4mg.gif)
Nachdem ich mir jetzt den Sonntag versaut habe bitte ich um eure Hilfe!!!
hier noch mal die Guestbook.sql:
# phpMyAdmin MySQL-Dump
# Host: localhost
# PHP Version: 4.3.1
# --------------------------------------------------------
#
# TABLE STRUCTURE FOR TABLE `guestbook`
#
CREATE TABLE guestbook (
entry_id INT(11) NOT NULL AUTO_INCREMENT,
visitors_name VARCHAR(64) NOT NULL DEFAULT '',
visitors_email VARCHAR(96) DEFAULT '',
entry_rating INT(1) DEFAULT NULL,
entry_status INT(1) DEFAULT '1',
date_added datetime DEFAULT NULL,
last_modified datetime DEFAULT NULL,
entry_read INT(5) NOT NULL DEFAULT '0',
PRIMARY KEY (entry_id)
) ENGINE=MyISAM;
# --------------------------------------------------------
#
# TABLE STRUCTURE FOR TABLE `guestbook_description`
#
CREATE TABLE guestbook_description (
entry_id INT(11) NOT NULL DEFAULT '0',
languages_id INT(11) NOT NULL DEFAULT '0',
entry_text text NOT NULL,
PRIMARY KEY (entry_id,languages_id)
) ENGINE=MyISAM;
# --------------------------------------------------------
#
# TABLE STRUCTURE FOR TABLE `configuration`
#
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_SHOW', 'true', 50, 1, NULL, now(), NULL, 'xtc_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_MAX_DISPLAY_ENTRIES', '6', 50, 2, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_MAX_DISPLAY_PAGE_LINKS', '8', 50, 3, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_NAME_MIN_LENGTH', '4', 50, 4, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_TEXT_MIN_LENGTH', '25', 50, 5, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GUESTBOOK_ALLOW_GUEST_ENTRY', 'true', 50, 6, NULL, now(), NULL, 'xtc_cfg_select_option(array(\'true\', \'false\'),');
# --------------------------------------------------------
#
# TABLE STRUCTURE FOR TABLE `configuration_group`
#
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('50', 'Guestbook', 'Guestbook description', '50', '1');
#
# Modification FOR TABLE admin_access
ALTER TABLE admin_access ADD guestbook INT(1) NOT NULL DEFAULT 0;
UPDATE admin_access SET guestbook=1 WHERE customers_id=1;
Danke für eure Hilfe
Linkback: https://www.modified-shop.org/forum/index.php?topic=29541.0