phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Ja, das wäre wohl zu empfehlen.harambee hat geschrieben:Soll ich danach nochmal den bisher nicht erfolgreichen Befehl wiederholen?
Jaharambee hat geschrieben:Wenn ja, dann vermutlich auch mit utf8_bin in der Zeile mit post_subject und ohne die drop_index-Zeile?
Code: Alles auswählen
Allgemeiner Fehler
SQL ERROR [ mysql4 ]
Field 'topic_last_poster_name' doesn't have a default value [1364]
SQL
INSERT INTO hkwforum_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (2, 1356026360, 1356026360, 26, 0, 1, 'Test 2', 'claus', 'AA0000', 0, 0, 0)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()
FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: [ROOT]/includes/functions_posting.php
LINE: 1979
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/posting.php
LINE: 1134
CALL: submit_post()Code: Alles auswählen
ALTER TABLE hkwforum_posts ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text); Code: Alles auswählen
MySQL-ERROR
MySQL meldet:
Duplicate key name 'post_content' Anscheinend hast du die Befehle auf der alten Datenbank ausgeführt. Du musst das ganze schon auf der neuen Datenbank ausführen. Ansonsten macht es keinen Sinn.Ich werde jetzt also nochmals auf die andere Datenbankversion umschalten
Bin ja schon dabei, bezweifle aber etwas, dass das hilftMiriam hat geschrieben:@harambee,
Du mußt ruhig bleiben, das bekommst Du hin... Kein Panik. Ruhig durchatmen und dann führst Du die Befehle in der DB noch einmal aus.
Wir werden sehen!Code: Alles auswählen
ALTER TABLE hkwforum_posts
MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX post_username,
ADD KEY post_username (post_username),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
ALTER TABLE hkwforum_posts ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text);
# Table: 'hkwforum_privmsgs'
ALTER TABLE hkwforum_privmsgs
MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY message_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY to_address text NOT NULL COLLATE utf8_bin,
MODIFY bcc_address text NOT NULL COLLATE utf8_bin,
MODIFY message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Code: Alles auswählen
ALTER TABLE hkwforum_posts ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text); Code: Alles auswählen
MySQL meldet:
Duplicate key name 'post_content'
Fehler bei der Anfrage:
ALTER TABLE hkwforum_posts ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text);