Not a Bug Floating Menu option in User Preferences got errors

Discussion in '[HA] Floating Menu' started by Anh Tran, Apr 23, 2017.

  1. Anh Tran

    Anh Tran New Member News Ticker XF License Validated

    Joined:
    Oct 6, 2016
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Gender:
    Male
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'dad_fm_show_floating_menu' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: admin, 8 minutes ago

    Stack Trace
    #0 /home/chlqgcaw/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_user...')
    #1 /home/chlqgcaw/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_user...')
    #2 /home/chlqgcaw/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_user...')
    #3 /home/chlqgcaw/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
    #4 /home/chlqgcaw/public_html/library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('xf_user_option', Array, 'user_id = 1')
    #5 /home/chlqgcaw/public_html/library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
    #6 /home/chlqgcaw/public_html/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
    #7 /home/chlqgcaw/public_html/library/XenForo/ControllerPublic/Account.php(766): XenForo_DataWriter->save()
    #8 /home/chlqgcaw/public_html/library/Brivium/ModernStatistic/ControllerPublic/Account.php(22): XenForo_ControllerPublic_Account->actionPreferencesSave()
    #9 /home/chlqgcaw/public_html/library/LiveUpdate/ControllerPublic/Account.php(7): Brivium_ModernStatistic_ControllerPublic_Account->actionPreferencesSave()
    #10 /home/chlqgcaw/public_html/library/Dadparvar/notifications/Extend/XenForo/ControllerPublic/Account.php(8): LiveUpdate_ControllerPublic_Account->actionPreferencesSave()
    #11 /home/chlqgcaw/public_html/library/Dadparvar/FloatingMenu/XenForo/ControllerPublic/Account.php(38): Dadparvar_notifications_Extend_XenForo_ControllerPublic_Account->actionPreferencesSave()
    #12 /home/chlqgcaw/public_html/library/XenForo/FrontController.php(351): Dadparvar_FloatingMenu_XenForo_ControllerPublic_Account->actionPreferencesSave()
    #13 /home/chlqgcaw/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #14 /home/chlqgcaw/public_html/index.php(13): XenForo_FrontController->run()
    #15 {main}

    Could you please help me fix this error, thank you
     
  2. Dadparvar

    Dadparvar is a Verified MemberDadparvar Administrator Staff Member XF License Validated

    Joined:
    Mar 28, 2016
    Messages:
    1,082
    Likes Received:
    136
    Trophy Points:
    63
    Hi,

    It says the database part of add-on is not added for you. Uninstall the add-on and install it as fresh. I think it will fix your problem.

    If not, I'll give you the query. But first uninstall and reinstall and let me know the result.
     
  3. Anh Tran

    Anh Tran New Member News Ticker XF License Validated

    Joined:
    Oct 6, 2016
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Gender:
    Male
    I'm trying to Uninstall but I can not do it, another errors appear when click Uninstall

    Server Error

    Mysqli statement execute error : Can't DROP 'dad_fm_show_floating_menu'; check that column/key exists

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Dadparvar/FloatingMenu/Install.php at line 95
    4. Dadparvar_FloatingMenu_Install::uninstall()
    5. call_user_func() in XenForo/DataWriter/AddOn.php at line 214
    6. XenForo_DataWriter_AddOn->_postDelete() in AddOnInstaller/XenForo/DataWriter/AddOn.php at line 10
    7. AddOnInstaller_XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1793
    8. XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 123
    9. XenForo_ControllerAdmin_AddOn->actionDelete() in XFUniverse/TaigaChatEssentials/Proxy/XenForo/ControllerAdmin/AddOn.php at line 11
    10. XFUniverse_TaigaChatEssentials_Proxy_XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 351
    11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    12. XenForo_FrontController->run() in /home/chlqgcaw/public_html/admin.php at line 13
     
  4. Dadparvar

    Dadparvar is a Verified MemberDadparvar Administrator Staff Member XF License Validated

    Joined:
    Mar 28, 2016
    Messages:
    1,082
    Likes Received:
    136
    Trophy Points:
    63
    OK.

    Do these steps in order. Then you can fully use the add-on with no problem :)

    1. Run this query in database so that it adds the missing part
    Code:
    ALTER TABLE `xf_user_option` ADD `dad_fm_show_floating_menu` BOOLEAN NOT NULL DEFAULT '1'
    2. Uninstall the add-on and Reinstall it. We don't know what other things are missed in your try to install or upgrade. So to make sure everything is OK, its better to have a fresh install ;)

    Let me know the result.
     
  5. Anh Tran

    Anh Tran New Member News Ticker XF License Validated

    Joined:
    Oct 6, 2016
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Gender:
    Male
    Thank you for your support, everything now GOOD.
     
    Dadparvar likes this.