Bazy danych SQL - Problem po wejsciu w temat
sebus231 - 07-02-2013, 15:18
Temat postu: Problem po wejsciu w temat
Witam, posiadam problem po wejsciu w temat o kodzie
| Kod: |
Could not get main information for similar topics
DEBUG MODE
SQL Error : 1214 The used table type doesn't support FULLTEXT indexes
SELECT t.*, u.user_id, u.username, u2.username as user2, u2.user_id as id2, f.forum_id, f.forum_name, p.post_time, p.post_username, MATCH(t.topic_title) AGAINST('zosta moderatorem') as relevance FROM phpbb_topics t, phpbb_users u, phpbb_forums f, phpbb_posts p, phpbb_users u2 WHERE t.topic_id <> 16 AND t.forum_id IN (4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 32, 33, 34) AND MATCH(t.topic_title) AGAINST('zosta moderatorem') AND t.forum_id = f.forum_id AND p.poster_id = u2.user_id AND p.post_id = t.topic_last_post_id AND t.topic_poster = u.user_id AND t.topic_status <> 2 GROUP BY t.topic_id ORDER BY t.topic_type DESC, relevance DESC LIMIT 0,5
Line : 3250
File : viewtopic.php |
link: http://forum-androida.pl/...rem-vt16.htm#18
Dajaj - 07-02-2013, 15:46
| Cytat: | | 1214 The used table type doesn't support FULLTEXT indexes |
Tabela nie obsługuje formatu pola " FULLTEXT " - zmień na inne ( TEXT itp )
phpmyadmin>phpbb_topics
sebus231 - 07-02-2013, 16:02
Dobra ok zmienić, ale możesz podać jakieś zapytanie bo jakoś nie mam pojęcia jak zmienić, albo instrukcje krok po kroku
[ Dodano: 07-02-2013, 17:09 ]
POmoże ktoś?
|
|
|
