TeamSpeak Fixed Cannot register after upgrading!

[SeToY]

Hey there,

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'nts_server_group_opts' in 'field list' - library\Zend\Db\Statement\Mysqli.php:77
Generated By: Unknown Account, Today at 10:56
Stack Trace
#0 D:\inetpub\wwwroot\domain.com\library\Zend\Db\Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 D:\inetpub\wwwroot\domain.com\library\Zend\Db\Adapter\Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 D:\inetpub\wwwroot\domain.com\library\Zend\Db\Adapter\Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 D:\inetpub\wwwroot\domain.com\library\Zend\Db\Adapter\Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 D:\inetpub\wwwroot\domain.com\library\XenForo\DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_option', Array)
#5 D:\inetpub\wwwroot\domain.com\library\XenForo\DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 D:\inetpub\wwwroot\domain.com\library\vw\XenForo\DataWriter\User.php(96): XenForo_DataWriter->_save()
#7 D:\inetpub\wwwroot\domain.com\library\XenForo\DataWriter.php(1419): vw_XenForo_DataWriter_User->_save()
#8 D:\inetpub\wwwroot\domain.com\library\XenForo\ControllerPublic\Register.php(416): XenForo_DataWriter->save()
#9 D:\inetpub\wwwroot\domain.com\library\Audentio\Invitation\Extend\XenForo\ControllerPublic\Register.php(63): XenForo_ControllerPublic_Register->actionRegister()
#10 D:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(369): Audentio_Invitation_Extend_XenForo_ControllerPublic_Register->actionRegister()
#11 D:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 D:\inetpub\wwwroot\domain.com\index.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(54) "https://domain.com/register/register"
  ["_GET"] => array(0) {
  }*****
}

 

[SeToY]

Hey,

Server Error Log
Error Info
ErrorException: Undefined index: nts_server_group_opts - library\XenForo\Visitor.php:678
Generated By: Jonazz97, Today at 09:12
Stack Trace
#0 D:\inetpub\wwwroot\domain.com\library\XenForo\Visitor.php(678): XenForo_Application::handlePhpError(8, 'Undefined index...', 'D:\\inetpub\\wwwr...', 678, Array)
#1 D:\inetpub\wwwroot\domain.com\library\NixFifty\TeamSpeak\ControllerPublic\Account.php(190): XenForo_Visitor->offsetGet('nts_server_grou...')
#2 D:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(369): NixFifty_TeamSpeak_ControllerPublic_Account->actionTeamSpeakIdentities()
#3 D:\inetpub\wwwroot\domain.com\library\XenForo\FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 D:\inetpub\wwwroot\domain.com\index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
  ["url"] => string(65) "https://domain.com/account/teamspeak/identities"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Naz]

I believe you’ve had this issue before where the installer steps haven’t run for you.

I’m mobile at the moment but if you pop open the Install.php file and look for the step for the latest version, that should have the query you need to run.

 

[SeToY]

Will do and post back. Every other install went fine, why didn't the TS installer execute the necessary queries?

 

[Naz]

Will do and post back. Every other install went fine, why didn't the TS installer execute the necessary queries?

Likely because there was an old version of the installer in PHP’s opcache that XF executed.

 

[Naz]

I've pushed out another version which just improves the installer in general and brings it a bit more in line with my other products.

Would definitely recommend using the Addon Installer as that can help against opcache related issues like this.

FWIW, the query is:

ALTER TABLE xf_user_option ADD COLUMN `nts_server_group_opts` MEDIUMBLOB NOT NULL

Cheers!

 

[SeToY]

ikely because there was an old version of the installer in PHP’s opcache that XF executed.

Just checked that. I'm running PHP on FastCGI in IIS, which means no OPCache.