Fixed mass of errors on uninstall

[alfa1]

I had group 2.2.6 installed. Upgraded to 2.2.9 successfully. As I am testing CLI importer I first uninstalled groups to remove all data. This failed. Here are the errors:

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'thread.team_id' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Alfa1, 3 minutes ago

Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT thr...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT thr...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT thr...')
#3 /library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT thr...', Array, 2)
#4 /library/XenForo/Model/Thread.php(550): XenForo_Model->fetchAllKeyed('\n\t\t\t\tSELECT thr...', 'thread_id')
#5 /library/Nobita/Teams/ControllerPublic/Abstract.php(140): XenForo_Model_Thread->getThreads(Array, Array)
#6 /library/Nobita/Teams/ControllerPublic/Abstract.php(99): Nobita_Teams_ControllerPublic_Abstract->_getRecentAndTrendingThreadsWidget()
#7 /library/Nobita/Teams/ControllerPublic/Team.php(114): Nobita_Teams_ControllerPublic_Abstract->_getTeamIndexWrapper('index', Object(XenForo_ControllerResponse_View))
#8 /library/XenForo/FrontController.php(347): Nobita_Teams_ControllerPublic_Team->actionIndex()
#9 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(55) "https://.../index.php?groups/"
["_GET"] => array(1) {
["groups/"] => string(0) ""
}
["_POST"] => array(0) {
}
}


Followed by a mass of these errors:

Server Error Log
Error Info
ErrorException: Undefined index: team_count - library/Nobita/Teams/Model/Category.php:519
Generated By: Alfa1, 6 minutes ago
Stack Trace

#0 /library/Nobita/Teams/Model/Category.php(519): XenForo_Application::handlePhpError(8, 'Undefined index...', '/home/...', 519, Array)
#1 /library/Nobita/Teams/ControllerPublic/Team.php(98): Nobita_Teams_Model_Category->canAddTeam()
#2 /library/XenForo/FrontController.php(347): Nobita_Teams_ControllerPublic_Team->actionIndex()
#3 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /index.php(13): XenForo_FrontController->run()
#5 {main}

Request State

array(3) {
["url"] => string(55) "https…/index.php?groups/"
["_GET"] => array(1) {
["groups/"] => string(0) ""
}
["_POST"] => array(0) {
}
}

 

[Truonglv]

Hmm! Please reimport XML again.

 

[alfa1]

On importing xml it just hangs and keeps giving errors.


Server Error



Mysqli statement execute error : Duplicate column name 'vb_thread_id'



Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297

Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479

Zend_Db_Adapter_Abstract->query() in Nobita/Teams/Installer.php at line 365

Nobita_Teams_Installer::install()

call_user_func() in XenForo/Model/AddOn.php at line 215

XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169

XenForo_Model_AddOn->installAddOnXmlFromFile() in AddOnInstaller/ControllerAdmin/AddOn.php at line 36

AddOnInstaller_ControllerAdmin_AddOn->actionInstallUpgrade() in XenForo/FrontController.php at line 347

XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134

XenForo_FrontController->run() in /admin.php at line 13

 

[Truonglv]

Just try with this file. Upload and overwrite it.

 

[alfa1]

Still no luck. When importing the xml my browser chokes on it. It uses 300MB RAM just for this. The import script never finishes. I can only abort it by closing the browser.

 

[Truonglv]

The import script never finishes. I can only abort it by closing the browser.

alfa1You not using CLI import?

Still no luck. When importing the xml my browser chokes on it.

It could not occurs.

 

[alfa1]

You not using CLI import?

NobitaImport of the XML for installing and uninstalling the addon.

 

[alfa1]

My server chocked on it. A lot of locks and server became unresponsive. Live site went down.

 

[Truonglv]

Are you test on localhost? Hmm

Please add me on skype: Truonglv[at]outlook.com

 

[alfa1]

No test on local host. I was uploading the xml through the xf installer. You have me on facebook.