#1091 - Can't DROP 'post_username'; check that column/key ex
Geplaatst: 07 dec 2010, 21:10
Beste,
Ik heb een probleem met m'n forum versie 3.0.7 die ik wou upgraden.
Ik moest echter een update doen van de database. Indien ik die wou updaten via de mysql_upgrader.php en deze ging invoeren in phpMyadmin kreeg ik een error terug van de query:
Fout
SQL-query:
# Table: 'phpbb_posts' ALTER TABLE phpbb_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 C[...]
MySQL retourneerde:
#1091 - Can't DROP 'post_username'; check that column/key exists
Ik heb een probleem met m'n forum versie 3.0.7 die ik wou upgraden.
Ik moest echter een update doen van de database. Indien ik die wou updaten via de mysql_upgrader.php en deze ging invoeren in phpMyadmin kreeg ik een error terug van de query:
Fout
SQL-query:
# Table: 'phpbb_posts' ALTER TABLE phpbb_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 C[...]
MySQL retourneerde:
#1091 - Can't DROP 'post_username'; check that column/key exists