Link to Mod (http://mods.simplemachines.org/index.php?mod=189)
IntroductionRelated Topics adds listing of "Related Topics" or Similar Topics on topic view.
Method used to create listing can be changed from Admin. (Currently only one option)
Currently only MySQL is supported.
VersionsFor SMF 2.0 use 1.4.
For SMF 1.1.x use 1.3.x
Please support development of this modification!This modification is free but if you like this mod, please support it by making small donation.
You can support development of this modification by donating via PayPal, Donate now (https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=801590)
Thank you!
Installation (1.3.x)1. Use package manager to install or do it manually
2. Edit settings and save (location depends on version)
(SMF 1.1) Configuration -> Features and Options
(SMF 2.0) Configuration -> Modifications -> Related Topics
3. Use Build index link to make index
FeaturesMethodsContains currently one search method
Fulltext- Related Topics are searched by Fulltext on subjects.
- MySQL only
Changelog1.4- Support for 2.0 Final
Nice mod :). This is a feature of vB, no? Great idea.
pure genious. Seriously. Defineately default-feature worth materail.
I dont recall of this feature with vB. Maybe a mod?
Quote from: Tippmaster on September 14, 2005, 06:39:21 PM
I dont recall of this feature with vB. Maybe a mod?
At last check, it's a feature. It may be disabled on some forums, but it's a implemented.
error installing:
2. Execute Modification Themes/default/Display.template.php Test failed
Quote from: OIDanTheManIO on September 14, 2005, 06:56:29 PM
Quote from: Tippmaster on September 14, 2005, 06:39:21 PM
I dont recall of this feature with vB. Maybe a mod?
At last check, it's a feature. It may be disabled on some forums, but it's a implemented.
yep, found it. It was disabled on my board. But it says "
This can have an effect on performance.". Hopefully this mod for smf wont do so, exept for the better
Quote from: Tippmaster on September 14, 2005, 07:36:25 PM
yep, found it. It was disabled on my board. But it says "This can have an effect on performance.". Hopefully this mod for smf wont do so, exept for the better
Being it sifts through the database searching for related topics, it will.
QuoteCan't find FULLTEXT index matching the column list
Ficheiro: /home/cmspt/public_html/smf/Sources/Display.php
Linha: 184
After this, in portuguese (because my board is in portuguese), it tells me that I'm using smf 1.0.5 buf the database is in version 1.0.2... Not possible, because I found out about SMF a few months ago, I never used anything else besides 1.0.5.
I've applied only the changes manually on SMF 1.0.5 and Aqua Soft ported theme, double checked (never did understand that "search after" thingy, so I tried after and before :P), the changes on Display.Template.php give no errors, only the ones on Display.php.
On line 184 I have this (part of the mod):
$related = db_query("SELECT *, MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') As Score FROM {$db_prefix}messages As ms WHERE MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //This is a great mod, even if it slows the forum a bit.
PS: I should say I'm using the Global Announcement mod, don't know if that has any influence...
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fxoomer.virgilio.it%2Flonax%2Fimages%2Fclap_ani.gif&hash=a9634f0c3f927951c4ce70fb097129e5223a1b4f)
I posted the idea for this.
And Niko made it really neat 8)
Great mod - Im looking forward to adding it :)
It would be nice to be able to limit it to specific boards as well.
Quote from: buf on September 15, 2005, 04:30:45 AM
QuoteCan't find FULLTEXT index matching the column list
Ficheiro: /home/cmspt/public_html/smf/Sources/Display.php
Linha: 184
After this, in portuguese (because my board is in portuguese), it tells me that I'm using smf 1.0.5 buf the database is in version 1.0.2... Not possible, because I found out about SMF a few months ago, I never used anything else besides 1.0.5.
I've applied only the changes manually on SMF 1.0.5 and Aqua Soft ported theme, double checked (never did understand that "search after" thingy, so I tried after and before :P), the changes on Display.Template.php give no errors, only the ones on Display.php.
On line 184 I have this (part of the mod):
$related = db_query("SELECT *, MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') As Score FROM {$db_prefix}messages As ms WHERE MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //
This is a great mod, even if it slows the forum a bit.
PS: I should say I'm using the Global Announcement mod, don't know if that has any influence...
At: Admin->Forum->Search->Search Method
Press "create a fulltext index"
Quote from: ArkServer on September 14, 2005, 07:11:29 PM
error installing:
2. Execute Modification Themes/default/Display.template.php Test failed
You have modifed theme or using 1.0.5
Quote from: ArkServer on September 14, 2005, 07:11:29 PM
error installing:
2. Execute Modification Themes/default/Display.template.php Test failed
Ive got that error - and so decided to redownload the display.template.php file from simplemachines ... and I still get the error with it... Ive attached it.
Also I guess this needs full text indexing on - which I have... but I would just like to warn other members considering this - if its needed then it could double your forum db size! Well worth it though ;)
Quote from: Tony on September 15, 2005, 06:36:00 PM
Quote from: ArkServer on September 14, 2005, 07:11:29 PM
error installing:
2. Execute Modification Themes/default/Display.template.php Test failed
Ive got that error - and so decided to redownload the display.template.php file from simplemachines ... and I still get the error with it... Ive attached it.
Also I guess this needs full text indexing on - which I have... but I would just like to warn other members considering this - if its needed then it could double your forum db size! Well worth it though ;)
same here i used original 1.1 beta 3 and still no luck
Just please make it for 1.0.5 since it is the last stable version and much of us still use it.
Quote from: Ivan Minic on September 17, 2005, 02:29:49 AM
Just please make it for 1.0.5 since it is the last stable version and much of us still use it.
Aye, I second this.
Quote from: Harelin on September 18, 2005, 01:43:19 PM
Quote from: Ivan Minic on September 17, 2005, 02:29:49 AM
Just please make it for 1.0.5 since it is the last stable version and much of us still use it.
Aye, I second this.
I don't third this! ;)
Any news about this? i still want to use it
Hi,
I added this mod manual in 1.1.beta3 and it´s working fine, but this script is not using the board permissions, so anyone could see all topics from hidden boards, where they are not members. Any plans in the future to exclude such postings ?
Thx and Regards
i also get a test failed on the display template. i use 1.1 beta3 default theme
Sorry but how can i make a fulltext index? I'm using SMF 1.0.5
Quote from: R1p.PeR on October 14, 2005, 07:15:18 PM
Sorry but how can i make a fulltext index? I'm using SMF 1.0.5
This was added in 1.1
Yes, but the full text index is a sql query (i think) so must be another way to do so, like
CREATE TABLE log_search_fulltext (
ID_SEARCH tinyint(3) unsigned NOT NULL default '0',
ID_MSG mediumint(9) NOT NULL default '0',
PRIMARY KEY (ID_SEARCH, ID_MSG)
) TYPE=MyISAM;
or sometin' like that
I am interested in your progress on the Related Forum Topics Mod as I still use the older version on www.certifiedsecuritypro.com and would like to use it on my new site, www.ethicalhacker.net where I use Joomla 1.0.2, SMF 1.1 RC1 and JoomlaHacks Bridge.
I'm also available to help test if needed.
Thanks.
1.0.5 version please
guess teh mod is dead.. xD
Quote from: Niko on September 14, 2005, 11:50:29 AM
Link to Mod (http://mods.simplemachines.org/index.php?mod=189)
Adds "Related Topics" under posts when there is at least one.
Todo
- Do not include topics older than x days
- Show Caterogy/Board next to topic title
- Ability to limit to search from same Caterogy/Board/Board and its parent(s)
- 1.0.5 Support
- Allow to choose how many to show
- User can select what ever if its collapsed or not by default
Please Read My Blogs SMF category @ http://www.madjoki.com/blog/categories/smf/ for more 'info'
Nice mod, NICER site! I like the blog, is that from wordpress??
I have manualy added this mod, but I am getting:
QuoteCan't find FULLTEXT index matching the column list
File: /home/lovesms/public_html/forum/Sources/Display.php
Line: 167
I have created the index!
QuoteSpace used by forum messages in the database: 685 KB
Space used to index messages in the database: 413 KB
Fulltext index: already created (remove fulltext index).
Fulltext search - match complete words is check`d..
Why am I still getting this error???
Got this error:
QuoteParse error: parse error, unexpected T_VAR, expecting ',' or ';' in .../Themes/Saf-Blue_for_1/Display.template.php on line 618
Using Saf Blue theme and applied this mod manually, but had problems with this part:
Quote<file name="Themes/default/Display.template.php">
<operation>
<search position="after"><![CDATA[ echo implode($context['menu_separator'], $buttonArray);
echo '
</td>
</tr>
</table>
</td>
</tr>
</table>
';]]></search>
The closest match I found for that had everything except for the
;' at the end.
I added it in anyway since it was the closest match...
Now I get the error I mentioned in my first sentence...
I tried testing it on my default to make sure it's not just the theme I'm using, but it failed...What is missing here to make it work?
Using SMF 1.1 RC1.
No progress anymore on this?
I'm looking for this mod long before. However it will show topics from hidden forums as well? I hope it picks permissions in future development, if any.
Or will there be a separate mod made by other genius member? We can only wait and hope there is...
Thanks in advance!
from phpMyAdmin :
ALTER TABLE smf_messages ADD FULLTEXT (subject,body);
and Work fine with SMF 1.1 RC1 and RC2
FaSan
Little Tips
If you don't want to visualize the Recycled's Topic, change this:
Display.php
<search>
$context['related_topics'][] = $x;
</search>
<replace>
if ($x['icon'] != 'recycled')
$context['related_topics'][] = $x;
</replace>
FaSan
Can't find FULLTEXT index matching the column list
File: .../Sources/Display.php
Line: 331
I still get this Database error altought i did this >" Create FULLTEXT index. Goto (Admin->Forum->Search->Search Method)
Press "create a fulltext index" " which has written at his adress : http://www.madjoki.com/blog/2005/08/28/related-topics-for-smf-11/
I'm using 1.1 RC2. How can i fix that problem without phpMyAdmin
I've create a Full Text Index (Admin->Forum->Search->Search Method) but don't work in my forum.
With phpMyAdmin, it work fine :)
Bye, FaSan
Is there any demo on this mod? I`ve installed it @ http://forum.alltheweb.ro but I can`t see any "related" stuff..
Well... It was something in the Packages Manager I suppose, the mod was`nt installed in the right way (I`ve installed it from there)...
Anyways... Manual install is the best way it seems :)
Working Demo of this mod @ http://forum.alltheweb.ro (http://forum.alltheweb.ro/index.php/board,9.0.html)
Quote from: J. S. on January 09, 2006, 09:07:47 AM
Well... It was something in the Packages Manager I suppose, the mod was`nt installed in the right way (I`ve installed it from there)...
Anyways... Manual install is the best way it seems :)
Working Demo of this mod @ http://forum.alltheweb.ro (http://forum.alltheweb.ro/index.php/board,9.0.html)
Hello there, just a question: Did you created the (Related Topics) table yourself or is it ready by default? And how does the script determine relevancy amongst topics?
BTW, nice forum you've there with this mod!! ;)
works, sample here: http://arkserver.servehttp.com/index.php?topic=1450.0
Tho i have one question. how can i move the related topic down to the latest post?
Quote from: ArkServer on January 10, 2006, 03:36:41 PM
works, sample here: http://arkserver.servehttp.com/index.php?topic=1450.0
Tho i have one question. how can i move the related topic down to the latest post?
edit
nevermind, it was easy to figre out. fixed!
//edit 2
The mod doesnt show related topics. Well.. not 100%
check this: http://arkserver.servehttp.com/index.php?topic=1458.0 and see related topics.
Quote from: J. S. on January 09, 2006, 09:07:47 AM
Well... It was something in the Packages Manager I suppose, the mod was`nt installed in the right way (I`ve installed it from there)...
Anyways... Manual install is the best way it seems :)
Working Demo of this mod @ http://forum.alltheweb.ro (http://forum.alltheweb.ro/index.php/board,9.0.html)
Hello JS,
How do you manualy install this mod ?
Like, I fisrts tried to install "Related Topics" via mod manager but it doesn't work... Nothing new appears anywhere on my forum (I haven't seen any).
Related topics look very interesting !
edit : I use SMF 1.1RC2
Hi People! :)
this mod is great!.
Howewer I'm stuck in the installation process.
I got this error:
Executar Modificación ./Sources/Display.php Éxito
2. Executar Modificación ./Themes/default/Display.template.php Prueba fallida (Failed).
So I started to do it manually to see what was wrong, the problem is here:
display.template.php
<operation>
<search position="after"><![CDATA[
currentSwap = !currentSwap;
}';]]></search>
<add><![CDATA[ echo '
var currentSwapRel = trueetc..
I have no lines containing "currentSwap = !currentSwap;"
I'm running SMF 1.1 RC2 and a very modified version of the SAF theme.
I haven't these lines because I erased them following the instructions to update the theme from rc1 to rc2. (http://www.simplemachines.org/community/index.php?topic=64744.0).
What I can do to make this work? I have no currentswap anywhere in the Display template.
Best,
Carla
I'm very interesting by this mod too !!! :P
Like Carla, I have the same problem :'(
This mod must to generate a lot of requiest ?? :-\
Can someone help me ?? ??? ??? ???
help !!! :-[
??? ??? ??? ??? ???
Works here.. 1.1 rc2
http://arkserver.servehttp.com/index.php?topic=736.0
Yeaaaaaaaaaah !!!
What is the code in display.template.php pleaaaase ?? :P
I've succssfully gotten this to work on my RC2 board. I'll post the modified package in a moment. Oh, beware, if it's already not stated somewhere, you'll have to modify your database. Specifically, the messages table. You need to create a new Index field. I called mine Score. You'll need to make it a FullText index field using the subject, body columns. I'll also provide a screen shot of my NaviCat (sql program) display for the changes.
Well, since I can't post attachments here, I'll link to my site.
Related Topics RC 2 Mod (http://www.ayeka.net/sendFile.php?file=downloads/Mods/Related%20Topics/Related_Topics.zip&u=0)
Hopefully, this will work for you.
I get the following "Template Parse Error!" after installing the mod in the version you posted, Senkusha:
QuoteTemplate Parse Error!
There was a problem loading the /Themes/default/Display.template.php template or language file. Please check the syntax and try again - remember, single quotes (') often have to be escaped with a slash (\). To see more specific error information from PHP, try accessing the file directly.
You may want to try to refresh this page or use the default theme.
parse error, unexpected T_STRING, expecting ',' or ';'
Tried finding out what was wrong by myself, but got confused by the switching of using " or ' to echo HTML :/.
I installed the rc2 mod and it works fine :) thanks dude!
there is an error in your code :
The really code of install1-1.xml is :
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE modification SYSTEM "http://www.simplemachines.org/xml/modification">
<modification xmlns="http://www.simplemachines.org/xml/modification" xmlns:smf="http://www.simplemachines.org/">
<id>Niko:RelatedTopics</id>
<version>1.0.1</version>
<file name="$sourcedir/Display.php">
<operation>
<search position="before"><![CDATA[$topicinfo = mysql_fetch_assoc($request);]]></search>
<add><![CDATA[$terms = explode(" ",$topicinfo['subject']);
foreach($terms As $term){
$term = str_replace(array(":","-","+","~"),"",$term); // These are reversed in mysql need to remove to work correctly
if(strlen($term) > 3) $mssub .= trim($term)." ";
}
$stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless');
$context['icon_sources'] = array();
foreach ($stable_icons as $icon)
$context['icon_sources'][$icon] = 'images_url';
$mssub = trim(mysql_real_escape_string($mssub));
//fatal_error($mssub);
$related = db_query("SELECT *, MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') As Score FROM {$db_prefix}messages As ms WHERE MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //
$context['related_topics'] = array();
$tids = array(
$topic => true,
);
while($relTopic = mysql_fetch_array($related)){
$x = $relTopic;
if(!isset($tids[$relTopic['ID_TOPIC']])){
$tids[$relTopic['ID_TOPIC']] = true; // Prevent same appearing many times
$tox = db_query("SELECT * FROM {$db_prefix}topics As t,{$db_prefix}messages As ml WHERE t.ID_TOPIC='{$relTopic['ID_TOPIC']}' AND ml.ID_MSG = t.ID_LAST_MSG LIMIT 0,1",__FILE__,__LINE__); //
$tox2 = db_query("SELECT * FROM {$db_prefix}topics As t,{$db_prefix}messages As ml WHERE t.ID_TOPIC='{$relTopic['ID_TOPIC']}' AND ml.ID_MSG = t.ID_FIRST_MSG LIMIT 0,1",__FILE__,__LINE__); //
$x['more'] = mysql_fetch_array($tox);
$x['first'] = mysql_fetch_array($tox2);
mysql_free_result($tox);
mysql_free_result($tox2);
$x += array('icon_url' => $settings[ $context['icon_sources'][ $x['icon'] ]] . '/post/' . $x['icon'] . '.gif');
$x['more']['time'] = timeformat($x['more']['posterTime'],true);
loadMemberData( array($x['more']['ID_MEMBER'], $x['first']['ID_MEMBER']) );
global $memberContext;
loadMemberContext( $x['more']['ID_MEMBER'] );
if(isset($memberContext[ $x['more']['ID_MEMBER'] ]))
$x['more']['member'] = $memberContext[ $x['more']['ID_MEMBER'] ];
else
$x['more']['member']['link'] = $x['more']['posterName'];
loadMemberContext( $x['first']['ID_MEMBER'] );
if(isset($memberContext[ $x['first']['ID_MEMBER'] ]))
$x['first']['member'] = $memberContext[ $x['first']['ID_MEMBER'] ];
else
$x['first']['member']['link'] = $x['first']['posterName'];
$x += array(
'is_sticky' => $x['more']['isSticky'],
'is_locked' => $x['more']['locked'],
'is_poll' => $x['more']['ID_POLL'] == 0 ? 0 : 1 );
determineTopicClass($x);
$context['related_topics'][] = $x;
unset($x);
}
}
mysql_free_result($related);]]>
</add>
</operation>
</file>
<file name="Themes/default/Display.template.php">
<operation>
<search position="before"><![CDATA[ echo '
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="middletext">', $txt[139], ': ', $context['page_index'], !empty($modSettings['topbottomEnable']) ? $context['menu_separator'] . ' <a href="#top"><b>' . $txt['topbottom4'] . '</b></a>' : '', '</td>
<td align="right" style="padding-right: 1ex;">
<table cellpadding="0" cellspacing="0">
<tr>
', template_button_strip($normal_buttons, 'top', true), '
</tr>
</table>
</td>
</tr>
</table>';
]]></search>
<add><![CDATA[ if(is_array($context['related_topics']) && count($context['related_topics']) > 0)
$showRelated = true;
if($showRelated){
echo '<br />';
echo '
<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
<tr class="catbg"><td colspan="7"><img src="', $settings['images_url'], '/collapse.gif" alt="+" border="0" id="related_img" onclick="swapRelated();"/> <a href="javascript:swapRelated();"> Related Topics</a></td></tr>
';
$i = 0;
echo '<tr id="related"><td colspan="7" class="windowbg2"><table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor"><tr class="titlebg"><td width="9%" colspan="2"></td>
<td>', $txt[70], '</a></td>
<td width="14%"> ', $txt[109], '
<td width="4%" align="center">', $txt[110], '</a></td>
<td width="4%" align="center">', $txt[301], '</a></td>
<td width="20%">', $txt[111], '</a></td>';
echo '</tr>';
foreach($context['related_topics'] as $tmp){
// echo "<tr><td>".print_r($tmp,true)."</td></tr>";
$color[0] = "windowbg";
$color[1] = "windowbg2";
echo "<tr>
<td valign=\"middle\" align=\"center\" width=\"4%\" class=\"{$color[$i % 2]}\">",'<img src="', $settings['images_url'], '/topic/', $tmp['class'], '.gif" alt="" /></td>',"
<td valign=\"middle\" align=\"center\" width=\"4%\" class=\"{$color[$i++ % 2]}\"><img src='",$tmp['icon_url'],"' alt=''></td>
<td class=\"{$color[$i % 2]}\"><a href=\"$scripturl?topic={$tmp['ID_TOPIC']}.0\">".$tmp['first']['subject']."</a></td>
<td class=\"{$color[$i++ % 2]}\">", $tmp['first']['member']['link'], "</td>
<td class=\"{$color[$i % 2]}\">",$tmp['more']['numReplies'],"</td>
<td class=\"{$color[$i++ % 2]}\">",$tmp['more']['numViews'],"</td>
<td class=\"{$color[$i++ % 2]}\">
<a href=",'"', "$scripturl?topic={$tmp['ID_TOPIC']}.msg{$tmp['more']['ID_MSG']}", '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>
<span class="smalltext">
', $tmp['more']['time'], '<br />
', $txt[525], ' ', $tmp['more']['member']['link'], "
</span>
</td>
</tr>";
//$i++;
}
echo '</table></td></tr>';
echo '</table>';
}]]></add>
</operation>
</file>
</modification>
Hmmm, I'll take another look at the code, and try to install fresh on another test board. In my defense, all I did was tweaked the version for SMF, and changed the search string to match the current template. When I did both installs on my own, production and test boards, they both worked flawlessly.
Sorry about this.
is it possible to filter out the recycled topics?
I'm not sure, since I didn't write this, and I don't know the MATCH...AGAINST syntax all that well. It could be possible, using a WHERE...AND statement to filter out those boards, however, I'm not sure how SMF determines if a board is a Recycling Board or not.
I installed the mod on 1.1rc2 and got this:
Can't find FULLTEXT index matching the column list
File: /.............../Sources/Display.php
Line: 164
So I uninstalled the mod; changed the 'after' to 'before' as suggested by kezayah; reinstalled the mod and it works!
Thanks Senkusha and kezayah! :D
I got that error when I first installed it as well. I modified my database to include a new index for the messages table as type FULLTEXT (per the MySQL site).
Hi guys,
Please take a look at your Forum Error Log and see whether you have the same error messages as these...
8: Undefined index: is_hot
File: /.............../Sources/Subs.php
Line: 2981
8: Undefined index: is_very_hot
File: /.............../Sources/Subs.php
Line: 2979
8: Undefined variable: mssub
File: /.............../Sources/Display.php
Line: 154
8: Undefined variable: showRelated
File: /.........../Themes/default/languages/Ignore.english.php (eval?)
Line: 625
Do you have these error messages? Any solution please?
;)
Just uninstalled and there are 2 uninstallation errors:
Quotehttp://............./index.php?action=packages;sa=uninstall;package=Related_Topics2.zip
512: parseModification(): The filename 'Themes/default/Display.template.php' is not a full path!
File: /...................../Sources/Subs-Package.php
Line: 1329
Quotehttp://............../index.php?action=packages;sa=uninstall2;package=Related_Topics2.zip
512: parseModification(): The filename 'Themes/default/Display.template.php' is not a full path!
File: /......................./Sources/Subs-Package.php
Line: 1329
... while the four errors in my last post no longer occur.
Yes, I see these errors as well. They are being caused by the determineTopicClass($var) function being called.
I have fixed this error and have adjusted my MOD modification package accordingly.
Quote from: Senkusha on April 18, 2006, 03:33:30 PM
I have fixed this error and have adjusted my MOD modification package accordingly.
QuotePlease wait while we find your download.....
Table 'mm_anime.smf_file_uploads' doesn't exist
:(
Quote from: fivearts on April 18, 2006, 11:30:46 AM
Hi guys,
Please take a look at your Forum Error Log and see whether you have the same error messages as these...
8: Undefined index: is_hot
File: /.............../Sources/Subs.php
Line: 2981
8: Undefined index: is_very_hot
File: /.............../Sources/Subs.php
Line: 2979
8: Undefined variable: mssub
File: /.............../Sources/Display.php
Line: 154
8: Undefined variable: showRelated
File: /.........../Themes/default/languages/Ignore.english.php (eval?)
Line: 625
Do you have these error messages? Any solution please?
;)
i have this errors too..
any idea?
So sorry. I fixed the bug in my downloads page!!!
Also, those errors in the Forum Error Log, have been corrected in the latest file release on my site.
Sorry!
Hi Senkusha,
Many thanks for packaging this mod. ;)
After installing, when I click on any topic, this error appears:
Parse error: parse error, unexpected ')', expecting ']' in /............../Sources/Display.php on line 205
Regarding keeping the recycled topics out of Related Topics list, would you mind adding this earlier tip into the mod please?
http://www.simplemachines.org/community/index.php?topic=49410.msg446923#msg446923
Thanks
Thanks for looking into this, Senkusha :).
Unfortunately the latest version from your site, while not giving me a template parsing error, gives me a blank page when entering a topic.
'is_hot' => $x['more']['numReplies'] >= $modSettings['hotTopicVeryPosts']);
That did the trick with the blank page, thanks :D.
EDIT #1: Do you need to enable it somewhere? Can't seem to find any changes in any threads on my installation :S.
EDIT #2: To clarify... I created a FULLTEXT index, Score, for my smf_messages table - based on 'subject' and 'body'. If I chose to create a FULLTEXT index in Admin->Forum->Search->Search method, if would create a FULLTEXT index, body, for my smf_messages table - based on 'body' alone. Didn't do anything else, so I deleted that one again.
" 'is_hot' => $x['more']['numReplies'] >= $modSettings['hotTopicVeryPosts']);"
Thanks, I'll make that change! (removing the final parensis) I just copied that code out of the MessageIndex.php code.
No, you don't need to enable it anywhere, from looking at the code, it's already enabled if it finds any related topics. If it doesn't find any, then it's disabled (for that mesasge) Also, I'd give it some time. I think the index has to be built as well.....but I'm not sure how this all works to begin with.
I'm not sure I understand what you mean by going into the Admin to create an index....perhaps I missed that bit somewhere?
I have a lot of errors in my log with your mod !!! :(
8: Undefined index: is_very_hot
Fichier: /home/www/****/web/Sources/Subs.php
Ligne: 3161
8: Undefined variable: mssub
Fichier: /home/www/****/web/Sources/Display.php
Ligne: 182
Quote from: Senkusha on April 20, 2006, 09:28:59 AM
[...]
No, you don't need to enable it anywhere, from looking at the code, it's already enabled if it finds any related topics. If it doesn't find any, then it's disabled (for that mesasge) Also, I'd give it some time. I think the index has to be built as well.....but I'm not sure how this all works to begin with.
[...]
Alrighty, I'll give it some time. Thanks again for taking time to fix up the mod :).
Quote from: Senkusha on April 20, 2006, 09:28:59 AM
[...]
I'm not sure I understand what you mean by going into the Admin to create an index....perhaps I missed that bit somewhere?
[...]
I probably worded it badly. Under ./index.php?action=managesearch;sa=method you can create fulltext or custom indexes if they do not yet exist, but I take it that's not the way you got it working :D.
Quote from: J. S. on January 09, 2006, 09:07:47 AM
Well... It was something in the Packages Manager I suppose, the mod was`nt installed in the right way (I`ve installed it from there)...
Anyways... Manual install is the best way it seems :)
[...]
...and this turned out to be my problem also.
The Package Manager didn't properly (if at all) install the mod, so I had to do it manually.
Works now :).
EDIT: A shame Niko didn't code it to honor board permissions, though, so I'll leave it off my forum for now.
does this mod work on 1.1 rc2 ?
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
Quote from: Søren Bjerg on April 21, 2006, 03:27:18 AM
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
okay ill try it.thanks!
*EDIT*
with that mod installed i get this error:
Quote
Database Error
Can't find FULLTEXT index matching the column list
File: /home/admin/public_html/forum/Sources/Display.php
Line: 174
Quote from: kezayah on April 20, 2006, 10:17:12 AM
I have a lot of errors in my log with your mod !!! :(
8: Undefined index: is_very_hot
Fichier: /home/www/****/web/Sources/Subs.php
Ligne: 3161
8: Undefined variable: mssub
Fichier: /home/www/****/web/Sources/Display.php
Ligne: 182
up !!! :'(
Quote from: Prasad007 on April 21, 2006, 03:28:48 AM
Quote from: Søren Bjerg on April 21, 2006, 03:27:18 AM
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
okay ill try it.thanks!
*EDIT*
with that mod installed i get this error:
Quote
Database Error
Can't find FULLTEXT index matching the column list
File: /home/admin/public_html/forum/Sources/Display.php
Line: 174
You have to create a FULL TEXT index in your messages table. This is explained above.
And the is_hot index problem should have been fixed in the latest release. (I fixed this on Wednesday, I beleive.
Quote from: Senkusha on April 21, 2006, 05:20:03 AM
And the is_hot index problem should have been fixed in the latest release. (I fixed this on Wednesday, I beleive.
I have installed your latest release of Wednesday and there are always the same errors !!! :-\
So sorry! I found the problem and fixed it. New file has been uploaded.
Quote from: Senkusha on April 21, 2006, 05:20:03 AM
Quote from: Prasad007 on April 21, 2006, 03:28:48 AM
Quote from: Søren Bjerg on April 21, 2006, 03:27:18 AM
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
okay ill try it.thanks!
*EDIT*
with that mod installed i get this error:
Quote
Database Error
Can't find FULLTEXT index matching the column list
File: /home/admin/public_html/forum/Sources/Display.php
Line: 174
You have to create a FULL TEXT index in your messages table.
how do u do that ?
Quote from: Senkusha on April 21, 2006, 06:43:24 AM
So sorry! I found the problem and fixed it. New file has been uploaded.
It's perfect !!! 8)
Quote from: Prasad007 on April 21, 2006, 11:34:47 AM
Quote from: Senkusha on April 21, 2006, 05:20:03 AM
Quote from: Prasad007 on April 21, 2006, 03:28:48 AM
Quote from: Søren Bjerg on April 21, 2006, 03:27:18 AM
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
okay ill try it.thanks!
*EDIT*
with that mod installed i get this error:
Quote
Database Error
Can't find FULLTEXT index matching the column list
File: /home/admin/public_html/forum/Sources/Display.php
Line: 174
You have to create a FULL TEXT index in your messages table.
how do u do that ?
Open your terminal / Command prompt, log into mysql and type the following command:
USE smf;
ALTER TABLE smf_messages ADD FULLTEXT(subject, body);Based on what I read on the MYSQL site, this is how to modify a table to include a new index.
Quote from: Senkusha on April 21, 2006, 06:11:56 PM
Quote from: Prasad007 on April 21, 2006, 11:34:47 AM
Quote from: Senkusha on April 21, 2006, 05:20:03 AM
Quote from: Prasad007 on April 21, 2006, 03:28:48 AM
Quote from: Søren Bjerg on April 21, 2006, 03:27:18 AM
Quote from: Prasad007 on April 21, 2006, 03:19:02 AM
does this mod work on 1.1 rc2 ?
The version Senkusha posted in this post (http://www.simplemachines.org/community/index.php?topic=49410.msg545996#msg545996) is an adapted version for 1.1 RC2.
okay ill try it.thanks!
*EDIT*
with that mod installed i get this error:
Quote
Database Error
Can't find FULLTEXT index matching the column list
File: /home/admin/public_html/forum/Sources/Display.php
Line: 174
You have to create a FULL TEXT index in your messages table.
how do u do that ?
Open your terminal / Command prompt, log into mysql and type the following command:
USE smf;
ALTER TABLE smf_messages ADD FULLTEXT(subject, body);
Based on what I read on the MYSQL site, this is how to modify a table to include a new index.
thanks. ill try that :)
How to exclude the deleted topics in the list because I have a basket ...
I have tested :
$related = db_query("SELECT *, MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') As Score FROM {$db_prefix}messages As ms WHERE ((MATCH (ms.subject,ms.body)) AND (ms.ID_BOARD <> 'xx')) AGAINST ('{$mssub}') ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //
'xx' = 75 for me
... but there is a error in MySQL >:(
Thanks
@ Prasad007 don't forget:
Create FULLTEXT index: Go to (Admin->Forum->Search->Search Method), press "create a fulltext index"
from http://www.madjoki.com/blog/categories/smf/
Quote from: kalligator on May 04, 2006, 11:08:25 PM
@ Prasad007 don't forget:
Create FULLTEXT index: Go to (Admin->Forum->Search->Search Method), press "create a fulltext index"
from http://www.madjoki.com/blog/categories/smf/
yup thanks! :)
Quote from: kezayah on May 04, 2006, 05:36:15 PM
How to exclude the deleted topics in the list because I have a basket ...
I have tested :
$related = db_query("SELECT *, MATCH (ms.subject,ms.body) AGAINST ('{$mssub}') As Score FROM {$db_prefix}messages As ms WHERE ((MATCH (ms.subject,ms.body)) AND (ms.ID_BOARD <> 'xx')) AGAINST ('{$mssub}') ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //
'xx' = 75 for me
... but there is a error in MySQL >:(
Thanks
And for my problem ? :-[
Senkusha help me please !!! :'(
:-\
are you (the creator of this mod) going to update this mod? (you have a nice todo list...)
Hi
I am getting some errors
Using the RC2 forum. Anybody can help ?
8: Undefined index: related_topics
Soryy for my english. I'm french.
This mod seems super but It's not ok on SMF 1.1 RC2
Somebody can help me to do it work ?
The related topic is something very good for user and i should be very happy to offer it to my members
Tanks before.
Tried to install this but i've gotten this error.
QuoteInstalling this package will perform the following actions:
Type Action Description
1. Execute Modification ./Sources/Display.php Test successful
2. Execute Modification ./Themes/default/Display.template.php Test failed
I am using SMF 1.1 RC 2
Thanks :)
I installed & created a full text search index, got this error:
QuoteCan't find FULLTEXT index matching the column list
File: /home/mydomain.com/forums/Sources/Display.php
Line: 173
Quote from: kai920 on June 14, 2006, 10:09:29 PM
I installed & created a full text search index, got this error:
QuoteCan't find FULLTEXT index matching the column list
File: /home/mydomain.com/forums/Sources/Display.php
Line: 173
Open phpmyadmin and run this query:
ALTER TABLE smf_messages ADD FULLTEXT(subject, body);
That should do it.
Thanks for the answer Remaker... I don't get the error message anymore - but there are no related topics that show below the message?
Quote from: kai920 on July 01, 2006, 01:31:32 PM
Thanks for the answer Remaker... I don't get the error message anymore - but there are no related topics that show below the message?
I have the same error. Is there a way to rebuild the index, or something?
This mod requires many queries !!! :o :o :o
Is it possible to modfiy the code to reduce the number of queries ???
I found it ...
Remplace the code in
--> display.php :
$terms = explode(" ",$topicinfo['subject']);
$mssub = '';
foreach($terms As $term)
{
$term = str_replace(array(":","-","+","~"),"",$term); // These are reversed in mysql need to remove to work correctly
if(strlen($term) > 3) $mssub .= trim($term)." ";
}
$mssub = trim(mysql_real_escape_string($mssub));
//fatal_error($mssub);
$related = db_query("
SELECT *, MATCH (ms.subject,ms.body)
AGAINST ('{$mssub}') As Score
FROM {$db_prefix}messages As ms
WHERE MATCH (ms.subject,ms.body)
AGAINST ('{$mssub}')
ORDER BY Score DESC LIMIT 0,10",__FILE__,__LINE__); //
$context['related_topics'] = array();
$tids = array(
$topic => true,
);
while($relTopic = mysql_fetch_array($related)){
$x = $relTopic;
if(!isset($tids[$relTopic['ID_TOPIC']])){
$tids[$relTopic['ID_TOPIC']] = true;
$tox = db_query("
SELECT
m.posterTime, ms.subject, m.ID_TOPIC, m.ID_MEMBER AS ID_MEMBER, ms.ID_MEMBER AS ID_FIRST_MEMBER, ms.posterTime AS firstPosterTime, m.ID_MSG, t.numReplies, t.numViews, t.ID_POLL, t.isSticky, t.locked, ms.icon,
IFNULL(mems.realName, ms.posterName) AS firstPosterName,
IFNULL(mem.realName, m.posterName) AS posterName, " . ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
IFNULL(lt.ID_MSG, IFNULL(m.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead,
IFNULL(lt.ID_MSG, IFNULL(m.ID_MSG, -1)) + 1 AS new_from') . "
FROM ({$db_prefix}topics As t,{$db_prefix}messages As m,{$db_prefix}messages As ms)
LEFT JOIN {$db_prefix}members AS mems ON (mems.ID_MEMBER = ms.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest'] ? "
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)" : '') . "
WHERE t.ID_TOPIC='{$relTopic['ID_TOPIC']}'
AND m.ID_MSG = t.ID_LAST_MSG
AND ms.ID_MSG = t.ID_FIRST_MSG
LIMIT 0,1",__FILE__,__LINE__);
$x = mysql_fetch_array($tox);
mysql_free_result($tox);
// Decide how many pages the topic should have.
$topic_length = $x['numReplies'] + 1;
if ($topic_length > $modSettings['defaultMaxMessages'])
{
$tmppages = array();
$tmpa = 1;
for ($tmpb = 0; $tmpb < $topic_length; $tmpb += $modSettings['defaultMaxMessages'])
{
$tmppages[] = '<a href="' . $scripturl . '?topic=' . $x['ID_TOPIC'] . '.' . $tmpb . ';topicseen">' . $tmpa . '</a>';
$tmpa++;
}
// Show links to all the pages?
if (count($tmppages) <= 5)
$pages = '« ' . implode(' ', $tmppages);
// Or skip a few?
else
$pages = '« ' . $tmppages[0] . ' ' . $tmppages[1] . ' ... ' . $tmppages[count($tmppages) - 2] . ' ' . $tmppages[count($tmppages) - 1];
if (!empty($modSettings['enableAllMessages']) && $topic_length < $modSettings['enableAllMessages'])
$pages .= ' <a href="' . $scripturl . '?topic=' . $x['ID_TOPIC'] . '.0;all">' . $txt[190] . '</a>';
$pages .= ' »';
}
else
$pages = '';
// Build the array.
$x = array(
'first_poster' => empty($x['ID_FIRST_MEMBER']) ? $x['firstPosterName'] : '<a href="' . $scripturl . '?action=profile;u=' . $x['ID_FIRST_MEMBER'] . '">' . $x['firstPosterName'] . '</a>',
'poster' => empty($x['ID_MEMBER']) ? $x['posterName'] : '<a href="' . $scripturl . '?action=profile;u=' . $x['ID_MEMBER'] . '">' . $x['posterName'] . '</a>',
'pages' => $pages,
'replies' => $x['numReplies'],
'views' => $x['numViews'],
'time' => timeformat($x['posterTime']),
'first_time' => timeformat($x['firstPosterTime']),
'href' => $scripturl . '?topic=' . $x['ID_TOPIC'] . '.msg' . $x['ID_MSG'] . ';topicseen#new',
'subject' => '<a href="' . $scripturl . '?topic=' . $x['ID_TOPIC'] . '">' . $x['subject'] . '</a>',
'is_sticky' => $x['isSticky'],
'is_locked' => $x['locked'],
'is_poll' => $x['ID_POLL'] > 0,
'new' => !empty($x['isRead']),
'new_from' => $x['new_from'],
'icon' => $settings['default_theme_url'] . '/images//post/' . $x['icon'] . '.gif',
);
if ($x['icon'] != 'recycled' && $x['icon'] != 'moved')
$context['related_topics'][] = $x;
}
}
mysql_free_result($related);
In display.template.php, replace :
$showRelated = false;
if(is_array($context['related_topics']) && count($context['related_topics']) > 0)
$showRelated = true;
if($showRelated)
{
$dhtml_collapsed = get_collapsed_state("related_topics");
echo '
<table><tr><td style="padding: 0 0 1px 0;"></td></tr></table>
<table border="0" width="100%" cellspacing="1" cellpadding="3" class="bordercolor">
<tbody>
<tr class="catbg">
<td align="center" colspan="6">
<a style="float:right;" href="javascript:void(0);" onclick="doCollapseObject(\'related_topics\', \'', $settings['csect_cookie'], '\'); return false;"><img class="midimage" id="img_related_topics" src="', $settings['images_url'], $dhtml_collapsed ? '/expand_b.gif' : '/collapse_b.gif', '" alt="*" border="0" /></a>', 'Topics similaires', '</td>
</tr>
</tbody>
<tbody id="related_topics"', $dhtml_collapsed ? ' style="display:none;" ' : ' ', '>
<tr class="titlebg">
<td colspan="2" align="center">', $txt[70], '</td>
<td width="18%">' . $txt[109] . '</td>
<td width="4%" align="center">', $txt[110], '</td>
<td width="4%" align="center">', $txt[301], '</td>
<td width="18%">', $txt[111], '</td>
</tr>';
$i = 0;
foreach($context['related_topics'] as $tmp)
{
echo '
<tr class="', $i ? 'windowbg' : 'windowbg2' , '">
<td valign="middle" align="center" width="3%"><img src="' . $tmp['icon'] . '" alt="" /> </td>
<td valign="middle">';
if($tmp['is_sticky'])
echo '<span style="float:right"><img src="', $settings['images_url'], '/topic/sticky_topic.gif" alt="', $txt['smf96'], '" title="', $txt['smf96'], '" border="0" /></span>';
if($tmp['is_locked'])
echo '<span style="float:right"><img src="', $settings['images_url'], '/topic/locked_topic.gif" alt="', $txt['igoh_locked'], '" title="', $txt['igoh_locked'], '" border="0" /></span>';
if($tmp['is_poll'])
echo '<span style="float:right"><img src="', $settings['images_url'], '/topic/poll_topic.gif" alt="', 'Sondage', '" title="', 'Sondage', '" border="0" /></span>';
echo '' . $tmp['subject'] . '
', $tmp['new'] ? '' : '<a href="' . $tmp['href'] . '"><img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/new.gif" alt="' . $txt[302] . '" border="0" /></a>', '';
if (!empty($tmp['pages']))
echo '
<br /><span style="padding: 4px 0 2px 0;" class="small_pagelink"><img style="margin: 0 0 -3px 0; padding: 0 2px 0 0;" src="', $settings['images_url'], '/topic/multi_pg.gif" width="11" alt="', $txt['multi_pg'], '" title="', $txt['multi_pg'], '" border="0" />', $tmp['pages'], '</span>';
echo '
</td>
<td valign="middle" width="18%">
<span class="smalltext">
' . $tmp['first_time'] . '<br />
' . $txt[525] . ' ' . $tmp['first_poster'] . '
</span>
</td>
<td valign="middle" align="center" width="4%">' . $tmp['replies'] . '</td>
<td valign="middle" align="center" width="4%">' . $tmp['views'] . '</td>
<td valign="middle" width="18%">
<span class="smalltext">
' . $tmp['time'] . '<br />
<a href="' . $tmp['href'] . '"><img src="' . $settings['images_url'] . '/icons/last_post.gif" alt="' . $txt[111] . '" title="' . $txt[111] . '" border="0" style="float: right;" /></a>
' . $txt[525] . ' ' . $tmp['poster'] . '
<span>
</td>
</tr>';
$i=1-$i;
}
echo '</tbody></table>';
}
I can't get any releated topics to show up. I manually installed the mod since the Package Manager won't do it.
I've created a full text index, I've even switched back to the default template for 1.1 RC2.
I'm getting a lot of these messages in my error logs:
Undefined variable: showRelated
Undefined variable: mssub
Any suggestions?
Hi kezayah,
Using your suggested codes with 1.1rc2, I got this error at the bottom of the topic page:
Fatal error: Call to undefined function: get_collapsed_state() in /home/fivearts/public_html/Sources/Load.php(1613) : eval()'d code on line 640
Any solution is greatly appreciated. Thanks
:D
Wow, This important mod is not available for 1.1 RC3, NIko can you make it for us please, that will be very much appreciated
plsss edit in rc3
this is a great addon indeed... i hope someone can make this worked...
I managed to make it work and added a few enhancements in it like board specific related topics only etc
Think link (http://www.engineeringserver.com/forum/ads_revenue/google_adsense_worth_trying-t2594.0.html;msg21189#new)
Quote from: udeze on October 25, 2006, 08:50:54 AM
Wow, This important mod is not available for 1.1 RC3, NIko can you make it for us please, that will be very much appreciated
Yes it is, would be excellent for RC3.
Quote from: ArkServer on November 24, 2006, 09:49:50 AM
I managed to make it work and added a few enhancements in it like board specific related topics only etc
Think link (http://www.engineeringserver.com/forum/ads_revenue/google_adsense_worth_trying-t2594.0.html;msg21189#new)
nice one! Any chance to share it with us? :)
New version finally:
* Totally rewritten
* Uses a lot of code stolen from SMF ;)
* 1 query only
* You wont see messages from boards you don't have permission to access
Whatever you mod does, it has destroyed by board.
I clicked proceed because everything tested fully, then it gave me a database error.
I went into a topic to see if everything is ok, but now I get this:
Can't find FULLTEXT index matching the column list
File: /home/tscar/public_html/board/Sources/Display.php
Line: 105
I Checked the modded files, and the change didnt even happen.
What do I do now to get my forum posts back? I need it done quick..
ALTER TABLE {$db_prefix}messages ADD FULLTEXT related (subject, body)
Did you get any errors? Check error log. So I can fix this.
8: Undefined index: related
File: /home/xxxx/public_html/board/Themes/default/Display.template.php (eval?)
Line: 673
I fixed it by replacing the Display.php file.
i tried to install it on easyphp/localhost but get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key_name = 'related'' at line 1
File:
Line:
Quote from: denislici on December 04, 2006, 05:01:16 AM
i tried to install it on easyphp/localhost but get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key_name = 'related'' at line 1
File:
Line:
yup, same problem here.
Except I have the File and Line numbers
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key_name = 'related'' at line 1
File: /home/blogaaja/public_html/helpdeskfin/Packages/temp/related_topics.php
Line: 2
Why... THE HELL!
Did it screw up my forums?
When it didnt even install?
It just brought up an error about your RETARDED SQL call...
Honestly mate?
If you make a script, test it b4 releasing it.
It's immensely awful.
Can you please tell me exactly what it modified, If anything so i can revert the changes
Yeah people should NOT download this... it's unstable
Quote from: augrunt on December 04, 2006, 07:47:27 AM
Why... THE HELL!
Did it screw up my forums?
When it didnt even install?
It just brought up an error about your RETARDED SQL call...
Honestly mate?
If you make a script, test it b4 releasing it.
It's immensely awful.
Can you please tell me exactly what it modified, If anything so i can revert the changes
I tested it with three different forums all worked ok.
You have your backups, don't you? you have original files? you have mod file you can use as reference for editing?
Uploaded new version with fix
Anyone test the new version? The last one hosed mine pretty heavily even though I didn't click proceed it still wrote stuff. Fortunately I had backups. *wipes brow*
You saved my day.
This mod was originally a concept of a modder from IPB, and vB and a phpBB modder adopted it ;)
I will test this when I get the time. I have to update two of my SMF forums to 1.1 still, then will work on migrating another IPB2.0.0 forum to SMF 1.1 after that.
:)
I installed it and it didn't kill my forum, but where is it supposed to appear?
What the f....
You have an error in your SQL syntax near 'ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN smf_topics AS t ON (t.ID_TOPIC = ms2.ID_T' at line 14
Tiedosto: /home/vhosts/markohosting.net/httpdocs/forum/Sources/Display.php
Rivi: 105
And it comes when I installed this mod and try to watch a message...
Quote from: Mazeman on December 05, 2006, 02:15:06 PM
What the f....
You have an error in your SQL syntax near 'ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN smf_topics AS t ON (t.ID_TOPIC = ms2.ID_T' at line 14
Tiedosto: /home/vhosts/markohosting.net/httpdocs/forum/Sources/Display.php
Rivi: 105
And it comes when I installed this mod and try to watch a message...
Which MySQL version your host has?
I have tested with 4.1.21 (standard and log) and 5.0.27-standard
Since code is pretty much copied from smf message index it should work...
Where is this mod supposed to appear? It installed successfully but hasn't appeared anywhere???
Quote from: L.G.S on December 05, 2006, 03:53:09 PM
Where is this mod supposed to appear? It installed successfully but hasn't appeared anywhere???
Do you use default theme?
It should appear under messages
And it won't appear if message doesn't have related topics.
see Display.template.php and find related it should be at bottom.
For different themes just get code from messageindex and replace
foreach ($context['topics'] as $topic) with $context['related'] as $topic edit header and footer so it works put whole code in if (count($context['related']) > 0)
{
... code ...
}
I use a custom theme that uses the default template and english files, so it should be showing ?????????
I looked in the default theme as well, not there either.
And Sql server is old :o and I can't change that to newer cause it isn't my server :(
3.23.58 is the version what PhpMyAdmin shows.
Here is the SQL query what is causing the prob.
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
" . ($user_info['is_guest'] ? '0' : 'IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1') . " AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM {$db_prefix}messages AS ms2
JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC = ms2.ID_TOPIC)
JOIN {$db_prefix}messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
JOIN {$db_prefix}messages AS mf ON (mf.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)" . ($user_info['is_guest'] ? '' : "
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject') AND NOT t.ID_TOPIC = $topic
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('$subject')
LIMIT 0,5", __FILE__, __LINE__);
Edit: Wrong code was there :(
But now that's the right one.
Can you try replacing it with this
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
" . ($user_info['is_guest'] ? '0' : 'IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1') . " AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM ({$db_prefix}messages AS ms2, {$db_prefix}boards AS b, {$db_prefix}topics AS t, {$db_prefix}messages AS ml, {$db_prefix}messages AS mf)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)" . ($user_info['is_guest'] ? '' : "
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE b.ID_BOARD = ms2.ID_BOARD AND t.ID_TOPIC = ms2.ID_TOPIC
AND ml.ID_MSG = t.ID_LAST_MSG AND mf.ID_MSG = t.ID_FIRST_MSG
AND $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject') AND NOT t.ID_TOPIC = $topic
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('$subject')
LIMIT 0,5", __FILE__, __LINE__);
of course you can ask your host to update mysql but I think I should make this mod work with MySQL 3.x
Now the error is gone. But I cant see any related topics and I even have topics with same name...
Do you have code in Display.template.php?
if not add
if (count($context['related']) > 0)
{
echo '
<div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;"' : '', '>
<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
<tr>
<td width="9%" colspan="2" class="catbg3"></td>
<td class="catbg3">', $txt[70],'</td>
<td class="catbg3">', $txt[109],'</td>
<td class="catbg3">', $txt[110],'</td>
<td class="catbg3">', $txt[301],'</td>
<td class="catbg3">', $txt[111],'</td>
</tr>';
foreach ($context['related'] as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));
echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="5%">
<img src="', $settings['images_url'], '/topic/', $topic['class'], '.gif" alt="" />
</td>
<td class="windowbg2" valign="middle" align="center" width="4%">
<img src="', $topic['first_post']['icon_url'], '" alt="" />
</td>
<td class="windowbg' , !empty($settings['seperate_sticky_lock']) && $topic['is_sticky'] ? '3' : '' , '" valign="middle" ', (!empty($topic['quick_mod']['remove']) ? 'id="topic_' . $topic['first_post']['id'] . '" onmouseout="mouse_on_div = 0;" onmouseover="mouse_on_div = 1;" ondblclick="modify_topic(\'' . $topic['id'] . '\', \'' . $topic['first_post']['id'] . '\', \'' . $context['session_id'] . '\');"' : ''), '>';
if (!empty($settings['seperate_sticky_lock']))
echo '
' , $topic['is_locked'] ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" id="lockicon' . $topic['first_post']['id'] . '" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" id="stickyicon' . $topic['first_post']['id'] . '" style="margin: 0;" />' : '';
echo '
', $topic['is_sticky'] ? '<b>' : '' , '<span id="msg_' . $topic['first_post']['id'] . '">', $topic['first_post']['link'], '</span>', $topic['is_sticky'] ? '</b>' : '';
// Is this topic new? (assuming they are logged in!)
if ($topic['new'] && $context['user']['is_logged'])
echo '
<a href="', $topic['new_href'], '" id="newicon' . $topic['first_post']['id'] . '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
echo '
<small id="pages' . $topic['first_post']['id'] . '">', $topic['pages'], '</small>
</td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '
</td>
<td class="windowbg' , $topic['is_sticky'] ? '3' : '' , '" valign="middle" width="4%" align="center">
', $topic['replies'], '
</td>
<td class="windowbg' , $topic['is_sticky'] ? '3' : '' , '" valign="middle" width="4%" align="center">
', $topic['views'], '
</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>';
echo '
</tr>';
}
echo '
</table>
</div>';
}
before
if ($context['show_spellchecking']) at almost end of file.
yup, the code is there.
But nothing...
Then it's not recognized by MySQL as related, it will search by subject from subject and body.
Quote from: Niko on December 06, 2006, 06:06:03 AM
Then it's not recognized by MySQL as related, it will search by subject from subject and body.
So what I should do?
Delete the mod and let it be?
Or write my own mod, that does the trick 8)
Eventually there will be topics that are related. I don't exactly know how it is calculated but from original message only topic is used to find related topics using MySQL's own function MATCH AGAINST.
Words that appear in post very often are not taken into count. Words under 4 characters are also excluded from index unless mysql config is configured to smaller limit
so what's the point in making this mod if you don't even know when it will work? None of my threads have shown related topics yet, and I've checked most of them.
Doubt the IPB and VB ones make you guess when they will start working ???
Quote from: L.G.S on December 06, 2006, 10:44:48 AM
so what's the point in making this mod if you don't even know when it will work? None of my threads have shown related topics yet, and I've checked most of them.
Doubt the IPB and VB ones make you guess when they will start working ???
Why would you have guess? It will work when theres topics that are related. Words most not be usually used.
if 1/2 posts have word "mysql" it won't be used. php will be never used on default mysql settings.
Actually this is very similar to how vbulletin does this.
if you want exactly how vbulletin does
replace
AND $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject') AND NOT t.ID_TOPIC = $topic
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('$subject')
with
AND $user_info[query_see_board] AND MATCH(ms2.subject) AGAINST('$subject') AND NOT t.ID_TOPIC = $topic
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject) AGAINST('$subject')
And make fulltext index for subject
Yes and what will that do?
I've been through at least 100 topics which seem to be the most original, and none of them have given me related topics. What's the point in having it if it's only EXACT related topics, which will probably never be found
it's not does not need to be exact to be found as related.
I have no problems finding topics with related topics at forum with 177 topics.
Subject must have words that are in appear less than < 1/2 posts and are not stopwords
See: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html for more information.
Did you try making it only use subject like I told you in previous post?
Sorry I did not mean to be rude towards you.
How do I make the modification?
Hmmm... . I tried this on a development version of the forum on daniel15.com, but the posts it finds seem to be completely unrelated (they just have very common words in them, like 'SMFShop').
Any way to make it return... "better" results?
P.S Yeah, I do understand that it's probably a limitation of the MySQL FULLTEXT engine.
Sorry must be having a real thick day...
Where does this show up and how do i get it to work, i've installed it no problem but unlike most mods i can't see where its supposed to be visable...
QuoteWhere does this show up and how do i get it to work, i've installed it no problem but unlike most mods i can't see where its supposed to be visable...
If there's any posts related to the current one, they will appear underneath the last post in the topic (or under the Quick Reply, if you have it enabled). Check your default theme.
If you're using a different theme, you'll need to edit the Display.template.php file for that theme.
Quote from: Daniel15 on December 07, 2006, 07:52:14 PM
QuoteWhere does this show up and how do i get it to work, i've installed it no problem but unlike most mods i can't see where its supposed to be visable...
If there's any posts related to the current one, they will appear underneath the last post in the topic (or under the Quick Reply, if you have it enabled). Check your default theme.
If you're using a different theme, you'll need to edit the Display.template.php file for that theme.
Ah right okay...Thought i was having a Blonde moment or something...
Any idea what i'm looking for as i'm kinda new to all this (Using the Helios_Multi Theme)...Thanks for any help...
Probably have a big chance of nothing appearing at all.
Curious, any chance to use the "Custom Index" instead??
Thanks!
Quote from: Laibeus Lord on December 09, 2006, 06:41:28 AM
Curious, any chance to use the "Custom Index" instead??
Thanks!
I don't think so. It would require whole different start point.
Quote from: Niko on December 05, 2006, 04:07:39 PM
see Display.template.php and find related it should be at bottom.
For different themes just get code from messageindex and replace
foreach ($context['topics'] as $topic) with $context['related'] as $topic edit header and footer so it works put whole code in if (count($context['related']) > 0)
{
... code ...
}
Sorry where should i be looking for this bit?? Here's the bottam bit of my Display.template.php. What should i be adding and where??
function theme_show_mod_buttons()
{
global $context, $settings, $options, $txt, $scripturl, $modSettings;
$moderationButtons = array();
if ($context['can_move'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=movetopic;topic=' . $context['current_topic'] . '.0">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/admin_move.gif" alt="' . $txt[132] . '" border="0" />' : $txt[132]) . '</a>';
if ($context['can_delete'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=removetopic2;topic=' . $context['current_topic'] . '.0;sesc=' . $context['session_id'] . '" onclick="return confirm(\'' . $txt[162] . '\');">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/admin_rem.gif" alt="' . $txt[63] . '" border="0" />' : $txt[63]) . '</a>';
if ($context['can_lock'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=lock;topic=' . $context['current_topic'] . '.' . $context['start'] . ';sesc=' . $context['session_id'] . '">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/admin_lock.gif" alt="' . (empty($context['is_locked']) ? $txt['smf279'] : $txt['smf280']) . '" border="0" />' : (empty($context['is_locked']) ? $txt['smf279'] : $txt['smf280'])) . '</a>';
if ($context['can_sticky'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=sticky;topic=' . $context['current_topic'] . '.' . $context['start'] . ';sesc=' . $context['session_id'] . '">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/admin_sticky.gif" alt="' . (empty($context['is_sticky']) ? $txt['smf277'] : $txt['smf278']) . '" border="0" />' : (empty($context['is_sticky']) ? $txt['smf277'] : $txt['smf278'])) . '</a>';
if ($context['can_merge'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=mergetopics;board=' . $context['current_board'] . '.0;from=' . $context['current_topic'] . '">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/merge.gif" alt="' . $txt['smf252'] . '" border="0" />' : $txt['smf252']) . '</a>';
if ($context['can_remove_poll'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=removepoll;topic=' . $context['current_topic'] . '.' . $context['start'] . '" onclick="return confirm(\'' . $txt['poll_remove_warn'] . '\');">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/admin_remove_poll.gif" alt="' . $txt['poll_remove'] . '" border="0" />' : $txt['poll_remove']) . '</a>';
if ($context['calendar_post'])
$moderationButtons[] = '<a href="' . $scripturl . '?action=post;calendar;msg=' . $context['topic_first_message'] . ';topic=' . $context['current_topic'] . '.0;sesc=' . $context['session_id'] . '">' . ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/linktocal.gif" alt="' . $txt['calendar37'] . '" border="0" />' : $txt['calendar37']) . '</a>';
if ($context['can_remove_post'] && !empty($options['display_quick_mod']) && $options['display_quick_mod'] == 1)
$moderationButtons[] = $settings['use_image_buttons'] ? '<input type="image" name="submit" id="quickmodSubmit" src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/delete_selected.gif" alt="' . $txt['quickmod_delete_selected'] . '" onclick="return confirm(\'' . $txt['quickmod_confirm'] . '\');" />' : '<a href="javascript:document.forms.quickModForm.submit();" onclick="return confirm(\'' . $txt['quickmod_confirm'] . '\');" id="quickmodSubmit">' . $txt['quickmod_delete_selected'] . '</a>';
return implode($context['menu_separator'], $moderationButtons);
}
?>
Working perfectly for me on 1.1 final with several mods installed:
Mod Name Version
1. Ad Managment 2.0 [ Uninstall ] [ List Files ] [ Delete ]
2. cbi, 1.0 1.0 [ Uninstall ] [ List Files ] [ Delete ]
3. Gender On Registration 1.0 [ Uninstall ] [ List Files ] [ Delete ]
4. Member posts recount 0.5 [ Uninstall ] [ List Files ] [ Delete ]
5. Reg Bar 1.0 [ Uninstall ] [ List Files ] [ Delete ]
6. Seo 4 SMF 0.2 [ Uninstall ] [ List Files ] [ Delete ]
7. Simple Blog 1.4.1 [ Uninstall ] [ List Files ] [ Delete ]
8. Spoiler Tag 0.3.0 [ Uninstall ] [ List Files ] [ Delete ]
9. Related Topics 1.1.1 [ Uninstall ] [ List Files ] [ Delete ]
The only think Iam missing is Related topic text.
I can see window filled with related topics but above it, I would need some txt so users would know that bellow are related topics.
If someone could tell me where to add it I would realy appriciate it.
So when are my related topics going to appear.. it's been over a week now
Quote from: L.G.S on December 12, 2006, 02:08:19 PM
So when are my related topics going to appear.. it's been over a week now
I'm wondering the same thing...
Quote from: IKShadow on December 12, 2006, 01:42:58 PM
The only think Iam missing is Related topic text.
I can see window filled with related topics but above it, I would need some txt so users would know that bellow are related topics.
If someone could tell me where to add it I would realy appriciate it.
Will fix this to new version but you can just add
(i didn't test this)
<tr>
<td class="titlebg" colspan="7">Related topics</td>
</tr>
Quote from: Mazeman on December 12, 2006, 02:23:06 PM
Quote from: L.G.S on December 12, 2006, 02:08:19 PM
So when are my related topics going to appear.. it's been over a week now
I'm wondering the same thing...
Like I said there needs to be posts that have few same words that are not usual (in 50% messages/subjects).
This cannot be affected by me, its MySQL thing.
Well what can we do to change it.. why cant we have an admin panel which we can select a % of the same topic to show or something.. I tried the IPB mod for this and it starts straight away.
hehe we would realy need some expanation how this FTI related thing works.
I dont belive we can set % how much related topic should be to show.
My forum is quite new ( Idid not transfer 150K of posts and 1.5K of users from the old phpbb one, we needed one fresh start ) but related topics worked immediately , and I have only 2K of posts and 100 users now.
I guess the problems you have its completly MYSQL FTI related, try to do manual FTI QUERY for related topics thingy. ( dunno sql statement, but someone will post it )
Is there a limit how many related topics will show, I dont want after few months to have list of 50 topics bellow.
p.s. Niko: The Related Topic text worked perfectly .
would this mod work with a non english forum correctly
im using french
Quote from: mgaidia on December 16, 2006, 07:40:38 PM
would this mod work with a non english forum correctly
im using french
off course , its uses mysql full text index function that looks for similar words.
p.s. Iam using it on non english forum.
Hi
I´m very interested in this mod and installed it first locally and then on my webserver. Unfortunately it doesen´t work on both.
I have at both servers SMF 1.1 with approx. 2900 topic and 27000 posts.
DB is mysql. Server Version: 4.1.21-standard
the table type is MyISAM, and the collation is "latin1_swedish_ci" (I don´t know why - tried to convert it to UTF-8, but made problems with äöü and recent topic function did not work also)
I tried it with the standard theme (english) and with my adapted customized theme (english & german).
I was not quite sure if I have to switch before installing to the "fulltext search" and create an index (it´s a creation only on the "subject" i have seen). but then the index is created 2 times and the DB is quite large.
or
if I have to leave it on "no index", install the mod. during installation, an index on "subject" and "body" is created.
with both versions I have had no luck.
I was wondering, why for the standard fulltext search creates only an index on the "subject" but works with the body text as well!?
=> is there a way to test the query manually e.g. in phpmyadmin?
this mod seems really quite interesting, but if it doesn´t work....hmm
=> what can be the reason/problem?
thanks for infos and help,
Patxi
will it work on forums with the "Custom index" method ?
Quote from: Enc0der on December 22, 2006, 07:37:09 AM
will it work on forums with the "Custom index" method ?
Maybe not, coz when my other forum was setup to the other two options, the mod was looking for the full text index function, so I ended up with 2 indexes. I decided to delete the one I'm not going to use in favor of the full-text index, since this is what the mod is looking for.
But then again I am not sure, that's just what I noticed.
great mod , i just install it on my forum , the installation is ok , but the mod doesn't works , is it possible to install it manually ?
p.s.
sorry for my english.
The mod probably will never show up then..
it will work automatically, you dont need to cofigure anything
Been just about a month for me, still nothing. Don't expect it to come if its going to take this long..
mod installed fine but it doesn't show related topics , what i should fix ? should i enable it from admin cp ?
Quote
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM rr_messages AS ms2
JOIN rr_boards AS b ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN rr_topics AS t ON (t.ID_TOPIC = ms2.ID_TOPIC)
JOIN rr_messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
JOIN rr_messages AS mf ON (mf.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN rr_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN rr_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)
LEFT JOIN rr_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 1)
LEFT JOIN rr_log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = 1)
WHERE 1 AND MATCH(ms2.subject, ms2.body) AGAINST('test') AND NOT t.ID_TOPIC = 27
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('test')
i just run this sql query on my smf database with 3 identical topics with subject "
test" and query result return 0 rows from table ,why ? i have 3 absolutely similar topics with same subject and same text.
Quote from: wudzzy on January 03, 2007, 03:48:59 AM
i just run this sql query on my smf database with 3 identical topics with subject "test" and query result return 0 rows from table ,why ?
You already answered to your question:
Quote from: wudzzy on January 03, 2007, 03:48:59 AM
i have 3 absolutely similar topics with same subject and same text.
Heres more information:
You can get statistics using myisam_ftdump (http://dev.mysql.com/doc/refman/4.1/en/myisam-ftdump.html)
Quote
Total rows: 14217
Total words: 373787
Unique words: 107873
Longest word: 166 chars (â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤â¤)
Median length: 8
Average global weight: 8.973130
Most common word: 4899 times, weight: 0.642917 (mutta)
You can use -c to check words stats:
Quote
372 3.6167856 kiitos
1 9.5621234 kiitosei
2 8.8689058 kiitosh
2 8.8689058 kiitoskiitos
1 9.5621234 kiitoskiitoskiitoskiitos
1 9.5621234 kiitoskun
7 7.6157911 kiitosta
3 8.4633704 kiits
count - weight - word. As you see more often word is mentiened less weight it has.
More information on fulltext search:
http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
Quote from: Niko on January 03, 2007, 05:09:26 AM
You already answered to your question:
no , i mean : forum have 3 similar topics with same subject and message body , but Related Topcis script doesn't show it as related.
I added more information to me previous message.
it is because words have no weight because they appear too often. You can't have related topics when every message is exactly same. it is MySQL limitation not related topics.
thanks Niko for fast reply.
please look at my attachment , my table have 3 fulltext indexes : body , subject , related. is this ok ?
Thanks wudzzy! With your SQL link I played a bit around and found the Error! Now it works on my forum!
Quote from: wudzzy on January 03, 2007, 03:48:59 AM
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM rr_messages AS ms2
JOIN rr_boards AS b ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN rr_topics AS t ON (t.ID_TOPIC = ms2.ID_TOPIC)
JOIN rr_messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
JOIN rr_messages AS mf ON (mf.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN rr_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN rr_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)
LEFT JOIN rr_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 1)
LEFT JOIN rr_log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = 1)
WHERE 1 AND MATCH(ms2.subject, ms2.body) AGAINST('test') AND NOT t.ID_TOPIC = 27
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('test')
it was just a simple thing:
add () in the SQL statement WHERE part. that´s it.
so I used:
WHERE NOT
(t.ID_TOPIC = $topic) AND $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject')
instead of
WHERE $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject') AND NOT
t.ID_TOPIC = $topic
the second thing I regognized is that propably the sort order is the other way round. if I leave the LIMIT and leave the NOT (t.ID_TOPIC = $topic) then the original topic is the last one. I guess it should be the first one. And I think the lower topics are more related to the original topic. Thus I DESC the order:
instead of
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('$subject')I wrote
ORDER BY (MATCH(ms2.subject, ms2.body) AGAINST('$subject')) DESChave you the same experience? or is it wrong?
my full SQL query looks now like this:
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
" . ($user_info['is_guest'] ? '0' : 'IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1') . " AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM {$db_prefix}messages AS ms2
JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC = ms2.ID_TOPIC)
JOIN {$db_prefix}messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
JOIN {$db_prefix}messages AS mf ON (mf.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)" . ($user_info['is_guest'] ? '' : "
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE NOT (t.ID_TOPIC = $topic) AND $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject')
GROUP BY ID_TOPIC
ORDER BY (MATCH(ms2.subject, ms2.body) AGAINST('$subject')) DESC
LIMIT 0,5", __FILE__, __LINE__);
Hopefully this helps some SMF users who want this really nice mod!
Patxi
any update on this dear Niko? ;)
I have never see this mod return any results and I have 50,000+ messages. any way to verify it's functioning correctly?
why don´t you read the message above and try it on your forum? use for example phpmyadmin to execute the sql-command from wudzzy with changes of my message from above.
Can someone--anyone--give us an example of something that SHOULD work. Like so many others (and really, we can't ALL be nuts), I CANNOT get this mod to display any related topics. I'm using a base, clean install. I'm using 1.1.1. I'm using the default template. I've set the "Fulltext index" option in the Admin area. This is the ONLY mod installed.
I created a topic with subject "purple monkey dishwasher 1" and message "purple monkey dishwasher". I created a second topic with subject "purple monkey dishwasher 2" and message "purple monkey dishwasher". The 1 doesn't show 2 as related and vice versa.
If that's not something that should appear in related topics, I don't know what is.
So please explain to us foolish imebiciles, O confident proponents of this mod, what SHOULD work? Give us an EXACT subject and message of two topics that should come up as related.
Or show me a working demo OF A SPECIFIC TOPIC, because none of the supposed demo links I've found in this topic show any related topics either. Some don't even show forums, just a bunch of crap pop-up ads.
Quote from: Patxi on January 10, 2007, 08:46:48 AM
why don´t you read the message above and try it on your forum? use for example phpmyadmin to execute the sql-command from wudzzy with changes of my message from above.
Patxi, it seems you made it worked. Kindly can you share it step by step?
Hello every one !
Thanks a lot Niko for your Mod. It had faced some difficulties installing it but it works fine now on my forum !
As a proof, here is my forum home page : http://www.voyage-net.com/forum/index.php (yes, it's French). There are related topics below almost all topics.
To go through the installation, I had to process step by step, manualy :
1/
Use PHPmyAdmin to create the Fulltext Indexes of subject and body columns in smf_messages table. Create also a "related" fulltext index by copying the request from "related_topics.php".
Something linke that :
ALTER TABLE {$db_prefix}messages
ADD FULLTEXT related (subject, body)
Of course, replace {$db_prefix} by the right prefix
2/
Modify source/Display.php according to what is suggested in install.xml (2 modifications in this file). Beware, keep a backup ;)
3/
Modify /Themes/Your_Theme/Display.template.php according to what is suggested in install.xml
=> It should works now! If you have the courage, you can then customize the design through Display.template.php ;)
Thanks again Niko. You work freely for us and I cannot understand people who believe they have the right to behave as "paying clients"...
OK now I saw a working installation on this... it looks good! :D
i will try it now on my test boards.
Quote from: Patxi on January 04, 2007, 09:18:11 AM
my full SQL query looks now like this:
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
" . ($user_info['is_guest'] ? '0' : 'IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1') . " AS new_from,
t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
mf.smileysEnabled AS firstSmileys, b.ID_BOARD, b.name
FROM {$db_prefix}messages AS ms2
JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC = ms2.ID_TOPIC)
JOIN {$db_prefix}messages AS ml ON (ml.ID_MSG = t.ID_LAST_MSG)
JOIN {$db_prefix}messages AS mf ON (mf.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)" . ($user_info['is_guest'] ? '' : "
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE NOT (t.ID_TOPIC = $topic) AND $user_info[query_see_board] AND MATCH(ms2.subject, ms2.body) AGAINST('$subject')
GROUP BY ID_TOPIC
ORDER BY (MATCH(ms2.subject, ms2.body) AGAINST('$subject')) DESC
LIMIT 0,5", __FILE__, __LINE__);
The SQL as is on this is fine but if you change "LIMIT 0,5" to "LIMIT 5" it will speed up the loading of the related topics significantly without affecting the returned results.
what's the status here? does it work or not?? mine installation doesn't :'(
I modified all the stuff described here and also enabled fulltext index as a search method... but nothing happens... it looks as the list of related topics is empty whiel trying to display it and gets filled too late??
FYI:
i am on RC3 whit all kind of mods installed... maybe there's a problem ???
Works with above modifications on 1.1.1. Thx everyone for the useful input!
At this moment the related topic function is working great on my forum. BUT....
It also shows topics from hidden boards, or boards where users don't have a permission
How can I exclude certain boards for the related topic function??
Regards,
Peter
What do I need to do to remove this mod fully?
I removed the code but I'm still getting errors, I think its because of the database changes. I had the original version of the mod, what would I need to do to get the database changes out?
I got it to work on 1.1.2 by following instructions in posts above, thanks guys.
But... one big problem.. it just shows completely random un-related topics. ...?!
After so much time spent on it, it just gives me the opposite of what I wanted. :(
A pity that this mod isn't working!
actually it is, just the keywords it takes in are sometimes-mostly not the right ones you'd expect.
There are version mod for smf 1.1.2 ?
Thanks
work the last version in rc2? i installed but dont show nothing in default theme :(
I've tried to install this mod again but no luck! ... can anyone simplify this manual process, please?
Hi,
I installed on 1.1.2 but it shows totally unrelated topics.
Is there a way to fix this (rise the level of concordace?)
Best regards,
CArla
I installed it on 1.1.1 and it doesn't show anything at all... I tried the manual installion but the database quiery shows an error!
It'll be great to have this mod working...
hwy I installed this mode AGAIN on 1.1.2 but nothing is showing. What do I have to do?
Since yesterday i work many hours to get this mod to work in SMF 1.1.2
No chance - first time i stuck completely with get a mod to work - since the god old Yabb :-[
Could someone port this mod for SMF 1.1.2? This would be very nice :)
No updates in the near future :'( ???
I've made the changes as suggested above and got it working on a clean version of 1.1.2.
1. Installed the modified version of the mod (which I hope Niko and everyone don't mind I created from their mod and tips respectively)
2. Admin > Search > Search Method
- Set to FULL TEXT
Posted some topics.
I've got the topics to show, but not always relevant. C'est la vie
Hi karlbenson,
thanks for this modification - it workes great on 1.1.2
But I think the position of the related topic should be over the first posting and with a headline formatted with the class titlebg. I added this mod at http://www.mkportal-support.de
Andreas
QuoteDatenbankfehler
You have an error in your SQL syntax near 'ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN yabbse_topics AS t ON (t.ID_TOPIC = ms2.I' at line 14
Datei: C:\Inetpub\domainname\forum\Sources\Display.php
Zeile: 105
I run into trouble, with your Version, karlbenson :'(
Do you have an idea how i could fix it?
Line 105 is marked red ;)
QuoteGROUP BY ID_TOPIC
ORDER BY (MATCH(ms2.subject, ms2.body) AGAINST('$subject')) DESC
LIMIT 5", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
Hope you could fix this issue.. It happens, when i want open/read a thread :'(
what version of smf are you running?
the actuall official Version, 1.1.2 ;)
following Mods are installed:
Modifikationen
Mod Name Mod Version
1. Hide Post 1.0.8 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
2. Moderator Activity Report for SMF1.1.2 1.2 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
3. Related Topics 1.1.1 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
4. Save PM as HTML 1.0.2 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
5. Group Moderators 1.4 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
8. SMF Arcade 2.0.8 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
9. SMF Arcade Trophies Mod 1.1.1 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
10. Users Online Today Mod 1.4.0 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
11. vMoveTopic Notify by PM 0.90 [ Deinstallieren ] [ Dateien auflisten ] [ Löschen ]
12. Who Voted What? 1.1.2
Unfortunately I've tested the version I posted twice on 2 clean versions of smf 1.1.2 without a single error.
:(
It looks like theres a problem. You could try reinstalling the mod.
Other than that it looks like it won't work with your current configuration/mods.
i know you tested on a clean Version. I checked out the code of each installed mod, to see which one look @ Display.php
Only 3 Mods are alter this file:
-related topics
-who polled what
-hide Post
I couldnt find the part which makes trouble, and try to alter a clean Display.php which only the related topic mod - also i run in errors :'(
Could you give me your Display.php? Then i try to manually add the two other mods (who polled what and hide Post) maybee i get it this way to work :)
Please tell me too, if you have other Mods installed, that alter your Display.php
Thanks for helping me :-*
I didnt have any mods installed.
I've gone through both of those modifications and they don't appear to effect that part.
Quote from: karlbenson on June 03, 2007, 10:16:04 AM
I didnt have any mods installed.
I've gone through both of those modifications and they don't appear to effect that part.
Thank you for testing the changes each mod are doing!
What else could be gone wrong? Could you attach your Display.php, that i could try if it would work?
Surfy
I'll just have to setup another clean install.
Give me a couple of minutes
Ok heres my display.php and display.template.php
You'll need to perform edits on both these files for your other modifications.
To bad, i run into the same trouble than bevore:
You have an error in your SQL syntax near 'ON (b.ID_BOARD = ms2.ID_BOARD)
JOIN yabbse_topics AS t ON (t.ID_TOPIC = ms2.' at line 14
Datei: C:\Inetpub\mydomain\forum\Sources\Display.php
Zeile: 105
I havent changed anything, only want to see, that at first the related-topic mod works
Ohh, one thing i see:
the related_topics.php file wasnt copied to the source folder, during Package-Manager installation :)
But still smf doenst like
QuoteGROUP BY ID_TOPIC
ORDER BY (MATCH(ms2.subject, ms2.body) AGAINST('$subject')) DESC
LIMIT 5", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
Maybee an MySql Problem? I use 3.2.2 of MySQL
possibly, thats a very old version of mysql.
I'm running on 5.0.2 using xammp lite
Even on my server I'm running 4.3
related_topics.php installs the mysql database change. it doesnt contain any functions (those are added to display.php)
I think you have two choices - upgrade mysql or don't use this mod. :(
sorry about that
I`ll try under MysQL 5.0 in my VMware Server, and reports the results :)
I have this working on 1.1.2 but it doesn't show up when i view the forum via a integration script.
I would love to use this mod for it, although i'm not sure what causes this to happen. any suggestions?
~Kerrang!
I have istalled this MOD. It works in the default theme but I cant get it to work in the custom theme I use. What can I do???
you need to make all the modifications to the 'template' files.
Hi, I have SMF 1.2 with Tiny Portal 0.97 and SoftMC_Blue as theme.
I had a really hard time trying to figure out how to install this mod, I wonder if anyone can help me.
hi
I need some preview images of what the mod looks like when being used ?
any link or image ...
regards.
Hmmm....
any preview image or demo? !
Quote from: lonrot on June 21, 2007, 02:22:30 PM
Hi, I have SMF 1.2 with Tiny Portal 0.98 and SoftMC_Blue as theme.
I had a really hard time trying to figure out how to install this mod, I wonder if anyone can help me.
Please help me.
anybody out there?
Cannot see any change in my forum. Tried default theme, added index in my messages table...nothing...
This is my Theme:
http://custom.simplemachines.org/themes/index.php?lemma=166
Help pretty please!
Niko can you make this mod to work with SMF 1.3 ?
I have sent you a PM I hope you can reply.
I can't find a topic which has the recent topics >:(
Hey, there is a bug in the query in display.php.
The Order has to be sorted by DESC:
ORDER BY MATCH(ms2.subject, ms2.body) AGAINST('$subject') DESC
With no modify this - you get the badest result and not the best.
I always wonder why I get related topic that seems not to fit to the subject.
You get much more better results if only the subject is part in the match:
...
WHERE $user_info[query_see_board] AND MATCH(ms2.subject, ms2.subject) AGAINST('$subject') AND NOT t.ID_TOPIC = $topic
GROUP BY ID_TOPIC
ORDER BY MATCH(ms2.subject, ms2.subject) AGAINST('$subject') DESC
I've installed everything but I dont see anything at the bottom of my topics with related topics. I also dont receive errors. Do I have to enable this somewhere?
Just a heads up for those who are just now finding this thread / learning about this modification.
I installed the original attachment found in the opening post, related_topics_1.1.1.zip, and it did not work and required extra database steps not included in any instructions, and still it would not work.
Then I came here to the last page (as of now) and didn't see anything useful, so I began on page 2 and went through each page, following advice from many different members. Thanks for all that hard work, but unfortunately none of the suggestions on pages 2-9 did me any good.
Then, FINALLY, at Page 10, Reply #189 (http://www.simplemachines.org/community/index.php?topic=49410.msg1111567#msg1111567), I found a fix that works. Thankyou so much karlbenson!!
I am using SMF 1.1.2 with a default theme that I've done a lot of custom mods to.
It also works on my test forum, which is a fresh install of SMF 1.1.3
Here is the download like for his modified package:
related_topics_1.1.1 (modified).zip (http://www.simplemachines.org/community/index.php?action=dlattach;topic=49410.0;attach=34287)
I NEVER like the modification processes, so I always install everything manually. Also lets me know how the script works and how the author did in writing it, which I enjoy.
Here is what I did to get this to work perfectly on SMF 1.1.2 and 1.1.3:
As always backup everything, your database and your original copies of the two files in step 2 & 3.
1) Get related_topics_1.1.1 (modified).zip (http://www.simplemachines.org/community/index.php?action=dlattach;topic=49410.0;attach=34287), extract, and review the file "install.xml"
2) Modify your Sources/Display.php file, two modifications required.
3) Modify your Themes/<theme>/Display.template.php file, one modification required.
4) Upload the file "related_topics.php" which was included in the ZIP to your Sources/ directory.
5) Enter your phpMyAdmin, select your database, click on the SQL tab to run a Query, and enter the following: "ALTER TABLE <prefix>messages ADD FULLTEXT related (subject, body)" where <prefix> is your table prefix if you created one. On a large forum this process will take a while.
6) Enter your Admin > Search > Search Method and create and enable the "Fulltext index". Also check the box for "Match whole words only" although I am not sure if this is required.
7) Finally, upload your files in steps 2 & 3 replacing your original files that you've already backed up.
8 ) Head to your forum and view any topic. Then, reload the same topic and see if there are any related threads listed below the last reply or shout box (if enabled which it should be :D)
HUGE thanks go out to Niko, Senkusha, kezayah, karlbenson, and anyone else who contributed to this mod. It is AWESOME and I hope it becomes a default feature in the future.
Regards,
BigMike
Ok, well, all of this work and I've decided to disable it right now.
My forum has over 700 combined users on it right now and it really put a huge load on my dedicated server.
On a single page load, it took my usual time from 0.11 seconds up to around 5 seconds.
On multiple page loads, like 10 in a row into new FireFox Tabs like always (the only way to work), it would go s-u-p-e-r slow and each page would take over 30 seconds to load.
So I am going to see if I can somehow prevent this script for activating until after the entire page is loaded. Then at the bottom it would say something like "Fetching Related Topics....." and then after 5 to 30 seconds, it would display the related topics.
This would not reduce the load on the server though, but it would allow pages to load up 99% before the increased load effected your view point.
BigMike
Following BigMikes comments.
I can confirm the exponentially increased load.
My forum has almost 350,000 posts, 20,000+ topics, 1600+members on a VPS/VDS server.
With this modification on my forum the load increased x300 (not 300%, 30000%)
Topics which took less than 0.1 seconds to be created took 30+ seconds.
I had to remove the modification as it was killing my forum, since then, all page times have gone back to normal
I wouldn't recommend people install this modification on medium/large or open/public forums.
---
Furthermore BigMike, regarding your suggestion to pre-fetch related topics, I do not believe that would help your community as a whole. The problem is the related topics search itself is VERY memory intensive, so it would slow down the pages for everyone else.
Moving forward, I think it may be an idea to reduce the searching capacity, possibly based on searching subject to subject or first posts only. It may not be as accurate, but it might be the only realistic way to use a related topics mod on large forums - question, how do big forums on other forum software do it much better and faster than this???
is there an example of this anywhere?
karlbenson: I was thinking about having a javascripted drop down box, much like the "Additional Options..." field on the reply/post template, in which once clicked on, it will run the search query and then display the results per user in an expanding div or span, whatever SMF uses.
This way, the search requests will only be called upon 1 at a time by real life individual members. This could also be restricted to members only to 1) reduce the amount of those potentially using the feature and 2) an extra incentive for lurking guests to finally make the jump to a member.
As for your suggestions regarding searching just the subject or the opening post, I think that would be a good idea. Is this how the VBB boards are doing it? It must be a huge load for their servers as well and yet they are doing ok as far as I can tell.
Regards,
BigMike
Quote from: shaiss on August 03, 2007, 03:54:06 PM
is there an example of this anywhere?
EDIT: I posted a link to my test forum, but then I remembered that my test forum does not allow guest viewing.
Here is a screen shot of the Related feature in action on a fresh 1.1.3 install:
Quote from: BigMike on August 06, 2007, 06:37:22 PM
I was thinking about having a javascripted drop down box, much like the "Additional Options..." field
Please review the following examples. I have not coded this, I simply modified the HTML for this example to illustrate my idea. The first image is the "Related Topics" field collapsed, the second image is the field expanded with the search in progress, and the third image shows the results of the search.
The idea is that no searching occurs until a user clicks on the "+ Related Topics..." link. Once this link is selected, then the database is searched for any related topics. Finally, after 5 or 10 seconds, or whatever, the results of the database search are displayed for the user to review.
This way hopefully far fewer Related Topic Searches are occurring at any given time.
So what do you guys think? Is this even possible?
That would be just awesome. I think the major problem of this modification is the bandwidth it "sucks" from the server, for too many topics.
If we could isolate this problem, requesting related topics only in some rare occasions, it would work just fine, I think.
Anyway, I don't know if it's possible because I don't know how to code PHP. But I hope someone hear our voices..
Is there a way to download this latest modifications? When will the mod be updated?
Quote from: guyverschuere on August 07, 2007, 02:03:36 AM
Is there a way to download this latest modifications? When will the mod be updated?
This mod was last updated on May 31st by karlbenson, and is available through the following link:
related_topics_1.1.1 (modified).zip (http://www.simplemachines.org/community/index.php?action=dlattach;topic=49410.0;attach=34287)
For installation instructions, I put together a step-by-step procedure on Page 11, Reply #218 (http://www.simplemachines.org/community/index.php?topic=49410.msg1167897#msg1167897)
So have you found a way of having users search for related topics or some other way of decreasing server load ?
Sounds a good mod, I have similar working in a wordpress news site. but my bandwidth is expensive so dont want heavy server loading.
I am willing to dive into some coding, but I first would like to know if I can run complex code from the template files? Other wise I'll need to learn how to make function calls across to the source files, which I am sure can't be too hard
@BigMike: Thanks, it works.
Quote from: BigMike on August 07, 2007, 05:51:44 PM
I am willing to dive into some coding, but I first would like to know if I can run complex code from the template files? Other wise I'll need to learn how to make function calls across to the source files, which I am sure can't be too hard
Just drown man. I'm pretty sure we can convince the mod's owner to add your update at SMF mods db.
ok, i didn't read all 12 pages and maybe someone suggest this already but-it would be much better if it colud be that related topics was just under topic title so when member write topic title , he get the list of similiar topic under box.
see
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.fotorola.com%2Fuploads%2F81aa2933c9.jpg&hash=cffa8d589d9d0d838c611d0da492535ec728e824) (http://www.fotorola.com/)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.fotorola.com%2Fuploads%2F103c76a41f.jpg&hash=b18cfda4398f6db33674c66c3efbaebabc2d1990) (http://www.fotorola.com/)
I think it is worked in ajax
Yes, that looks very nice.
Perhaps having an option as to where to display the Related Topics would be a good feature.
I personally prefer to have it at the bottom of a thread.
I like the green percentage bars :D
yes, it is from one of biggest serbian forum :)
There is one additional idea from me to speed up things a bit....
Once a user/guest (depends on who you allow it) has recieved the realted topics, it should be stored in some sort of cache (done by File or else) so that the next member/guest inside the same Thread, which will also search for realted topics, retrive that cached results....
A specificable "time to live" in addition to caching would also be nice
There is a Mod out there for mambo/joomla from which you can take some impressions, because file-storing cache works very well with it. The name is "page-cache by IRCmaxell (http://www.ircmaxell.com/downloads/joomla/components/joomla-page-caching/)"
I think caching would be the only solution for this ressource-eater.....
Regards, Christian
Here's new version of those who want to try it.
New features:
Settings to enable/disable, search method, count of how many related topics to show. Settings will be in Features and Options.
Search method allows you to choose between old fulltext and custom (which also uses fulltext).
Custom should work better as it saves results to database. Which prevents related topics disappearing. Currently there's no way to create custom index. (Replies will make results inaccurate).
Example: http://www.madjoki.com/smftest/index.php?board=1.0
IS the problem solved ? I fear it will zap my bandwidth ?
Also get an error
1. Extract File ./Sources/Subs-Related.php
2. Execute Modification ./Sources/ModSettings.php Test successful
3. Execute Modification ./Sources/RemoveTopic.php Test successful
4. Execute Modification ./Sources/Subs-Post.php Test successful
5. Execute Modification ./Sources/Display.php Test successful
6. Execute Modification ./Themes/default/Display.template.php Test failed
7. Execute Modification ./Themes/default/languages/Modifications.english.php Test successful
8. Execute Code related_topics.php
Quote from: Niko on August 18, 2007, 08:48:38 AM
Custom should work better as it saves results to database....
So this is some kind of "results-caching" as i mentioned above.......
So when 2.0 with that file-caching comes out, will it cache even that querys the results of related topics?
Regards, Christian
In a way, yes.
I have not yet updated related topics to work with 2.0, but there is no caching used apart from mysql table.
I updated this version (1.2 Beta 2) to use new method to use fulltext index (subjects are copied). It provides more accurate results as replies has almost always same subject and if there's some words used too many times, it won't be used.
To use this update to this from previous beta, you must drop table smf_related_topics. After that remove mod and install this. Then go to Features and Options and click "Build index for custom method" (or navigate to http://www.yourdomain.com/forum/index.php?action=related;sa=index;begin)
It will copy subjects to new table & run fulltext query against every topic and inserts results to smf_related_topics. It will cache only 25 relations as with no limits index was 6 MiB for 2800 topics. (About 150 k rows) Currently it uses 2 queries per topic view but I will reduce it to one.
I will think about caching also
Quote from: Farmacija on August 17, 2007, 11:34:33 AM
ok, i didn't read all 12 pages and maybe someone suggest this already but-it would be much better if it colud be that related topics was just under topic title so when member write topic title , he get the list of similiar topic under box.
see
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.fotorola.com%2Fuploads%2F81aa2933c9.jpg&hash=cffa8d589d9d0d838c611d0da492535ec728e824) (http://www.fotorola.com/)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.fotorola.com%2Fuploads%2F103c76a41f.jpg&hash=b18cfda4398f6db33674c66c3efbaebabc2d1990) (http://www.fotorola.com/)
I think it is worked in ajax
Good idea.
hm, i installed in on my test forum but there isn't any effect, i write just the same topic as one which exist from earlier??
WE NEED AN UPDATED AND ERROR FIXED VERSION OF THIS MOD! c`mon man...
everybody has 1.1.3. now and your mod is still old. i (and im sure lot more people) need this mod A LOT! can somebody help us please???
Quote from: PLAYBOY on August 18, 2007, 10:11:42 PM
WE NEED AN UPDATED AND ERROR FIXED VERSION OF THIS MOD! c`mon man...
everybody has 1.1.3. now and your mod is still old. i (and im sure lot more people) need this mod A LOT! can somebody help us please???
So? It works with 1.1.3 and last release was yesterday?
Heya,
quick question from me
I would love to have the topic subjects being bold, or at least a bit bigger than the category names, because in my theme (not default, build in myself) it's nearly the same sizes, so I would love to change that a bit
Could someone give some hints about this,
Just the subject needs to be bigger, or Bold, how can i change that everywhere, also when the topic is new, or sticky etc. etc. ;-)
Niko! Excellent!! I will be checking it out this week!
Many thanks for your time and effort! Much appreciated!
Regards,
BigMike
Receiving this error when installing!
An Error Has Occurred!
Hacking attempt...
Same error from me...
[Edit]
This is the error log:
Aplicar filtro: Mostrar solamente los mensajes de error con el mismo mensaje
Hacking attempt...
SELECT rs.id_topic, MATCH(rs.subject) AGAINST('Pet Shop Boys y Fangoria en el primer "cee' d Winter Festival"') AS score
FROM smf_related_subjects AS rs
WHERE MATCH(rs.subject) AGAINST('Pet Shop Boys y Fangoria en el primer "cee' d Winter Festival"')
ORDER BY MATCH(rs.subject) AGAINST('Pet Shop Boys y Fangoria en el primer "cee' d Winter Festival"') DESC
Archivo: /home/pajareo/public_html/Sources/Subs-Related.php
Línea: 360
May should be that ' in the topic subject wich causes the error ?
Fixed. Forgot to update last package after fixing this :(
Uninstall Beta 2 and install Beta 3 or upload new Subs-Related.php
Cool. Now installs ok, but how can I enable this mod to work with no-default theme?
Thanks in advance
Quote from: Niko on August 21, 2007, 08:00:51 AM
Fixed. Forgot to update last package after fixing this :(
Uninstall Beta 2 and install Beta 3 or upload new Subs-Related.php
Should I install this one while I have no problems?
and My other question is still not answered,
How can I make the topic subjects bold in the Related Topic area?
Got it: http://docs.simplemachines.org/index.php?topic=402.msg531#msg531 O:)
Quote from: Niko on August 21, 2007, 08:00:51 AM
Fixed. Forgot to update last package after fixing this :(
Uninstall Beta 2 and install Beta 3 or upload new Subs-Related.php
Installed fine. Working. Fantastic!
Thank you.
Works great for me too.
But tomorrow I'll write here about my bandwidth (lol)
all errors caused by different ways of installing this mod
QuoteYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 7)' at line 3
File: c:\program files\easyphp1-7\www\novo\Sources\Display.php
Line: 292
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Quote
Unknown column 'score' in 'field list'
File: c:\program files\easyphp1-7\www\novo\Sources\Subs-Related.php
Line: 426
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
As I said you need to drop related_topics before installing beta 2 if you installed beta 1
i drop it but i get the same error.
Quote from: Klauser on September 21, 2005, 06:59:55 AM
but this script is not using the board permissions, so anyone could see all topics from hidden boards, where they are not members. Any plans in the future to exclude such postings ?
Is it true? I did not notice this behavior in my forum...
Quote from: jossanaijr on August 22, 2007, 06:37:48 PM
Quote from: Klauser on September 21, 2005, 06:59:55 AM
but this script is not using the board permissions, so anyone could see all topics from hidden boards, where they are not members. Any plans in the future to exclude such postings ?
Is it true? I did not notice this behavior in my forum...
This post was from the year 2005....
Regards, Christian
Quote from: g-c on August 23, 2007, 10:18:37 AM
This post was from the year 2005....
Regards, Christian
Ups, sorry!
Quote from: Farmacija on August 22, 2007, 05:28:35 PM
i drop it but i get the same error.
Same Here!
Help!
I donno whas the problem but i updated everything it still gives the same error. I use PDX theme and the forum is 1.1.3.
I want to install this mod in my current theme (not Default one).
I'm manually installing it and i have to edit Display.template.php file of my theme.
I have to do the following modify:
Quote<file name="$themedir/Display.template.php">
<operation>
<search position="replace"><![CDATA[ echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>
</td>
</tr>
</table>';
}]]></search>
<add><![CDATA[ echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>
</td>
</tr>
</table><br /><br />';
}
// Added by Related Topics
ecc... ecc...
BUT in the Display.template.php file of my theme the code does not match the code of Default theme:
Quoteecho '
<input type="button" value="', $txt['spell_check'], '" onclick="spellCheck(\'postmodify\', \'message\');" />';
echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>
</td>
</tr>
</table>';
if ($context['show_spellchecking'])
echo '
<form name="spell_form" id="spell_form" method="post" target="spellWindow" action="', $scripturl, '?action=spellcheck"><input type="hidden" name="spellstring" value="" /></form>';
}
}
?>
How to correctly add Related Topics code? I do not know how to do it :(
I hope you can help me! Thank you in advance!
I did installed this mod in my SMF 1.1.3 and got it working very well...
...BUT...
It still has some HUGE problems with bandwidth. I can't give you all exactly numbers, but in 5 days my forum consumed ~ 800mb of band, a enormous number to my forum with only 400 members, that only 20 are really active...
Read my last message!
I know it works very well on SMF v1.1.3 but i do not know how to manually install it in my theme.
The code does not match!
Anyway thank you for your advices about the use of bandwidth.
I've encontered same problem, but you have to look in the code, and you'll find the exact match few lines after those ones. ;-)
Quote from: softcore on September 13, 2007, 12:00:09 AM
I did installed this mod in my SMF 1.1.3 and got it working very well...
...BUT...
It still has some HUGE problems with bandwidth. I can't give you all exactly numbers, but in 5 days my forum consumed ~ 800mb of band, a enormous number to my forum with only 400 members, that only 20 are really active...
The mod might use more CPU% but not bandwidth!
I want this to be default in smf 2.0
Quote from: [MaxX] on September 23, 2007, 10:42:26 AM
Quote from: softcore on September 13, 2007, 12:00:09 AM
I did installed this mod in my SMF 1.1.3 and got it working very well...
...BUT...
It still has some HUGE problems with bandwidth. I can't give you all exactly numbers, but in 5 days my forum consumed ~ 800mb of band, a enormous number to my forum with only 400 members, that only 20 are really active...
The mod might use more CPU% but not bandwidth!
Indeed. I'm sorry for my terrible mistake, this mod doesn't has any more problems with bandwidth. I am monitoring my server's band the last week, and I didn't see any relevant impact of (re)installing this mod!
Great job, I corrected my message above.
this is what I have been looking Im sure thisis agreat mod after installing it
I am having this
1. Extract File ./Sources/Subs-Related.php
2. Execute Modification ./Sources/ModSettings.php Test successful
3. Execute Modification ./Sources/RemoveTopic.php Test successful
4. Execute Modification ./Sources/Subs-Post.php Test successful
5. Execute Modification ./Sources/Display.php Test successful
6. Execute Modification ./Themes/default/Display.template.php Test failed
7. Execute Modification ./Themes/default/languages/Modifications.english.php Test successful
8. Execute Modification ./index.php Test successful
9. Execute Code related_topics.php
On a dilber theme
1.1.4
hope you can help me
Similar to all the other queries you keep posting...replied to with specific advice elsewhere.
Quote from: falguni1 on October 26, 2007, 04:46:29 AM
I want this to be default in smf 2.0
Don't think so it'll be there. I think its better as a Mod ;)
Quote from: TrueSatan on November 28, 2007, 05:45:38 AM
Similar to all the other queries you keep posting...replied to with specific advice elsewhere.
Yeah correct, because I am not a web designer. I am just someone who learned from forums. I just have 3 months experience in installing this and that
Is this mod still consuming huge amounts of resources?
Regards, Christian
i have this error:
Erro na base de dados: Can't find FULLTEXT index matching the column list
Ficheiro: /home/nemigue/public_html/Sources/Subs-Related.php
Linha: 157
Anyone here was able to install the mod in a pc virtual server? I tried but gve me a database error(something like don't allow FULLTEXT indexes). When i install on the web server it works fine, but of course would be nice to install on the pc server because I use to first make the changes on the pc and then upload the file so have the forum online a bit different than the one on the pc might be a bad idea(using WAMP5 Version 1.7.2 as virtual server)
i tried EVERYTHING but this mod just doesnt work for my forum at all. i think it needs to be checked and fixed in many ways.
this is my "Most Wanted Mod" but it doesnt work at all.
does ver 1.1 work with smf 1.4?
Quote from: PLAYBOY on February 19, 2008, 08:34:21 AM
i tried EVERYTHING but this mod just doesnt work for my forum at all. i think it needs to be checked and fixed in many ways.
this is my "Most Wanted Mod" but it doesnt work at all.
Are you sure you are using custom theme and if you do, you edited it properly?
I don't notice anything after installing this. [Default Theme]
Hello, searching is somehow not working in this topic, so i have to ask directly here,
i just installed the beta3 version of the related mod, but where the heck do i configure
it ?
i am using smf1.14 and dilbermc theme, after installing the mod i have no new menu entry, and no new bottom line, even if i switch to default theme ...
is there any form of documentation available ?!?!?
any hints would be very appreciated
greets
ck
QuoteNew features in 1.2.0
- Options are added to Features and Options
ah, i see, thank you very much, and after building the index, everything works fine ... :D
after installing this mod, when i try to view any subject, Here is what i get
Database Error
Can't find FULLTEXT index matching the column list
File: /home/site/public_html/forum/Sources/Subs-Related.php
Line: 157
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Can anybody help?
is there anyway i can see a demo of this thing in real? i havent even see what it looks like and if this mod works or not.
does it work for 1.1.4?
Quote from: PLAYBOY on March 13, 2008, 01:20:51 PM
after installing this mod, when i try to view any subject, Here is what i get
Database Error
Can't find FULLTEXT index matching the column list
File: /home/site/public_html/forum/Sources/Subs-Related.php
Line: 157
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Can anybody help?
I have the exact same error!
Portuguese SMF. Can someone please help us?
Thank you!
You need to create fulltext index from search settings.
Related Topics 1.3 Beta 1 for SMF 2.0 Beta 3 Public ONLY
installed the mod fine but it doesnt seem to be doing anything and i cant see any options in the features section.
Quote from: Niko on March 24, 2008, 03:05:07 PM
Related Topics 1.3 Beta 1 for SMF 2.0 Beta 3 Public ONLY
thanks Niko
:)
Works perfect in 1.1.4 with all of my custom themes.
Great job!!
Thank You :)
Quote from: PLAYBOY on March 13, 2008, 01:20:51 PM
after installing this mod, when i try to view any subject, Here is what i get
Database Error
Can't find FULLTEXT index matching the column list
File: /home/site/public_html/forum/Sources/Subs-Related.php
Line: 157
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Can anybody help?
I still get the same error.
Nobody can help me out about this???
Quote from: PLAYBOY on April 02, 2008, 05:12:33 AM
Quote from: PLAYBOY on March 13, 2008, 01:20:51 PM
after installing this mod, when i try to view any subject, Here is what i get
Database Error
Can't find FULLTEXT index matching the column list
File: /home/site/public_html/forum/Sources/Subs-Related.php
Line: 157
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Can anybody help?
I still get the same error.
Nobody can help me out about this???
Quote from: Niko on March 24, 2008, 12:28:43 PM<br />You need to create fulltext index from search settings.<br />
(or enable custom index, it's better).
I have tried the one for smf 2.0
it didint install at all because i got 1.1.4
then i tried the one for 1.1.4 but still the same thing. same error. same things.
i tried full index + custom index.
Marsh, under 'Security and Moderation' there is a 'Related Topics' section. Click the 'Build Index' and the topics should work.
Hi,
Thanks for this mod, really great ;)
One question:
Is there a way to make this mod not show any locked / recycled topics on the related topic list? I only need this to make it be perfect.
Thanks a lot
Hugs from Portugal
Hi,
All installed fine except for the Display.Template file.
It says to replace:
echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>
</td>
</tr>
</table>';
but my code is:
echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>';
I don't have the end table tags - my code then goes on to the quick reply box code so don't know where to add the code for this page?
Have attached my display.template page if anyone could have a look?
Many thanks in advance
The used table type doesn't support FULLTEXT indexes
File: C:\Programmi\Wamp\www\board\Packages\temp\related_topics.php
Linea: 72
Full Index txt active
How can I solve it?
thx
EDIT: it doesn't work with custom index too, on smf just installed too
i have installed successfully on my smf 2 beta 3.
im using silentwave theme by designer studio.
now i need to ask something..
the similar topics list is shown under the post, but i want to show it under quick reply box
here is the screenshot
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg293.imageshack.us%2Fimg293%2F2857%2F50455554ze4.jpg&hash=9d7be17a9dcfc98b8f24f9b0e4fbe5cbcba9918b)
i want similar topics to show under quick reply please help
Quote from: fgoc on April 07, 2008, 04:24:38 PM
Hi,
All installed fine except for the Display.Template file.
It says to replace:
echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>
</td>
</tr>
</table>';
but my code is:
echo '
<input type="hidden" name="sc" value="' . $context['session_id'] . '" />
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</form>';
I don't have the end table tags - my code then goes on to the quick reply box code so don't know where to add the code for this page?
Have attached my display.template page if anyone could have a look?
Many thanks in advance
Exactly the same problem here... :/
Hello!!!
Good job on this mod!
I was thinking if it's possibible to show in the related arguments, the tinyportal articles too.
Any way to do this?
Thank you!
Hi, I have the Dilbert theme installed and there is no Display.Template file in this theme, how can I install this mod? Thanks.
hum what I need to change in display.template to make the related topics table collapsible? thanks for the mod
Quote from: Patriiick on May 06, 2008, 02:03:54 PM
Hi, I have the Dilbert theme installed and there is no Display.Template file in this theme, how can I install this mod? Thanks.
If there's no Display template it will use one on Default theme (unless theme is based on another theme)
Niko hello ;
how will i place "related topics" to the below quick reply? is it same as smf 2.0 b3.1?
Quote from: fromtheflames on May 05, 2008, 03:36:40 PM
Hello!!!
Good job on this mod!
I was thinking if it's possibible to show in the related arguments, the tinyportal articles too.
Any way to do this?
Thank you!
up
Installed and works well with smf 1.1.5
Thanks for the nice mod!
HELP ME! I Installed this on www.custombats.co.uk/cbforum and now every single page says
Parse error: syntax error, unexpected T_VARIABLE in /home/sites/customcricketbats.co.uk/public_html/cbforum/Themes/default/languages/Modifications.english.php on line 47
This is the file in question and line 47 is the 2nd line of it!
// Added by Related Topics
$txt['related_topics'] = 'Related Topics';
$txt['relatedTopicsEnabled'] = 'Enable Related Topics';
$txt['relatedTopicsCount'] = 'How many related topics to show';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedMethod'] = 'Search Method<br /><span
class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index for custom method</a></span></b>';
$txt['relatedCustom'] = 'Custom';?>
Please someone help me - i need my forum!
Check that last line (which does have code) above that part ends with ;
this is the few lines above...
'Allows the user to delete feedback by anyone or anybody.'; $txt['cannot_smftrader_feedback'] = 'You are not allowed to submit feedback.'; $txt['cannot_smftrader_deletefeed'] = 'You are not allowed to delete feedback.'; $txt['permissionname_smftrader_autorating'] = 'Auto Approve Ratings'; $txt['permissionhelp_smftrader_autorating'] = 'Ratings do not need to wait for approval if this permission is given.'; //END SMF Trader System Text Strings;
// Added by Related Topics;
$txt['related_topics'] = 'Related Topics';
$txt['relatedTopicsEnabled'] = 'Enable Related Topics';
$txt['relatedTopicsCount'] = 'How many related topics to show';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedMethod'] = 'Search Method<br/><span class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index for custom method</a></span></b>';
$txt['relatedCustom'] = 'Custom';?>
Quote from: LeoFernandes on May 16, 2008, 07:25:28 AM
this is the few lines above...
'Allows the user to delete feedback by anyone or anybody.'; $txt['cannot_smftrader_feedback'] = 'You are not allowed to submit feedback.'; $txt['cannot_smftrader_deletefeed'] = 'You are not allowed to delete feedback.'; $txt['permissionname_smftrader_autorating'] = 'Auto Approve Ratings'; $txt['permissionhelp_smftrader_autorating'] = 'Ratings do not need to wait for approval if this permission is given.'; //END SMF Trader System Text Strings;
// Added by Related Topics;
$txt['related_topics'] = 'Related Topics';
$txt['relatedTopicsEnabled'] = 'Enable Related Topics';
$txt['relatedTopicsCount'] = 'How many related topics to show';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedMethod'] = 'Search Method<br/><span class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index for custom method</a></span></b>';
$txt['relatedCustom'] = 'Custom';?>
Can you attach whole file? (or upload somewhere)
Thanks for all the help i really do appreciate it! File is attached here!
Quote from: LeoFernandes on May 16, 2008, 08:09:27 AM
Thanks for all the help i really do appreciate it! File is attached here!
This should work.
Thankyou so much my friend! You saved my forum!
Hello, I´m using SoftMC and after the theme edit, nothing showed up. There are no Related Topics or something alike.
What can I do?
Quote from: lonrot on May 18, 2008, 08:05:20 PM
Hello, I´m using SoftMC and after the theme edit, nothing showed up. There are no Related Topics or something alike.
What can I do?
Have you build index from admin? It's necassary to make mod work.
But there's no edit required for that, as far as I know...
Hi Niko.
Any chance to upgrade this mod that we can add related topics manually?
I want to use this mod, but its not work.
If i want creat a custom index there stands:
Not done yet!
To avoid overloading your server, the process has been temporarily paused. It should automatically continue in a few seconds. If it doesn't, please click continue below.
8%
And when i am using Fulltextsearch there stands:
Can't find FULLTEXT index matching the column list
File: /home/board/Sources/Subs-Related.php
Line: 157
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.5, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.
Quote from: master2oo8 on May 30, 2008, 10:11:07 PM
I want to use this mod, but its not work.
If i want creat a custom index there stands:
Not done yet!
To avoid overloading your server, the process has been temporarily paused. It should automatically continue in a few seconds. If it doesn't, please click continue below.
8%
You need to wait for some time.
Quote from: Niko on May 31, 2008, 04:30:36 AM
Quote from: master2oo8 on May 30, 2008, 10:11:07 PM
I want to use this mod, but its not work.
If i want creat a custom index there stands:
Not done yet!
To avoid overloading your server, the process has been temporarily paused. It should automatically continue in a few seconds. If it doesn't, please click continue below.
8%
You need to wait for some time.
Waithing one hour and dont works :P
i am on a dedicated box, its impossible, that the server is overloaded
hello .
an error :
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi27.tinypic.com%2F25r1df7.jpg&hash=4a307e1e54d8a59f638fa7c6a880a36b99db9f52)
please help me .
i'm goto ( admin>search>Search method ) and click on the ( create a fulltext index ) , ( create custom index ) but give a error that i'm show on the picture .
i'm smf version 1.1.5 .
please help .
please help me :( :( :( :( :( :( :( :(
have the same error as iran-hosting
help us pls!!
who can't help me . >:( >:( >:(
i cant get this to work whit my theme, i use mysticjade theme
push
Hi!
I have installed your mod and it works fine.
(Except for problem to use with babylon theme and enh quickreply mod, but now is ok)
<input type="hidden" name="seqnum" value="', $context['form_sequence_number'], '" />
</td>
</tr>
</table></td>
</tr>
</table>
</form><br /><br />';
}
// Added by Related Topics1 questions:
How i can set? FullIndex or Custom search?
I know it stated that the newest version is for 2.0 Beta 3, however is there any way to get this to work on beta 3.1. I tried because there were manual instructions for it but can not get it to work. If others have had success with beta 3.1 I will try it again, otherwise I am going to wait for an update.
This is my number 1 most wanted mod so I will try whatever it may take. Is there any way to roll back to beta 3 (other than a reinstall)? Thank You to the developer for working on this.
PPPPPPPPPPPPPPPPPlease could you tell me how to have the related topics table collapsable and expandable?
when is this gonna be available for 2.0?
Quote from: Niko on September 14, 2005, 11:50:29 AM
Link to Mod (http://mods.simplemachines.org/index.php?mod=189)
Adds Related Topics (Similar Topics) to bottom of message view.
Contains two search methods
Fulltext (1.2 Only)
- Uses fulltext search on every message index view
- Requires no space in addition to fulltext index
- More replies there are, more inaccurate results are
Custom (Recommended)
- Copies subject to new table which will need more space
- Some of results are cached to database
- Fulltext query is only used when new topic is created or subject of first message edited
- Provides more results than normal fulltext
New features in 1.2.0
- Options are added to Features and Options
- Custom index
1.3 Beta 1
- Removed Fulltext
- For SMF 2.0 Beta 3 Public only
Download (http://www.simplemachines.org/community/index.php?topic=49410.msg1481766#msg1481766)
I can't get this to work on my theme (DarkBreak).
I have tried to make the new seacrh criteria as specified in new post but nothing shows - also there are no options in Features and Options?
Can someone help please?
After activating this mod, I`ve got error on any topic view (SMF 1.1.RC3) :( What to do?
Fatal error: Call to undefined function: getrelated() in /home/***/***/***/forum/Sources/Display.php on line 166
and when I try to add/delete topic (mod is turned off):
Fatal error: Call to undefined function: () in /home/***/***/***/forum/Sources/Subs-Related.php on line 424
Hi!
I've successfully installed it on my default theme 1.1.5, but I don't see any related topics in my message view. ???
Under 'Security and Moderation' there is a 'Related Topics' section. Click the 'Build Index' and the topics should work.
Thanks casp3r - is that only in 2.0? I don't see a Security & Moderation menu anywhere.
<3 great mod
@casp3r - go to ADMIN > Features and Options > Search Method (Build index for custom method)
Click the "Build index for custom method" and it will do the trick
Thank you spitfire1945!! That did the trick, alright ;)
it is kind of working with 1.1.5 but i cant see it at the base... any idea why is this not happening ?
Is there somebody gonna make this mod for 1.1.6? and 2.0?
I also think it would be good if you add the translations in mod page.
Quote from: PLAYBOY on September 17, 2008, 06:15:38 AM
Is there somebody gonna make this mod for 1.1.6? and 2.0?
I also think it would be good if you add the translations in mod page.
I think its compatible.. it does show in the parser... try it if it works..
New version released with SMF 1.1.0 - 1.1.6 and 2.0 Beta 4 supported.
perfect. you da man. or the lady. whatever.
I am using smf 1.1.6, using "classic" theme which comes with the default smf installation
while installing Related Topics 1.3 RC 2
i have got this >>
QuoteType Action Description
1. Extract File ./Sources/Subs-Related.php
2. Extract File ./Sources/Subs-RelatedFulltext.php
3. Execute Modification ./Sources/ModSettings.php Test successful
4. Execute Modification ./Sources/RemoveTopic.php Test successful
5. Execute Modification ./Sources/Subs-Post.php Test successful
6. Execute Modification ./Sources/Display..php Test successful
7. Execute Modification ./Themes/classic/Display.template.php Test failed
8. Execute Modification ./index.php Test successful
9. Execute Modification ./Themes/classic/languages/Modifications.english.php Test successful
10. Execute Modification ./Themes/classic/languages/Modifications.english-utf8.php Skipping file
11. Execute Modification ./Themes/classic/languages/Modifications.finnish.php Skipping file
12. Execute Modification ../Themes/classic/languages/Modifications.finnish-utf8.php Skipping file
any ideas ???
I want to ask for a update, may I?? :)
It would be nice to choose which boards related topics content should appear.
I mean, I want related topics from only board X, and not for board Y, because board Y is for off-topic.
Do you know what I mean? What about?
It says this mod works on 2.0 beta 4 but when I go to post a new topic is says the DB table "related_subjects" is missing.
DELETE FROM smf_related_subjects
WHERE id_topic IN(4364)
File: /Sources/Subs-RelatedFulltext.php
Line: 86
Not sure why this happens. I tried uninstalling and reinstalling, thinking maybe it didnt install right the first time.
Works perfect - great
Quote from: Septimus on September 26, 2008, 10:43:02 AM
It says this mod works on 2.0 beta 4 but when I go to post a new topic is says the DB table "related_subjects" is missing.
DELETE FROM smf_related_subjects
WHERE id_topic IN(4364)
File: /Sources/Subs-RelatedFulltext.php
Line: 86
Not sure why this happens. I tried uninstalling and reinstalling, thinking maybe it didnt install right the first time.
You need to create index from admin.
Exellent MOD! Kiitos Niko.
Theres major bug. It shows topics from those areas where users arent allowed to see. Recycle bin etc etc.
After uninstalling this mod, can i drop safely related_subjects and related_topics tables?
Quote from: Owdy on October 09, 2008, 03:23:13 AM
Theres major bug. It shows topics from those areas where users arent allowed to see. Recycle bin etc etc.
Fixed. Everyone please update ASAP.
Quote from: Owdy on October 09, 2008, 03:29:04 AM
After uninstalling this mod, can i drop safely related_subjects and related_topics tables?
Yes
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
it works!
great job!
Thanks a lot
Where does this display related topics? When you are creating a new topic?
Hello
I am using version 1.3 on SMF 1.1.6, there have this message in Forum Error Log
Quote8: Undefined index: related_topics
File: /home/.../public_html/forum/Themes/default/Display.template.php (eval?)
Line: 870
How to fix this problem or error
Thank you
Quote from: Niko on October 11, 2008, 04:26:21 PM
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
Quote from: Niko on October 11, 2008, 04:26:21 PM
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
I had the same problem. Now it works! :) Please, update the package.
When i click on Build index for the related contact i get the following in my address bar.
http://forum.spartangames.co.uk/smf/index.php?action=related;sa=index;begin
I get a done in the status bar and a white screen, but nothing seem's to have worked..
Anyone any idea's??
Quote from: Niko on October 11, 2008, 04:26:21 PM
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
Thanks for that file. Now the mod is working properly.
I have just installed this mod and am getting this error when i try to post anything.
Table 'ac919h_smf.smf_related_subjects' doesn't exist
File: /home2/ac919h/public_html/Sources/Subs-RelatedFulltext.php
Line: 86
Hi,
Also got quite the same error SISPro. When want to create new topic, the error occured:
QuoteTable 'test.4ae_related_subjects' doesn't exist
File: /home/webuser/toyota/public_html/Sources/Subs-RelatedFulltext.php
Line: 72
I have replace the Subs-Related.php with the one attached.
For now, i've uninstall the mod. Hopefully will resolve the error and can use it.
TQ.. :)
You need to generate index from settings.
Quote from: Niko on October 11, 2008, 04:26:21 PM
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
Still have this issue with the "native" package.
But works fine with this attached file.
You should update this file in the package and add compatibility 1.1.7, as soon as you can, of course. :-)
I will test your mod, but it seems to be a really interesting feature. Good job :)
Quote from: Eleglin on November 11, 2008, 08:47:22 AM
Quote from: Niko on October 11, 2008, 04:26:21 PM
Quote from: cr34t1v3 on October 11, 2008, 11:37:51 AM
Hi,
this won't work for me. err message:
Fatal error: Call to undefined function loadclassfile() in /home/forumanu/public_html/Sources/Subs-Related.php on line 311
i used 1.1.6
Any idea?
Thanks before
Seems like I have made mistake while updating. Replace Subs-Related.php with one attached.
Still have this issue with the "native" package.
But works fine with this attached file.
You should update this file in the package and add compatibility 1.1.7, as soon as you can, of course. :-)
I will test your mod, but it seems to be a really interesting feature. Good job :)
Updated
Sorry but I don't get all of what this mod does.
Does it let the admin mark related topics?
Quote from: ReptiGuy on November 13, 2008, 09:55:47 PM
Sorry but I don't get all of what this mod does.
Does it let the admin mark related topics?
I wish it would too lol..
When you read a topic like "Images of a Green Bear", you get links to topics such as "Images of Bear" and "Videos of Green Bear".
Related topics, see?
Yeah I get it.
Thanks for telling me.
I uploaded this mod.....no problem but wheres the settings?
I couldnt find it anywhere in the default theme.
I wish I could try it but every download link just gets me a blank page - ????
Eh, okay, nevermind, just saw the 'Link to Mod' at the beginning....
I'd like to say this does a fairly good job at recommending topics, even though it obviously only searches the subject line.
In the next version can you offer the ability to tweak it more such as also considering the date of the thread, replies on that thread, and keywords to not follow? Perhaps others . . . but I'm mostly happy with it already.
Hi Niko,
I am using SMF v1.1.7 and theme SmoothIt - which has NO tables - any suggestions how I could get this to work on my setup?
I tested this Mod on SMF 1.1.7 today. Due to lack of instruction from the readme document, it cost me a lot of time.
At first it show me the ...smf_related_subjects' doesn't exist error. I searched the web and find the answer here: just click the Build Index link then the table will be created.
Why not create that table when I clicked Save button at Admin side?
And, where should those Related Topics to be shown? Now I have the table created, but I can't see related topics list.
Hope the author will improve his readme file.
Thanks.
French version of Related Topic is available?
Quote from: baijianpeng on December 16, 2008, 09:54:57 AM
And, where should those Related Topics to be shown? Now I have the table created, but I can't see related topics list.
Supposed to shown at the bottom of every topic. If not, check if your theme has the file Display.template.php. If so, edit it.
I can't get this to work on my Display.template.php
The MOD failed so I added it myself
Attached.
New versions have been released for 1.1.8 and 2.0 RC1. Versions are 1.3.2 and 1.4 Alpha 1 (respectively). 1.4 supports SMF 2.0 RC1 only and contains improved admin. It doesn't contain any new features for now (from user perspective, code has been improved).
Thanx for this cool mod. Im using it now and it seems to work just fine.
When the new module is loaded into RC1 I get the following error when making any post:
Table 'm4inform_smf.smf02_related_subjects' doesn't exist
File: /home/m4inform/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 86
Went into config and reindexed and things look ok now.
Not sure where I'm supposed to see related topics?
Thanks, Niko .. for mod Rc1 updated =)
Does this Mod Increases Server Load too ????
Quote from: pariofdreamz on February 21, 2009, 05:57:10 PM
Does this Mod Increases Server Load too ????
Yes.
Quote from: PerryM on February 09, 2009, 05:36:13 PM
When the new module is loaded into RC1 I get the following error when making any post:
Table 'm4inform_smf.smf02_related_subjects' doesn't exist
File: /home/m4inform/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 86
Went into config and reindexed and things look ok now.
Not sure where I'm supposed to see related topics?
On topic pages
Quote from: Niko on February 22, 2009, 02:53:50 AM
Quote from: pariofdreamz on February 21, 2009, 05:57:10 PM
Does this Mod Increases Server Load too ????
Yes.
Quote from: PerryM on February 09, 2009, 05:36:13 PM
When the new module is loaded into RC1 I get the following error when making any post:
Table 'm4inform_smf.smf02_related_subjects' doesn't exist
File: /home/m4inform/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 86
Went into config and reindexed and things look ok now.
Not sure where I'm supposed to see related topics?
On topic pages
RC1 here, installed fine, created the search index, and enabled it. There is no change anywhere on the board that I can see -- an I've looked, and no related topic links -- anywhere. What, where, when, how??
Installed new smf 2.0 RC1 and uploaded the mod v 1.4 Alpha 1 and re-indexed and I still never see any related topics at the bottom of the pages.
Is there another switch somewhere that must be turned on?
Thanks
You and me both -- no one's talking...
I know this mod works - I've seen some smf web sites that use it just fine.
But I sure can't get it working for some reason....
bizare but im making a new website last week related topics worked fine.
this week i change my site start from scratch with a fresh install and a fresh package download... and now i get the error message you both are getting!
i have no idea why but its very anoying.
I never got an error message, the feature is just MIA...
when update dont forget portuguese and brazilian
<file name="$languagedir/Modifications.portuguese_pt.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics translate by smfpt.net
$txt['admin_related_topic'] = 'Tópicos relacionado';
$txt['related_topics'] = 'Tópicos relacionado';
$txt['relatedTopicsEnabled'] = 'Activar Tópicos relacionado';
$txt['relatedTopicsCount'] = 'Quantos tópicos relacionados a mostrar';
$txt['relatedIndex'] = 'Indexing method<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index</a></b></div>';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedCustom'] = 'Custom';]]></add>
</operation>
</file>
<file name="$languagedir/Modifications.brazilian_portuguese.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics translate by smfpt.net
$txt['admin_related_topic'] = 'Tópicos relacionado';
$txt['related_topics'] = 'Tópicos relacionado';
$txt['relatedTopicsEnabled'] = 'Activar Tópicos relacionado';
$txt['relatedTopicsCount'] = 'Quantos tópicos relacionados a mostrar';
$txt['relatedIndex'] = 'Indexing method<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index</a></b></div>';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedCustom'] = 'Custom';]]></add>
</operation>
</file>
<file name="$languagedir/Modifications.portuguese_pt-utf8.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics translate by smfpt.net
$txt['admin_related_topic'] = 'Tópicos relacionado';
$txt['related_topics'] = 'Tópicos relacionado';
$txt['relatedTopicsEnabled'] = 'Activar Tópicos relacionado';
$txt['relatedTopicsCount'] = 'Quantos tópicos relacionados a mostrar';
$txt['relatedIndex'] = 'Indexing method<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index</a></b></div>';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedCustom'] = 'Custom';]]></add>
</operation>
</file>
<file name="$languagedir/Modifications.brazilian_portuguese-utf8.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics translate by smfpt.net
$txt['admin_related_topic'] = 'Tópicos relacionado';
$txt['related_topics'] = 'Tópicos relacionado';
$txt['relatedTopicsEnabled'] = 'Activar Tópicos relacionado';
$txt['relatedTopicsCount'] = 'Quantos tópicos relacionados a mostrar';
$txt['relatedIndex'] = 'Indexing method<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Build index</a></b></div>';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedCustom'] = 'Custom';]]></add>
</operation>
</file>
Here's the spanish and spanish-latin translation:
//RELATED TOPICS
$txt['admin_related_topic'] = 'Tópicos relacionados';
$txt['related_topics'] = 'Tópicos relacionados';
$txt['relatedTopicsEnabled'] = 'Activar tópicos relacionados';
$txt['relatedTopicsCount'] = '¿Cuántos tópicos relacionados se mostrarán?';
$txt['relatedIndex'] = 'Método de indexado<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Crear Index</a></b></div>';
$txt['relatedFulltext'] = 'Solo texto';
$txt['relatedCustom'] = 'Personalizado';
//FIN RELATED TOPICS
And the spanish-utf8 translation:
//RELATED TOPICS
$txt['admin_related_topic'] = 'Tópicos relacionados';
$txt['related_topics'] = 'Tópicos relacionados';
$txt['relatedTopicsEnabled'] = 'Activar tópicos relacionados';
$txt['relatedTopicsCount'] = '¿Cuántos tópicos relacionados se mostrarán?';
$txt['relatedIndex'] = 'Método de indexado<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Crear Index</a></b></div>';
$txt['relatedFulltext'] = 'Solo texto';
$txt['relatedCustom'] = 'Personalizado';
//FIN RELATED TOPICS
Quote from: softcore on September 23, 2008, 06:15:34 PM
I want to ask for a update, may I?? :)
It would be nice to choose which boards related topics content should appear.
I mean, I want related topics from only board X, and not for board Y, because board Y is for off-topic.
Do you know what I mean? What about?
I still think this could be nice if added.
Any chances?
Helloo all ..
Hope all is well with all of you and everthing is fine.
Well my forum ws working fine upto mroning. Just now i was trying to delete some topics and it is giving error that your database is not upto date. while im using 1.1.8 version it is givn thefolwig message.
.....................................................................
Table 'nafseisl_smf1.smf_related_subjects' doesn't exist
File: /home/nafseisl/public_html/roundup/Sources/Subs-RelatedFulltext.php
Line: 72
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.8, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.
.......................................................................
even i checked the detailed version info it says that your current and the smf version is 1.1.8??
please help ..
Im getting this error after installing the Related Topic Mod .. i have uninstalled and it started deleting again.
Any chances to exclude some boards from "related topics"?
Quote from: softcore on April 15, 2009, 04:17:04 PM
Any chances to exclude some boards from "related topics"?
It's not possible in current version, but is planned for next version.
Quote from: nafseislam on April 12, 2009, 10:00:48 AM
Helloo all ..
Hope all is well with all of you and everthing is fine.
Well my forum ws working fine upto mroning. Just now i was trying to delete some topics and it is giving error that your database is not upto date. while im using 1.1.8 version it is givn thefolwig message.
.....................................................................
Table 'nafseisl_smf1.smf_related_subjects' doesn't exist
File: /home/nafseisl/public_html/roundup/Sources/Subs-RelatedFulltext.php
Line: 72
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.8, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.
.......................................................................
even i checked the detailed version info it says that your current and the smf version is 1.1.8??
please help ..
Im getting this error after installing the Related Topic Mod .. i have uninstalled and it started deleting again.
It's because you didn't build index. (or it failed but you would have had error)
Great mod!
Forum SMF 2 RC1, automatic installation mod Related_Topics_1.4_Alpha in adminpanel failed. Then set manually, but when you include the modification of index.php?action=admin;area=relatedtopics;sa=settings and then you can not view the topic due to errors: >:(
Table 'frmdb.smf_related_topics' doesn't exist
Файл: /home/webs/public_html/forum/Sources/Subs-Related.php
Строка: 35
Subs-Related.php 35 line is );
where full function
// Otherwise use customized fulltext index
$request = $smcFunc['db_query']('', '
SELECT IF(rt.id_topic_first = {int:topic}, rt.id_topic_second, rt.id_topic_first) AS id_topic
FROM {db_prefix}related_topics AS rt
JOIN {db_prefix}topics AS t ON (t.id_topic = IF(rt.id_topic_first = {int:topic}, rt.id_topic_second, rt.id_topic_first))
JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
WHERE (id_topic_first = {int:topic} OR id_topic_second = {int:topic})
AND {query_see_board}
ORDER BY rt.score DESC
LIMIT {int:limit}',
array(
'topic' => $topic,
'limit' => $modSettings['relatedTopicsCount'],
)
); // THIS is 35 line when error for ..forum/Sources/Subs-Related.php
Please, Give a full sql query in phpmyadmin, which must be met when installing the mod - in order to work correctly! ??? O:)
p.s. sory for my english, tnx google ;) http://translate.google.com/translate_t#
Related Topics 1.4 Alpha 2 is now available for downloads.
It contains improved code and ability to choose which boards to ignore. (Recycle board is now always ignored)
Quote from: kagorec on April 19, 2009, 06:44:29 AM
Great mod!
Forum SMF 2 RC1, automatic installation mod Related_Topics_1.4_Alpha in adminpanel failed. Then set manually, but when you include the modification of index.php?action=admin;area=relatedtopics;sa=settings and then you can not view the topic due to errors: >:(
Table 'frmdb.smf_related_topics' doesn't exist
Файл: /home/webs/public_html/forum/Sources/Subs-Related.php
Строка: 35
Subs-Related.php 35 line is );
where full function
// Otherwise use customized fulltext index
$request = $smcFunc['db_query']('', '
SELECT IF(rt.id_topic_first = {int:topic}, rt.id_topic_second, rt.id_topic_first) AS id_topic
FROM {db_prefix}related_topics AS rt
JOIN {db_prefix}topics AS t ON (t.id_topic = IF(rt.id_topic_first = {int:topic}, rt.id_topic_second, rt.id_topic_first))
JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
WHERE (id_topic_first = {int:topic} OR id_topic_second = {int:topic})
AND {query_see_board}
ORDER BY rt.score DESC
LIMIT {int:limit}',
array(
'topic' => $topic,
'limit' => $modSettings['relatedTopicsCount'],
)
); // THIS is 35 line when error for ..forum/Sources/Subs-Related.php
Please, Give a full sql query in phpmyadmin, which must be met when installing the mod - in order to work correctly! ??? O:)
p.s. sory for my english, tnx google ;) http://translate.google.com/translate_t#
Upload related_topics.php and run it to create tables.
Just for SMF 2.0 the "ignore board" function is available? Or the 1.3.2 version got it's code improved too?
Quote from: softcore on April 24, 2009, 08:22:55 PM
Just for SMF 2.0 the "ignore board" function is available? Or the 1.3.2 version got it's code improved too?
Just for SMF 2.0 for now.
Good Update.
Thank you.
Noticed these errors in my error log.
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
8: Undefined index: step
Apply Filter: Only show the errors from this file
File: /home/XXXXXXX/public_html/Sources/RelatedTopics.php
Line: 190 This is line 190:
Quote$last = $_REQUEST['step'] + $perStep;
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
You haven't selected which methods to use to determine related topics
is there an update for 1.1.9 ?
It should work just by version emulate (add version_emulate=1.1.8 to package server url). Updated package will be available in a few days.
Quote from: Chit-Chat ChatterBox Boss on May 17, 2009, 07:23:41 PM
Noticed these errors in my error log.
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
8: Undefined index: step
Apply Filter: Only show the errors from this file
File: /home/XXXXXXX/public_html/Sources/RelatedTopics.php
Line: 190
This is line 190:
Quote$last = $_REQUEST['step'] + $perStep;
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
You haven't selected which methods to use to determine related topics
Thanks for report! This will be fixed in next version.
No problem keep up the hard work!
Update, version 1.1.9 plz =/
Quoteadd version_emulate=1.1.8
where do i find the package server url?
Quote from: Niko on May 23, 2009, 01:50:45 PM
It should work just by version emulate (add version_emulate=1.1.8 to package server url). Updated package will be available in a few days.
Quote from: Chit-Chat ChatterBox Boss on May 17, 2009, 07:23:41 PM
Noticed these errors in my error log.
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
8: Undefined index: step
Apply Filter: Only show the errors from this file
File: /home/XXXXXXX/public_html/Sources/RelatedTopics.php
Line: 190
This is line 190:
Quote$last = $_REQUEST['step'] + $perStep;
http://www.chitchatchatterbox.com/index.php?action=admin;area=relatedtopics;sa=buildIndex
Apply Filter: Only show the errors with the same message
You haven't selected which methods to use to determine related topics
Thanks for report! This will be fixed in next version.
Do you know when the next version will be released?
not found version 1.1.9 =/
1.3.3 and 1.4 Alpha 3 version released. :)
What all was updated?
Quote from: Chit-Chat ChatterBox Boss on May 31, 2009, 03:31:03 PM
What all was updated?
1.1.9 and 2.0 RC1-1 support. And some small bug fixes (such as one you reported)
Ok sweet! Thanks.
First of all, fantastic mod. Thank you for your hard work!
I currently have version 1.4 Alpha 1 installed. Do I have to manually uninstall the old version of the mod through code edits before I can upgrade to Alpha 3? It would appear there is no uninstaller included.
hi how come I get this error, everything installed correctly shown in the packege installer. I use 2.0rc1-1
Table '****smf_related_subjects' doesn't exist
File: /******/Sources/Subs-RelatedFulltext.php
Line: 110
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0 RC1-1, while your database is at version 2.0 RC1. The above error might possibly go away if you execute the latest version of upgrade.php.
I check my datdabase and confirmed that, I found though smf_related_topics
nice mod, thank u
i download and installed this mod perfectly, but when i checked my forum topics, it's not showing any related topics.... i wonder why ?
we have several topic related to training and vaccinations, but none of them are showing below the topic.
great mod , how often does it update or do we need to cron in index link
I last read about this mod about 18 months ago. At that time people were moaning about server load and too many sql queries.
What do people think of the mod now ? is it worth installing ?
This is the french translation:
./Themes/default/languages/Modifications.french.php
./Themes/default/languages/Modifications.french-utf8.php
Find (at the end of the file):
?>
Add before:
// Added by Related Topics
$txt['admin_related_topic'] = 'Sujets Connexes';
$txt['related_topics'] = 'Sujets Connexes';
$txt['relatedTopicsEnabled'] = 'Activer les sujets connexes';
$txt['relatedTopicsCount'] = 'Combien de sujets connexes afficher';
$txt['relatedIndex'] = 'Méthode d\'indexation<div class="smalltext"><b><a href="' . $scripturl . '?action=related;sa=index;begin">Construire un index</a></b></div>';
$txt['relatedFulltext'] = 'Texte entier';
$txt['relatedCustom'] = 'Personnalisé';
Hi!
How to not appear "MOVED" topics in the related results?
It's annoying having the "MOVED" topic and the topic where it was moved to in the related posts results!
Thanks in advance.
Quote from: pinoypetfinder on June 17, 2009, 08:51:56 AM
i download and installed this mod perfectly, but when i checked my forum topics, it's not showing any related topics.... i wonder why ?
we have several topic related to training and vaccinations, but none of them are showing below the topic.
You need to build the index first in the administration, I guess.
When i try to rebuild indexes, it shows
"Database error, given array of integer values is empty"
SMF 2.0 RC1.2, Related_Topics_1.4_Alpha_3
Tried the 1.4 version. Got this:
QuoteThe package you are trying to download or install is either corrupt or not compatible with this version of SMF.
Quote from: bjraines on June 25, 2009, 08:13:47 PM
great mod , how often does it update or do we need to cron in index link
I would like to ask the same question? Does it update automatically or do we have to run the index link again?
Hi niko
Thank you for the mod, I am using it for a long time. I want to do sth with this mod, but I don't know if it is possible
I want to call related topics from a specific board in itself. I mean all topics and boards will be the same, but topics in one category will call the related topics in in itself.
Is this possible?
Example:
A topic in Cat one
Related topics will be from cat one
But other boards will be the same, no change in function
I don't know if I could tell :D
thanks.
I have a problem that someone may be able to help me with. I have installed this on an SMF2 1.2 forum and it seems to install ok, tables created, all good. But when I enable it in Modifications nothing shows up under my posts.
I saw a post about clicking "Build Index" and when I do this it gives an error message:
An Error Has Occurred!
Unable to load the 'main' template.
Anyone have any clues as to where this may be coming from. Even if it narrows down to the file I'd be greatful.
EDIT:
Its this bit thats not working --> index.php?action=related;sa=index;begin
How often do you have to build the index ?? or is it a one time thing ... btw .. great mod.
Also, what do i edit so i don't see Recycled topics ... ???
the post in the related topics block also seem to order by date, but it puts the newest date last, how can i switch it around you the newest date comes first ?? :-\
Wonder if this can be used on 1.1.10?
If so, is there any support for this? I see a lot of unanswered questions about recycled topics, and 'moved' topics showing up in the related area.
I'm using it with 1.1.10
does this work with 2.0 RC1.2???
1.4 Alpha_3 Translate ... :) , thx
<file name="$languagedir/Modifications.turkish.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics
$txt['admin_related_topic'] = 'İlgili Konular';
$txt['admin_related_topics_information'] = 'Bilgi';
$txt['admin_related_topics_settings'] = 'Ayarlar';
$txt['admin_related_topics_methods'] = 'Metodlar';
$txt['related_topics_admin_title'] = 'İlgili Konular';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Son Haberler';
$txt['related_news_unable_to_connect'] = 'Son Haberler için <a href="http://www.smfarcade.info">SMFArcade.info</a> adresine bağlanılamadı...';
$txt['related_version_info'] = 'Sürüm Bilgisi';
$txt['related_installed_version'] = 'Yüklü Sürüm';
$txt['related_latest_version'] = 'Son Sürüm';
$txt['related_topics_ignored_boards'] = 'Gözardı edilen Bölümler';
$txt['related_topics_methods_title'] = 'Metodlar';
$txt['related_topics_methods'] = 'İlgili konularda kullanılacak metodu belirlemediniz<div class="smalltext">Ayarları değiştirdikten sonra içeriği tekrar oluşturmanız gerekmektedir</div>';
$txt['related_topics_index'] = 'İçerik';
$txt['related_topics_rebuild'] = 'İçeriği Tekrar Oluştur';
$txt['related_topics_rebuild_desc'] = 'Ayarları değiştirdikten veya ilk arabelleği oluşturduktan sonra kullan';
$txt['relatedFulltext'] = 'TamMetin';
$txt['related_topics_settings_title'] = 'İlgili Konular';
$txt['relatedTopicsEnabled'] = 'Etkinleştir';
$txt['relatedTopicsCount'] = 'Kaç adet ilgili konu gösterilicek';
$txt['no_methods_selected'] = 'İlgili Konuların kullanıcağı metodu belirlemediniz.';
$txt['related_topics'] = 'İlgili Konular';
// END Added by Related Topics]]></add>
</operation>
</file>
<file name="$languagedir/Modifications.turkish-utf8.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Added by Related Topics
$txt['admin_related_topic'] = 'İlgili Konular';
$txt['admin_related_topics_information'] = 'Bilgi';
$txt['admin_related_topics_settings'] = 'Ayarlar';
$txt['admin_related_topics_methods'] = 'Metodlar';
$txt['related_topics_admin_title'] = 'İlgili Konular';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Son Haberler';
$txt['related_news_unable_to_connect'] = 'Son Haberler için <a href="http://www.smfarcade.info">SMFArcade.info</a> adresine bağlanılamadı...';
$txt['related_version_info'] = 'Sürüm Bilgisi';
$txt['related_installed_version'] = 'Yüklü Sürüm';
$txt['related_latest_version'] = 'Son Sürüm';
$txt['related_topics_ignored_boards'] = 'Gözardı edilen Bölümler';
$txt['related_topics_methods_title'] = 'Metodlar';
$txt['related_topics_methods'] = 'İlgili konularda kullanılacak metodu belirlemediniz<div class="smalltext">Ayarları değiştirdikten sonra içeriği tekrar oluşturmanız gerekmektedir</div>';
$txt['related_topics_index'] = 'İçerik';
$txt['related_topics_rebuild'] = 'İçeriği Tekrar Oluştur';
$txt['related_topics_rebuild_desc'] = 'Ayarları değiştirdikten veya ilk arabelleği oluşturduktan sonra kullan';
$txt['relatedFulltext'] = 'TamMetin';
$txt['related_topics_settings_title'] = 'İlgili Konular';
$txt['relatedTopicsEnabled'] = 'Etkinleştir';
$txt['relatedTopicsCount'] = 'Kaç adet ilgili konu gösterilicek';
$txt['no_methods_selected'] = 'İlgili Konuların kullanıcağı metodu belirlemediniz.';
$txt['related_topics'] = 'İlgili Konular';
// END Added by Related Topics]]></add>
</operation>
</file>
SMF2 RC2 please...
Updated version for SMF 2.0 RC2 is now available.
Quote from: Niko on November 28, 2009, 05:53:34 PM
Updated version for SMF 2.0 RC2 is now available.
Hi Niko,
thanks for this Mod!
I have one problem, see attached screenshot please
It's not the title "related topics"...it's normal? :-)
Thanks and sorry for my english
Antonio
Quote from: anto74 on November 29, 2009, 08:19:09 AM
Quote from: Niko on November 28, 2009, 05:53:34 PM
Updated version for SMF 2.0 RC2 is now available.
Hi Niko,
thanks for this Mod!
I have one problem, see attached screenshot please
It's not the title "related topics"...it's normal? :-)
Thanks and sorry for my english
Antonio
Oops. Just small overlook, will fix for next version. :)
Problem when creating index
QuoteDatabase error, given array of integer values is empty. (topics)
Any sollution??
Quote from: Boxer2 on November 29, 2009, 01:52:59 PM
Problem when creating index
QuoteDatabase error, given array of integer values is empty. (topics)
Any sollution??
+1
Quote from: digger on November 29, 2009, 02:04:14 PM
Quote from: Boxer2 on November 29, 2009, 01:52:59 PM
Problem when creating index
QuoteDatabase error, given array of integer values is empty. (topics)
Any sollution??
+1
Have you checked all boards? If I'm looking at it right, you check the boards you want to be ignored, and everything else is indexed. In other words, if you want a board indexed, do NOT check it. I think that's right, but what do I know - either way, I'm not getting any results with the thing. :)
Quote from: imno007 on November 29, 2009, 05:04:10 PM
Quote from: digger on November 29, 2009, 02:04:14 PM
Quote from: Boxer2 on November 29, 2009, 01:52:59 PM
Problem when creating index
QuoteDatabase error, given array of integer values is empty. (topics)
Any sollution??
+1
Have you checked all boards? If I'm looking at it right, you check the boards you want to be ignored, and everything else is indexed. In other words, if you want a board indexed, do NOT check it. I think that's right, but what do I know - either way, I'm not getting any results with the thing. :)
I have not checked any boards.
Doesnt work with uncheked or cheked boards...Same error, error is showing when it gets to 6% of progress
great mod!!!
Quote from: Boxer2 on November 29, 2009, 01:52:59 PM
Problem when creating index
QuoteDatabase error, given array of integer values is empty. (topics)
Any sollution??
I got that error too when creating index
any help ?
up
Excellent update.
I dont want to see topics in the recycle bin, how can i fix that ??????????
French version?
// Added by Related Topics
$txt['admin_related_topic'] = 'Sujets Connexes';
$txt['admin_related_topics_information'] = 'Information';
$txt['admin_related_topics_settings'] = 'Réglages';
$txt['admin_related_topics_methods'] = 'Méthodes';
$txt['related_topics_admin_title'] = 'Sujets Connexes';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Dernières Nouveautés';
$txt['related_news_unable_to_connect'] = 'Impossible de se connecter à <a href="http://www.smfarcade.info">SMFArcade.info</a> pour les dernières news...';
$txt['related_version_info'] = 'Information sur la Version ';
$txt['related_installed_version'] = 'Version Installée';
$txt['related_latest_version'] = 'Dernière Version';
$txt['related_topics_ignored_boards'] = 'Parties du forum ignorées';
$txt['related_topics_methods_title'] = 'Méthodes';
$txt['related_topics_methods'] = 'Sélectionner les méthodes à utiliser pour déterminer les Sujets Connexes<div class="smalltext">Reconstruction de l'index requis après changement de réglages</div>';
$txt['related_topics_index'] = 'Index';
$txt['related_topics_rebuild'] = 'Reconstruire les indexes';
$txt['related_topics_rebuild_desc'] = 'Utilisé ceci après un changement des réglages ou pour construire le cache initial';
$txt['relatedFulltext'] = 'Texte complet';
$txt['related_topics_settings_title'] = 'Sujets Connexes';
$txt['relatedTopicsEnabled'] = 'Sujets Connexes Disponibles';
$txt['relatedTopicsCount'] = 'Combien voir de sujets connexes';
$txt['no_methods_selected'] = 'Vous n\'avez pas déterminer de méthode pour déterminer les sujets connexes';
$txt['related_topics'] = 'Sujets Connexes';
// END Added by Related Topics
Hi
i've just installed the related topic mod on my smf 2.0 rc2 forum, but where are related topics visible? in wich part of the forum? mine is
http://ingegneria.bebnet.org
but i don't see them
problem solved...i mistake the ignored boards and i selected all of them :)
I'm using version 1.3.3 of this mod on SMF 1.1.11, how can i select boards to ignore ??? ??
QuoteUndefined index: can_approve_posts :8
File: /Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 900
http://www.simplemachines.org/community/index.php?topic=351441.0
Quote from: islam2hamy on December 05, 2009, 11:14:53 AM
QuoteUndefined index: can_approve_posts :8
File: /Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 900
http://www.simplemachines.org/community/index.php?topic=351441.0
Update to latest version (released earlier today)
Quote from: aw06 on December 05, 2009, 10:31:54 AM
I'm using version 1.3.3 of this mod on SMF 1.1.11, how can i select boards to ignore ??? ??
This feature isn't in 1.3.3 version.
Quote from: Niko on December 05, 2009, 11:42:16 AM
Quote from: islam2hamy on December 05, 2009, 11:14:53 AM
QuoteUndefined index: can_approve_posts :8
File: /Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 900
http://www.simplemachines.org/community/index.php?topic=351441.0 (http://www.simplemachines.org/community/index.php?topic=351441.0)
Update to latest version (released earlier today)
the same error !
Rebuild the Indexes ??
Quote from: islam2hamy on December 05, 2009, 12:31:18 PM
Quote from: Niko on December 05, 2009, 11:42:16 AM
Quote from: islam2hamy on December 05, 2009, 11:14:53 AM
QuoteUndefined index: can_approve_posts :8
File: /Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 900
http://www.simplemachines.org/community/index.php?topic=351441.0 (http://www.simplemachines.org/community/index.php?topic=351441.0)
Update to latest version (released earlier today)
the same error !
Rebuild the Indexes ??
Seems like missed other error. Will post fix later.
Ok
Quote from: Niko on December 05, 2009, 11:42:16 AM
Quote from: aw06 on December 05, 2009, 10:31:54 AM
I'm using version 1.3.3 of this mod on SMF 1.1.11, how can i select boards to ignore ??? ??
This feature isn't in 1.3.3 version.
And there is no way to atleast stop it from showing me topics in the recycle bin ??? .. very annoying .. arrrhhh
Quote from: Niko on December 05, 2009, 06:34:51 PM
Quote from: islam2hamy on December 05, 2009, 12:54:41 PM
Ok
Updated version. Should be OK now.
Same time when i installed tagging system i got those errors, and i was very sure this error would'nt be from Niko and posted a message here
http://www.simplemachines.org/community/index.php?topic=135761.msg2380013#msg2380013
Later today i found it is solved at your end.
Good will upate soon. Thank you .
Quote from: Niko on December 05, 2009, 06:34:51 PM
Quote from: islam2hamy on December 05, 2009, 12:54:41 PM
Ok
Updated version. Should be OK now.
Installed and got new issue. Related topics were not shown.
http://forum.com/index.php?action=admin;area=relatedtopics;sa=methods;save
Apply Filter: Only show the errors with the same message
2: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed
Apply Filter: Only show the errors from this file
File: /home/public_html/forum/Sources/RelatedTopics.php
Line: 119
http://forum.com/index.php?action=admin;area=relatedtopics;sa=methods;save
Apply Filter: Only show the errors with the same message
8: Undefined index: ignored_boards
Apply Filter: Only show the errors from this file
File: /home/public_html/forum/Sources/RelatedTopics.php
Line: 119
http://forum.com/index.php?topic=1825.0
Apply Filter: Only show the errors with the same message
8: Undefined index: can_approve_posts
Apply Filter: Only show the errors from this file
File: /home/public_html/forum/Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 791
Before installing the latest version.
with the old beta i have tried updating the index / rebuild index.
After 45 percent, it showed me this error,
Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY null' at line 153
File: /home/public_html/forum/Sources/Subs-RelatedFulltext.php
Line: 75
I recieve this error when posting a topic.
Table 'jeanie_smf.related_subjects' doesn't exist
File: /home/jeanie/public_html/forums/Sources/Subs-RelatedFulltext.php
Line: 113
It's still not working for me. I've tried it with the default curve theme and there's nothing. No errors on install, it just doesn't display any related topics. Oh well.
Quote from: imno007 on December 17, 2009, 03:26:39 PM
It's still not working for me. I've tried it with the default curve theme and there's nothing. No errors on install, it just doesn't display any related topics. Oh well.
I'm having the same problem, I have the 2.0rc2 version and install it correctly without errors .. use the SMF default theme, and when I go to some topic not have anything related topics = /
Did you build index? and is there topics that are counted as releated (check related topics tables in db)?
Edit: I fixed it.
In Subs-RelatedFulltext.php
Find
subject tinytext NOT NULL,
Replace
subject tinytext collate utf8_general_ci NOT NULL,
Some ideas for this mod:
1. Display related topics in all pages of multi-page topics (currently only displayed in last one)
2. Provide a stopword functionality, i.e. words that should not be taken into account for similarity metrics
Can it cope with UTF-8 and international characters?
I tried it on a Greek forum and it only creates related topics for posts with English titles
http://www.nonsmokersclub.com/forum/index.php?board=17.0
And not with Greek ones:
http://www.nonsmokersclub.com/forum/index.php?board=13.0
Look at the related subjects table. All Greek has been turned to quotations. I even tried changing the collation of smf_related_subjects to utf-8 but when I rebuilt index it was changed back to latin!
Quote from: Niko on December 18, 2009, 04:22:36 AM
Did you build index? and is there topics that are counted as releated (check related topics tables in db)?
I still have not established topics, or categories .. because we have not made the forum, I am in testing phases!
Now the MOD, not give me any related topic, or upgrading the database: /
get this error when trying to rebuild index:
Table '******.smf_related_topics' doesn't exist
File: /home/*******/public_html/Sources/RelatedTopics.php
Line: 179
(and same error when trying to view any thread on the site while the mod was installed)
just installed 1.4 b3
// Mod Authors for a "ADD AFTER" on this line. Ensure you end your change with a comma. For example:
'related' => array($txt['admin_related_topic']),
this is the way, it should have looked like
but installed was it as:
// Mod Authors for a "ADD AFTER" on this line. Ensure you end your change with a comma. For example: 'related' => array($txt['admin_related_topic']),
so it was disabled
Quote from: Kimmie on December 25, 2009, 03:18:20 AM
get this error when trying to rebuild index:
Table '******.smf_related_topics' doesn't exist
File: /home/*******/public_html/Sources/RelatedTopics.php
Line: 179
(and same error when trying to view any thread on the site while the mod was installed)
any ideas on this?
Can anybody tell me how to revers the order of the related topics list ?
Right now it is showing oldest topics at the top of the list. I would like to have the most recent related topics on top.
Cheers
Russian translation:
// Added by Related Topics RUS
$txt['admin_related_topic'] = 'Похожие темы';
$txt['admin_related_topics_information'] = 'Информация';
$txt['admin_related_topics_settings'] = 'Настройки';
$txt['admin_related_topics_methods'] = 'Методы';
$txt['related_topics_admin_title'] = 'Похожие темы';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = ' Последние новости';
$txt['related_news_unable_to_connect'] = 'Невозможно соединиться с <a href="http://www.smfarcade.info">SMFArcade.info</a> для получения последних новостей...';
$txt['related_version_info'] = ' Сведения о версии';
$txt['related_installed_version'] = 'Установленная версия';
$txt['related_latest_version'] = 'Последняя версия';
$txt['related_topics_ignored_boards'] = 'Игнорируемые разделы';
$txt['related_topics_methods_title'] = 'Методы';
$txt['related_topics_methods'] = 'Выберите метод, применяемый для определения похожих тем<div class="smalltext">После изменения этих настроек требуется пересборка индекса</div>';
$txt['related_topics_index'] = 'Индексация';
$txt['related_topics_rebuild'] = 'Пересборка индекса';
$txt['related_topics_rebuild_desc'] = 'Использовать это после изменения настроек или чтобы создать первоначальный кэш';
$txt['relatedFulltext'] = 'Полнотекстовый';
$txt['related_topics_settings_title'] = 'Похожие темы';
$txt['relatedTopicsEnabled'] = 'Активировать мод';
$txt['relatedTopicsCount'] = 'Как много похожих тем показывать';
$txt['no_methods_selected'] = 'Вы не выбрали используемый метод для определения похожих тем';
$txt['related_topics'] = 'Похожие темы';
// END Added by Related Topics RUS
Recommend using file languages.xml in ANSI for language translation windows-1251 and languages-utf8.xml encoded in utf8 without BOM - for language translation in the format utf8 :)
smf 1.1.11 is found?
Quote from: Tanks on January 03, 2010, 11:56:28 AM
Can anybody tell me how to revers the order of the related topics list ?
Right now it is showing oldest topics at the top of the list. I would like to have the most recent related topics on top.
Cheers
Please, anybody ? :)
Good idea Tanks, can anybody help?
I have installed the Mod on 1.1.11 and have the same problem.
Not able to see related topic in post even after enabling.
Does it work on SMF 1.1.11? Parser says "Sorry, but this modification does not appear to be compatible with the selected version."
Tried to install, and although it showed that it installed fine, there is no sign of the menu to select which boards to index.
Also, when reached 99% of indexing I got:
Duplicate entry '56601' for key 1
File: /home/xxx/public_html/forum/Sources/Subs-RelatedFulltext.php
Line: 58
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.
Quote from: ChaosEnergy on December 29, 2009, 09:56:22 AM
just installed 1.4 b3
// Mod Authors for a "ADD AFTER" on this line. Ensure you end your change with a comma. For example:
'related' => array($txt['admin_related_topic']),
this is the way, it should have looked like
but installed was it as:
// Mod Authors for a "ADD AFTER" on this line. Ensure you end your change with a comma. For example: 'related' => array($txt['admin_related_topic']),
so it was disabled
You should make these changes in Mod...
Not Showing Related Topics........ :(
I'm Using SMF 2.0 RC2
I'm too Using SMF 2.0 RC2 with 1.4 beta3 mod and when go to build index http://demo.svrljig.net/index.php?action=admin;area=relatedtopics;sa=buildIndex nothing happened just page is refreshing. Table smf_related_topics is empty and no related posts is showing. Mod is enabled. Please help :(
This MOD only shows related topics for new topics. Not for old topics !!!
I instaled on version 1.1.11 and i got an error in the END of indexing, i think, related with pretty urls. But for new topics, the MOD is working great :)
thanks
Any chance to get updated for RC3?
I'm using SMF 2.0 RC2 with 1.4 beta3 mod. When I try to run 'related_topics.php' through browser it shows message:
'Fatal error: Function name must be a string in /home/a8242326/public_html/related_topics.php on line 69'
What does it mean?
Thanks.
Still no way to prevent this mod from showing items in the trash ?? very annoying :-[
I use this mod. Please update it for RC3
no rc3 update ? :(
any update to rc3 please ?
haven't had time to update. just use version emulation until then, it should work
Quote from: scimmiotto on December 05, 2009, 09:13:22 AM
Hi
i've just installed the related topic mod on my smf 2.0 rc2 forum, but where are related topics visible? in wich part of the forum? mine is
http://ingegneria.bebnet.org
but i don't see them
Quote from: scimmiotto on December 05, 2009, 09:50:54 AM
problem solved...i mistake the ignored boards and i selected all of them :)
LOL!!! Same thing happened here hahaha... well I guess.. I'm rebuilding my index right now... so I'll see if that was the mistake... I'll edit when I have news lol.
Edit: Yeah! LMAO! It was that... and that's so stupid because I even translated the MOD to spanish and I TRANSLATED the part that said "IGNORE boards" and then I click on every board LOL..
Anyway, I bet a lot of people that couldn't see the related topic did the same thing... so uncheck all the boxes and rebuild your index and u'll see the Related Topics (running RC2)
is this mod stable for RC3?
I plan to use it if you guys say yes.
Quote from: jelence on March 14, 2010, 06:09:22 AM
I'm using SMF 2.0 RC2 with 1.4 beta3 mod. When I try to run 'related_topics.php' through browser it shows message:
'Fatal error: Function name must be a string in /home/a8242326/public_html/related_topics.php on line 69'
What does it mean?
Thanks.
Please?
can it be run on RC3?
In 1.4 Beta 3, install.xml, <file name="$themedir/Display.template.php"> part:
</tr>
</thead>
<tbody>';
foreach ($context['related_topics'] as $topic)
tbody element is left open. Fixing it eliminates xhtml errors.
Quote from: aw06 on March 16, 2010, 04:53:08 PM
Still no way to prevent this mod from showing items in the trash ?? very annoying :-[
BUUUUMMMPPPP
Quote from: budun on April 13, 2010, 12:39:26 PM
In 1.4 Beta 3, install.xml, <file name="$themedir/Display.template.php"> part:
</tr>
</thead>
<tbody>';
foreach ($context['related_topics'] as $topic)
tbody element is left open. Fixing it eliminates xhtml errors.
Thank you for reply!
I have found this piece of code, and it looks exactly like yours.
I don't know php, so, I don't know how to close tbody element, and where ?
Can you help me :-[?
Quote from: giveaway365.com on April 10, 2010, 03:18:36 AM
can it be run on RC3?
Use emulation with SMF 2.0 RC2 on install.
Quote from: Bugo on April 14, 2010, 05:39:52 AM
Quote from: giveaway365.com on April 10, 2010, 03:18:36 AM
can it be run on RC3?
Use emulation with SMF 2.0 RC2 on install.
how to use emulation ? I have no option like that on RC3 :(
Quote from: giveaway365.com on April 14, 2010, 07:05:35 AM
how to use emulation ? I have no option like that on RC3 :(
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg72.imageshack.us%2Fimg72%2F6398%2Fpackages.png&hash=5b642d2fc7b4c9b18d2c5e525c91dbf5974d98dc)
Admin CP > Package Manager > Browse Packages
Click on "Advanced".
Change "Emulate Version: SMF 2.0 RC3" to "Emulate Version: SMF 2.0 RC2".
Click "Apply".
Now, you should be able to install Related Topics 1.4 Beta 3.
Alternatively, instead of using emulation, you can edit the package.
Extract the zip package.
Open package-info.xml file with notepad or another text editor.
Find:
<install for="2.0 RC2">Replace with:
<install for="2.0 RC2, 2.0 RC3">Find:
<uninstall for="2.0 RC2">Replace with:
<uninstall for="2.0 RC2, 2.0 RC3">After making the edits, save the file.
Zip the package again.
If you choose to edit the package, you can also fix the part where the tbody element is left open.
Quote from: jelence on April 14, 2010, 05:33:57 AM
Quote from: budun on April 13, 2010, 12:39:26 PM
In 1.4 Beta 3, install.xml, <file name="$themedir/Display.template.php"> part:
</tr>
</thead>
<tbody>';
foreach ($context['related_topics'] as $topic)
tbody element is left open. Fixing it eliminates xhtml errors.
Thank you for reply!
I have found this piece of code, and it looks exactly like yours.
I don't know php, so, I don't know how to close tbody element, and where ?
Can you help me :-[?
I dont know much about php or html either. :) But this edit will eliminate markup validation warnings related to the tbody element which is left open. Please note that this has nothing to do with your post here (http://www.simplemachines.org/community/index.php?topic=49410.msg2538833#msg2538833).
In order to close the tbody element:
Extract Related Topics 1.4 Beta 3 zip package.
Open install.xml file.
At the end of <file name="$themedir/Display.template.php"> part:
Find:
echo '
</table>
</div><br />';
}
Replace with:
echo '
</tbody>
</table>
</div><br />';
}
After making the edit, zip the package again.
If you have Related Topics 1.4 Beta 3 package already installed, you can do the same edit on
Display.template.php file of your themedir using the cPanel of your server. But this would complicate things a bit. You will end up with errors if you try to uninstall the mod from Package Manager option in the Admin CP of SMF, because the modifications are altered. To prevent this, in the File Manager of the cPanel of your server, you should also replace the Related_Topics_1.4_Beta_3.zip package with the edited one. (Packages subdirectory of the directory containing your SMF install)
If this is complicated, just uninstall and delete Related Topics 1.4 Beta 3 package first. Then upload and reinstall the newly edited package.
Thanks budun :)!
I will try to remove it all, change cod, and then install again...
gr8!!
Thanks for the tutorial!
:)
Installed perfectly on 2.0RC3.
Quote from: jelence on March 14, 2010, 06:09:22 AM
I'm using SMF 2.0 RC2 with 1.4 beta3 mod. When I try to run 'related_topics.php' through browser it shows message:
'Fatal error: Function name must be a string in /home/a8242326/public_html/related_topics.php on line 69'
What does it mean?
Thanks.
I am having the same problem :(
Fatal error: Function name must be a string in /home/websit51/public_html/helponrelation.com/forum/related_topics.php on line 69
as "budun" told I have just edited it and install on RC3, not it works, you can see in the picture. edited file is attached to the message.
http://uploading.com/files/6d9c57ma/Related_Topics_1.4_Beta_3.zip/
Hi Guys
I did the same and its not working ...
Though it installed successfully but as I told you if i run that file on the server directly I got some errors
(told in above post)
There might be some issue with the installed mods
which are
1. Related Topics 1.4 Beta 3 [ Uninstall ]
2. Curve_centered_menu 1.1 [ Uninstall ]
3. Limit A Guests Daily PageViews Mod 2.1 [ Uninstall ]
4. Welcome Topic Mod 2.1 [ Uninstall ]
5. PM Notification Bar 2.0 [ Uninstall ]
6. Hack's Park Shoutbox 2.0.2 [ Uninstall ]
7. RSS Feed Icon 1.1 [ Uninstall ]
8. Referrals Mod 2.2.7.2 [ Uninstall ]
9. Blizzard WOW Quotes 1.1 [ Uninstall ]
10. SMF Trader System 1.4.3 [ Uninstall ]
11. SimplePortal 2.3.2 [ Uninstall ]
12. Topic Solved 1.1 [ Uninstall ]
13. MetaTags Modification 1.4 [ Uninstall ]
14. AjaxChat Integration 3.2.1 (modified for SMF 2 RC3) [ Uninstall ]
15. Thank-O-Matic 2.0 RC2 [ Uninstall ]
16. SA Shop 0.4.7 [ Uninstall ]
17. eFloating Bar for Guest & Members 0.1 [ Uninstall ]
18. Ad Managment 2.3.6.2 [ Uninstall ]
19. Global Headers Footers 2.0 [ Uninstall ]
20. Google Analytics Code 1.1 [ Uninstall ]
21. SA FBConnect 0.1 Final [ Uninstall ]
22. Google Search Your Site 1.0.0 [ Uninstall ]
23. Additional Home page Title | S-Ace 3.0 [ Uninstall ]
24. AJAX Instant Quick Reply 1.0.3 [ Uninstall ]
25. Sitemap 2.1.2 [ Uninstall ]
26. Copyright & Footer Links | S-Ace 3.1 [ Uninstall ]
27. Increase Number of Visitors (cheat) 1.0 [ Uninstall ]
28. Yet Another Global Announcements Mod 2.7.3 [ Uninstall ]
29. SMF Bay LITE 1.0.3 [ Uninstall ]
Pls guide me as soon as possible as I badly need this
thanks bundun due to your help, i also successfully added Related Topic Mod to my forum...... ;D ;D ;D
Related Topics 1.4 RC1 released with RC3 support! No other changes were made.
Quote from: Niko on May 29, 2010, 12:59:38 PM
Related Topics 1.4 RC1 released with RC3 support! No other changes were made.
just tested this on rc2 and i'm trying to change the 'ignore boards option' and i get this error:
'The database value you're trying to insert does not exist: value'
also i don't see this anywhere (i made 2 topics with the same names and it doesn't show the others on topic view)
Quote from: zx71 on May 29, 2010, 01:03:23 PM
Quote from: Niko on May 29, 2010, 12:59:38 PM
Related Topics 1.4 RC1 released with RC3 support! No other changes were made.
just tested this on rc2 and i'm trying to change the 'ignore boards option' and i get this error:
'The database value you're trying to insert does not exist: value'
also i don't see this anywhere (i made 2 topics with the same names and it doesn't show the others on topic view)
I was also having the same error in all the 3 sites of mine here how I fixed it ... it was actually with the default board that smf make during the installation.. .just make other board and delete the old board and during deletion it will ask you to move the topics under board to some other board and by this you will get it fixed....
PS: Just try to activate related topics one by one to detect that board having problem with..
Quote from: zx71 on May 29, 2010, 01:03:23 PM
Quote from: Niko on May 29, 2010, 12:59:38 PM
Related Topics 1.4 RC1 released with RC3 support! No other changes were made.
just tested this on rc2 and i'm trying to change the 'ignore boards option' and i get this error:
'The database value you're trying to insert does not exist: value'
Same error I had, Niko.
Here's what shows in the error logs:
The database value you're trying to insert does not exist: value
Function: updateSettings
File: /home/*****/public_html/forum.com/Sources/Subs.php
Line: 6102: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passedFile: /home/******/public_html/forum.com/Sources/RelatedTopics.php
Line: 1198: Undefined index: ignored_boards
File: /home/*****/public_html/forum.com/Sources/RelatedTopics.php
Line: 119
thanx a lot... it helped me a lot... I luv it.
so any fix for this yet?
Hi! Great Mod! It's about time there was a Related Topics mod for SMF 2
I have one issue though. is there any way to filter out the topic pointing to the same topic you're already looking at?
Thanks!
Turkish Translate :
// Added by Related Topics
$txt['admin_related_topic'] = 'Benzer Konular';
$txt['admin_related_topics_information'] = 'Bilgiler';
$txt['admin_related_topics_settings'] = 'Ayarlar';
$txt['admin_related_topics_methods'] = 'Metodlar';
$txt['related_topics_admin_title'] = 'Benzer Konular';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Son Yenilikler';
$txt['related_news_unable_to_connect'] = 'Bağlanamama hatası <a href="http://www.smfarcade.info">SMFArcade.info</a> ';
$txt['related_version_info'] = 'Versiyon Bilgisi';
$txt['related_installed_version'] = 'Kurulu Versiyon';
$txt['related_latest_version'] = 'En Son Versiyon';
$txt['related_topics_ignored_boards'] = 'Gözardı edilecek Bölümler';
$txt['related_topics_methods_title'] = 'Metodlar';
$txt['related_topics_methods'] = 'Lütfen Benzer Konu için Kullanacagınız Metodu seciniz <div class="smalltext">Yeniden yapılandırma için Index gereklidir.</div>';
$txt['related_topics_index'] = 'Index';
$txt['related_topics_rebuild'] = 'Yeniden Indexi yapılandır';
$txt['related_topics_rebuild_desc'] = 'Benzer konular için ön bellek hazırlar bu değişim';
$txt['relatedFulltext'] = 'Tam Metin';
$txt['related_topics_settings_title'] = 'Benzer Konular';
$txt['relatedTopicsEnabled'] = 'Benzer Konuları Aktif et';
$txt['relatedTopicsCount'] = 'Kaç adet benzer konu başlığı gözüksün ?';
$txt['no_methods_selected'] = 'Hangi yöntemi kullanacagınızı seçmediniz';
$txt['related_topics'] = 'Benzer Konular';
// END Added by Related Topics
I've installed this but its not showing at all (I've enabled it and checked the boxes for the forums), I'm using SMF 2.0 RC3 with a custom theme.
Here's a link to a random thread: http://thewitchespath.com/index.php?topic=298.msg1823#new
Edit: Just checked and it doesnt work on any theme, I did use the rebuild index thing but it made no difference
Quote from: PurpleCrow on June 15, 2010, 01:47:23 PM
I've installed this but its not showing at all (I've enabled it and checked the boxes for the forums), I'm using SMF 2.0 RC3 with a custom theme.
Here's a link to a random thread: http://thewitchespath.com/index.php?topic=298.msg1823#new
Edit: Just checked and it doesnt work on any theme, I did use the rebuild index thing but it made no difference
I'm having the same problem. Did you manage to fix this?
Quote from: SallyM on June 19, 2010, 12:16:31 AM
Quote from: PurpleCrow on June 15, 2010, 01:47:23 PM
I've installed this but its not showing at all (I've enabled it and checked the boxes for the forums), I'm using SMF 2.0 RC3 with a custom theme.
Here's a link to a random thread: http://thewitchespath.com/index.php?topic=298.msg1823#new
Edit: Just checked and it doesnt work on any theme, I did use the rebuild index thing but it made no difference
I'm having the same problem. Did you manage to fix this?
I think (dont quote me on it LOL) that the mod will only add topics to the "Related TOpics" bit if it thinks there are any relevent topics about. Some threads dont have anything, some have a couple of threads there.
I get following error:
Table 'smf_related_subjects' doesn't exist
Datei: C:\inetpub\vhosts\windows-phone.info\httpdocs\forum\Sources\Subs-RelatedFulltext.php
Zeile: 78
when I click on rebuild index - it's a new installation on 2.0 rc 3
nice mod there
here is the arabic translation
// Added by Related Topics
$txt['admin_related_topic'] = 'مواضيع مشابهة';
$txt['admin_related_topics_information'] = 'معلومات';
$txt['admin_related_topics_settings'] = 'خصائص';
$txt['admin_related_topics_methods'] = 'طرق';
$txt['related_topics_admin_title'] = 'مواضيع مشابهة';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'آخر الأخبار';
$txt['related_news_unable_to_connect'] = 'لم نستطع الإتصال ب <a href="http://www.smfarcade.info">SMFArcade.info</a> من أجل الحصول على آخر الأخبار';
$txt['related_version_info'] = 'معلومات النسخة';
$txt['related_installed_version'] = 'النسخة المثبتة';
$txt['related_latest_version'] = 'آخر نسخة';
$txt['related_topics_settings_title'] = 'مواضيع مشابهة';
$txt['related_topics_methods_title'] = 'طرق';
$txt['related_topics_methods'] = 'إختر الطرق التي يتم جلب المواضيع المشابهة عبرها<div class="smalltext">إعادة إنشاء الفهرس بعد تعديل هذا الخيار إجباري</div>';
$txt['related_topics_index'] = 'الفهرس';
$txt['related_topics_rebuild'] = 'إعادة إنشاء الفهرس';
$txt['related_topics_rebuild_desc'] = 'إستعمل هذا الخيار بعد تعديل الخصائص أو تحديث التخزين المؤقت';
$txt['relatedFulltext'] = 'Fulltext';
$txt['relatedTopicsEnabled'] = 'تفعيل المواضيع المشابهة';
$txt['relatedTopicsCount'] = 'عدد المواضيع التي يتم عرضها';
$txt['relatedIgnoredboards'] = 'المنتديات التي يتم تجاهلها<div class="smalltext">إفصل بين كل منتدى بفاصلة (,)</div>';
$txt['no_methods_selected'] = 'لم تقم بإختيار أي طريقة التي يتم جلب المواضيع المشابهة بها';
$txt['related_topics'] = 'المواضيع المشابهة';
// END Added by Related Topics
if you can
please add the translation and the SmfArabic team's copyrights in readme
thank you
no fix?
For the ones,who would like to colorize the usernames in related topics table
Only 1.1.x
./Sources/Subs-Related.php
$topics_ids = implode(',', $topics_ids);
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
$topics_ids = implode(',', $topics_ids);
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL, mgf.ID_GROUP, mgf.onlineColor,
mgl.ID_GROUP AS lastID_GROUP, mgl.onlineColor AS lastOnlineColor,
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE $user_info[query_see_board]
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
LEFT JOIN {$db_prefix}membergroups AS mgf ON (mgf.ID_GROUP = IF(memf.ID_GROUP = 0, memf.ID_POST_GROUP, memf.ID_GROUP))
LEFT JOIN {$db_prefix}membergroups AS mgl ON (mgl.ID_GROUP = IF(meml.ID_GROUP = 0, meml.ID_POST_GROUP, meml.ID_GROUP))
WHERE $user_info[query_see_board]
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'username' => $row['firstMemberName'],
'name' => $row['firstDisplayName'],
'id' => $row['firstID_MEMBER'],
'href' => !empty($row['firstID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] : '',
'link' => !empty($row['firstID_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstDisplayName'] . '">' . $row['firstDisplayName'] . '</a>' : $row['firstDisplayName']
),
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'username' => $row['firstMemberName'],
'name' => $row['firstDisplayName'],
'id' => $row['firstID_MEMBER'],
'href' => !empty($row['firstID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] : '',
'link' => empty($row['firstID_MEMBER']) ? $row['firstDisplayName'] : (!empty($row['ID_GROUP']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '"><span style="color:'.$row['onlineColor'].'">' . $row['firstDisplayName'] . '</span></a>' : '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '">' . $row['firstDisplayName'] . '</a>')
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'username' => $row['lastMemberName'],
'name' => $row['lastDisplayName'],
'id' => $row['lastID_MEMBER'],
'href' => !empty($row['lastID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] : '',
'link' => !empty($row['lastID_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '">' . $row['lastDisplayName'] . '</a>' : $row['lastDisplayName']
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'username' => $row['lastMemberName'],
'name' => $row['lastDisplayName'],
'id' => $row['lastID_MEMBER'],
'href' => !empty($row['lastID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] : '',
'link' => empty($row['lastID_MEMBER']) ? $row['lastDisplayName'] : (!empty($row['lastID_GROUP']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '"><span style="color:'.$row['lastOnlineColor'].'">' . $row['lastDisplayName'] . '</span></a>' : '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '">' . $row['lastDisplayName'] . '</a>')
),
Quote from: Delita Heiral on May 30, 2010, 01:29:10 PM
2: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passedFile: /home/******/public_html/forum.com/Sources/RelatedTopics.php
Line: 119
Got exact same error in a new forum.
Quote from: Duncan85 on July 11, 2010, 05:02:47 AM
For the ones,who would like to colorize the usernames in related topics table
Only 1.1.x
./Sources/Subs-Related.php
$topics_ids = implode(',', $topics_ids);
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
$topics_ids = implode(',', $topics_ids);
$result = db_query("
SELECT
t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL, mgf.ID_GROUP, mgf.onlineColor,
mgl.ID_GROUP AS lastID_GROUP, mgl.onlineColor AS lastOnlineColor,
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
WHERE $user_info[query_see_board]
LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)") . "
LEFT JOIN {$db_prefix}membergroups AS mgf ON (mgf.ID_GROUP = IF(memf.ID_GROUP = 0, memf.ID_POST_GROUP, memf.ID_GROUP))
LEFT JOIN {$db_prefix}membergroups AS mgl ON (mgl.ID_GROUP = IF(meml.ID_GROUP = 0, meml.ID_POST_GROUP, meml.ID_GROUP))
WHERE $user_info[query_see_board]
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'username' => $row['firstMemberName'],
'name' => $row['firstDisplayName'],
'id' => $row['firstID_MEMBER'],
'href' => !empty($row['firstID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] : '',
'link' => !empty($row['firstID_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstDisplayName'] . '">' . $row['firstDisplayName'] . '</a>' : $row['firstDisplayName']
),
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'username' => $row['firstMemberName'],
'name' => $row['firstDisplayName'],
'id' => $row['firstID_MEMBER'],
'href' => !empty($row['firstID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] : '',
'link' => empty($row['firstID_MEMBER']) ? $row['firstDisplayName'] : (!empty($row['ID_GROUP']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '"><span style="color:'.$row['onlineColor'].'">' . $row['firstDisplayName'] . '</span></a>' : '<a href="' . $scripturl . '?action=profile;u=' . $row['firstID_MEMBER'] . '">' . $row['firstDisplayName'] . '</a>')
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'username' => $row['lastMemberName'],
'name' => $row['lastDisplayName'],
'id' => $row['lastID_MEMBER'],
'href' => !empty($row['lastID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] : '',
'link' => !empty($row['lastID_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '">' . $row['lastDisplayName'] . '</a>' : $row['lastDisplayName']
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'username' => $row['lastMemberName'],
'name' => $row['lastDisplayName'],
'id' => $row['lastID_MEMBER'],
'href' => !empty($row['lastID_MEMBER']) ? $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] : '',
'link' => empty($row['lastID_MEMBER']) ? $row['lastDisplayName'] : (!empty($row['lastID_GROUP']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '"><span style="color:'.$row['lastOnlineColor'].'">' . $row['lastDisplayName'] . '</span></a>' : '<a href="' . $scripturl . '?action=profile;u=' . $row['lastID_MEMBER'] . '">' . $row['lastDisplayName'] . '</a>')
),
What do you mean colorize?
Thanks but i am currently using Custom index as the search method on my SMF 1.1.11
Is there a way for you to update your mod to make it work with Custom index, as it is much better than Fulltext index.
Thanks again for this nice mod, but i do not want to settle for the less stable Fulltext, as Custom index is much more stable and also more accurate.
Quote from: venex on July 17, 2010, 10:13:53 PM
What do you mean colorize?
Like you see the membernames in online list by their membergroup color,this will be same for the related topics table
I installed it successfully. But the related topics are pointing to boards instead of the main topic people clicked, Is it how it was made?. Is these a problem, if it is how can I solve this? view my site to see what I am talking about www.africatopforum.com
My above question is solved. Did one have to be building the index manually or doest happens automatically after the first build index?
Quote from: perfec2 on July 21, 2010, 03:48:40 PM
My above question is solved. Did one have to be building the index manually or doest happens automatically after the first build index?
Normally, you only have to build it once, but i did the same thing and the search results were better if i rebuild it manually afterward. Must be a bug in SMF.
How often do you do that?
Quote from: perfec2 on July 22, 2010, 04:38:20 AM
How often do you do that?
i guess it depends on the size of your forum. how many posts do you have? and how many new posts are added every day?
once a week works for the very active forum. if you have a forum the size of this one, then probably once a day. lol
This looks like extral work. Thanks for your assistance.
after install of related topics 1.4 rc1 I get the error:
QuoteTable 'smf_related_subjects' doesn't exist
hope someone can help me
Hi. I am getting this error, although the installation went fine, but there's no such table at the tabase for sure, chcked myself:
Table 'forum.smf_related_subjects' doesn't exist
File: /home/NAME/public_html/forum/Sources/Subs-RelatedFulltext.php
Line: 116
What query i should execute to get it created?
Quote from: frozenas on July 30, 2010, 07:54:30 PM
Hi. I am getting this error, although the installation went fine, but there's no such table at the tabase for sure, chcked myself:
Table 'forum.smf_related_subjects' doesn't exist
File: /home/NAME/public_html/forum/Sources/Subs-RelatedFulltext.php
Line: 116
What query i should execute to get it created?
Try attached file,upload to the root directory,where SSI.php is also located and run php file by calling this url
http://www.yoursite.com/related_topics.php
i have just install this mod bit still now showing relatedTopic please help me i have manauly modify Display.template.php
but Still Not working please help me
Rebuild Indexes button %2
Database error, given array of integer values is empty. (topics)
problemli 2.0.RC2
Translation by MOD Translator SirtLanVadisi in german and german-utf8 languages version 1.4 rc1
<file name="$themedir/languages/Modifications.german.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Related Topics Mod translation by SirtLanVadisi.NeT
$txt['admin_related_topic'] = 'Zusammenhängende Themen';
$txt['admin_related_topics_information'] = 'Informationen';
$txt['admin_related_topics_settings'] = 'Einstellungen';
$txt['admin_related_topics_methods'] = 'Methoden';
$txt['related_topics_admin_title'] = 'Zusammenhängende Themen';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Letzte Nachrichten';
$txt['related_news_unable_to_connect'] = 'Keine Verbindung zum<a href="http://www.smfarcade.info">SMFArcade.info</a> für die neuesten Nachrichten zu verbinden....';
$txt['related_version_info'] = 'Version Information';
$txt['related_installed_version'] = 'Installierte Version';
$txt['related_latest_version'] = 'Letzte Version';
$txt['related_topics_ignored_boards'] = 'Ignorierte Boards';
$txt['related_topics_methods_title'] = 'Methoden';
$txt['related_topics_methods'] = 'Wählen Sie die Methoden zur Bestimmung Verwandte Themen<div class="smalltext">Umbau der Index verwendet wird, nachdem Sie diese Einstellungen ändern müssen</div>';
$txt['related_topics_index'] = 'Index';
$txt['related_topics_rebuild'] = 'Bauen Sie Indexs wieder auf';
$txt['related_topics_rebuild_desc'] = 'Verwenden Sie diese nach Änderung der Einstellungen oder erste Cache bauen';
$txt['relatedFulltext'] = 'Fulltext';
$txt['related_topics_settings_title'] = 'Zusammenhängende Themen';
$txt['relatedTopicsEnabled'] = 'Zusammenhängende Themen Aktif';
$txt['relatedTopicsCount'] = 'Wie viele zusammenhängende Themen, um sich zu zeigen';
$txt['no_methods_selected'] = 'Sie Zufluchtsort gewählt, die Methoden zu nutzen, um Themen zu bestimmen';
$txt['related_topics'] = 'Zusammenhängende Themen';
// Related Topics Mod translation by SirtLanVadisi.NeT
]]></add>
</operation>
</file>
<file name="$themedir/languages/Modifications.german-utf8.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
// Related Topics Mod translation by SirtLanVadisi.NeT
$txt['admin_related_topic'] = 'Zusammenhängende Themen';
$txt['admin_related_topics_information'] = 'Informationen';
$txt['admin_related_topics_settings'] = 'Einstellungen';
$txt['admin_related_topics_methods'] = 'Methoden';
$txt['related_topics_admin_title'] = 'Zusammenhängende Themen';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Letzte Nachrichten';
$txt['related_news_unable_to_connect'] = 'Keine Verbindung zum<a href="http://www.smfarcade.info">SMFArcade.info</a> für die neuesten Nachrichten zu verbinden....';
$txt['related_version_info'] = 'Version Information';
$txt['related_installed_version'] = 'Installierte Version';
$txt['related_latest_version'] = 'Letzte Version';
$txt['related_topics_ignored_boards'] = 'Ignorierte Boards';
$txt['related_topics_methods_title'] = 'Methoden';
$txt['related_topics_methods'] = 'Wählen Sie die Methoden zur Bestimmung Verwandte Themen<div class="smalltext">Umbau der Index verwendet wird, nachdem Sie diese Einstellungen ändern müssen</div>';
$txt['related_topics_index'] = 'Index';
$txt['related_topics_rebuild'] = 'Bauen Sie Indexs wieder auf';
$txt['related_topics_rebuild_desc'] = 'Verwenden Sie diese nach Änderung der Einstellungen oder erste Cache bauen';
$txt['relatedFulltext'] = 'Fulltext';
$txt['related_topics_settings_title'] = 'Zusammenhängende Themen';
$txt['relatedTopicsEnabled'] = 'Zusammenhängende Themen Aktif';
$txt['relatedTopicsCount'] = 'Wie viele zusammenhängende Themen, um sich zu zeigen';
$txt['no_methods_selected'] = 'Sie Zufluchtsort gewählt, die Methoden zu nutzen, um Themen zu bestimmen';
$txt['related_topics'] = 'Zusammenhängende Themen';
// Related Topics Mod translation by SirtLanVadisi.NeT
]]></add>
</operation>
</file>
Too bad Niko has abandoned this excellent mod. It's very useful.
Hello @ all smf community.
I've successfull install and use this mod but guest can't see it.
Can you help me ?
regards
Quote from: sharks on September 24, 2010, 07:21:25 PM
Too bad Niko has abandoned this excellent mod. It's very useful.
I haven't abandoned this mod.
after successful installation... i cant see my topics whn clicked???
i uninstalled it but samr problem :(
link is in signature
Quote from: codevarun on April 21, 2010, 06:35:04 AM
Quote from: jelence on March 14, 2010, 06:09:22 AM
I'm using SMF 2.0 RC2 with 1.4 beta3 mod. When I try to run 'related_topics.php' through browser it shows message:
'Fatal error: Function name must be a string in /home/a8242326/public_html/related_topics.php on line 69'
What does it mean?
Thanks.
I am having the same problem :(
Fatal error: Function name must be a string in /home/websit51/public_html/helponrelation.com/forum/related_topics.php on line 69
Hi,
Did anyone ever manage to run the related_topics.php past this error? I didn't see any resolution in this thread. I can't seem to get past this error. Thanks!
Just updated to 2.0 RC4 so I had to re-install this mod, and it's not working :(
"Package is corrupt or not compatible with your SMF version"
Thanks.
Quote from: dsanchez on November 08, 2010, 09:07:57 AM
Just updated to 2.0 RC4 so I had to re-install this mod, and it's not working :(
"Package is corrupt or not compatible with your SMF version"
Thanks.
@dsanchez The author hasn't had a chance to upate it yet...
"1.1.6, 1.1.7, 1.1.8, 1.1.9, 2.0 RC2, 2.0 RC3" Only.
Perhaps its just a case of rebuilding/editing the XML info inside the package? you might like to give that ago whilst waiting for the author.
@anyone else :)
Has anyone tried this on a big board - does it have an impact? and does it work with Sphinx?
Quote from: Tony on November 08, 2010, 09:13:54 AM
Has anyone tried this on a big board - does it have an impact? and does it work with Sphinx?
My board has near 70 000 posts and 3000 members, and related topics has worked fine!
I have just installed this on my forum SMF 1.1.11 and no errors. I enabled it, built Fulltext index, but nothing shows up anything. It's like i never installed this mod. It's freaky. Can someone help me out? I keep going over everything, but i have indeed checked everything. There are only a few options for this mod in the Features and Options screen.
Quote from: anidea on November 02, 2010, 12:25:55 PM
Quote from: codevarun on April 21, 2010, 06:35:04 AM
Quote from: jelence on March 14, 2010, 06:09:22 AM
I'm using SMF 2.0 RC2 with 1.4 beta3 mod. When I try to run 'related_topics.php' through browser it shows message:
'Fatal error: Function name must be a string in /home/a8242326/public_html/related_topics.php on line 69'
What does it mean?
Thanks.
I am having the same problem :(
Fatal error: Function name must be a string in /home/websit51/public_html/helponrelation.com/forum/related_topics.php on line 69
Hi,
Did anyone ever manage to run the related_topics.php past this error? I didn't see any resolution in this thread. I can't seem to get past this error. Thanks!
help? I'd really like to use this too :(
Here is the error that keeps repeating itself in my forum error log:
http://www.sharks.com/smf/index.php?action=jsmodify;topic=206355;sesc;xml
Database Error: Table 'sharks_db1.db_related_subjects' doesn't exist
File: /home/sharks/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 72
Quote from: Duncan85 on July 31, 2010, 08:47:09 AM
Quote from: frozenas on July 30, 2010, 07:54:30 PM
Hi. I am getting this error, although the installation went fine, but there's no such table at the tabase for sure, chcked myself:
Table 'forum.smf_related_subjects' doesn't exist
File: /home/NAME/public_html/forum/Sources/Subs-RelatedFulltext.php
Line: 116
What query i should execute to get it created?
Try attached file,upload to the root directory,where SSI.php is also located and run php file by calling this url
http://www.yoursite.com/related_topics.php
I have tried the file and it gives me this error:
Fatal error: Function name must be a string in /home/sharks/public_html/smf/related_topics.php on line 69
I have also installed and tried this mod with a fresh SMF 1.1.9 (as this mod says it is compatible up to 1.1.9) but with the same failure.
@Niko, </tbody> tag is missing in install.xml...
Quote from: Bugo on November 15, 2010, 07:11:08 PM
@Niko, </tbody> tag is missing in install.xml...
Is that why it's not working for SMF 1.1.11?
Any help guys? I really would like to enable this nice feature on my SMF 1.1.11 :(
Maybe someone has uploaded a fixed version of this mod as attachment to their reply in this topic, but i can't find it. I have installed the 1.3.3 version from this page: http://custom.simplemachines.org/mods/index.php?mod=189
For those of you who have successfully installed this mod on SMF 1.1.11, can you please confirm that 1.3.3 is the correct package?
OK, i ran the build index from the link added by the mod and it appeared to be working for at least a few topics on my forum, but then i got this error:
Database Error
Duplicate entry '206847' for key 'PRIMARY'
File: /home/sharks/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 58
How to fix that and complete the fulltext index?
Quote from: dsanchez on November 08, 2010, 09:07:57 AM
Just updated to 2.0 RC4 so I had to re-install this mod, and it's not working :(
"Package is corrupt or not compatible with your SMF version"
Thanks.
open package-info.xml
find:
<install for="2.0 RC3">replace with:
<install for="2.0 RC4">find
<uninstall for="2.0 RC3">replace with:
<uninstall for="2.0 RC4">then upload the package and proceed with installation.
I tested in a website and its working fine without any errors in the log. :)
Quote from: sharks on November 24, 2010, 09:13:24 AM
OK, i ran the build index from the link added by the mod and it appeared to be working for at least a few topics on my forum, but then i got this error:
Database Error
Duplicate entry '206847' for key 'PRIMARY'
File: /home/sharks/public_html/smf/Sources/Subs-RelatedFulltext.php
Line: 58
How to fix that and complete the fulltext index?
In the forum maintenance, try clearing the cache then run the error check. now go to the mod & try to re build the index.
thank you very much Neo_TE :D
Can someone provide a working version for RC4?
i have installed this mod for 2 times.. but i can see any related topics??
maybe i'm missing something :(
I have a very strange, strange bug - in combination with SMF 2.0 RC4 (not tested with RC 3).
in Sources/Display.php there is following line of Code:
echo $topic; //output : 16523
// Added by Related Topics
if (!empty($modSettings['relatedTopicsEnabled']))
{
require_once($sourcedir . '/Subs-Related.php');
loadRelated($topic);
}
echo $topic; // output : 16401 - so thats the bug :-)
The problem is following part of code in subs-related.php
if (!empty($settings['message_index_preview']))
{
// Limit them to 128 characters - do this FIRST because it's a lot of wasted censoring otherwise.
$row['first_body'] = strip_tags(strtr(parse_bbc($row['first_body'], $row['first_smileys'], $row['id_first_msg']), array('<br />' => '')));
...
if I disable this line - $row['first_body'] = strip_tags... the variable $topic does not change and all works fine;
The strange thing is that the problem occurs only on this topic - perhaps also on others - but I have not found others untill now.
EDIT: The problem has to do with the first_parameter of parse_bbc in the disabled line - if I remove the third parameter so that no cache is used - all works fine...
Any chance updating the MOD to RC4??
It's working very well :)
Tanks
I have a question you see on the left hand icon that is a hot topic, plain or very hot do not show whether you are involved in the thread or not.
How to do that it was also shown that the person logged on as she wrote in this topic and not just kind of how this is the thread - these icons, so to operate as branches in the index?
Thank you for your help
Ps. sorry for the mistakes I write with a translator because English is not my native language
I had been using it on SMF 1.1.11 , then SMF 1.1.12 came out I upgraded it. I am unble to have it pass installation stage, as I am getting "atleast one error was encountered"
Please how can I get it work for SMF 1.1.12?
Did you update the package xml file to enable it to install on 1.1.12?
How would I do that sharks?
Perfec2, please see this post:
http://www.simplemachines.org/community/index.php?topic=49410.msg2584095#msg2584095
Works properly in RC5. To get this mod to work in SMF 2.0 RC4/RC5 do the following edits in the "package-info.xml" file.
Find :
<install for="2.0 RC3">
Replace With :
<install for="2.0 RC3, 2.0 RC4, 2.0 RC5">
Find :
<uninstall for="2.0 RC3">
Replace With :
<uninstall for="2.0 RC3, 2.0 RC4, 2.0 RC5">
or just follow the link in the previous post for a simpler solution ;)
Getting this error.
QuoteTable 'mocheng_omnia.smf_related_subjects' doesn't exist
File: /home/mocheng/public_html/omnia/Sources/Subs-RelatedFulltext.php
Line: 72
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.
when I tried to run http://www.mysite.com/related_topics.php
I got this
::)
Fatal error: Function name must be a string in /home/mocheng/public_html/omnia/related_topics.php on line 69
anyone got answers to this problem? Thanks.
help help help...
The mod installer hasn't been updated since the changes to the database installation methods back in 2.0 RC2 or thereabouts... so it won't work until someone updates it.
Quote from: Arantor on March 06, 2011, 08:12:59 AM
The mod installer hasn't been updated since the changes to the database installation methods back in 2.0 RC2 or thereabouts... so it won't work until someone updates it.
sir, kindly request you to update at least the installation for rc4/5.
Only the mod author can update it!
sorry, I didn't mean you to update it. Just requesting only the portion the needs to make it work... :(
While I could tell you how to fix it, I can't update the master package which means you will have to download it, unpack it, modify a file, repack it and then upload it to your site... because only the mod's author can distribute the package - no-one else is even allowed to distribute the fixed installer file.
No prob. Fixed already :)
thanks for your support.
This is a great mod... I'm another one waiting patiently for an upgrade to 2.0 RC5
Fingers crossed
Sweetwater
it doesnt installt it on rc5.
Sorry that this mod has been overlooked but now there's version for 2.0 Gold :)
Theme has also been improved so it fits in curve.
Hey Niko... first of all, thanks for updating this for 2.0 gold. :)
I tried installing this on a virgin/clean SMF 2.0 test install (never was a RC or beta or 1.x) and am getting an error similar to coolfx350's earlier when I try to post a new thread:
Table 'xxxxxx.smf_related_subjects' doesn't exist
File: /xxxxxxxx/Sources/Subs-RelatedFulltext.php
Line: 109
Sorry, but I think this is bugged. I installed on a 2.0 board and it was causing big problems. When members would click on a topic, it was often taking them to another entirely different topic, maybe one by the same author. I've used this mod in the past and I'm pretty sure that's not the way it's supposed to work - the related topics should only show up at the bottom as recommendations, correct? ;)
Could you make this mod so that it's compatible with SMF gallery. For instance, related topics based on the image's description. I tried putting it in the gallery_template.php, but it didn't work:
// Added by Related Topics
if (!empty($context['related_topics']) > 0)
{
echo '
<br />
<div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;"' : '', '>
<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
<tr class="titlebg">
<td colspan="7">', $txt['related_topics'], '</td>
</tr>
<tr>
<td width="9%" colspan="2" class="catbg3"></td>
<td class="catbg3">', $txt[70],'</td>
<td class="catbg3">', $txt[109],'</td>
<td class="catbg3">', $txt[110],'</td>
<td class="catbg3">', $txt[301],'</td>
<td class="catbg3">', $txt[111],'</td>
</tr>';
foreach ($context['related_topics'] as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));
echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="5%">
<img src="', $settings['images_url'], '/topic/', $topic['class'], '.gif" alt="" />
</td>
<td class="windowbg2" valign="middle" align="center" width="4%">
<img src="', $topic['first_post']['icon_url'], '" alt="" />
</td>
<td class="windowbg' , !empty($settings['seperate_sticky_lock']) && $topic['is_sticky'] ? '3' : '' , '" valign="middle" ', (!empty($topic['quick_mod']['remove']) ? 'id="topic_' . $topic['first_post']['id'] . '" onmouseout="mouse_on_div = 0;" onmouseover="mouse_on_div = 1;" ondblclick="modify_topic(\'' . $topic['id'] . '\', \'' . $topic['first_post']['id'] . '\', \'' . $context['session_id'] . '\');"' : ''), '>';
if (!empty($settings['seperate_sticky_lock']))
echo '
' , $topic['is_locked'] ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" id="lockicon' . $topic['first_post']['id'] . '" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" id="stickyicon' . $topic['first_post']['id'] . '" style="margin: 0;" />' : '';
echo '
', $topic['is_sticky'] ? '<b>' : '' , '<span id="msg_' . $topic['first_post']['id'] . '">', $topic['first_post']['link'], '</span>', $topic['is_sticky'] ? '</b>' : '';
// Is this topic new? (assuming they are logged in!)
if ($topic['new'] && $context['user']['is_logged'])
echo '
<a href="', $topic['new_href'], '" id="newicon' . $topic['first_post']['id'] . '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
echo '
<small id="pages' . $topic['first_post']['id'] . '">', $topic['pages'], '</small><br />
<small>', $topic['board_link'], '</small>
</td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '
</td>
<td class="windowbg' , $topic['is_sticky'] ? '3' : '' , '" valign="middle" width="4%" align="center">
', $topic['replies'], '
</td>
<td class="windowbg' , $topic['is_sticky'] ? '3' : '' , '" valign="middle" width="4%" align="center">
', $topic['views'], '
</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>';
echo '
</tr>';
}
echo '
</table>
</div>';
}
Turkish Translation...
// Added by Related Topics
$txt['admin_related_topic'] = 'Benzer Konular';
$txt['admin_related_topics_information'] = 'Bilgi';
$txt['admin_related_topics_settings'] = 'Ayarlar';
$txt['admin_related_topics_methods'] = 'Metodlar';
$txt['related_topics_admin_title'] = 'Benzer Konular';
$txt['related_topics_admin_desc'] = '';
$txt['related_latest_news'] = 'Son Haberler';
$txt['related_news_unable_to_connect'] = 'Mod sahibi adrese ulasilamadi. <a href="http://www.smfarcade.info">SMFArcade.info</a> Son haberler icin.';
$txt['related_version_info'] = 'Versiyon bilgisi';
$txt['related_installed_version'] = 'Yuklu versiyon';
$txt['related_latest_version'] = 'Son Versiyon';
$txt['related_topics_ignored_boards'] = 'Kabul edilmeyen Bolumler';
$txt['related_topics_methods_title'] = 'Metodlar';
$txt['related_topics_methods'] = 'Bu metodlar benzer konularin secilmesi icin kullanilmaktadir. <div class="smalltext"> Bu ayarlar degistirildikten sonra tekrar index yapilmasi gereklidir.</div>';
$txt['related_topics_index'] = 'Indeks';
$txt['related_topics_rebuild'] = 'Tekrar yaratilmis indeksler';
$txt['related_topics_rebuild_desc'] = 'Ayarlari degistirdikten yada anlik cache yarattiktan sonra bunu kullan.';
$txt['relatedFulltext'] = 'Tam Yazim';
$txt['related_topics_settings_title'] = 'Benzer Konular';
$txt['relatedTopicsEnabled'] = 'Benzer Konular Aktif';
$txt['relatedTopicsCount'] = 'Kac tane benzer konular gosterilsin';
$txt['no_methods_selected'] = 'Benzer konularin gosterilmesi icin hangi yolun kullanilacagini secmediniz.';
$txt['related_topics'] = 'Benzer Konular';
// End of Related Topics
I'm just curious to know if this mod is stressful on the server ?
I dont think so.
I dont think you should worry about that with this mod.
Quote from: agent47 on June 27, 2011, 12:17:40 PM
I'm just curious to know if this mod is stressful on the server ?
Unless you have >1000000 members, no
Table 'fees0_8346974_msf.smf_related_subjects' doesn't exist
File: /home/vol1/0fees.net/fees0_8346974/mortalstuntages.0fees.net/htdocs/Sources/Subs-RelatedFulltext.php
Line: 109
I unable to post new topic how to resolve
Yes I have install a pic as logo
When you run the file in my root related_topics.php displayed:
Function Must Be a string name in .... / public_html / related_topics.php on line 69
Why is THAT?
In the administration panel the mod is active.
Theme default.
Version 2.0
I got "The used table type doesn't support FULLTEXT indexes" when I'm trying to "Rebuild Indexes". What can be causing this?
I have installed in SMF 1.1.9
I have enabled the mod but it's not working that is not displaying any posts.
Quote from: f00ty on July 24, 2011, 04:24:22 PM
I got "The used table type doesn't support FULLTEXT indexes" when I'm trying to "Rebuild Indexes". What can be causing this?
Actually I have 1 custom field in my smf message tables. Is this the problem?
manual install
SMF 2.0 Last
run /related_topics.php
Fatal error: Function name must be a string in /xxx/xxx/xxx/related_topics.php on line 69
when post new topic is error viewing
Wrong value type sent to the database. Integer expected. (id_msg)
Sorry, My English is poor.
i installed this mod.. built indexes.. but i cant see anything on post page??
Quote from: f00ty on July 30, 2011, 02:07:13 PM
Quote from: f00ty on July 24, 2011, 04:24:22 PM
I got "The used table type doesn't support FULLTEXT indexes" when I'm trying to "Rebuild Indexes". What can be causing this?
Actually I have 1 custom field in my smf message tables. Is this the problem?
I deleted that field and I'm still getting the error.
"The used table type doesn't support FULLTEXT indexes
File: .../Sources/Subs-RelatedFulltext.php
Line: 28"
Anyways I see smf_related_topics made in my smf database.
After installing this mod on SMF 2.0 the regular search could no longer find anything.
After I removed this mod the forum search worked again.
No error at anytime.
Quote from: coolfx350 on February 24, 2011, 09:50:28 PM
Getting this error.
QuoteTable 'mocheng_omnia.smf_related_subjects' doesn't exist
File: /home/mocheng/public_html/omnia/Sources/Subs-RelatedFulltext.php
Line: 72
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.
when I tried to run http://www.mysite.com/related_topics.php
I got this
::)
Fatal error: Function name must be a string in /home/mocheng/public_html/omnia/related_topics.php on line 69
the answer to this is on page 27 and 28 of this thread, i had same problem and that solved mine. however after the above step, go to your Admin panel, clear the couch, then click on find and repair. After that go to the related topic link in you admin panel > general settings > then click on rebuild index and that's all
this mod is dead or alive?? i mean can i get any help from here??
Quote from: !RFAN on October 21, 2011, 06:40:19 AM
this mod is dead or alive?? i mean can i get any help from here??
I'd say it's dead 8)
Quote from: Niko on October 21, 2011, 06:36:24 PM
Quote from: shuban on October 21, 2011, 05:22:56 PM
Quote from: !RFAN on October 21, 2011, 06:40:19 AM
this mod is dead or alive?? i mean can i get any help from here??
I'd say it's dead 8)
Not quite ;)
Thanks :)
I installed this mod many times.. built indexes but i cant see related topics on post page? What should i do??
hi, i have this error:
Unknown column 'id_topic' in 'where clause'
Arquivo: /home/marcos/public_html/smf/Sources/Subs-RelatedFulltext.php
Linha: 109
somebody help-me! :(
when I try to create a new thread get this error:
Unknown column 'id_topic' in 'where clause'
Arquivo: /home/marcos/public_html/smf/Sources/Subs-RelatedFulltext.php
Linha: 109
topic DEAD?
My forum says that this mod don't support my version of forum and my version is 2.0.1 :(
I tryed both archives.Help?I really cant manually install this...
i installed the mod, but nothing is showing
This not work for my version.
I have 2.0.1 version...
Works just fine on my SMF2.0.1
Emulate SMF2.0 when you install
Settings -> Related Topics -> Methods - Rebuild Indexes (link on bottom left)
Settings -> Related Topics -> Settings - Enable Related Topics
And there you go!
Related Topics not seen by guest or members. Only one that can see the related topics is the admin. So what is the deal ? Is there some setting for this ?
I logged in as a non admin and I see no related topics on a post that has related topics while logged in as admin. I do not login and visit as a guest and get the same thing, no related topics.
Please, update.
Please, please, version emulation
How can I install a mod that doesn't work in my SMF version? (http://wiki.simplemachines.org/smf/How_can_install_a_mod_that_doesn%27t_work_in_my_SMF_version)
Its sad to when i see My site visitors Find the information they're came for Directly from Google, facebook or other links.. then Leave the Page immediately Because the HOME button is too small or nothing else eye catching to read.
This Mod is A LIFE SAVER - It shows Exactly the related posts of the article being read. WOW!
Gives my visitors more reason to stay on the site a little longer..
Those having Problems installing it.. I use SMF 2.0.2 and it shows mod not supported So i EMULATE 2.0 version and it installed smoothly.
Topic dead, the author doesn't help the users
Quote from: Diego Andrés on January 01, 2012, 03:27:34 PM
Topic dead, the author doesn't help the users
Well, others are trying to help, but it doesn't change the fact that this mod is still abandoned as nobody fixes its bugs or updates it to be 100% compatible with the latest SMF 1.1.x or SMF 2.x (without any bypass methods).
Run this on 2.0.2 or not?
Quote from: sharks on January 02, 2012, 12:15:43 AM
Quote from: Diego Andrés on January 01, 2012, 03:27:34 PM
Topic dead, the author doesn't help the users
Well, others are trying to help, but it doesn't change the fact that this mod is still abandoned as nobody fixes its bugs or updates it to be 100% compatible with the latest SMF 1.1.x or SMF 2.x (without any bypass methods).
It works for the latest version of SMF 1.1.x. I have it working on mine.
OK
runs now on my 2.0.2 but there are many errors in the acp
Is it possible to manipulate this mod so that is produces Related Topics that have no replies? :-\
1.x
Quote from: Guillelmus on November 20, 2011, 08:36:42 PM
Works just fine on my SMF2.0.1
Emulate SMF2.0 when you install
Settings -> Related Topics -> Methods - Rebuild Indexes (link on bottom left)
Settings -> Related Topics -> Settings - Enable Related Topics
And there you go!
Really?? Can you please help, I am using the default theme on smf2.0.1 but doesnt work
It gives error in installation in core theme.
I'm using SMF 2.0
Quote from: Game.ruler on February 04, 2012, 03:47:47 PM
It gives error in installation in core theme.
I'm using SMF 2.0
Wat kind of error?
IF it says its a different version of smf then try using the emulator....
I know u d ask me what the emulator is
:laugh:
The related topics mod shows the oldest posts first - is there anyway to modify this so it shows the newest posts first?
Not sure if it was the best way to do it, but I managed to solve the problem by adding "ORDER BY lastPosterTime DESC" to the MySQL query.
Quote from: sharks on January 02, 2012, 12:15:43 AM
Quote from: Diego Andrés on January 01, 2012, 03:27:34 PM
Topic dead, the author doesn't help the users
Well, others are trying to help, but it doesn't change the fact that this mod is still abandoned as nobody fixes its bugs or updates it to be 100% compatible with the latest SMF 1.1.x or SMF 2.x (without any bypass methods).
What bugs exactly ?
Finally got updated for SMF 2.0.2. Also support for SMF 1.1 version dropped and no longer available here.
What changes 1.4.1 to 1.4?
I got this problem
QuoteThe used table type doesn't support FULLTEXT indexes
Archivo: /www/mundonet.org/htdocs/foro/Sources/Subs-RelatedFulltext.php
Línea: 29
That's when I try to rebuild index
Quote from: Diego Andrés on March 20, 2012, 12:20:12 AM
I got this problem
QuoteThe used table type doesn't support FULLTEXT indexes
Archivo: /www/mundonet.org/htdocs/foro/Sources/Subs-RelatedFulltext.php
Línea: 29
That's when I try to rebuild index
You most likely use InnoDB for tables and your MySQL version doesn't support FULLTEXT on InnoDB. (The only version that support is 5.6.4)
It installed fine with no errors but nothing shows up. :(
It installed perfectly and i've rebuild index and enabled it...but no related topics are shown when i open topics though in real topic has some related topics...
Pls help n thanks in advance
Quote from: drfun on September 18, 2011, 04:14:08 PM
Quote from: coolfx350 on February 24, 2011, 09:50:28 PM
Fatal error: Function name must be a string in /home/mocheng/public_html/omnia/related_topics.php on line 69
the answer to this is on page 27 and 28 of this thread
drfun,
I've looked at pages 27 & 28 and
I don't see a solution anywhere.
I did my part by doing some php research following by some troubleshooting. So far I believe this error possibly comes from 3 issues:
1) The code is using a predefined system variable name
2) The code is using a
$ when it shouldn't be
3) The code is using square brackets [] instead of round brackets ()
I changed
$smcFunc to a different name,
$smcFuncRT, all throughout the entire file, got the same error as above,
Function name must be a stringI changed
$smcFunc to
smcFunc, got
syntax error, unexpected '[' on line 69.
I changed
$smcFunc['db_list_tables']() to
$smcFunc('db_list_tables')(), got
syntax error, unexpected '(' on line 69.
I changed
$smcFunc['db_list_tables']() to
$smcFunc['db_list_tables'][], got
Cannot use [] for reading on line 69.
I dropped the end brackets (), using just
$smcFunc['db_list_tables'], got
in_array() expects parameter 2 to be array on line 75 &
Function name must be a string on line 79.
I am at a lost.
I am using SMF v2.0 and I've manually installed both mod versions 1.4 & 1.4.1. I ran a file compare on these two versions and none of the code has changed, only updated version numbers and the addition of a "New-BSD" license. That is it; v1.4 & v1.4.1 are one & the same as far as manual installs goes.
Can someone please share how to fix this?
The closest person do help was Arantor on page 29, who said the following:
Quote from: Arantor on March 06, 2011, 12:41:36 PM
While I could tell you how to fix it, I can't update the master package which means you will have to download it, unpack it, modify a file, repack it and then upload it to your site... because only the mod's author can distribute the package - no-one else is even allowed to distribute the fixed installer file.
Quote from: drfun on September 18, 2011, 04:14:08 PMi had same problem and that solved mine.
WHY OH WHY do people post things like this? This is a community of helping others -- please just share the info on how to fix it! :) Arantor & drfun, I am sorry to be calling you guys out, but people have been asking for help on this error for more than 1 year. If you gentlemen could
please just show us how to fix this that would be great! :D
I appreciate the help!! Also HUGE thanks to the OP for this fantastic mod!! I can't wait to start using it on my site!!
Thanks!!
BigMike
Quote from: Drover on April 11, 2012, 02:27:32 PM
It installed fine with no errors but nothing shows up. :(
I am in the same boat... installs fine... updates the database fine... enabled... but... nothing.
Ok, I was able to get past line 69 but now it stops on line 80. Here is what I did:
Replace:
global $smcFunc, $db_prefix, $db_type, $db_show_debug;
With:
global $smcFunc, $db_prefix, $db_type, $db_show_debug, $db_name, $db_prefix;
And replace:
$existingTables = $smcFunc['db_list_tables']();
With:
db_extend();
$existingTables = $smcFunc['db_list_tables']($db_name, $db_prefix . '%');
This gets past line 69. But now I get the same error (Fatal error: Function name must be a string) on line 80, which is:
78: // Create table
79: if (!$tableExists && empty($table['smf']))
80: $smcFunc['db_create_table']('{db_prefix}' . $table_name, $table['columns'], $table['indexes']);
I searched and found the create_table function in DbPackages-mysql.php, line 87:
function smf_db_create_table($table_name, $columns, $indexes = array(), $parameters = array(), $if_exists = 'ignore', $error = 'fatal')
So the info being passed in by the Related Topic mod is (prefix+tablename, tablecolumn, tableindex). The SMF function is expecting at least (tablename, column, index, parameters). So it seems we are just missing the parameter, but I haven't researched what that would be yet.
Any help is appreciated, thanks!
Mike
EDIT
Update: Ok, at the top of the DbPackages file, it explains the function and says there are no $parameters yet. So I am just gonna make a dummy variable and pass it through to see if it works.
Update: Dummy variable idea did nothing.
Update: I think $smcFunc['db_create_table'] is expecting a string for the column, but this mod is trying to insert an array $table['columns']. I could be wrong but this is not correct?
Update: I added db_extend('packages'); and db_extend('extra'); and the install script returned a blank white page. So no errors but also no confirmation. I looked at my database and I have a new table created called `related_topics` but when I go to index.php?action=admin;area=modsettings;sa=related; nothing comes up...
Update: Why don't we just use $smcFunc['db_query'] instead of $smcFunc['db_create_table'] and use standard SQL like a normal person?
Ok guys! I got it to work. Sorry I couldn't post earlier, I had to leave for a business meeting.
I encountered the
Fatal error: Function name must be a string in ... related_topics.php on line 69 and made changes to related_topics.php as mentioned in my trouble shooting above.
After my last trouble shooting attempt, the file returned a blank page, as I mentioned above,
Quote from: BigMike on April 16, 2012, 03:26:46 PM
Update: I added db_extend('packages'); and db_extend('extra'); and the install script returned a blank white page. So no errors but also no confirmation. I looked at my database and I have a new table created called `related_topics` but when I go to index.php?action=admin;area=modsettings;sa=related; nothing comes up...
Low and behold this did the trick!!
Step 1) I attached my final related_topics.php file to this post. Back up your database (I continuously backed mine up during all of this and you should to), give it a shot and see if it returns a blank page for you. It should at the least get you past line 69.
Step 2) Navigate to index.php?action=admin;area=relatedtopics;sa=settings; and it should come up! (of course this assumes you've already performed all the required file modifications and all files are in place as per the install.xml file)
Step 3) If you've made it this far it's all downhill from here. Check the box for "Enable Related Topics" and hit save.
Step 4) Click on Methods (index.php?action=admin;area=relatedtopics;sa=methods;) and choose any boards you'd like to ignore, then hit save.
At this time everything is installed, activated and working properly yet no Related Topics will appear on any thread. This is because you have to Rebuild your Search Index. Related Topics provides the direct link at the bottom of Step 4 to rebuild the index. This may take a long time depending on the size of your forum.
After that is done, browse to any topic and KAZAAM you should now see a Related Topics box at the bottom of the page!
Here it is working on my forum, freshly updated to v2.0.2: http://board.marlincrawler.com/index.php?topic=87153.0
Again, find my related_topics.php file attached to this post.
HUGE Thanks for the OP for all his/her effort in making this mod! It's great 8)
BigMike
I'd love to learn how to integrate this with Sphinx Search *hint* *hint* ;)
Update: The mod seems to be working great and I really like having it.
I have started receiving a critical error of the following:
"Wrong value type sent to the database. Integer expected. (id_msg)"
I searched this site and found this thread where a member by the name of bindasboy solved this by manually creating a missing table: http://www.simplemachines.org/community/index.php?topic=285866.0 I posted to this thread and will share the info if I can get some help and/or figure it out!
Thanks
Bigmike
Quote from: FrizzleFried on April 14, 2012, 09:28:19 PM
Quote from: Drover on April 11, 2012, 02:27:32 PM
It installed fine with no errors but nothing shows up. :(
I am in the same boat... installs fine... updates the database fine... enabled... but... nothing.
Have you guys ran the reindexing of your search index? This is required by the mod or else nothing will show up. Please see my above post where I mentioned this as step 4:
Quote from: BigMike on April 16, 2012, 08:14:42 PM
Step 4) Click on Methods (index.php?action=admin;area=relatedtopics;sa=methods;) and choose any boards you'd like to ignore, then hit save.
At this time everything is installed, activated and working properly yet no Related Topics will appear on any thread. This is because you have to Rebuild your Search Index. Related Topics provides the direct link at the bottom of Step 4 to rebuild the index. This may take a long time depending on the size of your forum.
After that is done, browse to any topic and KAZAAM you should now see a Related Topics box at the bottom of the page!
Good luck!!
Mike
Quote from: gay on August 10, 2011, 04:20:23 AM
when post new topic is error viewing
Wrong value type sent to the database. Integer expected. (id_msg)
gay, did you ever figure this out? Thanks
OP, here is my `related_topics` table structure. Would you please let me know if I am missing something here? Thanks!
# Column Type Collation Attributes Null Default
1 id_topic int(10) UNSIGNED No None
2 subject tinytext latin1_swedish_ci No None
@bigmike
I already wrote that i've done rebuild index. But still no related topics are showing in topic view. Pls help. Thanks in advance
Somebody should just take over this mod and continue its development. So many people are having difficulties with the bugs, etc. BigMike would be a bankable developer to keep this mod valid now and for the foreseeable future.
I agree... I'd try this mod again and I'm even willing to do a manual edit or two... but it seems this mod in it's current state requires many (?) edits ... and frankly, I am not sure exactly which manual edits it needs.
Wont even install here, keeps bringing up install error.
dimspace, what is the install error? :-\
Quote from: BigMike on May 24, 2012, 05:05:04 PM
dimspace, what is the install error? :-\
edit:
Fatal error: require() [function.require]: Failed opening required '/home/vrforum/public_html/Packages/temp/SMF-2.0/related_topics.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/vrforum/public_html/Sources/Packages.php on line 951
951 is the line in packages that assigns the temp directory
require($boarddir . '/Packages/temp/' . $context['base_path'] . $action['filename']);
but theres no reason at all why the installer should be trying to go to packages/temp/smf-2.0/related-topics.php
i could do it manually, but im not convinced im that worried considering it seems to have a fair few problems.
That's required for installation as database changes are part of installation. The only problems this package has are install related.
(That particular one implies there's a problem with permissions.)
Nice mod, tnx.
Really nice,
works like a charm.
Only problem at install is with core template.
but its easy to fix. there is one bit of code replaced that is different in core and default curve template.
after changing this in Themes/core/Display.template.php it works:
find:
if ($context['show_spellchecking'])
echo '
<form action="', $scripturl, '?action=spellcheck" method="post" accept-charset="', $context['character_set'], '" name="spell_form" id="spell_form" target="spellWindow"><input type="hidden" name="spellstring" value="" /></form>
replace with:
if ($context['show_spellchecking'])
echo '
<form action="', $scripturl, '?action=spellcheck" method="post" accept-charset="', $context['character_set'], '" name="spell_form" id="spell_form" target="spellWindow"><input type="hidden" name="spellstring" value="" /></form>
its exactly the same code, but in core template it has different spacing/tabs, so that is why it fails
Da
very good and very heavy mod !
when Im using this mod on my big forum, then I will receive 500 internal error on 10% of times.
its not good for big forums
Quote from: amiralib on June 04, 2012, 01:18:00 AM
very good and very heavy mod !
when Im using this mod on my big forum, then I will receive 500 internal error on 10% of times.
its not good for big forums
It is true that this mod will put a higher load on a server. As for a vote of confidence for other users, our server is powered by an Intel Core i7-2600 and this mod never throws any server errors on our 930,000 post forum.
Regards,
BigMike
It installed perfectly and i've rebuild index and enabled it...but no related topics are shown when i open topics though in real topic has some related topics...
I'm using SMF 2.0.2
Pls help n thanks in advance
Installed this, and I don't see anything unless I enable "Quick Reply" then when enabled, its within the quick reply box. Its installed on the core theme. Anyone know how to fix this issue?
I am trying to remove this mod, but I get this error:
QuoteThis package cannot be uninstalled, because there is no uninstaller!
Please contact the mod author for more information.
How can I uninstall it?
Don't know if someone posted solution for "The used table type doesn't support FULLTEXT indexes"
but this is how I solved it:
1. Login to phpMyAdmin
2. Select database
3. !!! Make backup !!!
4. Run this query (replace PREFIX_ with your db prefix!):
CREATE TABLE IF NOT EXISTS PREFIX_related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
) ENGINE=MyISAM;
5. Open file ./Sources/Subs-RelatedFulltext.php
6. Find:
global $smcFunc, $db_prefix;
$smcFunc['db_query']('', '
DROP TABLE IF EXISTS ' . $db_prefix . 'related_subjects',
array('security_override' => true)
);
$smcFunc['db_query']('', '
CREATE TABLE IF NOT EXISTS ' . $db_prefix . 'related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
)',
array('security_override' => true)
);
return true;
Replace it with:
/*global $smcFunc, $db_prefix;
$smcFunc['db_query']('', '
DROP TABLE IF EXISTS ' . $db_prefix . 'related_subjects',
array('security_override' => true)
);
$smcFunc['db_query']('', '
CREATE TABLE IF NOT EXISTS ' . $db_prefix . 'related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
)',
array('security_override' => true)
);
return true;*/
7. Save and upload file
8. Rebuild indexes :)
9. Post reply in this topic and let me know if this worked for you :)
QuoteDon't know if someone posted solution for "The used table type doesn't support FULLTEXT indexes"
This error is only going to become more common as MySQL 5.5+ makes InnoDB default, not MyISAM.
Quote from: phantomm on July 06, 2012, 02:38:43 PM
Don't know if someone posted solution for "The used table type doesn't support FULLTEXT indexes"
but this is how I solved it:
Is your fix a way of getting round having InnoDB tables?
Yes, essentially. InnoDB is now default, the above basically just forces them to be MyISAM on creation, an option not explicitly given by the standard DB library, and otherwise it just creates what is the system default.
Thanks, so if I'm understanding this correctly, essentially the code above builds its own MyIsam table just for the fulltext index for 'Related Topics' which means it gets round the InnoDB problem.
Isn't that what I said?
Na..
It missed the "builds its own myIsam table" bit of the question. ::) (Which was my question) It didn't say what "them" was (ambiguous). Error.
I'm not that pedantic though. Don't worry about it. Life goes on. Ho hum. Happy days. etc.. etc..
(Modified to add the word Error)
Hi
I'm using 1.1 and i m setup this modification but i have a problem.
When i was enter the build index, answer me main error.
Who can upload Subs-Related.php for 1.1.
change in Sources/Subs-RelatedFulltext.php
$smcFunc['db_query']('', '
CREATE TABLE IF NOT EXISTS ' . $db_prefix . 'related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
)',
array('security_override' => true)
);
for:
$smcFunc['db_query']('', '
CREATE TABLE IF NOT EXISTS ' . $db_prefix . 'related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
) ENGINE=MyISAM',
array('security_override' => true)
);
Just found out it now only supports 2.X.X and not 1.1.X version.
Gutted.
I dont think it is working for me. SMF 2.0.2
please help, i uninstall Related post and it still show bellow post and i intsall it back and it becomes double, please how can i remove one of the two my forum link is www.9jageek.com
You did not fully uninstall the mod properly.
You may have to manually edit some files.
Not working for me :(
Quote from: bestfriendavinash on October 12, 2012, 12:51:06 PM
Not working for me :(
How doesn't the mod work for you?
/me is unfamiliar with the mod.
Quote from: Old Fossil on October 12, 2012, 12:53:33 PM
Quote from: bestfriendavinash on October 12, 2012, 12:51:06 PM
Not working for me :(
How doesn't the mod work for you?
/me is unfamiliar with the mod.
unfamiliar with the mod ;D
I have installed and activated the mod, but doesnot work...dont know why and how 8)
Any errors on install?
Have you checked your forums error log recently?
Quote from: Old Fossil on October 12, 2012, 01:22:29 PM
Any errors on install?
Have you checked your forums error log recently?
No error on install
No error in forum log, still not working
(SMF 2.0) Configuration -> Modifications -> Related Topics
Did you do the above?
Quote from: Old Fossil on October 12, 2012, 01:38:51 PM
(SMF 2.0) Configuration -> Modifications -> Related Topics
Did you do the above?
yes
Quote from: Old Fossil on October 12, 2012, 12:43:27 PM
You did not fully uninstall the mod properly.
You may have to manually edit some files.
which file will i edit?
Hi, I installed this mod in 2.0.2 and got no errors. I can set options in Admin. But when I go to the message board, I don't see any "related topics."
1. Where should the "related topics" show up? When someone searches? When they post? When they click on a post?
2. Other than set the options in Admin, is there something I need to do to activate this mod?
I also checked the Error Log and saw no errors related to this mod.
Thanks! Can't wait to see what it looks like & how it works!
installed fine
No page to configue unless use url it sends you to after installation (admin/?area=relatedtopics;sa=methods)
and even then there is an empty checkbox at the bottom that was already ticked
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimageshack.us%2Fa%2Fimg703%2F3708%2Fimage1nfc.jpg&hash=8b54eaa01d934c450f2cb6432e3ce553096f2b1f) (http://imageshack.us/photo/my-images/703/image1nfc.jpg/)
Uploaded with ImageShack.us (http://imageshack.us)
and the related topics bit still doesn't show
didn't work > no support > uninstalled > fine without
Hello
I've upgraded to 2.0.3 and This Mod has been disabled
www.irmeta.com/meta/index.php
please help
I updated to 2.0.3 using the Package Manager and this mod is still working normally.
Do you have any related reoccurring errors in your error log?
Until sometime after upgrading to 2.0.3 worked without problem and was disabled later
I install a smf 2.0.3 and this mod on another server for test
http://iranmeta.net/test/index.php?board=1.0
but not work
2.0.4 te hata veriyor.
Error in 2.0.4
Working version or another mod doing the same job?
Quote from: lazanya on February 10, 2013, 10:51:48 AM
2.0.4 te hata veriyor.
Error in 2.0.4
Working version or another mod doing the same job?
http://custom.simplemachines.org/mods/index.php?mod=3473
Quote from: Jorge_CS_ on February 11, 2013, 09:25:00 AM
Quote from: lazanya on February 10, 2013, 10:51:48 AM
2.0.4 te hata veriyor.
Error in 2.0.4
Working version or another mod doing the same job?
http://custom.simplemachines.org/mods/index.php?mod=3473
thanks a lot
Quote from: Jorge_CS_ on February 11, 2013, 09:25:00 AM
Quote from: lazanya on February 10, 2013, 10:51:48 AM
2.0.4 te hata veriyor.
Error in 2.0.4
Working version or another mod doing the same job?
http://custom.simplemachines.org/mods/index.php?mod=3473
very thanks
It s very good
please i unstalled this mod if it's still appearing within admin panel
any code to remove it ??
hmmm i have a long way togo
I have many topics starting in please or please help. How come this mod doesn't find any topics related to these titles? In other words, when a topic with the title "please help" is made, it doesn't show other topics which also have this title.
Any reason for it?
After installing related topic mod on my smf 2.0.4, any time i
try to rebuild index
The used table type doesn't support FULLTEXT indexes File: /
home/afriwapc/public_html/Sources/Subs-
RelatedFulltext.php Line: 29
can anyone help me with this?
No, we can't - it cannot be made to work on your site since you're using InnoDB for the messages table (and DON'T change that)
I think InnoDB supports Fulltext index in the latest versions of MySQL. Which means you'll probably have to upgrade your MySQL version, which means you'll probably have to upgrade your OS system, wich means you'll have to use a dedicated server and find an good administrator. Cheers :)
I have the same problem.
In phpMyAdmin it shows that table type are MyISAM not InnoDB but when I do
CREATE TABLE IF NOT EXISTS smf_related_subjects (
id_topic int(10) unsigned NOT NULL,
subject tinytext NOT NULL,
PRIMARY KEY (id_topic),
FULLTEXT KEY subject (subject)
)
it reports that FULLTEXT is not supported. Is there a way to make it working? I have a fresh forum so even setting up everything again is not a (very big) problem.
Using MySQL 5.5.32, UTF-8.
Any chance someone can upload the old version that's compatible with 1.1.19?
As I posted in your other topic, you probably should consider upgrading to 2.0 since 1.1.x will soon be not supported.
Could you tell me the point behind this code:
', (!empty($topic['quick_mod']['remove']) ? 'id="topic_' . $topic['first_post']['id'] . '" onmouseout="mouse_on_div = 0;" onmouseover="mouse_on_div = 1;" ondblclick="modify_topic(\'' . $topic['id'] . '\', \'' . $topic['first_post']['id'] . '\', \'' . $context['session_id'] . '\');"' : ''), '
Please can you make this mod to work the way i saw it on a forum.
Waiting for your support.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.upload.ee%2Fimage%2F4433983%2Frelated-topic-by-same-author.PNG&hash=453f670c97af0af32fa995147ff0afde3b0e98ba)
So it's not possible to use this mod if your server doesn't support fulltext indexes? Or is there any way I could modify the mod to get it to work without fulltext?
2.1 Beta onlyI have attached a working version of the mod for SMF 2.1 beta. (See Picture) This version does
not support 2.0 or 1.1.x.
For the avoidance of doubt as per the mod (http://custom.simplemachines.org/mods/index.php?mod=189) listing this mod is under BSD-New Licence which does permit sharing modifications.
Quote from: http://madjoki.com/smf-mods/license/
Copyright (c) 2012, Niko Pahajoki
All rights reserved.
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:
* Redistributions of source code must retain the above copyright
notice, this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in the
documentation and/or other materials provided with the distribution.
* Neither the name of the Niko Pahajoki nor the
names of its contributors may be used to endorse or promote products
derived from this software without specific prior written permission.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL Niko Pahajoki BE LIABLE FOR ANY
DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
I am posting this out of courtesy to the community, but I will not be developing or bug fixing it further so do not contact me. Hopefully some eager mod author will takes this and (under the same licence) develops this mod for smf.
Thanks Karl for the update!
Thanks. But now wished I'd seen this mod first http://custom.simplemachines.org/mods/index.php?mod=3473
Yeah but that mods license you can't make your own version according to the license.
Quote from: karlbenson on March 19, 2015, 08:01:13 PM
Thanks. But now wished I'd seen this mod first http://custom.simplemachines.org/mods/index.php?mod=3473
While it might have more bells and whistles, that mod doesn't use an index to find similar topics, there I believe this one is the superior kind.
Does this mod work for 2.0.10, or if not, is there a mod that does/maybe it's a feature in the software now?
I don't know if anyone else experiences this or not but it's kind of an hassle. Google is using dates from the related topics table to grab the oldest and apply that as the indexed date related to the entire page.
I have a particular situation in a thread created two weeks ago that Google returns as being from Apr 2012. Apr 2012 is the oldest of the related topics that this topic has.
Does anyone have any pointers on this? I found this:
https://support.google.com/customsearch/answer/2364585?hl=en
And I'm trying to get it setup, but I don't know if it will help or not.
Cheers
Edit: I'm thinking that most likely the best way to prevent this is to make the related topics available to logged in users only.
Edit2: I opted to just hard code it:
$topic['last_post']['time']
to:
$context['user']['is_logged'] ? $topic['last_post']['time'] : ''
hi I install this mod on SMF 2.0.11 and it caused error to my database, please how can I fix it?
This doesn't go to the right Topic where browsing a board normally, i had to turn it off.
any idea why ?
Niko was last active exactly a year ago today. I think it's safe to assume this mod is abandoned. Can anyone suggest an alternative?
The mod still works. I use it on my forums.
I have installed this Mod without any error, but after configure the settings as it said, related topics box doesn't appears anywhere. I'm using v2.0.13 with Anecdota Theme, it's a bit strange, i don't think it could be related with the Theme, but if anyone knows let me know to ask to Theme's Author.
Thank you.
Quote from: aegersz on August 22, 2016, 01:56:24 AM
This doesn't go to the right Topic where browsing a board normally, i had to turn it off.
any idea why ?
sorted - i forgot to rebuild the indexes ... now finally installed and functioning well !
When trying to rebuild the indexes got this error message:
Incorrect string value: '\xC4\x8Denja...' for column 'subject' at row 110
File: /var/www/html/Sources/Subs-RelatedFulltext.php
Line: 71
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php.
any help will be appreciated!
I had this mod working well on my old forum but on a new SMF 2.0.17 it breaks the code when wanting to access a topic and give this error message:
Wrong value type sent to the database. Integer expected. (id_msg)
When wanting to rebuild the index I get this error:
The used table type doesn't support FULLTEXT indexes
File: /var/www/web7/htdocs/Sources/Subs-RelatedFulltext.php
Line: 29
Any thoghts?
You're running it on a modern MySQL instance that uses InnoDB tables by default, and this mod expects MyISAM tables.
Don't use this mod; use the other one that's actually maintained.
Thank you
Quote from: Arantor on August 20, 2020, 07:02:40 PMYou're running it on a modern MySQL instance that uses InnoDB tables by default, and this mod expects MyISAM tables.
Don't use this mod; use the other one that's actually maintained.
Forgive the ol' bump up, Arantor, but what other plugin? SMF's Customize only showed one mod for "related".
Quote from: Douglas on August 17, 2021, 04:12:45 PMQuote from: Arantor on August 20, 2020, 07:02:40 PMYou're running it on a modern MySQL instance that uses InnoDB tables by default, and this mod expects MyISAM tables.
Don't use this mod; use the other one that's actually maintained.
Forgive the ol' bump up, Arantor, but what other plugin? SMF's Customize only showed one mod for "related".
it's because it's named similar topics :)
https://custom.simplemachines.org/index.php?mod=3473
Thanks, Arantor! Appreciate it!
*giggles* not arantor, but you're welcome
Doggone it, Shadav... I am so sorry!