Page 1 of 1

Errors lately.

Posted: 11/11/2006 - 1:48
by Analog-X64
Recently I've been getting the following errors when I click on the "View posts since last visit"

Code: Select all

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '1239460158' for key 1

INSERT INTO board_search_results (search_id, session_id, search_time, search_array) 
VALUES(1239460158, '3919522b7dd4e4832d1f630f607a30b6', 1163209599, 'a:7:
{s:14:"search_results";s:22:"3130, 4190, 4215, 4216";s:17:"total_match_count";i:4;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:200;}')

Line : 706
File : search.php

Posted: 11/11/2006 - 8:34
by Chris Abbott
I think everyone gets it once in a while, and it usually goes away when you ask again.

LMan has tried some numerous things, but it seems a very sticky error.

Chris

Posted: 11/11/2006 - 18:23
by Analog-X64
I did a bit of research and found that this problem existed in phpBB back in 2005 and the authors of the phpBB mentioned that fix would be available in the next release.

Also in some other threads it was suggested that if you have "phpmyadmin" you can run the "Repair/Optimize" built in Feature of phpmyadmin to fix this issue.

Posted: 12/11/2006 - 1:18
by Vosla
I experience those errors often when serverload seems to be very high e.g. ping times are already very bad. Anyway - page reload and error's gone almost instantly.

Posted: 12/11/2006 - 1:53
by Analog-X64
Vosla wrote:I experience those errors often when serverload seems to be very high e.g. ping times are already very bad. Anyway - page reload and error's gone almost instantly.
Yup same here I just refresh.

As long as it doesnt cause a database corruption to our beloved website/forum.

Posted: 12/11/2006 - 12:19
by Chris Abbott
Server load isn't very high on that machine. I wonder if maybe the backup is still causing problems. Me and LMan want to move server anyway, but it's tough to find cost-effectiveness and good support in the same package.

Chris

Posted: 12/11/2006 - 12:53
by Analog-X64
Chris Abbott wrote:Server load isn't very high on that machine. I wonder if maybe the backup is still causing problems. Me and LMan want to move server anyway, but it's tough to find cost-effectiveness and good support in the same package.

Chris
I know the feeling. Right I run a site for my Wife and we got a good deal as far as bandwidth per month and the type of service. However it is a Share Web hosting and a week does not go by that our site is down for 10-15 mintues and I have to create a ticket and they re-boot the server to get it up and running.

They have Virtual Server Hosting which would eliminate the problem but that is something like $44 a Month U.S. and I just cant afford it.

I wish I could setup my own server at home and do everything myself but no residential service exists like that, and any business service would just be astronomical.