XF 1.5 Custom Username Icons error


Well-known member
got this error after upgrade to 1.5 how to fix it

#0 /home/alejaserija/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT thr...')
#1 /home/alejaserija/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT thr...')
#2 /home/alejaserija/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT thr...')
#3 /home/alejaserija/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT thr...', Array, 2)
#4 /home/alejaserija/public_html/library/XenForo/Model/Thread.php(563): XenForo_Model->fetchAllKeyed('\n\t\t\t\tSELECT thr...', 'thread_id')
#5 /home/alejaserija/public_html/library/XenForo/ControllerPublic/Forum.php(103): XenForo_Model_Thread->getThreads(Array, Array)
#6 /home/alejaserija/public_html/library/*******/AdvancedRules/ControllerPublic/Forum.php(7): XenForo_ControllerPublic_Forum->actionIndex()
#7 /home/alejaserija/public_html/library/XenForo/FrontController.php(347): *******_AdvancedRules_ControllerPublic_Forum->actionIndex()
#8 /home/alejaserija/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/alejaserija/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}

array(3) {
["url"] => string(34)
["_GET"] => array(0) {
["_POST"] => array(0) {


Well-known member
That does really explain the error, it is just the stack trace. Other than that, does it work with add-ons disabled.

Tracy Perry

Well-known member
If you look in your stack trace you provided
/home/alejaserija/public_html/library/*******/AdvancedRules/ControllerPublic/Forum.php(7): XenForo_ControllerPublic_Forum->actionIndex()
you will notice that it is calling *******'s Advanced Rules... try disabling THAT one and see if it works. Or see if there is an update.. you will have to go to his site for support (if it's still there) as he's not on here much due to his history of issues. He hasn't been line here sine 04/2015.

It may very well be that add-on is not 1.5 compatible (it has been known to happen).
Last edited:


Well-known member
and shows this error

Server Error
Mysqli prepare error: Not unique table/alias: 'last_post_user'

    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 XenForo/Model.php at line 219
    XenForo_Model->fetchAllKeyed() in XenForo/Model/Thread.php at line 563
    XenForo_Model_Thread->getThreads() in XenForo/ControllerPublic/Forum.php at line 103
    XenForo_ControllerPublic_Forum->actionIndex() in WidgetFramework/XenForo/ControllerPublic/Forum.php at line 12
    WidgetFramework_XenForo_ControllerPublic_Forum->actionIndex() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/alejaserija/public_html/index.php at line 13


Well-known member
So you have to wait.
Someone else except the developer of this add on can't answer your question.

Only give you the advice to disable it till the issue is solved.

Tracy Perry

Well-known member
Then you have resolved what the problem is.. so you need to address the issue through the author of that add-on.
I don't see that you have posted the issue to the discussion topic if it is the custom icon add-on by ThemesCorp.
I did see some posts similar to that last error you showed in that discussion topic.
Custom Username Icons - ThemesCorp.com [Paid]