checkout-layout in error

[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

[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

[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

[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.

[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

[Angelo.pe]

Should I make the backup first?

[Jan]

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

Jan

[Angelo.pe]

Hi Jan, I made the backup. The link to beta version doesn't work. Please, could you give me it? Thank you

[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

[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