phpBB România

A functionat pana la importarea tabelului phpbb_search_wordlist

Precizez ca am reparat tabelul!

Solutii ! Help

Aceeasi eroare ?

da
Error
SQL query:

-- -- Salvarea datelor din tabel `phpbb_search_wordlist` -- INSERT INTO `phpbb_search_wordlist` (`word_id`, `word_text`, `word_common`, `word_count`) VALUES (1, 'acesta', 0, 1), (2, 'este', 0, 15), (3, 'mesaj', 0, 3), (4, 'exemplu', 0, 4), (5, 'din', 0, 17), (6, 'instalarea', 0, 2), (7, 'phpbb3', 0, 0), (8, 'totul', 0, 2), (9, 'pare', 0, 1), (10, 'functioneze', 0, 0), (11, 'normal', 0, 0), (12, 'puteti', 0, 0), (13, 'sterge', 0, 0), (14, 'acest', 0, 11), (15, 'daca', 0, 1), (16, 'doriti', 0, 0), (17, 'continua', 0, 0), (18, 'configurarea', 0, 0), (19, 'forumului', 0, 2), (20, 'timpul', 0, 1), (21, 'procesului', 0, 0), (22, 'instalare', 0, 2), (23, 'prima', 0, 4), (24, 'categorie', 0, 0), (25, 'primul', 0, 2), (26, 'forum', 0, 10), (27, 'atribuit', 0, 0), (28, 'set', 0, 1), (29, 'permisiuni', 0, 0), (30, 'potrivit', 0, 0), (31, 'grupurilor', 0, 0), (32, 'predefinite', 0, 0), (33, 'administratori', 0, 0), (34, 'roboti', 0, 0), (35, 'moderatori', 0, 5), (36, 'globali', 0, 1), (37, 'viz[...]

MySQL said:

#1062 - Duplicate entry 'puteti' for key 2


Am o vaga idee ca problema ar fi ca cuvantul "puteti" este de 2 ori introdus
pentru ca :

INSERT INTO `phpbb_search_wordlist` (`word_id`, `word_text`, `word_common`, `word_count`) VALUES
(1, 'acesta', 0, 1),
(2, 'este', 0, 15),
(3, 'mesaj', 0, 3),
(4, 'exemplu', 0, 4),
(5, 'din', 0, 17),
(6, 'instalarea', 0, 2),
(7, 'phpbb3', 0, 0),
(8, 'totul', 0, 2),
(9, 'pare', 0, 1),
(10, 'functioneze', 0, 0),
(11, 'normal', 0, 0),
(12,'puteti', 0, 0),
(13, 'sterge', 0, 0),
(14, 'acest', 0, 11),
(15, 'daca', 0, 1),
(16, 'doriti', 0, 0),
(17, 'continua', 0, 0),
(18, 'configurarea', 0, 0),
(19, 'forumului', 0, 2),
(20, 'timpul', 0, 1),
(21, 'procesului', 0, 0),
(22, 'instalare', 0, 2),
(23, 'prima', 0, 4),
(24, 'categorie', 0, 0),
(25, 'primul', 0, 2),
(26, 'forum', 0, 10),
(27, 'atribuit', 0, 0),
(28, 'set', 0, 1),
(29, 'permisiuni', 0, 0),
(30, 'potrivit', 0, 0),
(31, 'grupurilor', 0, 0),
(32, 'predefinite', 0, 0),
(33, 'administratori', 0, 0),
(34, 'roboti', 0, 0),
(35, 'moderatori', 0, 5),
(36, 'globali', 0, 1),
(37, 'vizitatori', 0, 1),
(38, 'utilizatori', 0, 1),
(39, 'înregistrati', 0, 1),
(40, 'coppa', 0, 0),
(41, 'asemenea', 0, 1),
(42, 'alegeti', 0, 0),
(43, 'stergeti', 0, 0),
(44, 'uitati', 0, 0),
(45, 'stabiliti', 0, 0),
(46, 'pentru', 0, 15),
(47, 'toate', 0, 5),
(48, 'aceste', 0, 0),
(49, 'grupuri', 0, 0),
(50, 'categoriile', 0, 0),
(51, 'forumurile', 0, 0),
(52, 'care', 0, 15),
(53, 'creati', 0, 0),
(54, 'recomandat', 0, 2),
(55, 'redenumiti', 0, 0),
(56, 'copiati', 0, 0),
(57, 'permisiunile', 0, 0),
(58, 'acestea', 0, 3),
(59, 'când', 0, 1),
(60, 'categorii', 0, 0),
(61, 'forumuri', 0, 0),
(62, 'noi', 0, 3),
(63, 'distractie', 0, 0),
(64, 'maxima', 0, 0),
(65, 'bine', 0, 3),
(66, 'ati', 0, 2),
(67, 'venit', 0, 1),
(87, 'playeri', 0, 1),
(86, 'numarul', 0, 1),
(85, 'functie', 0, 1),
(84, '4ghz', 0, 1),
(83, 'ruleze', 0, 2),
(82, 'trebui', 0, 3),
(81, 'procesorul', 0, 1),
(80, 'preferat', 0, 2),
(79, 'puternic', 0, 1),
(78, 'rand', 0, 2),
(77, 'nevoie', 0, 2),
(76, 'choke', 0, 1),
(75, 'loss', 0, 1),
(74, 'lag', 0, 2),
(73, 'fara', 0, ,
(72, 'server', 0, 4),
(71, 'unui', 0, 3),
(70, 'optima', 0, 1),
(69, 'rularea', 0, 1),
(68, 'ull', 0, 1),
(88, 'ceintele', 0, 1),
(89, 'sistemului', 0, 1),
(90, 'cresc', 0, 1),
(91, 'asadar', 0, 1),
(92, 'memorie', 0, 2),
(93, 'spune', 0, 2),
(94, '1gb', 0, 1),
(95, 'dupa', 0, 10),
(96, 'ghidul', 0, 1),
(97, 'aici', 0, 12),
(98, 'puteti', 0, 5),

etc

Esti sigur ca ai reparat tabela si ai facut salvarea bazei de date din nou ?
Daca da, poti incerca sa rulezi (inainte de salvare) pe tabela respectiva urmatoarea comanda SQL:

l-am pus in SQL si primesc urmatoare eroare: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table WHERE `word_text` LIKE 'puteti'' at line 1

l-am pus is schema si primesc urmatoarea eroare :Error
SQL query:

--
-- Salvarea datelor din tabel `phpbb_search_results`
--
-- --------------------------------------------------------
DELETE FROM TABLE WHERE `word_text` LIKE 'puteti';


MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table WHERE `word_text` LIKE 'puteti'' at line 5

Incearca asta:
Poti incerca sa stergi manual, daca ai indetificat randul in tabela, inainte de salvare.

asta fac in acest moment , dar sunt prea multe cuvinte duble , nu exista vreun mod , program , combinatie de taste , orice x-(

Repararea tabelei ar trebui sa rezolve problema. Ai facut asta ?

da nu functioneaza (

daca as sari peste acest tabel? si l-as introduce ulterior (de pe alta sursa), ar functiona?

Da, poti regenera indecsii de cautare din Panoul administratorului.