[ABD] Advanced Similar Topics 1.2.5 (AJAX support)&phpBBSeo

mymy · Post by **mymy** » Thu May 12, 2011 6:32 pm

there is an error

#1091 - Can't DROP 'topic_title'; check that column/key exists

What I must do?

Peter77sx · Post by **Peter77sx** » Thu May 12, 2011 7:33 pm

Nothing.

it means it does not exist in your database.. which is what MOD author needed you to do.

Porutchik wrote:and install MOD again

mymy · Post by **mymy** » Thu May 12, 2011 9:58 pm

unfortunately it doesn't work

I had unistalled entries form data base, installed again, coppied again all the 7 files, again checked modified files. Also I did the manual instructions. New topic page looks like this (normal):
[image now expired]

tell me please, I don't known if this important, I had upgraded to version 1.1.1 from 1.0.4??

I checked all sections in forum (I had clicked on the New topic) and not even once I saw the similar topics table..

I really don't have an idea....

mymy · Post by **mymy** » Sun May 22, 2011 9:15 am

help please

I don't know php as good as You....

Porutchik · Post by **Porutchik** » Thu Aug 02, 2012 3:14 pm

Mod is updated to 1.1.2
[*] small change code

The instructions for update you can find at folder contrib. (update_from_111_112.xml)
See first post for download link.

Porutchik · Post by **Porutchik** » Sun Mar 03, 2013 9:43 pm

Mod is updated to 1.2.0

[*]Adapted for UMIL ((Unified Modification Install Library)
[*]Standart MODX 1.2.6
[*]Changed module in ACP
[*]Add new config variable
[*]Large change code

The instructions for update you can find at folder contrib. (update_from_112_120.xml)
See first post for download link.

Translate.
If you would like to translate this Mod into normal English or another language, please send me an email or PM or post it In this topic.

Porutchik · Post by **Porutchik** » Tue Mar 05, 2013 10:02 pm

Update. Current version 1.2.1

[+] This mod now is full compatible with the phpBB SEO Ultimate SEO URL (Advanced/Mixed/Simple) by dcz.

For updated.
Copy:
root/similar_topics.php -> similar_topics.php
root/includes/acp/info/acp_similar_topics.php -> includes/acp/info/acp_similar_topics.php
root/install_similar_topics.php -> install_similar_topics.php

To run install_similar_topics.php point your browser to, for example, domain.tld/phpBB3/install_similar_topics.php.

Porutchik · Post by **Porutchik** » Sat Mar 16, 2013 7:01 pm

Mod is updated to 1.2.5

[*]Support for any Topic Description mod

The instructions for update you can find at folder contrib. (update_from_121_125.xml)
See first post for download link.

Translate.
If you would like to translate this Mod into normal English or another language, please send me an email or PM or post it In this topic.

Kot Matroskin · Post by **Kot Matroskin** » Sun Mar 17, 2013 8:29 am

After updating from 1.2.0 with automod the following error is occurred:

Code: Select all

[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_similar_topics.php on line 102: Undefined index: similar_topics_topic_desc_field

P.S. I do not use "topic description mod". It looks that is why this setting didn't configured:

Code: Select all

		if ($use_topic_desc)
		{
			if (!$umil->config_exists('similar_topics_topic_desc_field'))
			{
				$umil->config_add('similar_topics_topic_desc_field', request_var('topic_desc_field', ''));
			}
			if (!$umil->table_index_exists(TOPICS_TABLE, 'topic_desc'))
			{
				$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' ADD FULLTEXT (`topic_desc`)';
				$result = $db->sql_query($sql);
			}
		}

Porutchik · Post by **Porutchik** » Sun Mar 17, 2013 9:29 am

See diy-instructions

install_similar_topics.php - there is a PHP install file that needs to be run in order to complete the installation. To run it point your browser to, for example, domain.tld/phpBB3/install_similar_topics.php.

Kot Matroskin · Post by **Kot Matroskin** » Sun Mar 17, 2013 9:36 am

Of course I did it. Pay attention on my code snippet above -- it is from mentioned file, and described the root of the issue, why 'similar_topics_topic_desc_field' config variable didn't set as expected.

Porutchik · Post by **Porutchik** » Sun Mar 17, 2013 9:40 am

I do not understand.

Пиши уже по русски у меня.

Porutchik · Post by **Porutchik** » Sun Mar 17, 2013 9:53 am

If do not use "topic description mod"

Code: Select all

DELETE FROM `phpbb_config` WHERE `phpbb_config`.`config_name` = 'similar_topics_use_topic_desc'.

And purge all cache.

Kot Matroskin · Post by **Kot Matroskin** » Sun Mar 17, 2013 9:55 am

Porutchik wrote:Пиши уже по русски у меня.

Your forum doesn't allow anonymous posting, and I'm too lazy to register.

So, let me explain. After installing your mod works fine on forum.

But corresponding admin page has minor issue: it tries to get non-existent config value, especially $config['similar_topics_topic_desc_field'] on line 102, and fails. This value has not been set in install_similar_topics.php, because I have no "Topic description" mod installed (it my assumption).

Look at the code below (it is install_similar_topics.php file, line 254). If $use_topic_desc variable equals false, so $config['similar_topics_topic_desc_field'] will never been set.

Code: Select all

		if ($use_topic_desc)
		{
			if (!$umil->config_exists('similar_topics_topic_desc_field'))
			{
				$umil->config_add('similar_topics_topic_desc_field', request_var('topic_desc_field', ''));
			}
			if (!$umil->table_index_exists(TOPICS_TABLE, 'topic_desc'))
			{
				$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' ADD FULLTEXT (`topic_desc`)';
				$result = $db->sql_query($sql);
			}
		}

Hope this explanation will be more understandable.

Kot Matroskin · Post by **Kot Matroskin** » Sun Mar 17, 2013 9:57 am

Porutchik wrote:If do not use "topic description mod"
Code: Select all
DELETE FROM `phpbb_config` WHERE `phpbb_config`.`config_name` = 'similar_topics_use_topic_desc'.
And purge all cache.

As for me, better solution will be adding empty $config['similar_topics_topic_desc_field'] variable into the config (what I've did already). It will allow to avoid unpredictable issues with your mod in feature when I'll try to install mentioned "Topic description" mod.

advertisements