Error when updating to 2.2.12

diego222

Active member
Affected version
2.2.11
Hi,

When I tried to upgrade to 2.2.12 through automatic process through my forum panel, I get this error message and now I can't continue. What should I do now?... upgrade it manually (download package, upload through ftp and go through upgrade process)?

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'cookie_third_parties' in 'field list' in src/XF/Db/AbstractStatement.php at line 230
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 324
  6. XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1526
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
  8. XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/BbCodeMediaSite.php at line 85
  9. XF\AddOn\DataType\BbCodeMediaSite->importAddOnData() in src/XF/Job/AddOnData.php at line 110
  10. XF\Job\AddOnData->run() in src/XF/Job/Atomic.php at line 40
  11. XF\Job\Atomic->run() in src/XF/Job/Manager.php at line 260
  12. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
  13. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 153
  14. XF\Job\Manager->runUnique() in src/XF/Install/Controller/AbstractController.php at line 24
  15. XF\Install\Controller\AbstractController->manualJobRunner() in src/XF/Install/Controller/Upgrade.php at line 266
  16. XF\Install\Controller\Upgrade->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
  17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
  21. XF\App->run() in src/XF.php at line 524
  22. XF::runApp() in install/index.php at line 14
 
It seems the new column for cookie consens is not there. Can you take a look at thia at your DB?
 
Just FYI, I got an error that may be related:
  • ErrorException: [E_WARNING] Undefined array key "cookieConsent"
  • src/XF/Pub/App.php:675
(I'm hoping it is benign error since no plans to provide granularity of permissions on cookies.)
 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'cookie_third_parties' in 'field list' in src/XF/Db/AbstractStatement.php at line 230

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 324
  6. XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1521
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
  8. XF\Mvc\Entity\Entity->save() in src/XF/AddOn/DataType/BbCodeMediaSite.php at line 85
  9. XF\AddOn\DataType\BbCodeMediaSite->importAddOnData() in src/XF/Job/AddOnData.php at line 110
  10. XF\Job\AddOnData->run() in src/XF/Job/Atomic.php at line 40
  11. XF\Job\Atomic->run() in src/XF/Job/Manager.php at line 260
  12. XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
  13. XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 153
  14. XF\Job\Manager->runUnique() in src/XF/Install/Controller/AbstractController.php at line 24
  15. XF\Install\Controller\AbstractController->manualJobRunner() in src/XF/Install/Controller/Upgrade.php at line 266
  16. XF\Install\Controller\Upgrade->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
  17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
  21. XF\App->run() in src/XF.php at line 524
  22. XF::runApp() in install/index.php at line 14
I have this same problem in my ACP while trying to upgrade from 2.2.10 to 2.2.13 by using the ACP method of upgrading.
My site and ACP aren't reachable and only displays: "The site is currently being upgraded. Please check back later"

I'm wondering what the fix was, should I try and go back in my browser? I'm at /forums/install/index.php?upgrade/run-job

Kind of freaking out right now as I can't change anything...
 
I was able to complete the update process by using the manual update described earlier in this thread:
"it seems everything its ok now... just upgrade manually (without needing to upload through ftp) and works fine now"

Everything seems to be ok for me, needed to update by going to the install directory with my browser.
 
Top Bottom