Multi Prefix [Paid] 2.16.3

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.1 - Maintenance update

• Do not truncate prefix list if an old XF1 version wasn't cleanly uninstalled or upgraded. Update installer to attempt to migrate this.
  • If this update throws an SQL exception on updating, please contact open a ticket as a manual migration must be done.

Read the rest of this update entry...

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.2 - Bugfix update

• Properly extend client-side phrase list, allowing translations to reliably work

Read the rest of this update entry...

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.3 - Minor feature update

• Clickable prefixes in thread title when viewing a thread (or resource)

Read the rest of this update entry...

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.4 - Bugfix/Compatibility update

• Rework clickable prefix feature to be opt-in. (new prefix rendering type 'html-clicky')
  • Fixes new posts widget titles not being clickable.
  • Fixes for 3rd party add-ons displaying prefixes

Read the rest of this update entry...

 

[zTurko]

Hello, I have an error:

XF\Db\Exception: MySQL query error [1265]: Data truncated for column 'prefix_id' at row 4 in src/XF/Db/AbstractStatement.php at line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
4. XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 151
5. XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 143
6. XF\Db\SchemaManager->alterTable() in src/addons/SV/MultiPrefix/Setup.php at line 30
7. SV\MultiPrefix\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
8. SV\MultiPrefix\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
9. SV\MultiPrefix\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 390
10. XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
14. XF\App->run() in src/XF.php at line 328
15. XF::runApp() in admin.php at line 13

I opened the ticket: Ticket ID: #140

 

[Xon]

Please just post in on place.

Follow the advice in this thread;
Install Multi Prefix after uninstalling the legacy stub (or uninstalling a very old version on XF1)

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.5 - Maintenance update

• Update installer to use shared library code
• Migrate core of multi-prefix filtering code from bespoke to shared library code

Read the rest of this update entry...

 

[JoyFreak]

Does this add-on work with resource prefix too?

 

[Xon]

Does this add-on work with resource prefix too?

From the product description;

Supported content types

• Threads
• Resources

So, yes it should work.

 

[Tealk]

Hello @Xon,

would it be possible to include a permission that allows ignoring the min/max prefixes?

 

[Zulenka]

@Xon

When a prefix is used on a thread, the used pre-fix appears on the browser tab. Is it possible to remove/disable this function somewhere?

 

[Xon]

would it be possible to include a permission that allows ignoring the min/max prefixes?

If you are willing to pay for the development time, sure. Otherwise it will go onto a very long list due to my existing XF1 => XF2 add-on conversion efforts.

@Xon

When a prefix is used on a thread, the used pre-fix appears on the browser tab. Is it possible to remove/disable this function somewhere?

You'll need to edit the thread_view template and adjust this line;

<xf:title page="{$page}">{{ prefix('thread', $thread, 'escaped') }}{$thread.title}</xf:title>

to

<xf:title page="{$page}">{$thread.title}</xf:title>

 

[Zulenka]

Thank you kindly!

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.2.6 - Bugfix update

• Fix error upgrading from pre-v1.6.0 XF versions

Read the rest of this update entry...

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.3.0 - Feature update

• Support Prefix Essentials ignore prefix feature when a thread has multiple prefixes
• Update single prefix selection to be near identical to multi-prefix selection in behaviour
• Fix "Indirect modification of overloaded property SV\MultiPrefix\XF\Entity\Forum::$sv_default_prefix_ids has no effect" when editing a forum

Read the rest of this update entry...

 

[S Thomas]

The following should remove all multiple prefixes picking the first to keep.


Run each statement one after the other.

Please ensure you have a database backup, or at least clone the xf_thread table somewhere as this is a destructive operation and this SQL is provided as-is and is a best effort.

UPDATE xf_thread
SET prefix_id=IF(LEFT(prefix_id,LOCATE(',',prefix_id) - 1) != '', LEFT(prefix_id,LOCATE(',',prefix_id) - 1), prefix_id);
where prefix_id like '%,%';

UPDATE xf_thread
SET prefix_id = '0'
WHERE prefix_id = '';

alter table xf_thread prefix_id INT UNSIGNED NOT NULL DEFAULT 0;

@Xon Is there an updated query for that somewhere or is that the current state? Just making sure since the query is invalid because of the ; in the second line and nobody seemed to complain about it.

 

[Xon]

@Xon Is there an updated query for that somewhere or is that the current state? Just making sure since the query is invalid because of the ; in the second line and nobody seemed to complain about it.

It looks like that was fixed a while ago. Strictly speaking it isn't a problem due to the IF statement bit, but it would cause an error if you want it because the where clause is an invalid statement by itself. Having the where clause just avoids some database churn and ensures it is restartable if you need to run each statement in chunks.

 

[S Thomas]

Not sure if you mean fixed in your addon or where, but the client isn't running your addon any more, so I guess that's some legacy stuff. However, I just ran into that problem today (ES wasn't installed prior to that).
So basically just throw out the where clause, alright, thanks

Meh, the CHANGE / MODIFY keyword is missing aswell:

ALTER TABLE `xf_thread` CHANGE `prefix_id` `prefix_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';

 

[Xon]

I reconstructed that query from some add-on code, I'm surprised no one mentioned anything.

 

[Xon]

Xon updated Multi Prefix with a new update entry:

2.3.1 - Bugfix update

• Fix case where non-minified select2 is used
• Fix 404 due to incorrect select2 reference

Read the rest of this update entry...