El problema sucede cuando importamos la información en una nueva base de mysql (también cuando migramos nuestro foro phpBB3 a otro servidor) muestra el siguiente error:
![Imagen](http://franzpc.files.wordpress.com/2012/08/error-importar-base-mysql-phpbb3.png)
Navegando en la web y consultando con expertos en phpBB3, generalmente el problema sucede con la tabla phpbb_search_wordlistError
MySQL ha dicho:
#1062 - Duplicate entry '??????' for key 2
Solución:
Si aún tienes acceso a tu base de mysql desde phpMyAdmin ingresa y elimina la tabla phpbb_search_wordlist luego exportas la base y la puedes importar en una nueva base (servidor).
Pero si el problema es que únicamente cuentas con el archivo de respaldo de la base, y quieres reparar tu foro phpBB3, como mysql no deja importar por completo la base, desde notepad (se ve mejor con wordpad u otro editor de texto) debes eliminar la información correspondiente a la tabla phpbb_search_wordlist, la siguiente estructura es la que tendrías que borrar:
Código: Seleccionar todo
--
-- Estructura de tabla para la tabla `phpbb_search_wordlist`
--
CREATE TABLE `phpbb_search_wordlist` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_text` varchar(255) collate utf8_bin NOT NULL default '',
`word_common` tinyint(1) unsigned NOT NULL default '0',
`word_count` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`word_id`),
UNIQUE KEY `wrd_txt` (`word_text`),
KEY `wrd_cnt` (`word_count`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=59 ;
--
-- Volcar la base de datos para la tabla `phpbb_search_wordlist`
--
INSERT INTO `phpbb_search_wordlist` VALUES (1, 0x74686973, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (2, 0x6578616d706c65, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (3, 0x706f7374, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (4, 0x796f7572, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (5, 0x706870626233, 0, 2);
INSERT INTO `phpbb_search_wordlist` VALUES (8, 0x7365656d73, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (9, 0x776f726b696e67, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (10, 0x796f75, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (11, 0x6d6179, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (12, 0x64656c657465, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (13, 0x6c696b65, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (14, 0x616e64, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (16, 0x736574, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (17, 0x626f617264, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (18, 0x647572696e67, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (19, 0x746865, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (20, 0x70726f63657373, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (21, 0x6669727374, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (22, 0x63617465676f7279, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (23, 0x666f72756d, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (24, 0x617265, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (25, 0x61737369676e6564, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (26, 0x617070726f707269617465, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (27, 0x7065726d697373696f6e73, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (28, 0x666f72, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (32, 0x626f7473, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (33, 0x676c6f62616c, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (34, 0x6d6f64657261746f7273, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (35, 0x677565737473, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (36, 0x72656769737465726564, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (37, 0x7573657273, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (38, 0x636f707061, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (39, 0x616c736f, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (40, 0x63686f6f7365, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (41, 0x6e6f74, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (42, 0x666f72676574, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (43, 0x61737369676e, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (44, 0x616c6c, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (45, 0x7468657365, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (46, 0x6e6577, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (48, 0x666f72756d73, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (49, 0x637265617465, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (51, 0x72656e616d65, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (52, 0x636f7079, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (53, 0x66726f6d, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (54, 0x7768696c65, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (55, 0x6372656174696e67, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (56, 0x68617665, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (57, 0x66756e, 0, 1);
INSERT INTO `phpbb_search_wordlist` VALUES (58, 0x77656c636f6d65, 0, 1);
Espero que a alguien le pueda ser útil esta información.