|
Could not obtain search results
DEBUG MODE
SQL Error : 1055 Expression #39 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'amerykany.ph.post_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT t.* , 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 (topics t, forums f, users u, posts p, posts p2, users u2 )
LEFT JOIN posts ph ON (t.topic_id = ph.topic_id AND ph.post_marked = 'y')
WHERE t.topic_id IN (955, 4669, 4655, 4670, 10, 25, 45, 182, 250, 207, 496, 516, 712, 1238, 975, 1205, 1359, 1211, 1218, 1315, 1609, 1580, 2625, 2469, 2850, 2912, 2956, 2838, 2839, 1909, 2449, 2495, 3118, 2962, 3001, 3230, 3344, 3545, 4285, 4360, 4578, 4559, 186, 401, 399, 239, 249, 378, 728, 818, 1317, 1113, 1200, 1212, 1214, 1355, 1769, 2413, 2598, 3380, 3997, 3896, 4000, 3808, 3836, 3978, 3980, 4029, 4050, 4112, 4086, 4094, 4153, 4170, 4174, 4206, 4232, 4270, 4275, 4349, 4359, 4408, 4526, 4502, 4564, 9, 41, 67, 126, 136, 149, 162, 187, 276, 390, 453, 500, 512, 657, 881, 1138, 1530, 1243, 1434, 1413, 1930, 1802, 1815, 1833, 1835, 2002, 1929, 1914, 2330, 1952, 2711, 2727, 2793, 2792, 1765, 1774, 2009, 3536, 4586, 17, 115, 40, 61, 63, 64, 71, 83, 84, 85, 86, 99, 110, 113, 114, 116, 117, 121, 127, 131, 138, 151, 153, 157, 228, 244, 317, 360, 558, 536, 530, 562, 488, 510, 519, 595, 569, 577, 578, 750, 597, 616, 782, 638, 655, 662, 722, 719, 893, 791, 806, 808, 811, 814, 913, 921, 1081, 1106, 1117, 1163, 1847, 1848, 1734, 1862, 2602, 1534, 1710, 1842, 1962, 2287, 2391, 2571, 2596, 2885, 3097, 2980, 3107, 3334, 3392, 3844, 3988, 3826, 3853, 4134, 4368, 12, 42, 43, 44, 49, 50, 51, 54, 60, 66, 77, 87, 128, 130, 135, 150, 163, 204, 274, 457, 331, 345, 542, 552, 538, 413, 446, 509, 559, 774, 596, 711, 746, 1751, 999, 1004, 1023, 1246, 1313, 1352, 1807, 1844, 2562, 2087, 2163, 2748, 2524, 2523, 2397, 2439, 2561, 2443, 2452, 2463, 2651, 2505, 2509, 2622, 2670, 2653, 2547, 2560, 2665, 2582, 2593, 2605, 2611, 2692, 2632, 2666, 2667, 2671, 2696, 2733, 2700, 2720, 2736, 2738, 2739, 2740, 2742, 2757, 2764, 2796, 2844, 2847, 2864, 2168, 2211, 2568, 2970, 2994, 3003, 3335, 3048, 3049, 3050, 3125, 3074, 3457, 3120, 3220, 3187, 3188, 3197, 3204, 3336, 3436, 3525, 3483, 3658, 3499, 3604, 3537, 3674, 3874, 3697, 4057, 3827, 4021, 4194, 4022, 4020, 4051, 4120, 4069, 4181, 4180, 4157, 4175, 4184, 4196, 4212, 4220, 4227, 4327, 4246, 4289, 4302, 4303, 4308, 4392, 4320, 4352, 4354, 4361, 4364, 4365, 4609, 69, 553, 764, 822, 1107, 1118, 1698, 2474, 2487, 2836, 2928, 3002, 3072, 3460, 3647, 3891, 4009, 4226, 4321, 947, 2931, 4316, 4339, 4596, 1502, 2395, 2649, 279, 280, 281, 282, 283, 284, 285, 286, 287, 289, 290, 291, 292, 297, 301, 303, 305, 306, 308, 388, 418, 980, 981, 1127, 1167, 1176, 1216, 1220, 1289, 1305, 1512, 1731, 1776, 1822, 1941, 2475, 3653, 3694, 3870, 4030, 4200, 4204, 4523, 4312, 4384, 4379, 4377, 4577, 4416, 4420, 4435, 4475, 4541, 4557, 4579, 125, 400, 695, 797, 583, 594, 835, 879, 969, 1206, 2800, 1321, 1718, 3168, 3272, 3672, 3955, 987, 1150, 1855, 1703, 948, 996, 3402, 3528, 4304, 4028, 3995, 3977, 4208, 4268, 4552, 2431, 2824, 3138, 3582, 4173, 4311, 4383, 4343, 4363, 4370, 4397, 4492, 4403, 4498, 4487, 4516, 4540, 4640, 4547, 4565, 4590, 4641, 389, 3057, 3412, 3354, 3983, 3889, 3512, 3562, 3989, 3986, 3984, 3861, 4010, 4032, 4209, 4280, 4668, 4671)
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 f.password = ''
GROUP by t.topic_id ORDER BY p2.post_time DESC LIMIT 0, 25
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/ |
|
|