Great Mod thanks,
I am trying to run the SQL and get the error on "ADD FULLTEXT"
Can you tell me what do I change on the SQL?
From This:
Code: Select all
ALTER TABLE `phpbb_topics` ADD FULLTEXT (`topic_title`);
ALTER TABLE `phpbb_users` ADD `user_options_similar` INT(11) UNSIGNED NOT NULL DEFAULT '0';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_stopwords',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_noshow_forums_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_ignore_forums_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_sort_type','relev');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_max_topics',5);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_posting',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_viewtopic',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_amount_words_viewtopic', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_amount_words_posting', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_relevance', 0);
To look like this? Yes No?
Code: Select all
ALTER TABLE `phpbb_topics` ENGINE = MYISAM;
ALTER TABLE `phpbb_topics` ADD FULLTEXT (`topic_title`);
ALTER TABLE `phpbb_users` ADD `user_options_similar` INT(11) UNSIGNED NOT NULL DEFAULT '0';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_stopwords',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_noshow_forums_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_ignore_forums_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_sort_type','relev');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_max_topics',5);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_posting',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_viewtopic',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_amount_words_viewtopic', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_amount_words_posting', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('similar_topics_min_relevance', 0);
Thanks for your help and sorry for question.
UPDATE:
Yipee! Got it working, thank you... Great Mod.
