English version - [General] SQL Error : 1062 Duplicate entry 'xxxx' for key 1
evilmc - 24-02-2009, 22:24
Temat postu: [General] SQL Error : 1062 Duplicate entry 'xxxx' for key 1
| Kod: | Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '391474839' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(391474839, 'f6fe4f1cd8a05572a0728e1c646ff903', 'a:7:{s:14:"search_results";s:103:"775, 813, 960, 1973, 2540, 3341, 3599, 5127, 5156, 5174, 5181, 5188, 5192, 5193, 5197, 5200, 5201, 5202";s:17:"total_match_count";i:18;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:-1;}')
Line : 705
File : search.php
If you can not fix this problem,
you can find help, or ask question at: http://www.przemo.org/phpBB2/ |
Why is this happening?
MagicalFire - 24-02-2009, 22:31
do your query to SQL
| Kod: |
TRUNCATE `phpbb_search_results`;
TRUNCATE `phpbb_search_wordlist`;
TRUNCATE `phpbb_search_wordmatch`;
|
after this
Administration Panel---->SQL-->Rebuild Search
| Cytat: | | Rebuilding the search table, will take a while but will increase the effectivness of the search function. |
evilmc - 24-02-2009, 22:33
and does not work search on the forum :S
please for help
Best regards
Bojan
MagicalFire - 24-02-2009, 22:34
you already answered the question
evilmc - 24-02-2009, 22:43
| MagicalFire napisał/a: | | you already answered the question |
I did not see your response
Thank you again and is currently being renewed search
MagicalFire - 24-02-2009, 22:47
evilmc,
search working properly ? | evilmc napisał/a: | | I did not see your response |
sorry 
evilmc - 24-02-2009, 22:55
| MagicalFire napisał/a: | evilmc,
search working properly ? |
Search is not renewed...12 % need to wait:)
MagicalFire - 24-02-2009, 22:59
how not to run
write on this subject
evilmc - 27-02-2009, 18:51
search working! thanx again!
|
|
|
