Error when navigating after the final confirmation of the guest order (error 1054)

[Slava]

J6.1.3/PC6.1.8

I’m getting an error message on the website after the final confirmation of the guest order. When I try to navigate further, I see a page with the following message: “The requested page can’t be found. An error has occurred while processing your request.”

Error details:
The requested page can't be found.
...
1054 Unknown column 'cu.bank_account_number' in 'field list'

What steps can be taken to resolve this issue?

[Jan]

Hi, is this full error message? Seems like your database is not fully updated. Did you try to check your Joomla and database (Fix the database in Joomla administration)

Jan

[Slava]

Hi, full error message (URL.../catalog/cart):
The requested page can't be found.
An error has occurred while processing your request.
You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Go to the Home Page
If difficulties persist, please contact the website administrator and report the error below.
1054 Unknown column 'cu.bank_account_number' in 'field list'

I checked the database in Joomla:
Joomla\System\Database\All database table structures are up to date.

The specified issue persists.

[Jan]

Hi, there is no info about the table, but as the system writes, the column is missing in database and needs to be added manually . See install.sql

admin/install/sql/mysql/install.utf8.sql

It should be table phocacart_currencies.

So the column needs to be added there.

[Slava]

Is it possible to resolve the issue without direct access to the database?

[Slava]

bank_account_number
iban
bic_swift
pdf_invoice_qr_information
pdf_invoice_qr_code
The missing fields were added manually in accordance with the specification — the error has been resolved.

Why weren’t these fields created automatically during the component installation?