Leere (nicht lösche) die relevanten 3 Tabellen manuell via phpmyadmin....
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_search_results
Info: https://www.phpbb.com/community/viewtop ... &t=2170630
...und dann versuche es nochmal.
Leere (nicht lösche) die relevanten 3 Tabellen manuell via phpmyadmin....
Code: Alles auswählen
Allgemeiner Fehler
SQL ERROR [ mysqli ]
Duplicate entry 'search_indexing_state' for key 'PRIMARY' [1062]
SQL
INSERT INTO phpbb3_config (config_name, config_value, is_dynamic) VALUES ('search_indexing_state', '\\phpbb\\search\\fulltext_mysql,create,0', 0)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/config/db.php
LINE: 161
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/phpbb/config/db.php
LINE: 122
CALL: phpbb\config\db->set_atomic()
FILE: [ROOT]/includes/acp/acp_search.php
LINE: 602
CALL: phpbb\config\db->set()
FILE: [ROOT]/includes/acp/acp_search.php
LINE: 302
CALL: acp_search->save_state()
FILE: [ROOT]/includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_search->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
phpbb3_config
die Zeile mit search_indexing_state
löschen.
Code: Alles auswählen
DELETE FROM phpbb3_config where config_name=search_indexing_state
Code: Alles auswählen
Allgemeiner Fehler
SQL ERROR [ mysqli ]
Duplicate key name 'post_text' [1061]
SQL
ALTER TABLE phpbb3_posts ADD FULLTEXT post_text (post_text)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/search/fulltext_mysql.php
LINE: 1052
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/includes/acp/acp_search.php
LINE: 371
CALL: phpbb\search\fulltext_mysql->create_index()
FILE: [ROOT]/includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_search->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()