Page 1 of 1

Debug Mode

Posted: Wed Jun 28, 2006 12:16 pm
by Millymollymandy
I'm getting this when trying to access posts since last visit:-

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(312592359, '6e5f13963f5f9aba93877e78d8ff601b', 1151496893, 'a:7:{s:14:"search_results";s:118:"2305, 2381, 2407, 2413, 2442, 2449, 2462, 2468, 2469, 2470, 2473, 2474, 2476, 2477, 2478, 2480, 2481, 2482, 2484, 2485";s:17:"total_match_count";i:20;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: Wed Jun 28, 2006 1:38 pm
by Andy Hamilton
not really sure what is happening there?

This new server is proving to be less than perfect, let me know if it continues. I am hoping it is just a hicup.

Posted: Wed Jun 28, 2006 8:46 pm
by alcina
Could be a caching problem M3. The SQL error implies that it already has an entry for the search you're making, well the search_id anyway! Try clearing your web browser's cache.

Alcina

Posted: Wed Jun 28, 2006 8:53 pm
by Martin
could be Andy's had a tinker, and left "debug mode" switched in! :?

Posted: Thu Jun 29, 2006 5:40 am
by Millymollymandy
It is OK this morning!

Posted: Fri Jul 28, 2006 3:12 pm
by hedgewizard
it's doing it again!
Could not obtain search results

DEBUG MODE

SQL Error : 1030 Got error 12 from table handler

Posted: Sat Jul 29, 2006 5:53 am
by Millymollymandy
I had that too a couple of days ago - it was only when trying to view posts since last visit!

Posted: Sat Jul 29, 2006 3:57 pm
by Andy Hamilton
I have hads this out with the hosting company. they are terrible it is a fault with them and not much we can do. I am looking into a dedicated hosting package. You might have also noticed an advertse here bit on the front page I am hoping that this will pay for it about £60 a month once - not sure if someone would pay for it but this is less than 1p per hit. when have that then we should stop having these problems, I did think that the last move would be ok, but alas they saw me coming.

Posted: Sun Jul 30, 2006 6:20 am
by Millymollymandy
It's not a problem Andy - if it happens once a month that's no big deal at all. The main thing is that the 'go-slow' I used to get regularly has gone - which is just as well, because there are so many posts these days it's hard enough to catch up even with fast speed!