[BUG]: Unknown column 'add_jcb_powers_path' in 'field list' #1106
Labels
No Milestone
No project
No Assignees
3 Participants
Notifications
Due Date
No due date set.
Blocks
#1108 [BUG]: 1054 Unknown column 'add_jcb_powers_path' in 'field list'
joomla/Component-Builder
Reference: joomla/Component-Builder#1106
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
What Happened?
Only updated from jcb 3.2.1-alpha1 to jcb 3.2.1-alpha3
Using the same component, nothing changed, only trying to re-compile
Steps to reproduce the Bug
update jcb to 3.2.1-alpha3
Which Joomla version are you compiling in?
3
Which PHP version are you compiling in?
8.0
Which Joomla versions are you targeting?
3
Which PHP version are you targeting?
8.0
Which Web server is JCB running on?
Apache
Which Relational Database is JCB running on?
Mariadb
Which OS is JCB running on?
Linux ubuntu
Which JCB version are you using?
3.2.1-alpha3
Which Joomla version is JCB installed on?
Joomla 3
Where in JCB did this issue occur?
Compilation of a component, Compiler(admin_view)
On which browsers did you encounter the issue?
Firefox
Additional Comments
No response
Please give us more information, screenshots and details. We did not experience the same, and are not able to reproduce this just yet.
I have the same issue on Joomla 5 using 5.0.0-beta2. Also under Linux Ubuntu but for this with php8.2
I just updated to the latest version.
And here only Hello world is there as a component, as I'm now mainly trying to create in joomla 3.
this is some error text related to vdm:
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
Then some from the apache error log:
[Wed Apr 10 20:45:13.203473 2024] [proxy_fcgi:error] [pid 1699] [client 127.0.0.1:44984] AH01071: Got error 'PHP message: PHP Deprecated: Optional parameter $replaceValue declared before required parameter $componentId is implicitly treated as a required parameter in /var/www/site83.test/joomla5componentdev/administrator/components/com_componentbuilder/src/Model/AjaxModel.php on line 3726; PHP message: PHP Deprecated: Optional parameter $replaceValue declared before required parameter $regexSearch is implicitly treated as a required parameter in /var/www/site83.test/joomla5componentdev/administrator/components/com_componentbuilder/src/Model/AjaxModel.php on line 3772; PHP message: PHP Deprecated: Optional parameter $replaceValue declared before required parameter $regexSearch is implicitly treated as a required parameter in /var/www/site83.test/joomla5componentdev/administrator/components/com_componentbuilder/src/Model/AjaxModel.php on line 3819', referer: http://site83.test/joomla5componentdev/administrator/index.php?option=com_componentbuilder&view=compiler
[Wed Apr 10 20:45:17.243950 2024] [proxy_fcgi:error] [pid 1699] [client 127.0.0.1:44984] AH01071: Got error 'PHP message: PHP Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Interpretation.php on line 6402; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50; PHP message: PHP Deprecated: Implicit conversion from float 3.1 to int loses precision in /var/www/site83.test/joomla5componentdev/libraries/vendor_jcb/VDM.Joomla/src/Componentbuilder/Compiler/Helper/Get.php on line 50', referer: http://site83.test/joomla5componentdev/administrator/index.php?option=com_componentbuilder&view=compiler
and a screenshot of the error, which is equal to the error with jcb 3.2.1-Alpha1 on joomla 3 with php 8.0.30
Does this help?
I've logged the query that it tries to run to compile the demo component since i have the exact same issue:
SELECT
add_jcb_powers_pathFROM
#__componentbuilder_joomla_componentWHERE
id= 25This is where it fails.
the column is not there after updating. So it seems it's not in the update mysql files for JCB.
Running the sql manually from the update file 5.0.0-alpha.sql fixed it:
ALTER TABLE
#__componentbuilder_joomla_componentADDadd_jcb_powers_pathTINYINT(1) NOT NULL DEFAULT 0 AFTERadd_javascript;ALTER TABLE
#__componentbuilder_joomla_componentADDjcb_powers_pathVARCHAR(255) NOT NULL DEFAULT '' AFTERjavascript;Yes the update of the database was skipped, it seems like our alpha, beta versions and the database updates they add are not always triggered...
I am looking into this and trying to see what we can do so that we will continue to have an automatic database update flow.
Thanks for finding it.
I tried similar to add the column to one the tables but that did not work.
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:
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:
Zal ik doen.
Thanks very much!