Error upgrading from 1.1 to 1.2

[Anthony Parsons]

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option join xf_user user on user.user_id = option.user_id ' at line 1 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: anthony, 1 minute ago
Stack Trace
#0 /home/ptsdforu/public_html/c/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n              ...')
#1 /home/ptsdforu/public_html/c/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n              ...')
#2 /home/ptsdforu/public_html/c/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n              ...')
#3 /home/ptsdforu/public_html/c/library/SV/PersistentAlert/Installer.php(18): Zend_Db_Adapter_Abstract->query('\n              ...')
#4 /home/ptsdforu/public_html/c/library/XenForo/Model/AddOn.php(214): SV_PersistentAlert_Installer::install(Array, Array, Object(SimpleXMLElement))
#5 /home/ptsdforu/public_html/c/library/ConvEss/Model/AddOn.php(24): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), 'xm_persistental...')
#6 /home/ptsdforu/public_html/c/library/XenForo/Model/AddOn.php(169): ConvEss_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), 'xm_persistental...')
#7 /home/ptsdforu/public_html/c/library/XenForo/ControllerAdmin/AddOn.php(237): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/php0julXR', 'xm_persistental...')
#8 /home/ptsdforu/public_html/c/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_AddOn->actionUpgrade()
#9 /home/ptsdforu/public_html/c/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/ptsdforu/public_html/c/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(69) "https://www.myptsd.com/c/admin.php?add-ons/xm_persistentalert/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/xm_persistentalert/upgrade"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

 

[Xon]

@Anthony Parsons what version of MySQL?

Does the following query work?

  update xf_user_option as `option`
  join xf_user as `user` on user.user_id = `option`.user_id
  set `option`.xm_persistentalert = user.xm_persistentalert

 

[Xon]

Please try version 1.2.1, if this doesn't work I will need your MySQL version. Please send it via PM's if you don't want it disclosed.

 

[Anthony Parsons]

Running 5.6 stable.

 

[Anthony Parsons]

Yep, that worked, thanks.