• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Unable to delete Prefix

I’m getting the following error when I try to delete a prefix from my Admin CP.

Server Error

Mysqli statement execute error : Truncated incorrect DOUBLE value: '12,13,18'

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
    Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter/ThreadPrefix.php at line 153
    XenForo_DataWriter_ThreadPrefix->_postDelete() in XenForo/DataWriter.php at line 1793
    XenForo_DataWriter->delete() in XenForo/Controller.php at line 1021
    XenForo_Controller->_deleteData() in XenForo/ControllerAdmin/ThreadPrefix.php at line 179
    XenForo_ControllerAdmin_ThreadPrefix->actionDelete() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/scriptdr/public_html/admin.php at line 13
I’m not sure it an add-on is causing this. I have recently installed Multi Prefix add-on by Xon and Hide Prefix from user groups by Sonnb. I have disabled both of them, but I’m still getting the above error.

Please ignore my question. I can delete prefix now. looks like I need to enable the add-on Multi prefix before I delete the prefix.