Advanced Tags & Prefixes - IPS 4.x

[AlexJ]

Ryan H,

When I upgraded the IPBoard 3.4.x to latest version, IPS staff told me that because of tags addon "Convert all tags to lower case" become Enabled during upgrade and it messes up all my tags. 

On 3.4.x my selection for Force tags to lowercase is disabled. Any idea on how to resolve the issue? Thank you.

An

 

Edited October 28, 2017 by AlexJ

[Ryan H.]

On 10/27/2017 at 4:12 AM, Telemacus2 said:

Ok, no worries, fixed. What happened is when I edited those prefixes manually from Capital to lower in the "manage prefixes" section of the acp, each forum's list of allowed prefixes doesnt' update the change, so when I changed a prefix from "Exclusive" to "exclusive", that "exclusive" prefixe would no longer be available in that forum until I reedited that forum's list of allowed prefixes. 

Yeah, that'll happen. I think someone else mentioned that recently; something I'll see if I can handle in the code.

17 hours ago, AlexJ said:

Ryan H,

When I upgraded the IPBoard 3.4.x to latest version, IPS staff told me that because of tags addon "Convert all tags to lower case" become Enabled during upgrade and it messes up all my tags. 

On 3.4.x my selection for Force tags to lowercase is disabled. Any idea on how to resolve the issue? Thank you.

I'm not aware of any way my app could have caused that. If they have something to support that claim, please have them explain/contact me.

If the data was changed, there's no way to just undo it. You'll need to change the setting back and then correct any data manually.

[AlexJ]

On 10/28/2017 at 7:58 PM, Ryan H. said:

Yeah, that'll happen. I think someone else mentioned that recently; something I'll see if I can handle in the code.

I'm not aware of any way my app could have caused that. If they have something to support that claim, please have them explain/contact me.

If the data was changed, there's no way to just undo it. You'll need to change the setting back and then correct any data manually.

I just tested that on my test board. I can dump the DB and start again from scratch if you can give me some pointers. IPS staff tells me issue with your addon and you put me back to IPS loop. I have no idea what to do here mate. Just looking for the fix so upgrade goes smooth.

 

 

[Gabriel Torres]

@Ryan H.

We have an interesting situation here that I need some advice on.

We disabled the traditional tags/prefixes from IPS, leaving AT&P active and with preset prefixes in certain forums. For example, in the "programming languages" forum the prefixes available are "C", "Python", "PHP", and so on. Live example:

http://www.clubedohardware.com.br/forums/forum/16-programação-web/

This works really well.

The problem is when someone posts a topic that is off-topic for that forum: the user chooses a random prefix just so he can post in that forum, and then we have move the topic to the correct place, but the prefix stays with the topic and no option for us to delete the prefix is available.

For example: http://www.clubedohardware.com.br/forums/topic/1260422-configurações-do-roteador-para-o-wifi-se-conectar-automaticamente/

We need to find a way to remove the prefix in cases like this. Any suggestion?

Thanks!

Gabriel.

[Ryan H.]

On 10/30/2017 at 9:02 PM, AlexJ said:

I just tested that on my test board. I can dump the DB and start again from scratch if you can give me some pointers. IPS staff tells me issue with your addon and you put me back to IPS loop. I have no idea what to do here mate. Just looking for the fix so upgrade goes smooth.

 

I don't know of any way that issue (setting change) could be caused by my plugin. I don't know why they would push it on me except by association to the tag system. Have you tried upgrading without AT&P (either removing it before or not installing it after)? Does that have any impact on the setting changing?

On 10/31/2017 at 12:08 AM, Gabriel Torres said:

We need to find a way to remove the prefix in cases like this. Any suggestion?

Set up a mod mass action (or whatever they're called these days). You can create one to remove prefix, and apply that to any topic from any forum.

[Gabriel Torres]

@Ryan H. Worked like a charm!!!! You are the best!

[motomac]

Hi, @Ryan H.!

I've got an error when trying to rechache tags in the ACP:

SELECT `tag_aai_lookup`, `tag_meta_app`, `tag_meta_area`, `tag_meta_id`, `tag_id` FROM `core_tags` GROUP BY `tag_meta_id` ORDER BY `tag_id` ASC LIMIT 0,100
IPS\Db\Exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'site.core_tags.tag_aai_lookup' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
#0 /var/www/site.com/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\advancedt...', Array, true)
#1 /var/www/site.com/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 /var/www/site.com/applications/advancedtagsprefixes/modules/admin/manage/tools.php(277): IPS\Db\_Select->rewind()
#3 /var/www/site.com/system/Dispatcher/Controller.php(85): IPS\advancedtagsprefixes\modules\admin\manage\_tools->rebuild()
#4 /var/www/site.com/applications/advancedtagsprefixes/modules/admin/manage/tools.php(26): IPS\Dispatcher\_Controller->execute()
#5 /var/www/site.com/system/Dispatcher/Dispatcher.php(146): IPS\advancedtagsprefixes\modules\admin\manage\_tools->execute()
#6 /var/www/site.com/admin/index.php(13): IPS\_Dispatcher->run()
#7 {main}

Now all tags disappeared. Please, help!

Edited November 4, 2017 by motomac

[Ryan H.]

On 11/4/2017 at 2:32 AM, motomac said:

Hi, @Ryan H.!

I've got an error when trying to rechache tags in the ACP:

Now all tags disappeared. Please, help!

I don't have the SQL settings in place to test it, but you can try this:

Open applications/advancedtagsprefixes/modules/admin/manage/tools.php

Find: (line 275)

        $keys        = \IPS\DB::i()->select( array( 'tag_aai_lookup', 'tag_meta_app', 'tag_meta_area', 'tag_meta_id', 'tag_id' ), 'core_tags', NULL, '`tag_id` ASC', array( $start, $perCycle ), 'tag_meta_id' );

Change to:

        $keys        = \IPS\DB::i()->select( array( 'tag_aai_lookup', 'tag_meta_app', 'tag_meta_area', 'tag_meta_id', 'tag_id' ), 'core_tags', NULL, '`tag_id` ASC', array( $start, $perCycle ) );

Save, retry.

It will be slower (running based on tag instead of topic), but I think that will be the only side effect.

[motomac]

Hi, @Ryan H.!

I made this change and started the process. It's running now, but I see strange numbers:

Current is bigger than total.

Is it OK?

[motomac]

Update: The progress was stopped with error:

DELETE FROM `core_search_index_tags` WHERE index_id=51701 AND index_tag=1213
IPS\Db\Exception: Truncated incorrect DOUBLE value: 'Продам' (1292)
#0 /var/www/site.com/system/Db/Db.php(1074): IPS\_Db->preparedQuery('/*IPS\\advancedt...', Array)
#1 /var/www/site.com/applications/advancedtagsprefixes/modules/admin/manage/tools.php(401): IPS\_Db->delete('core_search_ind...', Array)
#2 /var/www/site.com/system/Dispatcher/Controller.php(85): IPS\advancedtagsprefixes\modules\admin\manage\_tools->rebuild()
#3 /var/www/site.com/applications/advancedtagsprefixes/modules/admin/manage/tools.php(26): IPS\Dispatcher\_Controller->execute()
#4 /var/www/site.com/system/Dispatcher/Dispatcher.php(146): IPS\advancedtagsprefixes\modules\admin\manage\_tools->execute()
#5 /var/www/site.com/admin/index.php(13): IPS\_Dispatcher->run()
#6 {main}

Edited November 14, 2017 by motomac

[Ryan H.]

20 hours ago, motomac said:

Hi, @Ryan H.!

I made this change and started the process. It's running now, but I see strange numbers:

Current is bigger than total.

Is it OK?

Hmm. That would be a side-effect of the change. Yes, that's okay.

20 hours ago, motomac said:

Update: The progress was stopped with error:

hmm ... not sure the exact cause here, but try this:

applications/advancedtagsprefixes/modules/admin/manage/tools.php Line 401

                                array( 'index_tag=?', $k ),

to

                                array( 'index_tag=?', (string)$k ),

 

[sofos]

Hi @Ryan H.!! 

I would like to explain you the current problem that I have with the Plugin:

 

With this process I mass-add a prefix into "Notizie audio e video" topic. The result:

For the 1st page everything works fine but when I go to the last pages or fewer:

It should represent all the Prefixes like in the 1st page but from the 3rd it changes the prefix.

 

Stuffs:

IPB: 4.2.6

Advanced Tag and Prefixes:  3.1.9

Database: MariaDB

 

 

[sofos]

the last page

[Ryan H.]

11 hours ago, sofos said:

the last page

 

Thanks for all the details. I'll have to investigate.

[Ryan H.]

On 11/17/2017 at 10:22 AM, sofos said:

Hi @Ryan H.!! 

I would like to explain you the current problem that I have with the Plugin:

Stuffs:

IPB: 4.2.6

Advanced Tag and Prefixes:  3.1.9

Database: MariaDB

Here's a patch for that. Only affects spaces or other special chars in prefix name on the mass-add tool.

Open: applications/advancedtagsprefixes/modules/admin/manage/tools.php

Find: (line 733-736

                if( $key == 'atp_addTags' or $key == 'atp_searchForums' )
                {
                    $values[ $key ] = array_filter( explode( ',', urldecode( $values[ $key ] ) ) );
                }

Add after:

                elseif( $key == 'atp_addPrefix' )
                {
                    $values[ $key ] = urldecode( $values[ $key ] );
                }

Save. Re-run tool, chosen prefix should overwrite all the bad ones you've got now.

[sofos]

 

On 3/12/2017 at 4:46 AM, Ryan H. said:

Here's a patch for that. Only affects spaces or other special chars in prefix name on the mass-add tool.

Open: applications/advancedtagsprefixes/modules/admin/manage/tools.php

Find: (line 733-736

                if( $key == 'atp_addTags' or $key == 'atp_searchForums' )
                {
                    $values[ $key ] = array_filter( explode( ',', urldecode( $values[ $key ] ) ) );
                }

Add after:

                elseif( $key == 'atp_addPrefix' )
                {
                    $values[ $key ] = urldecode( $values[ $key ] );
                }

Save. Re-run tool, chosen prefix should overwrite all the bad ones you've got now.

 @Ryan H.  I've tried with this solution but doesn't work anyway. After the 1st cycle each Tags become longer.

Edited December 5, 2017 by sofos

[Ryan H.]

8 hours ago, sofos said:

 @Ryan H.  I've tried with this solution but doesn't work anyway. After the 1st cycle each Tags become longer.

I don't know what to tell you then -- that solution resolved that exact problem perfectly for me.

[RObiN-HoOD]

Can I use this app for tags reordering? By default I can't in the configuration of tags.

In IPB4 when you add a tag it's just added at the end. I have around 40 tags. If I delete the 5th and want to add another at that position I can't. It's added at the end no matter what. If I remember correctly in IPB3 it was a big text field and you could add it wherever you wanted.

Any solution to this?

[ChrisVanMeer]

Hi there,

I have a strange issue with the plugin. All works well, except the Prefix doesn't show up when creating a new topic.
Even though I have specified that a prefix is required. All prefixes are visible for all users.

I can't seem to get it to work. Can someone point me in the right direction?

I forgot to add allowed prefixes on the forum at hand....my apologies.

Chris

Edited December 8, 2017 by ChrisVanMeer

[Ryan H.]

On 12/7/2017 at 5:39 AM, RObiN-HoOD said:

Can I use this app for tags reordering? By default I can't in the configuration of tags.

In IPB4 when you add a tag it's just added at the end. I have around 40 tags. If I delete the 5th and want to add another at that position I can't. It's added at the end no matter what. If I remember correctly in IPB3 it was a big text field and you could add it wherever you wanted.

Any solution to this?

No, that's not something the app will help with.

[ChrisVanMeer]

Hi Ryan,

I use your application, but I can't it to force a user to use a prefix.
It is not marked as "required".

I have these settings on a subforum:

Could you tell me what I am doing wrong?

[ChrisVanMeer]

Hmm, I seem to have found the cause...the user at hand that is creating topics is doing this through TapaTalk.
I guess there is no way to force them there to honor prefixes huh?

[Ryan H.]

On 12/13/2017 at 8:54 AM, ChrisVanMeer said:

Hmm, I seem to have found the cause...the user at hand that is creating topics is doing this through TapaTalk.
I guess there is no way to force them there to honor prefixes huh?

I don't know how the app works; not something I can speak to.

[Silnei L Andrade]

Hello @Ryan H.,

I tried to create a prefix for some forums using the mass tool and it created several tags like these there. I already deleted these tags, I deleted the prefix, but they still appear in the listing. What do I do to solve this? Will I have to remove them all manually?

I try delete manually but i cant, the tag returns. I try  "Rebuild Tag Cache" and donr works too. 

 

Edited December 17, 2017 by Silnei L Andrade

[joshuaj]

Hi @Ryan H.,

I've set up my Articles database to make a post in a specific forum. I click on the "Tags & Prefix" tab to set it up, it doesn't actually post the prefix in the forum.