| |
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 'lesio.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 (phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 )
LEFT JOIN phpbb_posts ph ON (t.topic_id = ph.topic_id AND ph.post_marked = 'y')
WHERE t.topic_id IN (683, 1107, 1108, 1219, 160, 117, 143, 157, 177, 194, 220, 245, 263, 268, 455, 587, 786, 906, 1174, 1240, 1252, 1254, 1255, 1681, 1795, 1789, 1800, 1801, 1847, 1963, 1904, 2149, 2206, 2255, 2231, 2304, 2309, 2564, 2796, 2832, 499, 1627, 1732, 1752, 1753, 1754, 168, 407, 431, 506, 693, 1199, 1667, 2287, 2512, 2592, 2758, 2783, 80, 373, 425, 863, 1227, 111, 113, 115, 464, 543, 547, 69, 140, 313, 274, 279, 340, 342, 343, 344, 350, 362, 376, 444, 511, 1020, 1021, 1662, 2034, 2043, 2162, 2059, 2028, 2090, 2126, 2370, 2526, 2530, 2700, 2771, 30, 109, 232, 233, 248, 249, 269, 409, 410, 411, 458, 484, 507, 582, 690, 927, 1125, 1138, 1278, 1666, 1802, 2065, 2423, 170, 172, 173, 218, 280, 288, 310, 321, 324, 337, 338, 370, 403, 405, 485, 422, 487, 488, 503, 548, 549, 592, 1843, 978, 981, 1102, 1142, 1164, 1188, 1401, 2026, 2012, 2171, 2195, 2417, 192, 334, 413, 436, 526, 594, 1835, 1940, 1953, 2209, 2212, 2352, 2371, 2373, 2854, 38, 40, 56, 59, 76, 103, 104, 121, 126, 130, 149, 166, 188, 235, 264, 318, 354, 501, 505, 522, 563, 1131, 1141, 1176, 1668, 1669, 1671, 1825, 1820, 1908, 2173, 2048, 1949, 1990, 2194, 2294, 2568, 2563, 2813, 2818, 2021, 15, 16, 20, 22, 23, 24, 25, 53, 1171, 71, 84, 93, 94, 96, 97, 99, 120, 133, 136, 155, 156, 159, 162, 185, 189, 196, 199, 211, 2268, 228, 230, 231, 243, 304, 259, 265, 271, 272, 273, 325, 335, 339, 466, 495, 523, 568, 694, 884, 1015, 1017, 1139, 1248, 1198, 1719, 1221, 1237, 2109, 1808, 1991, 1997, 2178, 2122, 2184, 2154, 2267, 2436, 2435, 386, 385, 380, 381, 388, 740, 741, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 1019, 1040, 1432, 65, 68, 73, 74, 91, 207, 470, 1260, 2166, 2172, 387, 739, 742, 748, 807, 1373, 1374, 1375, 1376, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 722, 610, 620, 665, 698, 699, 723, 767, 768, 771, 772, 773, 774, 775, 776, 942, 923, 924, 932, 933, 936, 937, 939, 943, 944, 946, 947, 949, 950, 951, 1025, 1026, 1037, 1038, 1039, 1041, 1157, 1530, 1566, 1594, 1596, 1597, 1598, 1599, 1602, 1604, 1605, 1606, 1607, 1608, 1629, 1630, 1733, 1735, 1736, 1745, 1746, 1747, 1748, 1749, 1750, 1751, 2123, 1896, 2363, 2542, 2544, 285, 489, 1166, 1130, 1016, 1027, 1122, 1124, 1168, 1192, 1160, 1167, 1172, 1173, 1181, 1189, 1190, 1191, 1193, 1196, 1197, 1202, 1203, 1204, 1216, 1217, 1222, 1236, 1251, 2220, 1400, 1402, 2070, 2040, 2027, 2058, 2045, 2044, 2055, 2054, 2111, 2221, 2112, 2114, 2115, 2116, 2117, 2219, 2205, 2258, 2256, 2237, 2259, 2284, 2285, 2286, 2321, 2493, 2494, 2495, 2497, 2498, 2499, 2500, 2506, 2507, 2508, 2509, 2510, 2511, 182, 183, 260, 1995, 673, 646, 647, 648, 674, 675, 676, 677, 678, 679, 688, 864, 881, 882, 885, 886, 928, 1009, 1456, 1624, 1625, 1626, 1741, 1742, 1791, 1895, 2535, 1184, 1312, 1313, 1314, 1555, 2201, 2591, 605, 717, 1218, 622, 468, 790, 1201, 1845, 2486, 2733, 2685, 2736, 2787, 716, 585, 251, 254, 284, 395, 437, 438, 439, 497, 515, 519, 559, 560, 571, 574, 583, 692, 788, 1011, 1195, 1302, 2227, 2382, 2735, 2777, 255, 107, 576, 2460, 32, 564, 573, 1613, 397, 2062, 593, 186, 567, 793, 2607, 2643, 531, 534, 1080, 1081, 1082, 1214, 1215, 535, 537, 1241, 532, 533, 540, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 2190, 530, 536, 539, 542, 1674, 718, 719, 720, 721, 19, 21, 14, 63, 70, 81, 90, 101, 122, 123, 178, 216, 227, 301, 461, 473, 590, 521, 1612, 2846, 645, 996, 997, 999, 504, 1568, 596, 597, 600, 602, 603, 606, 607, 608, 611, 612, 614, 615, 616, 618, 619, 624, 631, 635, 636, 637, 638, 639, 641, 642, 643, 644, 652, 653, 654, 656, 657, 658, 660, 806, 895, 909, 952, 955, 956, 957, 959, 960, 961, 962, 963, 964, 965, 967, 968, 969, 970, 1018, 1684, 1426, 1427, 1428, 1430, 1431, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1484, 1485, 1486, 1487, 1488, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527, 1534, 1535, 1536, 1575, 1611, 1618, 1619, 1620, 1621, 1623, 1631, 1639, 1640, 1641, 1654, 1685, 1763, 1764, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1780, 1781, 1784, 2067, 2536, 2537, 2538, 2545, 2540, 2541, 2543, 2778, 374, 680, 681, 682, 709, 743, 825, 826, 827, 828, 848, 849, 850, 851, 852, 853, 854, 883, 805, 1183, 879, 907, 684, 685, 686, 687, 998, 1134, 1135, 705, 706, 707, 708, 746, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 1537, 725, 781, 782, 787, 1253, 714, 715, 1031, 1032, 1033, 1034, 1035, 1036, 1077, 1289, 1290, 1291, 1293, 1299, 1300, 1301, 1303, 1304, 1305, 1306, 1307, 1341, 1342, 1370, 1371, 1372, 1420, 1421, 1457, 1541, 1542, 1574, 1578, 1579, 1580, 1615, 1616, 1617, 1670, 1778, 1779, 1785, 1786, 1787, 1788, 1790, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 765, 795, 796, 797, 1239, 1368, 1755, 1756, 1757, 1758, 1759, 1761, 1762, 738, 778, 1690, 813, 990, 1692, 1691, 1695, 1694, 1696, 1581, 1582, 1583, 1584, 1636, 1637, 1693, 1697, 749, 750, 751, 752, 993, 994, 1075, 1232, 1233, 1348, 798, 799, 800, 801, 802, 803, 804, 1643, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 866, 867, 868, 870, 871, 872, 873, 874, 875, 919, 920, 921, 922, 1228, 1242, 1243, 1347, 887, 888, 889, 890, 891, 892, 893, 894, 1136, 1137, 1429, 896, 897, 1567, 1792, 2749, 905, 908, 898, 899, 900, 901, 902, 1489, 855, 904, 1225, 518, 570, 926, 1337, 1338, 1339, 1340, 911, 1665, 2252, 2322, 2799, 971, 974, 1528, 2602, 2604, 976, 982, 983, 984, 985, 986, 987, 1028, 1029, 1229, 1003, 1004, 1005, 1006, 1007, 1008, 569, 780, 784, 1099, 1100, 1101, 1213, 1386, 551, 713, 1433, 1532, 1572, 1573, 1723, 1585, 1586, 1588, 1589, 1590, 1591, 1722, 1721, 1724, 1725, 1726, 1727, 1728, 1729, 1730, 1731, 2264, 1012, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1309, 1310, 1642, 1834, 2844, 441, 544, 1022, 1112, 1114, 1117, 1118, 1533, 1632, 1633, 1634, 1635, 1856, 1292, 1294, 1295, 1296, 1297, 1298, 989, 991, 1083, 1558, 1559, 1560, 1561, 1562, 1563, 1564, 1565, 1120, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1552, 1553, 1554, 1072, 1073, 1074, 1076, 1328, 1329, 1078, 1079, 1349, 1084, 1085, 1086, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 2629, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1230, 1231, 1592, 1096, 1097, 1098, 814, 1095, 555, 556, 558, 1103, 1105, 1106, 1109, 1110, 1284, 1434, 550, 552, 553, 554, 1111, 1132, 1133, 1702, 1703, 1704, 1705, 1706, 1707, 1708, 1711, 1712, 1713, 1714, 1715, 1249, 1250, 1244, 1273, 1274, 1275, 1276, 1317, 1318, 1277, 1556, 1557, 1279, 1280, 1281, 1286, 1425, 1287, 1288, 1308, 1644, 1737, 1311, 1315, 1316, 1319, 1321, 1322, 1320, 1323, 1324, 1325, 1448, 1326, 1327, 1377, 1378, 1379, 1380, 1381, 1403, 1404, 1405, 1406, 1407, 1408, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1531, 1587, 1343, 1344, 1345, 1346, 1382, 1383, 1384, 1409, 1410, 1411, 1385, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1709, 1710, 1422, 1423, 1424, 1543, 2851, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1447, 1474, 1544, 1545, 1546, 1547, 1548, 1549, 1506, 1529, 1539, 1540, 1550, 1551, 1593, 1601, 1628, 1609, 1610, 1645, 1646, 1647, 1648, 1649, 1650, 1699, 1700, 1701, 1738, 1739, 1740, 144, 138, 1267, 1687, 2052, 2228, 2229, 2236, 2242, 2313, 2316, 2319, 2362, 2424, 2471, 2472, 2576, 2682, 2335, 2333, 2795, 2656, 2792)
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/ |
| |
|
FAQ