|
Could not obtain search results
DEBUG MODE
SQL Error : 1055 Expression #38 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'htsz_forum.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, p.post_lp, p2.post_lp as post_lp2
FROM (phpbb2_topics t, phpbb2_forums f, phpbb2_users u, phpbb2_posts p, phpbb2_posts p2, phpbb2_users u2 )
LEFT JOIN phpbb2_posts ph ON (t.topic_id = ph.topic_id AND ph.post_marked = 'y')
WHERE t.topic_id IN (2007, 3487, 5353, 6100, 6464, 942, 1435, 2565, 3554, 2320, 2321, 9178, 21, 340, 589, 686, 905, 999, 1108, 1124, 1409, 1639, 1963, 2290, 2702, 3119, 3463, 3560, 3649, 3650, 3876, 3981, 4091, 4199, 4240, 5591, 6181, 6204, 6580, 6667, 6692, 6747, 6768, 6816, 6917, 7960, 8551, 726, 847, 1577, 1682, 1752, 2148, 3592, 3595, 5888, 6235, 6268, 6499, 6510, 6536, 6636, 7048, 8101, 8167, 8389, 9461, 10297, 582, 735, 756, 770, 790, 884, 948, 1043, 1069, 1070, 1270, 1277, 1441, 1482, 1566, 1592, 1748, 1749, 1781, 1816, 1831, 1916, 2157, 2726, 2682, 3334, 4387, 5459, 6847, 7344, 10502, 10818, 208, 1066, 1067, 1068, 1381, 1641, 1860, 1947, 2073, 2152, 2278, 2651, 2938, 3014, 3326, 3525, 4826, 4952, 5052, 5734, 5837, 7837, 27, 158, 257, 388, 502, 689, 805, 1640, 2000, 2008, 3443, 3511, 3641, 4064, 4126, 4139, 4182, 4254, 8414, 10766, 364, 584, 643, 664, 766, 1014, 925, 926, 928, 929, 933, 934, 1010, 1421, 1453, 1593, 1744, 2020, 2889, 3105, 3549, 3606, 6514, 6691, 6769, 7402, 9012, 9470, 546, 650, 1509, 2038, 2303, 2818, 4622, 7263, 622, 1301, 2159, 2218, 3248, 3846, 5623, 6040, 6844, 8180, 696, 850, 1060, 1402, 2693, 4291, 6448, 7181, 3298, 3985, 9846, 9887, 9985, 3750, 4263, 5237, 5431, 5824, 6637, 7147, 7907, 8175, 8299, 10292, 5542, 6542, 8730, 9009, 1063, 3237, 2123, 3643, 943, 1024, 1225, 2003, 2116, 4109, 4520, 9929, 3587, 4815, 5551, 10924, 11305, 2259, 2266, 2270, 2312, 5231, 5446, 5450, 3577, 3662, 4131, 508, 543, 544, 713, 953, 1276, 1492, 1864, 1876, 2025, 3190, 4015, 5560, 5654, 7022, 4384, 5995, 7019, 7171, 9321, 10158, 10686, 3967, 7352, 8332, 9019, 5058, 5333, 5997, 7623, 11379, 11576, 11577, 3084, 3926, 4397, 4598, 4776, 4838, 4846, 5265, 6469, 2840, 3147, 3351, 3896, 5732, 8044, 8053, 8259, 8369, 9493, 9658, 9725, 9906, 10112, 10194, 10262, 10473, 10618)
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, 20
Line : 828 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/ |
|
|