[BUG]: 1054 Unknown column 'add_jcb_powers_path' in 'field list' #1108

New Issue

Closed

opened 2024-04-11 09:40:56 +00:00 by Safweb · 1 comment

Safweb commented

2024-04-11 09:40:56 +00:00

What Happened?

Function Location

1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Utilities/GetHelper.php:82
6 VDM\Joomla\Utilities\GetHelper::var() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Config.php:707
7 VDM\Joomla\Componentbuilder\Compiler\Config->getJcbpowerspath() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Abstraction/BaseConfig.php:91
8 VDM\Joomla\Abstraction\BaseConfig->get() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php:1077
9 VDM\Joomla\Componentbuilder\Compiler\Helper\Get->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Structure.php:419
10 VDM\Joomla\Componentbuilder\Compiler\Helper\Structure->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Interpretation.php:289
11 VDM\Joomla\Componentbuilder\Compiler\Helper\Interpretation->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Infusion.php:64
12 VDM\Joomla\Componentbuilder\Compiler\Helper\Infusion->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Compiler.php:84
13 VDM\Joomla\Componentbuilder\Compiler\Helper\Compiler->__construct() JROOT/administrator/components/com_componentbuilder/src/Model/CompilerModel.php:292
14 VDM\Component\Componentbuilder\Administrator\Model\CompilerModel->builder() JROOT/administrator/components/com_componentbuilder/src/Controller/CompilerController.php:116
15 VDM\Component\Componentbuilder\Administrator\Controller\CompilerController->compiler() JROOT/libraries/src/MVC/Controller/BaseController.php:730
16 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143
17 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150
19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:195
20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58
22 require_once() JROOT/administrator/index.php:32

Steps to reproduce the Bug

When I try to Compile, it doesn't matter if it's for 3, 4 or 5, I get the same error.

Which Joomla version are you compiling in?

5.0.3

Which PHP version are you compiling in?

8.2.16

Which Joomla versions are you targeting?

Which PHP version are you targeting?

8.2.16

Which Web server is JCB running on?

Linux

Which Relational Database is JCB running on?

10.5.24-MariaDB

Which OS is JCB running on?

LiteSpeed

Which JCB version are you using?

5.0.0-beta2

Where in JCB did this issue occur?

Compilation of a component

On which browsers did you encounter the issue?

Firefox

Additional Comments

No response

### What Happened? # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138 2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138 3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020 4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785 5 Joomla\Database\DatabaseDriver->setQuery() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Utilities/GetHelper.php:82 6 VDM\Joomla\Utilities\GetHelper::var() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Config.php:707 7 VDM\Joomla\Componentbuilder\Compiler\Config->getJcbpowerspath() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Abstraction/BaseConfig.php:91 8 VDM\Joomla\Abstraction\BaseConfig->get() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php:1077 9 VDM\Joomla\Componentbuilder\Compiler\Helper\Get->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Structure.php:419 10 VDM\Joomla\Componentbuilder\Compiler\Helper\Structure->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Interpretation.php:289 11 VDM\Joomla\Componentbuilder\Compiler\Helper\Interpretation->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Infusion.php:64 12 VDM\Joomla\Componentbuilder\Compiler\Helper\Infusion->__construct() JROOT/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Compiler.php:84 13 VDM\Joomla\Componentbuilder\Compiler\Helper\Compiler->__construct() JROOT/administrator/components/com_componentbuilder/src/Model/CompilerModel.php:292 14 VDM\Component\Componentbuilder\Administrator\Model\CompilerModel->builder() JROOT/administrator/components/com_componentbuilder/src/Controller/CompilerController.php:116 15 VDM\Component\Componentbuilder\Administrator\Controller\CompilerController->compiler() JROOT/libraries/src/MVC/Controller/BaseController.php:730 16 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143 17 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:195 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58 22 require_once() JROOT/administrator/index.php:32 ### Steps to reproduce the Bug When I try to Compile, it doesn't matter if it's for 3, 4 or 5, I get the same error. ### Which Joomla version are you compiling in? 5.0.3 ### Which PHP version are you compiling in? 8.2.16 ### Which Joomla versions are you targeting? 5 ### Which PHP version are you targeting? 8.2.16 ### Which Web server is JCB running on? Linux ### Which Relational Database is JCB running on? 10.5.24-MariaDB ### Which OS is JCB running on? LiteSpeed ### Which JCB version are you using? 5.0.0-beta2 ### Where in JCB did this issue occur? Compilation of a component ### On which browsers did you encounter the issue? Firefox ### Additional Comments _No response_

Safweb added the

Bug

label 2024-04-11 09:40:56 +00:00

Llewellyn added a new dependency 2024-04-11 09:49:02 +00:00

#1106 [BUG]: Unknown column 'add_jcb_powers_path' in 'field list'

Llewellyn commented

2024-04-21 23:29:36 +00:00

Owner

We have now added a fallback to make sure the JCB tables are always going to have all views, and columns going forward.

Your welcome to look at this new set of classes over here:

Base or Abstract Schema
JCB Schema

Called during the install J3 J4 J5 (post update event)

You can theoretically do that same in your projects, demonstration in tutorial coming soon ;)

PLEASE Test the latest JCB releases:

We have now added a fallback to make sure the JCB tables are always going to have all views, and columns going forward. Your welcome to look at this new set of classes over here: - Base or [Abstract Schema](https://git.vdm.dev/joomla/Component-Builder/src/branch/4.x/libraries/vendor_jcb/VDM.Joomla/src/Abstraction/Schema.php) - JCB [Schema](https://git.vdm.dev/joomla/Component-Builder/src/branch/4.x/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Table/Schema.php) Called during the install [J3](https://git.vdm.dev/joomla/Component-Builder/src/commit/5e980f5f95c475010d7f8b8493c114af84337fd6/script.php#L9807) [J4](https://git.vdm.dev/joomla/Component-Builder/src/commit/5e52db0d549d040916886d8c49c2c6f4c5972814/ComponentbuilderInstallerScript.php#L3208) [J5]() (post update event) You can theoretically do that same in your projects, demonstration in tutorial coming soon ;) PLEASE Test the latest JCB releases: - [version 3.2.1-beta1](https://git.vdm.dev/joomla/pkg-component-builder/archive/v3.2.1-beta1.zip) - [version 4.0.0-beta4](https://git.vdm.dev/joomla/pkg-component-builder/archive/v4.0.0-beta4.zip) - [version 5.0.0-beta4](https://git.vdm.dev/joomla/pkg-component-builder/archive/v5.0.0-beta4.zip)

Llewellyn closed this issue

2024-04-24 19:40:56 +00:00