NationStates Jolt Archive


General Error: Could not insert search results

Henleaze Avenue
02-12-2003, 22:33
Tried to do a 'View your own posts' search, and it came up with this...

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(730263281, 'd03e7595f02c7a236dae56cc2d4b337a', 'a:7:{s:14:"search_results";s:425:"74382, 82726, 88484, 89781, 90871, 91203, 91680, 91754, 92514, 92534, 92581, 93298, 93586, 93624, 93675, 93957, 93975, 93977, 94571, 94621, 94824, 94828, 95098, 95268, 95326, 95355, 95357, 95460, 95586, 95611, 95656, 95672, 96044, 96295, 96427, 96463, 96735, 97003, 97020, 97132, 97315, 97371, 97561, 97866, 97918, 97983, 97985, 98002, 98032, 98033, 98092, 98348, 98350, 99086, 99246, 99266, 99408, 99483, 99533, 99566, 99585";s:17:"total_match_count";i:61;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 : 598
File : /home/nation/public_html/forum/search.php

...which naturally was somewhat worrying. I'm using Internet Explorer 6 with Windows 98, ISP is BT. Only happened once, so unsure if this is a bug or just the server being inventively cruel.
Goobergunchia
02-12-2003, 22:36
Works for me.... (http://www.nationstates.net/forum/search.php?search_author=Henleaze+Avenue)
Henleaze Avenue
02-12-2003, 23:10
Only happened once

Hasn't happened before or since... most likely not a bug, but just wanted to make sure.
Phoebos
03-12-2003, 00:10
This happens occasionally, and tends to fix itself.
Phoebos
03-12-2003, 00:10
This happens occasionally, and tends to fix itself.
SalusaSecondus
03-12-2003, 03:56
Phoebos is correct. Hmm, this should probably get added to the Tech FAQ.

http://www.weirdozone.0catch.com/projects/nationstates/salusasecondus/salusasecondus2.jpg
SalusaSecondus
Tech Modling
PGP: 0x0604DF3E