1
   

Just Wanted to Give the Mods a "Heads Up"

 
 
Reply Fri 8 Jul, 2005 05:14 pm
Hey- Look what I got when I clicked on an A2K link:

Quote:
Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1217220250, 'ec6eb07823f473f6fe6c78f73e8f5daf', 'a:7:{s:14:"search_results";s:4008:"1722, 25, 1072, 90, 92, 261, 188, 198, 735, 206, 209, 1541, 216, 762, 233, 235, 267, 269, 294, 309, 312, 314, 763, 501, 368, 500, 406, 407, 409, 419, 444, 445, 457, 462, 479, 507, 547, 1886, 573, 583, 598, 636, 639, 641, 661, 1098, 680, 681, 691, 696, 706, 707, 711, 760, 761, 780, 1701, 879, 896, 900, 901, 919, 936, 1121, 947, 959, 962, 985, 1249, 1253, 1031, 1034, 1035, 1261, 1066, 1094, 13493, 1127, 1160, 1164, 1167, 1181, 1182, 1216, 1312, 1319, 1379, 1380, 1388, 1389, 1390, 1436, 1437, 1440, 1441, 1641, 1449, 1452, 1453, 1457, 1505, 1511, 1533, 1565, 1610, 1626, 1653, 1654, 1655, 1885, 1739, 1765, 1774, 1799, 1805, 1809, 1817, 1818, 1831, 1889, 1895, 2019, 1914, 1945, 1946, 1948, 1996, 2004, 2074, 2075, 2092, 2093, 2102, 2123, 2145, 2165, 2182, 2205, 2209, 2210, 2255, 2260, 2263, 2268, 2269, 2277, 2325, 2443, 2448, 2449, 2503, 2525, 2641, 2709, 2711, 2713, 2728, 2737, 2741, 2742, 2828, 2833, 2865, 2871, 2879, 2880, 2919, 2952, 2985, 3005, 3083, 3105, 3116, 3145, 3161, 3182, 9004, 3199, 3202, 3250, 3252, 3275, 3341, 3390, 3467, 3468, 3491, 3533, 3577, 3583, 3585, 3586, 3588, 3629, 3643, 3675, 3676, 3731, 3763, 3764, 3765, 3766, 3788, 3795, 3844, 3859, 3887, 3898, 3947, 3966, 3971, 4029, 4082, 4162, 4204, 4358, 4373, 4440, 4486, 4612, 14611, 4617, 4619, 4774, 4807, 4961, 4962, 4964, 5016, 5193, 5156, 5202, 5566, 5359, 5455, 5494, 5526, 5584, 5600, 5651, 5663, 5697, 5699, 5779, 5787, 5793, 5848, 5932, 5935, 5968, 5992, 6007, 6274, 6348, 6365, 6470, 6529, 6531, 6536, 6629, 6652, 6727, 6732, 6753, 6757, 6774, 6777, 6854, 6873, 6874, 6907, 6909, 6912, 6913, 6955, 6977, 6995, 7183, 7153, 7177, 7231, 7236, 7252, 8125, 7303, 7340, 7347, 7349, 7376, 7414, 7467, 7505, 7510, 7533, 7575, 7576, 7625, 7637, 7641, 7682, 19754, 7738, 7739, 7740, 7809, 7920, 7934, 7956, 8006, 8018, 8101, 8128, 8202, 8259, 8308, 8333, 8334, 8348, 8399, 8467, 8484, 8619, 8645, 8682, 8707, 8708, 8770, 8789, 8822, 8850, 8884, 8919, 8932, 9151, 8984, 9041, 9043, 9046, 9072, 9120, 9178, 9217, 9286, 9371, 9416, 9528, 9423, 9439, 9440, 9563, 9603, 9728, 9774, 10339, 10351, 10383, 10472, 10627, 10804, 12826, 12932, 13132, 13266, 13317, 13341, 13534, 13535, 13540, 13587, 13776, 13783, 13832, 13856, 13862, 13971, 14064, 14134, 14172, 14276, 14278, 14310, 14318, 14331, 14359, 14483, 14542, 14652, 14851, 15162, 15242, 15286, 15625, 15663, 15810, 15964, 16050, 16096, 16146, 16191, 16272, 16375, 16491, 16564, 16741, 16756, 16776, 16910, 17065, 17245, 17246, 17360, 17439, 17479, 17531, 17533, 17538, 17592, 17805, 18019, 18061, 18063, 18108, 18343, 18369, 18526, 18550, 18660, 18713, 18897, 18916, 18956, 18996, 19101, 19108, 19144, 19145, 19197, 19201, 19304, 19683, 19725, 19762, 19821, 19869, 19916, 20283, 20656, 21135, 21194, 23077, 21427, 21616, 21672, 21701, 21791, 21821, 21830, 22555, 22601, 22696, 22698, 22735, 22800, 23154, 23229, 23261, 23304, 23354, 23658, 23708, 23799, 23801, 24061, 24075, 24335, 24774, 24941, 25386, 25450, 25580, 25638, 25980, 25981, 26284, 26441, 26707, 26853, 26871, 27498, 27734, 27891, 27984, 27988, 41117, 28362, 28753, 28830, 29116, 29118, 29219, 29298, 29482, 29527, 30303, 30365, 30461, 30723, 30858, 31246, 31469, 31666, 31673, 31775, 32011, 32013, 32058, 32847, 32966, 33747, 33848, 34033, 34106, 34211, 34284, 35720, 35875, 35956, 36328, 36447, 36775, 36781, 37091, 37903, 38217, 38219, 38412, 38479, 38516, 38543, 38704, 38901, 38917, 38981, 39428, 39480, 39548, 39714, 39724, 40020, 40155, 40222, 40291, 40363, 40463, 40526, 40529, 40588, 40657, 40718, 40794, 40911, 41288, 41413, 41470, 41550, 41551, 41573, 41684, 41687, 41765, 41941, 41984, 42158, 42214, 42286, 42815, 42847, 43032, 43044, 43427, 43499, 44021, 44063, 44168, 44475, 44549, 44691, 44762, 44845, 45170, 45355, 45393, 45652, 46649, 46943, 47252, 47496, 47714, 47826, 47828, 48055, 48281, 48349, 48428, 48523, 48562, 48825, 48967, 49048, 49122, 49172, 49202, 49282, 49572, 49573, 49727, 49782, 49860, 49934, 50125, 50258, 50569, 50605, 51851, 51863, 52311, 54018, 54046, 54098, 54140, 54358, 54481";s:17:"total_match_count";i:632;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 : 750
File : search.php
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 961 • Replies: 7
No top replies

 
mac11
 
  1  
Reply Fri 8 Jul, 2005 06:17 pm
I'm sure it makes sense to the hamsters.
0 Replies
 
jespah
 
  1  
Reply Fri 8 Jul, 2005 07:13 pm
Look, it's a SQL query!
0 Replies
 
Phoenix32890
 
  1  
Reply Sat 9 Jul, 2005 07:11 am
jespah wrote:
Look, it's a SQL query!


O-kay. Now what in blazes is an SQL query?
0 Replies
 
jespah
 
  1  
Reply Sat 9 Jul, 2005 04:02 pm
SQL is a database language (a database is a bunch of tables that all are related somehow, such as a list of friends, a list of phone numbers and a list of states with their abbreviations. These 3 lists are the tables and you can link them together to make addresses for your friends). You query it in order to ask it either for results or to do something.

This query is looking to insert certain records into a particular table. The table is apparently called phpbb_search_results and the fields it's trying to insert into (a field is a box in the table, if we are looking at addresses, you might have one field for first name, one for surname, one for street, one for city, one for state, one for ZIP) are evidently search_id, session_id, search_array. The values it's trying to insert are most of what you posted. It seems to have failed at Line #750.
0 Replies
 
MinDSaY
 
  1  
Reply Sat 9 Jul, 2005 04:14 pm
Can't believe I'm dumber than the box infront of me...
0 Replies
 
Phoenix32890
 
  1  
Reply Sat 9 Jul, 2005 06:02 pm
jes- Thanks for the explanation! Very Happy
0 Replies
 
jespah
 
  1  
Reply Sun 10 Jul, 2005 11:01 am
Hey, no prob, I guess my SQL classes paid off. Smile
0 Replies
 
 

Related Topics

How to use the new able2know - Discussion by Craven de Kere
New A2K feature requests. - Discussion by DrewDad
I'm the developer - Discussion by Nick Ashley
JIM NABORS WAS GOY? - Question by farmerman
A2K censors tags? - Discussion by hingehead
New A2K Bugs - Discussion by sozobe
New A2K annoyances - Discussion by sozobe
The a2k world is changing 3: about voting - Discussion by Craven de Kere
LOST & MISPLACED A2K people. - Discussion by msolga
Welcome to the 'New' My Posts - Discussion by Nick Ashley
The "I get folksonomy" club - Discussion by Robert Gentel
 
  1. Forums
  2. » Just Wanted to Give the Mods a "Heads Up"
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/18/2024 at 06:48:13