checkout-layout in error

Phoca Templates - templates for Joomla! CMS
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

checkout-layout in error

Post by Angelo.pe »

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 ;-)
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48345
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: checkout-layout in error

Post by Jan »

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
If you find Phoca extensions useful, please support the project
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

Re: checkout-layout in error

Post by Angelo.pe »

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
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

Re: checkout-layout in error

Post by Angelo.pe »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48345
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: checkout-layout in error

Post by Jan »

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
If you find Phoca extensions useful, please support the project
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

Re: checkout-layout in error

Post by Angelo.pe »

Should I make the backup first?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48345
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: checkout-layout in error

Post by Jan »

Of course it is better to make backup. But there should not be any problem as this is just standard package :idea:

Jan
If you find Phoca extensions useful, please support the project
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

Re: checkout-layout in error

Post by Angelo.pe »

Hi Jan, I made the backup. The link to beta version doesn't work. Please, could you give me it? Thank you
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 140
Joined: 02 May 2020, 12:42

Re: checkout-layout in error

Post by Angelo.pe »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48345
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: checkout-layout in error

Post by Jan »

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:

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;
TO:

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;
etc. so the missing columns will be added to system.

Jan
If you find Phoca extensions useful, please support the project
Post Reply