Cum pot sa mut forumul!

[yocosmin]

A functionat pana la importarea tabelului phpbb_search_wordlist

Precizez ca am reparat tabelul!

Solutii ! Help

[dorin]

Aceeasi eroare ?

[yocosmin]

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

[dorin]

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:

Cod: Selectaţi tot

DELETE FROM table WHERE `word_text` LIKE 'puteti'; 

[yocosmin]

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

[dorin]

Incearca asta:

Cod: Selectaţi tot

DELETE from phpbb_search_results where word_text = 'puteti';

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

[yocosmin]

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

[dorin]

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

[yocosmin]

da nu functioneaza (

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

[bogdan]

Da, poti regenera indecsii de cautare din Panoul administratorului.