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

Not a Bug Floating Menu option in User Preferences got errors

Anh Tran

New Member
News Ticker
License Validated
#1
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
 

Dadparvar

Administrator
Staff member
License Validated
Resources Layouts [XF2]
Pricing Tables [XF2]
#2
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.
 

Anh Tran

New Member
News Ticker
License Validated
#3
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
 

Dadparvar

Administrator
Staff member
License Validated
Resources Layouts [XF2]
Pricing Tables [XF2]
#4
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.