Ataj1
Posty: 47
|
 Wysłany: 11-12-2007, 17:08 [Problem] SQL Error : 1054
|
|
|
witam
Gdy próbuję odszukac wszystkie posty napisane przez jakiegoś usera lub wyszukac tematy w których dostał punkt POMÓGŁ wyskakuje taki oto komunikat. Mógłby ktoś pomóc?
TU PUNKTY POMÓGŁ:
| Kod: |
Could not obtain post ids
DEBUG MODE
SQL Error : 1054 Nieznana kolumna 'f.forum_min_posts' w where clause
SELECT p.post_id FROM (phpbb_posts p, phpbb_forums f, phpbb_users u) WHERE p.post_id IN (11, 12, 13, 14, 15, 16, 17, 18, 67, 66, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 93, 94, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 172, 173, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 207, 208, 209, 211, 212, 214, 216, 218, 222, 224, 226, 227, 229, 231, 235, 238, 240, 244, 247, 250, 251, 252, 253, 254, 258, 260, 261, 263, 266, 268, 270, 357, 358, 359, 360, 361, 362, 363, 364, 366, 367, 368, 369, 370, 372, 373, 375, 376, 377, 378, 389, 394, 397, 529, 534, 542, 546, 700, 704, 711, 720, 724, 725, 726, 729, 730, 732, 736, 737, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 854, 855, 858, 867, 868, 870, 875, 878, 935, 1120, 993, 999, 1002, 2599, 1032, 1063, 1115, 1119, 1135, 1137, 1141, 1143, 1145, 1154, 1188, 1220, 1221, 1222, 1223, 1284, 1285, 1290, 1292, 1294, 1298, 1300, 1303, 1304, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1315, 1316, 1317, 1318, 1319, 1338, 1323, 1337, 1327, 1328, 1330, 1332, 1340, 1341, 1342, 1343, 1344, 1345, 1390, 1410, 1411, 1412, 1415, 1416, 1417, 1418, 1419, 1421, 1423, 1424, 1426, 1427, 1428, 1429, 1460, 1461, 1462, 1463, 1464, 1475, 1484, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1506, 1507, 1531, 1534, 1535, 1536, 1537, 1539, 1540, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1561, 1564, 1565, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1576, 1578, 1580, 1581, 1582, 1595, 1596, 1649, 1699, 1700, 1701, 1703, 1705, 1706, 1808, 1809, 1810, 1917, 1926, 1929, 1930, 1932, 1933, 1937, 1938, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032, 2033, 2159, 2257, 2259, 2261, 2285, 2286, 2301, 2302, 2303, 2304, 2305, 2343, 2392, 2396, 2399, 2400, 2402, 2405, 2406, 2407, 2409, 2410, 2412, 2413, 2416, 2418, 2420, 2421, 2423, 2430, 2431, 2526, 2531, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2583, 2586, 2587, 2589, 2591, 2592, 2593, 2594, 2595, 2596, 2600, 2601, 2602, 2604, 2605, 2606, 2607, 2614, 2619, 2620, 2621, 2623, 2625, 2626, 2657, 2659, 2661, 2663, 2698, 2699, 2703, 2705, 2733, 2735, 2739, 2741) AND f.forum_id = p.forum_id AND f.forum_id IN (1, 2, 3, 4, 5, 38, 6, 7, 8, 9, 10, 11, 12, 37, 14, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 35, 36, 28, 29, 30, 31, 32, 33, 34) AND u.user_id = p.poster_id AND u.username LIKE 'Ocieks' AND ( 244 >= f.forum_min_posts OR 1 = 1 )
Line : 600
File : search.php |
A TU WYSZUKIWANIE WSZYSTKICH POSTóW USERA:
| Kod: | Could not obtain post ids
DEBUG MODE
SQL Error : 1054 Nieznana kolumna 'f.forum_min_posts' w where clause
SELECT p.post_id FROM (phpbb_posts p, phpbb_forums f, phpbb_users u) WHERE p.post_id IN (2539) AND f.forum_id = p.forum_id AND f.forum_id IN (1, 2, 3, 4, 5, 38, 6, 7, 8, 9, 10, 11, 12, 37, 14, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 35, 36, 28, 29, 30, 31, 32, 33, 34) AND u.user_id = p.poster_id AND u.username LIKE 'Ocieks' AND ( 244 >= f.forum_min_posts OR 1 = 1 )
Line : 600
File : search.php |
|
|
FAQ - PIERWSZA POMOC!!
REGULAMIN
SZUKAJ
Użytkownicy
Grupy
Statystyki
Rejestracja
Zaloguj
Download
Katalog Forów
