| View previous topic :: View next topic |
| Author |
Message |
Neon_WA
Joined: 08 Nov 2008
Posts: 7146
Location: Margaret River, West Australia
|
 Posted: Tue Jan 13, 2009 4:05 am Post subject: search errors |
 |
|
it might come right, but the search forums is having a dummy spit lol
this is an example of the returned error
| Quote: | General Error
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '734100736' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(734100736, '280e536c3b76cc1f3e97cddafeef6f2d', 'a:7:{s:14:"search_results";s:65:"4756, 4945, 5006, 6153, 8495, 8958, 9128, 9670, 9896, 9955, 11071";s:17:"total_match_count";i:11;s:12:"split_search";a:1:{i:0;s:5:"sz994";}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:200;}')
Line : 684
File : search.php
|
_________________
There are 10 types of people in this world:
those who understand binary and those who don't. ~Author Unknown
http://www.x86-guide.net/Neon-WA/en/collection.html |
|
| Back to top |
|
 |
CPUShack
Joined: 16 Jun 2003
Posts: 34259
Location: State of Jefferson, USA
|
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Tue Jan 13, 2009 5:21 pm Post subject: |
|
|
It could be due to high server load or temporary MySQL error. I took a quick look at log files and I couldn't find any serious problems like database is down, not enough memory, etc, at the time of your post. If anybody will see similar errors in the future please post and I'll spend more time investigating it.
Gennadiy |
|
| Back to top |
|
|
Neon_WA
Joined: 08 Nov 2008
Posts: 7146
Location: Margaret River, West Australia
|
| Posted: Tue Mar 17, 2009 1:40 am Post subject: |
|
|
Search response today about 1 minute before i posted this 
| Quote: | Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '1103280960' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1103280960, 'c9cd787a5a7e39fe3861d5e2295d6349', 'a:7:{s:14:"search_results";s:16:"1737, 8173, 8885";s:17:"total_match_count";i:3;s:12:"split_search";a:1:{i:0;s:9:"d600aut1b";}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:200;}')
Line : 684
File : search.php |
i will note when it comes back ok
edit 1.5hrs later >> came alright, then came back. Only way to stop it is close the window and reopen a new page. Not sure what is triggering it
_________________
There are 10 types of people in this world:
those who understand binary and those who don't. ~Author Unknown
http://www.x86-guide.net/Neon-WA/en/collection.html |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Tue Mar 17, 2009 11:22 am Post subject: |
|
|
I run an MySQL command on phpbb_search_results table that will likely fix the problem. If you see the same problem in the future please post - I will run another command that will rebuild the table completely.
Gennadiy |
|
| Back to top |
|
|
cooperalp
Joined: 14 Feb 2009
Posts: 688
Location: Alberta
|
| Posted: Sat Mar 21, 2009 1:39 am Post subject: |
|
|
Today I got the same error for the first time.
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '1519322641' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1519322641, '5e23a364eeb660283558f769ca6423f3', 'a:7:{s:14:"search_results";s:18:"2823, 10303, 10688";s:17:"total_match_count";i:3;s:12:"split_search";a:1:{i:0;s:7:"winchip";}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:200;}')
Line : 684
File : search.php |
|
| Back to top |
|
|
Neon_WA
Joined: 08 Nov 2008
Posts: 7146
Location: Margaret River, West Australia
|
| Posted: Sat Mar 21, 2009 1:50 am Post subject: |
|
|
i tried it with the same search word soon as i saw the post and it was ok.
I would like to know what the trigger or combination that sets it off
edit >> when i posted this message it took a while for it to post.. when i checked there was three copies of the same post and i only hit submit once 
double edit >> when i did the search for winchip it found only 4 matches... now its finding 147 
must be an intel running the puter hosting this place 
_________________
There are 10 types of people in this world:
those who understand binary and those who don't. ~Author Unknown
http://www.x86-guide.net/Neon-WA/en/collection.html |
|
| Back to top |
|
|
cooperalp
Joined: 14 Feb 2009
Posts: 688
Location: Alberta
|
| Posted: Sat Mar 21, 2009 11:33 am Post subject: |
|
|
| Neon_WA wrote: |
double edit >> when i did the search for winchip it found only 4 matches... now its finding 147 |
This is normal. If you search winchip under the subject title "off topic" , search engine will find 4 topics containing that word. If you search it on the main page of the forum, it starts searching under all the subject titles and will find 147 topics. Depends on where you search it basically. |
|
| Back to top |
|
|
gshv
Joined: 01 Feb 2003
Posts: 7898
Location: Fairfax, VA USA
|
| Posted: Sun Mar 22, 2009 9:28 pm Post subject: |
|
|
I will rebuild the phpbb_search_results table tomorrow. Hopefully that will finally fix the problem.
Gennadiy |
|
| Back to top |
|
|
Neon_WA
Joined: 08 Nov 2008
Posts: 7146
Location: Margaret River, West Australia
|
| Posted: Sun Mar 22, 2009 9:42 pm Post subject: |
|
|
| gshv wrote: | I will rebuild the phpbb_search_results table tomorrow. Hopefully that will finally fix the problem.
Gennadiy |
but it would be nice to know what triggers it
Not sure if it is happening at different times of the day to others, but when it happens to me, it seems to be generally around the same time.
Least i know how to stop it, by closing and reopening the window fixes it most times. Not sure if that is giving me a different link into the server. Could it be hardware cos the site is generally slow to respond when i get the search errors.
Oh well.. hopefully it wont be an issue anymore 
_________________
There are 10 types of people in this world:
those who understand binary and those who don't. ~Author Unknown
http://www.x86-guide.net/Neon-WA/en/collection.html |
|
| Back to top |
|
|
|
![[ Hidden ]](https://cdn.cpu-world.com/forum/templates/CPUWorld/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
