phpBB2 by Przemo

[sebus231]

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

[Gadatliwa Kasia]

[Dajaj]

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]

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ś?