Related Topics

Started by niko, September 14, 2005, 11:50:29 AM

Previous topic - Next topic

dimspace

Wont even install here, keeps bringing up install error.

BigMike

dimspace, what is the install error? :-\

dimspace

#642
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.

Arantor

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.)

kak2z

Новости и слухи Дом 2. Популярные рецепты в рубрике Что приготовить

DaKrampus

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

amiralib

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

BigMike

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

Game.ruler

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

Kat9119

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?

mageguild

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?

Adrek

#651
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 :)
Polskie wsparcie SMF na simplemachines.org

the simplest solution is most likely the right one

Arantor

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.

Armada

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?
--- SMF Rocks even more than YabbSE---

Arantor

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.

Armada

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.
--- SMF Rocks even more than YabbSE---

Arantor

Isn't that what I said?

Armada

#657
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)
--- SMF Rocks even more than YabbSE---

Flypside


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.
SMF SUPPORT SERVICE | SEO | PORTAL | FORUM | MOD | THEME | DATABASE | GOOGLE OPT vs..

contact: [email protected]


ingilizce dökümanları

thefantas

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)
      );

Advertisement: