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
 
View Profile mac11
 
  1  
Reply Fri 8 Jul, 2005 06:17 pm
I'm sure it makes sense to the hamsters.
0 Replies
 
View Profile jespah
 
  1  
Reply Fri 8 Jul, 2005 07:13 pm
Look, it's a SQL query!
0 Replies
 
  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
 
View Profile 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
 
View Profile MinDSaY
 
  1  
Reply Sat 9 Jul, 2005 04:14 pm
Can't believe I'm dumber than the box infront of me...
0 Replies
 
  1  
Reply Sat 9 Jul, 2005 06:02 pm
jes- Thanks for the explanation! Very Happy
0 Replies
 
View Profile 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
I'm the developer - Discussion by Nick Ashley
New A2K feature requests. - Discussion by DrewDad
The a2k world is changing 3: about voting - Discussion by Craven de Kere
New A2K annoyances - Discussion by sozobe
New A2K Bugs - Discussion by sozobe
A2K censors tags? - Discussion by hingehead
The a2k world is changing 4: STARTING TONIGHT - Discussion by Craven de Kere
Avatar - Discussion by snood
LOST & MISPLACED A2K people. - Discussion by msolga
New A2K Coolnesses - Discussion by sozobe
 
  1. able2know
  2. » Just Wanted to Give the Mods a "Heads Up"
Copyright © 2009 Horizontal Verticals :: Page generated in 0.34 seconds on 11/27/2009 at 08:10:51 Top End