| |
Could not obtain search results
DEBUG MODE
SQL Error : 1038 Out of sort memory, consider increasing server sort buffer size
SELECT t.* , pt.post_text, pt2.post_text as last_post_text, f.forum_id, f.forum_name, f.forum_color, f.forum_moderate, u.username, u.user_id, u.user_level, u.user_jr, u2.username as user2, u2.user_id as id2, u2.user_level as user_level2, u2.user_jr as user_jr2, p.post_username, p2.post_username AS post_username2, p2.post_time, ph.post_id as post_helped, p.post_approve, p2.post_approve as post_approve2
FROM (phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 , phpbb_posts_text pt, phpbb_posts_text pt2)
LEFT JOIN phpbb_posts ph ON (t.topic_id = ph.topic_id AND ph.post_marked = 'y')
WHERE t.topic_id IN (181, 4721, 7120, 10016, 18526, 13, 12, 5250, 4424, 15668, 19244, 19258, 19266, 19275, 19346, 19347, 19401, 19402, 19483, 19513, 17524, 25, 19322, 26, 27, 33, 203, 575, 576, 577, 578, 580, 581, 582, 583, 1745, 1747, 3174, 4275, 4955, 6002, 6170, 7420, 7599, 8207, 10484, 19325, 19516, 1463, 18560, 18740, 18541, 18566, 18728, 18556, 18544, 18543, 18579, 18581, 18584, 18586, 18588, 18589, 18590, 18591, 18593, 18594, 18595, 18596, 18599, 18600, 18601, 18602, 18606, 18607, 18608, 18631, 18632, 18630, 18629, 18633, 18680, 18657, 18658, 18679, 18681, 18691, 18757, 18758, 18759, 18762, 18782, 18789, 18811, 18822, 18836, 18837, 18865, 18919, 18920, 18929, 18991, 19043, 19035, 19036, 19039, 19041, 19042, 19044, 19047, 19048, 19049, 19136, 19137, 19138, 19139, 19140, 19141, 19145, 19148, 19149, 19150, 19151, 19152, 19153, 19159, 19160, 19161, 19163, 19164, 19165, 19166, 19167, 19168, 19169, 19170, 19172, 19173, 19175, 19176, 19177, 19178, 19180, 19181, 19182, 19195, 19203, 19206, 19210, 19217, 19218, 19270, 19301, 19292, 19293, 19294, 19299, 19300, 19303, 19311, 19312, 19313, 19315, 19317, 19319, 19320, 19326, 19497, 19500, 19506, 19520, 19521, 19522, 18, 23, 10469, 19, 793, 21, 30, 5249, 384, 2931, 5246, 5247, 3110, 616, 1120, 18552, 18553, 18554, 19188, 19200, 19221, 19289, 19342, 19343, 19344, 19345, 94, 115, 163, 190, 3290, 3291, 3935, 4085, 4266, 4316, 5039, 5210, 5330, 6397, 7832, 7846, 8038, 8405, 8743, 8867, 9418, 9447, 9542, 10127, 10128, 10319, 10421, 11166, 11495, 11563, 11565, 11671, 11822, 11865, 12424, 12512, 12638, 12815, 13186, 13201, 13344, 13552, 13594, 13725, 13845, 13909, 13996, 14212, 14268, 14335, 14368, 14469, 14506, 14582, 14611, 14729, 14732, 14740, 14825, 14895, 14979, 15057, 15223, 15340, 15425, 15458, 15646, 15667, 15694, 15954, 16062, 16090, 16094, 16147, 16171, 16185, 16229, 16470, 16514, 16628, 16838, 16981, 16986, 17240, 17358, 17651, 17781, 17811, 18572, 17877, 17879, 17882, 17947, 18015, 18091, 18140, 18211, 18352, 18578, 18761, 3397, 4600, 5260, 5278, 6007, 8936, 9248, 9369, 13568, 15947, 16822, 17226, 219, 10135, 11249, 2151, 1695, 2914, 2923, 2958, 4462, 4630, 5158, 5363, 5509, 5795, 6969, 7314, 7562, 7622, 7667, 7722, 7816, 7933, 8075, 9657, 9813, 10094, 10181, 10487, 10643, 10667, 10772, 11438, 12154, 13316, 13776, 13793, 13800, 14758, 14943, 15215, 15802, 15929, 15990, 16122, 16131, 16190, 16250, 16387, 16463, 16464, 16465, 16967, 16974, 17687, 17697, 17745, 17747, 17784, 18111, 18113, 18362, 18415, 18446, 204, 3643, 19192, 19205, 19227, 19265, 37, 61, 538, 592, 613, 614, 661, 700, 739, 1350, 1431, 1458, 1543, 1649, 1739, 1794, 1822, 1841, 1919, 1923, 1977, 1982, 2025, 2108, 2149, 2156, 2266, 2278, 2295, 2540, 2578, 2669, 2804, 2827, 2987, 3051, 3070, 3083, 3159, 3189, 3253, 3282, 3520, 3629, 3649, 3760, 3902, 4074, 4089, 4184, 4247, 4296, 4483, 4509, 4523, 4581, 4606, 4620, 4631, 4704, 4741, 4768, 4868, 5000, 5010, 5023, 5215, 5253, 5310, 5315, 5512, 5534, 5551, 5572, 5759, 5852, 5958, 5964, 5979, 5988, 5993, 6032, 6050, 6064, 6071, 6253, 6260, 6315, 6359, 6460, 6597, 6685, 6829, 6890, 6898, 7024, 7206, 7207, 7227, 7262, 7299, 7360, 7581, 7734, 7745, 7766, 7781, 7806, 7906, 8021, 8039, 8064, 8076, 8197, 8242, 8319, 8346, 8352, 8370, 8435, 8459, 8466, 8500, 8517, 8552, 8596, 8748, 8749, 8826, 8873, 8992, 9024, 9036, 9054, 9079, 9085, 9120, 9125, 9177, 9225, 9274, 9276, 9279, 9281, 9345, 9354, 9360, 9362, 9398, 9461, 9476, 9487, 9492, 9493, 9662, 9741, 9883, 9914, 10034, 10044, 10111, 10189, 10305, 10346, 10360, 10369, 10419, 10420, 10437, 10898, 11005, 11063, 11100, 11117, 11318, 11365, 11602, 11824, 11932, 11946, 12048, 12163, 12245, 12272, 12282, 12590, 12697, 12723, 12752, 12759, 12805, 12835, 12844, 13056, 13262, 13467, 13528, 13586, 13628, 13777, 13780, 13931, 13935, 13937, 13958, 14025, 14099, 14260, 14270, 14899, 15005, 15019, 15036, 15065, 15074, 15274, 15365, 15398, 15439, 15443, 15452, 15467, 15491, 15536, 15539, 15545, 15559, 15567, 15580, 15583, 15589, 15594, 15674, 15783, 15787, 15849, 15850, 15868, 15913, 15927, 16047, 16059, 16128, 16226, 16264, 16308, 16320, 16363, 16366, 16402, 16388, 16445, 16449, 16460, 16528, 16541, 16544, 16548, 16604, 16721, 17182, 22, 24, 41, 200, 296, 298, 299, 388, 390, 391, 392, 393, 394, 395, 396, 397, 399, 400, 401, 404, 405, 406, 407, 408, 409, 410, 411, 491, 493, 703, 710, 1044, 1578, 1583, 2727, 2786, 3315, 3344, 3526, 3585, 3605, 3728, 4132, 4253, 4351, 4787, 4829, 4859, 4893, 5052, 5129, 5281, 5401, 6377, 6378, 6519, 6526, 6531, 6532, 6534, 6535, 6539, 6540, 6541, 6548, 6555, 6562, 6601, 6565, 6566, 6571, 6572, 6576, 6586, 6589, 6591, 6592, 6602, 6606, 6607, 6608, 6609, 6610, 6614, 6615, 6621, 6630, 6679, 6696, 6697, 6703, 6707, 6719, 6785, 6818, 6822, 6845, 6892, 6893, 6899, 6906, 6907, 6925, 6930, 6933, 6943, 6983, 7136, 7164, 7166, 7243, 7276, 7324, 7333, 7339, 7340, 7351, 7358, 7359, 7362, 7363, 7364, 7365, 7367, 7368, 7369, 7372, 7413, 7404, 7428, 7445, 7455, 7456, 7458, 7463, 7464, 7466, 7478, 7493, 7503, 7542, 7554, 7585, 7586, 7588, 7589, 7609, 7620, 7643, 7650, 7663, 7712, 7716, 7718, 7719, 7746, 7765, 7776, 7779, 7802, 7877, 7883, 7904, 7913, 7920, 7935, 7939, 7940, 7941, 7947, 7989, 8015, 8026, 8027, 8060, 8078, 8088, 8096, 8109, 8127, 8113, 8128, 8142, 8144, 8152, 8156, 8164, 8165, 8172, 8173, 8175, 8178, 8185, 8202, 8217, 8221, 8232, 8233, 8234, 8266, 8268, 8275, 8291, 8292, 8376, 8378, 8379, 8451, 8470, 8474, 8477, 8492, 8523, 8525, 8527, 8528, 8533, 8534, 8547, 8548, 8628, 8633, 8661, 8663, 8680, 8681, 8715, 8733, 8753, 8772, 8775, 8784, 8824, 8924, 8928, 8941, 8944, 8945, 8946, 8948, 8950, 8961, 8963, 8964, 8965, 8966, 8974, 8987, 8996, 8999, 9009, 9027, 9064, 9092, 9098, 9099, 9101, 9112, 9113, 9115, 9128, 9157, 9185, 9193, 9194, 9203, 9256, 9285, 9290, 9291, 9331, 9337, 9338, 9365, 9372, 9377, 9381, 9382, 9388, 9405, 9419, 9449, 9452, 9500, 9507, 9566, 9567, 9573, 9592, 9614, 9616, 9620, 9627, 9631, 9632, 9640, 9645, 9650, 9791, 9956, 9957, 9958, 10188, 10237, 10248, 10288, 10692, 11791, 11873, 12227, 12505, 12557, 12566, 12700, 12843, 12847, 12894, 12903, 13013, 13831, 15003, 15166, 15222, 15235, 15246, 15273, 15315, 15334, 15411, 15433, 15770, 16174, 16245, 16462, 16710, 16770, 16821, 16824, 16937, 17025, 17059, 17080, 17110, 17134, 17168, 17169, 17224, 17231, 17234, 17248, 17250, 17251, 17252, 17302, 17328, 17365, 17379, 17467, 17468, 17499, 17500, 17505, 17506, 17516, 17519, 17520, 17535, 17540, 17541, 17543, 17546, 17549, 17550, 17553, 17575, 17602, 17616, 17630, 17638, 17642, 17657, 17671, 17690, 17693, 17699, 17700, 17701, 17705, 17706, 17718, 17723, 17725, 17728, 17729, 17732, 17735, 17736, 17741, 17742, 17867, 17869, 17871, 17872, 17874, 17917, 17949, 17957, 17962, 17973, 17980, 17987, 17991, 18021, 18022, 18035, 18038, 18054, 18064, 18069, 18070, 18141, 18147, 18153, 18158, 18449, 18585, 18597, 18598, 18613, 18682, 18724, 18725, 19146, 19144, 19171, 2826, 3072, 8993, 9000, 1552, 4798, 5076, 5856, 6817, 17256, 258, 1205, 5606, 10649, 10866, 257, 16908, 7951, 7950, 8970, 5248, 1656, 1756, 1968, 3195, 3673, 5095, 5240, 8124, 9080, 9608, 16234, 2930, 6852, 7860, 8685, 8919, 10114, 12747, 12851, 13955, 14556, 14760, 16249, 18334, 5243, 5242, 1855, 2005, 2717, 4516, 4653, 5168, 6259, 9633, 10780, 11477, 12101, 12251, 12538, 12581, 12724, 13924, 16181, 16247, 16360, 17102, 18513, 8726, 647, 2247, 3927, 17557, 17558, 17821, 9245, 15113, 9744, 17237, 3197, 5241, 6369, 16288, 16641, 17188, 2932, 6410, 16187, 16271, 17008, 17149, 18044, 18058, 5244, 2939, 2964, 3066, 5245, 9562, 9574, 9812, 10396, 16039, 16046, 3220, 4318, 4390, 5618, 5980, 6403, 7297, 7645, 8122, 8251, 10097, 11109, 19179, 19183, 19189, 19190, 19193, 19196, 19197, 19201, 19202, 19204, 19207, 19209, 19211, 19212, 19213, 19215, 19216, 19219, 19220, 19222, 19223, 19224, 19225, 19228, 19229, 19230, 19231, 19232, 19233, 19235, 19236, 19237, 19238, 19240, 19241, 19242, 19243, 19245, 19246, 19247, 19248, 19249, 19251, 19252, 19253, 19254, 19256, 19257, 19259, 19260, 19261, 19262, 19263, 19264, 19267, 19271, 19273, 19274, 19278, 19279, 19280, 19281, 19284, 19285, 19288, 19290, 19291, 19296, 19298, 19302, 19304, 19308, 19309, 19310, 19314, 19318, 19321, 19324, 19327, 19329, 19330, 19331, 19332, 19333, 19335, 19336, 19337, 19338, 19339, 19340, 19348, 19349, 19350, 19351, 19352, 19353, 19354, 19355, 19356, 19359, 19360, 19361, 19362, 19363, 19365, 19368, 19369, 19372, 19373, 19374, 19377, 19378, 19380, 19382, 19383, 19384, 19387, 19389, 19390, 19394, 19395, 19396, 19398, 19400, 19404, 19405, 19407, 19408, 19409, 19410, 19411, 19412, 19413, 19414, 19415, 19416, 19417, 19418, 19419, 19420, 19423, 19424, 19425, 19426, 19427, 19428, 19430, 19431, 19432, 19434, 19435, 19437, 19438, 19439, 19440, 19441, 19442, 19443, 19445, 19446, 19448, 19450, 19451, 19452, 19453, 19456, 19457, 19458, 19459, 19460, 19461, 19462, 19463, 19464, 19465, 19466, 19467, 19468, 19469, 19470, 19472, 19473, 19474, 19476, 19477, 19479, 19480, 19481, 19484, 19485, 19486, 19487, 19488, 19489, 19490, 19491, 19492, 19493, 19494, 19495, 19496, 19498, 19499, 19501, 19502, 19503, 19504, 19505, 19507, 19508, 19509, 19510, 19511, 19512, 19514, 19515, 19517, 19518, 19519, 19523, 3499, 5999, 6076, 6424, 9496, 16026, 16677, 17036, 19323, 15572, 5061, 10205, 4068, 4071, 4112, 5049, 5394, 5929, 5978, 6775, 6915, 6916, 6917, 8041, 6918, 6970, 6998, 11390, 16089, 5005, 11316, 19038, 19198, 3929, 4034, 4117, 4520, 4853, 5040, 5723, 6913, 7474, 8710, 11310, 11314, 11320, 12126, 17282, 17289, 17290, 3993, 6204, 6018, 6019, 6020, 6021, 6022, 7043, 6163, 7209, 17820, 14387, 14583, 9687, 11293, 12333, 14754, 15833, 8344, 8556, 8816, 9148, 9498, 10258, 10329, 10316, 17560, 17561, 17628)
AND t.topic_poster = u.user_id
AND f.forum_id = t.forum_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND pt.post_id = t.topic_first_post_id AND pt2.post_id = t.topic_last_post_id
AND f.password = ''
GROUP by t.topic_id ORDER BY p2.post_time DESC LIMIT 0, 35
Line : 835
File : search.php
Jeśli nie potrafisz znaleźć rozwiązania tego problemu,
możesz spróbować poszukać, lub zadać pytanie na forum: http://www.przemo.org/phpBB2/ |
| |
|
