Search Not Completing Successfully

MPastor

Board Regular
Joined
Apr 8, 2004
Messages
136
I just joined your forum today...looks like a great resource. For some strange reason, most of my searches fail to provide any results and actually end with a GENERAL ERROR. I've pasted the beginning of one such Error resonse below.

I hope you can help me...
...Mike



General Error

Could not insert search results

DEBUG MODE

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

INSERT INTO search_results (search_id, session_id, search_array) VALUES(822350116, 'e7f1cd784790cae82588c2249cac077f', 'a:7:{s:14:"search_results";s:13699:"78, 96, 112, 268, 598, 676, 694, 709, 792, 855, 891, 893, 947, 1134, 1136, 1225, 1226, 1231, 1233, 1299, 1320, 1336, 1342, 1465, 1577, 1584, 1617, 1627, 1684, 1808, 1873, 1886, 1905, 1921, 1930, 1937, 2215, 2220, 2427, 2430, 2436, 2675, 2761, 2816, 2837, 2854, 2886, 2926, 2942, 2961, 2971, 3081, 3103, 3113, 3131, 3139, 3150, 3214, 3227, 3244, 3367, 3371, 3390, 3396, 3448, 3549, 3561, 3621, 3625, 3719, 3743, 3770, 3812, 3865, 3867, 3888, 3906, 3938, 3943, 3944, 3949, 3951, 3993, 4004, 4018, 4074, 4104, 4269, 4436, 4446, 4529, 4541, 4640, 4704, 4737, 4834, 4987, 5020, 5032, 5128, 5188, 5211, 5256, 5261, 5299, 5369, 5376, 5431, 5486, 5513, 5677, 5711, 5810, 5815, 5836, 5908, 5927, 5966, 5975, 6002, 6037, 6090, 6091, 6112, 6130, 6167, 6232, 6234, 6256, 6313, 6325, 6414, 6422, 6451, 6542, 6547, 6586, 6712, 6807, 6811, 6824, 6835, 6854, 6861, 6879, 6881, 6906, 6909, 6925, 6947, 6965, 7020, 7027, 7066, 7145, 7221, 7254, 7294, 7320, 7321, 7328, 7348, 7398, 7428, 7459, 7471, 7512, 7575, 7604, 7630, 7641, 7718, 7782, 7814, 7818, 7863, 7864, 7892, 8031, 8056, 8145, 8238, 8290, 8317, 8348, 8417, 8429, 8431, 8436, 8510, 8683, 8722, 8795, 8852, 8955, 8960, 8963, 9096, 9103, 9115, 9132, 9152, 9161, 9180, 9219, 9229, 9233, 9269, 9288, 9348, 9416, 9465, 9480, 9498, 9505, 9514, 9552, 9578, 9580, 9612, 9649, 9770, 9781, 9866, 9887, 9894, 9910, 9940, 10050, 10075, 10083, 10094, 10099 .....THERE'S LOT'S MORE, This is just a sample of what I get.
 
Heya Mike!

You're not being ignored, but I'm reporting your post to the more than capable moderators to see if they can figger it out.

Smitty
 
Did not feel ignored. Thanks for focusing on getting it to the right person/area.

Don't know if this was a temporary glitch on the server, if it was due to a situation on my browser client.

Regardless....It's working fine now!!!! (y)
 
I think (assume) it was a temp glitch, something like too many people trying to do a search at the same time, which filled up the search results table.

Glad to see its working ok now !
 

Forum statistics

Threads
1,221,674
Messages
6,161,215
Members
451,691
Latest member
fjaimes042510

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top