XF 1.5 Error on prefix delete

[Steve F]

Getting this when trying to delete a prefix. Just to note we did have an add-on installed previously (months ago) where we could select multiple prefixes but has since been uninstalled.

Mysqli statement execute error : Truncated incorrect DOUBLE value: '1,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/*********/public_html/admin.php at line 13

 

[Mike]

That add-on appears to have left remnants of the data it manipulated. I would have to recommend contacting the author of it.

 

[TPerry]

Getting this when trying to delete a prefix. Just to note we did have an add-on installed previously (months ago) where we could select multiple prefixes but has since been uninstalled.

I think Daniel did an update to that add-on that resolved the removal issue. Try getting the new version and installing it again and then removing it.