Fixed 2.3.0 Beta 4 Install Stopped

philmckrackon

philmckrackon

Active member
Affected version
2.3.0 Beta 4
XF 2.2.15 to XF 2.3.0 Beta 3 ~ OK
XF 2.2.15 to XF 2.3.0 Beta 4 ~ ERROR
PHP version 8.2.17
MySQL version 8.0.36
Tried with and without addons enabled. Debug & Developers mode = false
Completed install by rerunning https://<my domain/******/install/

$config['enableListeners'] = 1;

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'priority' 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 40
  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 219
  6. XF\Db\AbstractAdapter->insert() in src/XF/Job/Manager.php at line 550
  7. XF\Job\Manager->_enqueue() in src/XF/Job/Manager.php at line 497
  8. XF\Job\Manager->enqueueUnique() in src/XF/Repository/Icon.php at line 168
  9. XF\Repository\Icon->enqueueUsageAnalyzer() in src/XF/Entity/Phrase.php at line 180
  10. XF\Entity\Phrase->_postSave() in src/XF/Mvc/Entity/Entity.php at line 1314
  11. XF\Mvc\Entity\Entity->save() in src/XF/Install/InstallHelperTrait.php at line 463
  12. XF\Install\Upgrade\AbstractUpgrade->createWidget() in src/XF/Install/Upgrade/2030010-230a.php at line 361
  13. XF\Install\Upgrade\Version2030010->step8() in src/XF/Install/Controller/Upgrade.php at line 179
  14. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 352
  15. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
  16. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  17. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
  19. XF\App->run() in src/XF.php at line 532
  20. XF::runApp() in install/index.php at line 14

$config['enableListeners'] = 0;

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'priority' 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 40
  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 219
  6. XF\Db\AbstractAdapter->insert() in src/XF/Job/Manager.php at line 550
  7. XF\Job\Manager->_enqueue() in src/XF/Job/Manager.php at line 497
  8. XF\Job\Manager->enqueueUnique() in src/XF/Repository/Icon.php at line 168
  9. XF\Repository\Icon->enqueueUsageAnalyzer() in src/XF/Entity/Phrase.php at line 180
  10. XF\Entity\Phrase->_postSave() in src/XF/Mvc/Entity/Entity.php at line 1314
  11. XF\Mvc\Entity\Entity->save() in src/XF/Install/InstallHelperTrait.php at line 463
  12. XF\Install\Upgrade\AbstractUpgrade->createWidget() in src/XF/Install/Upgrade/2030010-230a.php at line 361
  13. XF\Install\Upgrade\Version2030010->step8() in src/XF/Install/Controller/Upgrade.php at line 179
  14. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 352
  15. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
  16. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  17. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
  19. XF\App->run() in src/XF.php at line 532
  20. XF::runApp() in install/index.php at line 14
 
Last edited:
We will fix this properly for Beta 5 but for now you will need to run this query manually to be able to continue:
Chris D said:
SQL: 
ALTER TABLE `xf_job`
ADD `attempts` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `last_run_date`,
ADD `priority` SMALLINT UNSIGNED NOT NULL DEFAULT '100' AFTER `attempts`
Click to expand...
Once added, the upgrades should be resumable.
 
Last edited:
I get this in (phpmyadmin)

Code: 
ALTER TABLE `xf_job`
ADD `priority` SMALLINT UNSIGNED NOT NULL DEFAULT '100' AFTER `attempts`;
MySQL said: Documentation

#1054 - Unknown column 'attempts' in 'xf_job'
 
Heh fair point...

Probably this one:

SQL: 
ALTER TABLE `xf_job`
ADD `attempts` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `last_run_date`,
ADD `priority` SMALLINT UNSIGNED NOT NULL DEFAULT '100' AFTER `attempts`
 
You need to ensure you continue the upgrade or, if the upgrade completed, rebuild master data by running the install script again.
 
Maybe enable debug mode and see if any other errors surface:

Code: 
$config['enableListeners'] = false;

Also check if you can access admin.php directly and check if there are any new error logs.
 
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.0 Beta 5).

Change log:
Enforce xf_job structure during upgrade to avoid issues with missing columns caused by upgrade steps that run before the job table structure is changed.
Click to expand...
There may be a delay before changes are rolled out to the XenForo Community.
 
XF Bug Bot said:
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.0 Beta 5).

Change log:

There may be a delay before changes are rolled out to the XenForo Community.
Click to expand...

MattW said:
I know this is marked as resolved, but I've just attempted a 2.2.15 to 2.3.0 Beta 4, and end up in the same state as Pete's attempt:

View attachment 301450
Click to expand...
It says it's resolved in Beta 5. I reran the install to complete the process. Have you tried that?
 
philmckrackon said:
It says it's resolved in Beta 5. I reran the install to complete the process. Have you tried that?
Click to expand...
Yes, and rebuilt the master data. The upgrade completed, but the admin and front end are messed up as shown in the screen shot.

The issue with additional SQL I can get around, but the end result after that looks like Pete's
 
MattW said:
Yes, and rebuilt the master data. The upgrade completed, but the admin and front end are messed up as shown in the screen shot.

The issue with additional SQL I can get around, but the end result after that looks like Pete's
Click to expand...

Set $config['enableListeners'] = false;
before rebuild Masterdata?
 
In the inspector, do any CSS files fail to load properly? Also it looks like server errors have been logged in case that's relevant.
 
Jeremy P said:
In the inspector, do any CSS files fail to load properly? Also it looks like server errors have been logged in case that's relevant.
Click to expand...
No, there are no CSS files reporting missing or not loading.

Also, job.php is stuck in a constant loop

1713432819986.webp

1713432913764.webp

I wonder if the Cloudflare addon and R2 storage is causing issues?
 
That appears to be from a template modification to core.less, there is no .structItem-cell--productThumb class in the core.
 

Similar threads

Daveo16
Fixed 2.3.0 Beta 5 Install Bug
Replies
11
Views
812
XF Bug Bot
XF Bug Bot
C
  • Question Question
XF 2.3 2.3.0 beta 5 setup error
Replies
0
Views
49
caspondable
C
A
Duplicate Errors upgrade XFRM from 2.2.5 to 2.3.0 Beta 1
Replies
1
Views
141
Jeremy P
Jeremy P
Mr Lucky
  • Question Question
Version 2.3.0 beta 2 XFES\Elasticsearch\RequestException: Elasticsearch indexing error
Replies
8
Views
264
Mr Lucky
Mr Lucky
D
Error when updating to 2.2.12
Replies
8
Views
1K
ChicagoCoin
ChicagoCoin
Top Bottom