FAQFAQ  SzukajSzukaj  UżytkownicyUżytkownicy  GrupyGrupy RejestracjaRejestracja  ZalogujZaloguj
Błąd Ogólny
 
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 'db1_prusai_h2_pl.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 (510, 814, 1223, 1275, 1320, 119, 170, 199, 200, 663, 682, 817, 818, 819, 820, 860, 1034, 1317, 1446, 1452, 1454, 137, 32, 111, 112, 113, 350, 1159, 1453, 232, 233, 309, 474, 491, 521, 771, 946, 956, 1213, 1250, 1261, 1302, 1318, 1341, 331, 421, 637, 683, 744, 951, 952, 953, 954, 955, 1175, 1226, 157, 1284, 1449, 75, 117, 240, 257, 392, 516, 529, 875, 1012, 1072, 1135, 1186, 1288, 1296, 1414, 1442, 1444, 13, 18, 70, 71, 525, 610, 619, 1018, 1187, 1243, 1256, 1345, 1434, 1436, 1438, 1440, 1455, 1456, 1591, 523, 570, 673, 676, 710, 712, 715, 745, 746, 747, 748, 749, 750, 774, 783, 801, 805, 807, 825, 880, 1006, 1354, 1592, 1588, 1589, 155, 12, 134, 49, 77, 129, 300, 803, 912, 931, 1066, 1176, 1263, 1351, 1376, 154, 336, 55, 91, 121, 127, 187, 130, 335, 193, 186, 185, 210, 306, 346, 347, 387, 395, 398, 423, 504, 508, 509, 531, 540, 609, 679, 680, 681, 706, 1016, 1138, 1183, 1191, 1251, 1266, 1299, 1352, 564, 702, 1052, 1245, 1279, 61, 62, 135, 28, 39, 41, 47, 50, 56, 57, 58, 63, 65, 69, 78, 189, 81, 92, 93, 94, 95, 103, 104, 105, 106, 107, 108, 110, 115, 118, 122, 123, 124, 125, 132, 139, 140, 145, 162, 172, 334, 178, 417, 209, 212, 217, 221, 415, 882, 258, 329, 283, 301, 307, 324, 338, 339, 405, 422, 428, 433, 434, 440, 441, 495, 469, 470, 473, 476, 484, 485, 486, 488, 489, 497, 501, 544, 506, 517, 520, 522, 524, 528, 541, 557, 561, 562, 563, 571, 572, 573, 574, 575, 576, 577, 585, 586, 587, 588, 593, 594, 595, 597, 598, 599, 1088, 604, 608, 614, 615, 616, 617, 618, 622, 623, 631, 639, 640, 643, 642, 644, 647, 651, 657, 659, 665, 674, 677, 678, 685, 687, 689, 692, 693, 694, 705, 707, 708, 711, 717, 718, 721, 722, 727, 728, 729, 730, 731, 733, 735, 737, 738, 739, 740, 741, 742, 743, 751, 753, 754, 755, 757, 758, 759, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 772, 773, 775, 778, 779, 780, 784, 785, 788, 789, 790, 792, 793, 796, 797, 800, 809, 852, 853, 854, 855, 856, 857, 858, 865, 873, 874, 883, 885, 886, 887, 889, 890, 891, 892, 895, 901, 905, 906, 907, 916, 918, 919, 924, 926, 932, 933, 948, 949, 950, 960, 977, 996, 998, 999, 1002, 1014, 1026, 1027, 1031, 1038, 1039, 1041, 1042, 1044, 1045, 1049, 1050, 1059, 1060, 1063, 1070, 1071, 1073, 1074, 1075, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1087, 1089, 1090, 1091, 1093, 1094, 1095, 1096, 1097, 1098, 1101, 1102, 1111, 1112, 1118, 1119, 1121, 1129, 1137, 1153, 1154, 1155, 1157, 1158, 1163, 1164, 1168, 1170, 1179, 1180, 1181, 1182, 1192, 1193, 1194, 1195, 1204, 1205, 1209, 1232, 1237, 1238, 1240, 1241, 1254, 1257, 1259, 1264, 1276, 1278, 1283, 1287, 1297, 1304, 1305, 1309, 1311, 1312, 1322, 1323, 1334, 1335, 1370, 1374, 1402, 1404, 1415, 1425, 1426, 1427, 1429, 1435, 1437, 1451, 239, 361, 851, 700, 830, 833, 836, 837, 843, 844, 848, 849, 850, 878, 1206, 1364, 1391, 1408, 1409, 348, 349, 214, 218, 219, 223, 227, 228, 263, 264, 272, 273, 274, 305, 310, 400, 402, 439, 556, 579, 580, 581, 650, 1136, 1141, 1190, 1363, 1392, 1395, 1445, 29, 131, 166, 205, 638, 827, 981, 982, 190, 191, 160, 163, 188, 165, 169, 174, 176, 182, 195, 184, 197, 201, 211, 583, 584, 1203, 260, 271, 330, 311, 1441, 254, 259, 279, 280, 281, 295, 296, 297, 298, 304, 312, 313, 314, 315, 317, 318, 319, 320, 321, 322, 438, 445, 446, 449, 450, 451, 452, 453, 454, 455, 456, 460, 461, 462, 464, 465, 466, 477, 1130, 1382, 1416, 284, 285, 286, 288, 289, 291, 292, 1331, 1040, 1144, 1151, 1173, 1208, 1230, 1236, 1249, 1268, 1292, 1294, 1330, 1342, 1346, 1347, 1353, 1372, 1373, 1407, 1411, 1431, 356, 357, 358, 359, 362, 363, 364, 365, 366, 367, 370, 371, 372, 373, 374, 375, 376, 382, 383, 384, 1030, 410, 539, 686, 828, 829, 831, 834, 835, 839, 840, 841, 845, 846, 847, 876, 877, 935, 936, 937, 938, 939, 940, 941, 961, 962, 963, 965, 966, 968, 969, 997, 1008, 1122, 565, 567, 568, 589, 590, 591, 592, 1201, 1000, 1234, 126, 378, 861, 862, 1037, 1150, 1281, 1189, 1315, 1421, 1422, 1450, 1269, 1270, 1271, 1272, 1397, 1398, 1399) 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/
 


Powered by phpBB modified by Przemo © 2003 phpBB Group
Theme 3myl_parchemin realise par SGo modified for przemo by joli
Strona wygenerowana w 0.01 sekundy. Zapytań do SQL: 13