Multi Prefix

Multi Prefix [Paid] 1.8.16

No permission to buy ($20.00)
Overview FAQ Updates (66) Reviews (23) History Discussion
hnit said:
Hey, people. I had a problem. All of my prefixes from everywhere on the forum are now gone after installing this. I don't see any logs for such.
There are over 1k threads which lost the prefixes and I don't even remember it myself what belongs where.

Any way to reverse it?

or a way to batch add prefixes somehow?
Click to expand...
Please ensure the templates finished recompiling, or you'll get some odd-results. Sometimes just upgrading an add-on in-place to the same version fixes it.

What version are you using?

If that doesn't fix it; please PM me on https://atelieraphelion.com/ as this will require some assistance. I will need you to run SQL or provide me the relevant access todo some checks on the data.
 
This addon blocks XF2 upgrade in the sense that it needs to be uninstalled before the board can be upgraded.
 
I'm aware, I haven't yet written an update which unblocks the XF2 upgrade process but it is on my to-do list.
 
Hey @Xon - getting an error trying to upgrade 1.6.5 > 1.7.4

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in SV/MultiPrefix/Installer.php at line 90
SV_MultiPrefix_Installer::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/wweforums.net/httpdocs/admin.php at line 13
 
Solidus said:
Hey @Xon - getting an error trying to upgrade 1.6.5 > 1.7.4

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in SV/MultiPrefix/Installer.php at line 90
SV_MultiPrefix_Installer::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/wweforums.net/httpdocs/admin.php at line 13
Click to expand...
What version of MySQL?

Does running this work?
Code: 
                    INSERT IGNORE xf_resource_prefix_link (prefix_id, resource_id) 
                    select prefix_id, resource_id
                    from xf_resource
                    where prefix_id <> 0 and xm_prefixes = '0'
or this:
Code: 
                    INSERT IGNORE INTO xf_resource_prefix_link (prefix_id, resource_id) 
                    select prefix_id, resource_id
                    from xf_resource
                    where prefix_id <> 0 and xm_prefixes = '0'
?
 
Still the same error w/ 1.7.5
And here's a different error,

Code: 
ErrorException: substr() expects parameter 1 to be string, array given - library/SV/MultiPrefix/XenForo/ControllerPublic/Forum.php:50
Generated By: Unknown Account, Today at 4:36 PM

Code: 
#0 [internal function]: XenForo_Application::handlePhpError(2, 'substr() expect...', '/var/www/vhosts...', 50, Array)
#1 /var/www/vhosts/wweforums.net/httpdocs/library/SV/MultiPrefix/XenForo/ControllerPublic/Forum.php(50): substr(Array, 0, 1)
#2 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/ControllerPublic/Forum.php(202): SV_MultiPrefix_XenForo_ControllerPublic_Forum->_getDisplayConditions(Array)
#3 /var/www/vhosts/wweforums.net/httpdocs/library/Audentio/UIX/ControllerPublic/Forum.php(23): XenForo_ControllerPublic_Forum->actionForum()
#4 /var/www/vhosts/wweforums.net/httpdocs/library/NFLJ/Sportsbook/XenForo/ControllerPublic/Forum.php(209): Audentio_UIX_ControllerPublic_Forum->actionForum()
#5 /var/www/vhosts/wweforums.net/httpdocs/library/PrefixForumListing/Extend/ControllerPublic/Forum.php(7): NFLJ_Sportsbook_XenForo_ControllerPublic_Forum->actionForum()
#6 /var/www/vhosts/wweforums.net/httpdocs/library/CTA/FeaturedThreads/ControllerPublic/Forum.php(215): PrefixForumListing_Extend_ControllerPublic_Forum->actionForum()
#7 /var/www/vhosts/wweforums.net/httpdocs/library/SV/MultiPrefix/XenForo/ControllerPublic/Forum.php(20): CTA_FeaturedThreads_ControllerPublic_Forum->actionForum()
#8 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(351): SV_MultiPrefix_XenForo_ControllerPublic_Forum->actionForum()
#9 /var/www/vhosts/wweforums.net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts/wweforums.net/httpdocs/index.php(13): XenForo_FrontController->run()
#11 {main}
 
@Solidus the lines numbers in your error log do not match up with MultiPrefix 1.7.5 (they match 1.7.3). Can you try re-uploading the files & try flushing the opcode cache (restarting php-fpm or apache does the trick) and then try again?
 
Solidus said:
I already did this when trying to update to 1.7.5, restarted both php-fpm and Apache.
Click to expand...

For 1.7.5, this should should be line 50 in library/SV/MultiPrefix/XenForo/ControllerPublic/Forum.php
Code: 
if ($prefixIds && is_array($prefixIds))
I re-downloaded the 1.7.5 zip from my add-on site & manually checked it against what is marked as 1.7.5 in my source-code repository, and they match.

In 1.7.3; this was line 50;
Code: 
if (substr($prefixId, 0, 1) == '!')
This matches the error message about substr() and the line number.

Please check the file on-disk to verify if it is the right one. It is possible you are being stung by the op-code cache being reloaded from disk (opcache.file_cache, and check opcache.validate_timestamps = 1 )
 
Re-uploaded 1.7.5, restarted Apache and php-fpm.
opcache.validate_timestamps = 1 and opcache.file_cache has "no value"
This is line 50,

Code: 
        if ($prefixIds && is_array($prefixIds))

here's the error on XML import,

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in SV/MultiPrefix/Installer.php at line 99
SV_MultiPrefix_Installer::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/wweforums.net/httpdocs/admin.php at line 13

Truly bizarre.
 
@Xon I'm getting this error when upgrading from Multi Prefix 1.5.5 to 1.7.5:

Code: 
Server Error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in SV/MultiPrefix/Installer.php at line 99
    SV_MultiPrefix_Installer::install() in XenForo/Model/AddOn.php at line 214
    XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
    XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/public/admin.php at line 13

I tried restarting php-fpm and nginx, not helping.
 
You must log in or register to reply here.

Similar threads

Ozzy47
[OzzModz] XFRM: Prefix Sync [Paid]
Replies
1
Views
186
Ozzy47
Ozzy47
Ozzy47
[OzzModz] Prefix Sorting [Paid]
Replies
0
Views
159
Ozzy47
Ozzy47
G
  • Suggestion Suggestion
Duplicate Enhancing Thread Navigation: Implementing Clickable Thread Prefixes for Efficient Filtering
Replies
2
Views
884
Paul B
Paul B
AndyB
Direct message search plus [Paid]
Replies
0
Views
103
AndyB
AndyB
AndyB
Post thread check [Paid]
Replies
0
Views
142
AndyB
AndyB
Top Bottom