Archiwum działu Ogólne (posty do 12.2007) - [Problem] SQL Error : 1054
Ataj1 - 11-12-2007, 17:08
Temat postu: [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 |
Centurion - 11-12-2007, 17:13
forum_min_posts brakuje komorki w bazie
wrzuc to zapytanie do phpmyadmina
| Kod: | | ALTER TABLE phpbb_forums ADD forum_min_post smallint(5) not null default '0' |
Ataj1 - 11-12-2007, 17:27
| Centurion napisał/a: | forum_min_posts brakuje komorki w bazie
wrzuc to zapytanie do phpmyadmina
| Kod: | | ALTER TABLE phpbb_forums ADD forum_min_post smallint(5) not null default '0' |
|
| Kod: | Błąd
zapytanie SQL:
SELECT *
FROM `phpbb_forums`
WHERE ALTER TABLE phpbb_forums ADD forum_min_post smallint( 5 ) NOT NULL default '0' LIMIT 0 ,
30
MySQL zwrócił komunikat:
#1064 - Something is wrong in your syntax obok 'ALTER TABLE phpbb_forums ADD forum_min_post smallint ( 5 ) not n' w linii 1 |
Centurion - 11-12-2007, 17:52
a skad Ci sie tam wzielo SELECT * FROM? ma byc tylko to co napisalem
Ataj1 - 17-12-2007, 17:02
| Kod: | zapytanie SQL:
ALTER TABLE phpbb_forums ADD forum_min_post smallint( 5 ) NOT NULL default '0'
MySQL zwrócił komunikat: Dokumentacja
#1060 - Powtórzona nazwa kolumny 'forum_min_post'
|
|
|
|
