I’m setting the template Mebel of J4 and the link dedicated to the checkout layout shows this message error.
1054 UNKNOWN COLUMN 'C.PARAMS_SHIPPING' IN 'FIELD LIST'
What would be the problem?
Thank you in advance
checkout-layout in error
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: checkout-layout in error
Hi, can you enable debug mode to get full error message including file and row of the problem?
Which version of Phoca Cart do you use? Are all parts of Phoca Cart like modules and plugins updated to latest version?
Jan
Which version of Phoca Cart do you use? Are all parts of Phoca Cart like modules and plugins updated to latest version?
Jan
If you find Phoca extensions useful, please support the project
- Angelo.pe
- Phoca Professional
- Posts: 140
- Joined: 02 May 2020, 12:42
Re: checkout-layout in error
Hi Jan, thank you very much for the reply. I can't go with this error
In this moment I'm using:
Joomla 4.2.6
Phoca 4.0.5
all modules and plugins were updated to the last version possible.
Debug mode shows this message:
1054 UNKNOWN COLUMN 'C.PARAMS_SHIPPING' IN 'FIELD LIST'
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048
3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/db.php:42
5 PhocacartCartDb::getCartDb() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/cart.php:166
6 PhocacartCart->__construct() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/rendercheckout.php:27
7 PhocacartCartRendercheckout->__construct() JROOT/components/com_phocacart/views/checkout/view.html.php:123
8 PhocaCartViewCheckout->display() JROOT/libraries/src/MVC/Controller/BaseController.php:639
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocacart/controller.php:53
10 PhocaCartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocacart/phocacart.php:16
12 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:200
16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:241
17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
18 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:61
19 require_once() JROOT/index.php:32
In this moment I'm using:
Joomla 4.2.6
Phoca 4.0.5
all modules and plugins were updated to the last version possible.
Debug mode shows this message:
1054 UNKNOWN COLUMN 'C.PARAMS_SHIPPING' IN 'FIELD LIST'
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048
3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/db.php:42
5 PhocacartCartDb::getCartDb() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/cart.php:166
6 PhocacartCart->__construct() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/rendercheckout.php:27
7 PhocacartCartRendercheckout->__construct() JROOT/components/com_phocacart/views/checkout/view.html.php:123
8 PhocaCartViewCheckout->display() JROOT/libraries/src/MVC/Controller/BaseController.php:639
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocacart/controller.php:53
10 PhocaCartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocacart/phocacart.php:16
12 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:200
16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:241
17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
18 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:61
19 require_once() JROOT/index.php:32
- Angelo.pe
- Phoca Professional
- Posts: 140
- Joined: 02 May 2020, 12:42
Re: checkout-layout in error
Hi Jan,
in the top of the page there is also this message:
WE ARE SORRY!
Gantry 5 provides a custom error page for you to configure with either positions, particles or a combination of both, as well as styling.
in the top of the page there is also this message:
WE ARE SORRY!
Gantry 5 provides a custom error page for you to configure with either positions, particles or a combination of both, as well as styling.
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: checkout-layout in error
Hi, are you able to test the latest Beta version (to test if the problem still occurs):
https://github.com/PhocaCz/PhocaCart/re ... Beta13.zip
Jan
https://github.com/PhocaCz/PhocaCart/re ... Beta13.zip
Jan
If you find Phoca extensions useful, please support the project
- Angelo.pe
- Phoca Professional
- Posts: 140
- Joined: 02 May 2020, 12:42
Re: checkout-layout in error
Should I make the backup first?
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: checkout-layout in error
Of course it is better to make backup. But there should not be any problem as this is just standard package
Jan
Jan
If you find Phoca extensions useful, please support the project
- Angelo.pe
- Phoca Professional
- Posts: 140
- Joined: 02 May 2020, 12:42
Re: checkout-layout in error
Hi Jan, I made the backup. The link to beta version doesn't work. Please, could you give me it? Thank you
- Angelo.pe
- Phoca Professional
- Posts: 140
- Joined: 02 May 2020, 12:42
Re: checkout-layout in error
Hi Jan,
I managed to install the beta 13 version. I cleared the cache but the problem is still the same.
The shopping cart page shows the error (shown below) after logging in
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048
3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/db.php:42
5 PhocacartCartDb::getCartDb() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/cart.php:166
6 PhocacartCart->__construct() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/rendercheckout.php:27
7 PhocacartCartRendercheckout->__construct() JROOT/components/com_phocacart/views/checkout/view.html.php:123
8 PhocaCartViewCheckout->display() JROOT/libraries/src/MVC/Controller/BaseController.php:639
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocacart/controller.php:53
10 PhocaCartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocacart/phocacart.php:16
12 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:200
16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:241
17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
18 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:61
19 require_once() JROOT/index.php:32
I managed to install the beta 13 version. I cleared the cache but the problem is still the same.
The shopping cart page shows the error (shown below) after logging in
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1048
3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/db.php:42
5 PhocacartCartDb::getCartDb() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/cart.php:166
6 PhocacartCart->__construct() JROOT/administrator/components/com_phocacart/libraries/phocacart/cart/rendercheckout.php:27
7 PhocacartCartRendercheckout->__construct() JROOT/components/com_phocacart/views/checkout/view.html.php:123
8 PhocaCartViewCheckout->display() JROOT/libraries/src/MVC/Controller/BaseController.php:639
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocacart/controller.php:53
10 PhocaCartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocacart/phocacart.php:16
12 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:200
16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:241
17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
18 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:61
19 require_once() JROOT/index.php:32
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: checkout-layout in error
Hi, this means, that the database column was not added when updating
The update is a part of 4.0.0 (so in case 4.0.0 was nost installed but updated, maybe the columns were not added):
administrator/components/com_phocacart/update/sql/mysql/4.0.0.sql
Try to open this file (4.0.0.sql), uncomment the queries (removing -- from start) and try to add them step by step into your database (of course with cour database prefix, e.g.:
FROM:
TO:
etc. so the missing columns will be added to system.
Jan
The update is a part of 4.0.0 (so in case 4.0.0 was nost installed but updated, maybe the columns were not added):
administrator/components/com_phocacart/update/sql/mysql/4.0.0.sql
Try to open this file (4.0.0.sql), uncomment the queries (removing -- from start) and try to add them step by step into your database (of course with cour database prefix, e.g.:
FROM:
Code: Select all
-- 4.0.0 Beta ==> RC
-- ALTER TABLE `#__phocacart_cart_multiple` ADD COLUMN `params_shipping` text;
-- ALTER TABLE `#__phocacart_cart_multiple` ADD COLUMN `params_payment` text;
Code: Select all
ALTER TABLE `jos_phocacart_cart_multiple` ADD COLUMN `params_shipping` text;
ALTER TABLE `jos_phocacart_cart_multiple` ADD COLUMN `params_payment` text;
Jan
If you find Phoca extensions useful, please support the project