error message after saving article

Phoca Cart - complex e-commerce extension
User avatar
Angelo.pe
Phoca Enthusiast
Phoca Enthusiast
Posts: 93
Joined: 02 May 2020, 12:42

error message after saving article

Post by Angelo.pe » 13 May 2021, 19:01

Hello guys,
I update to the last version and now, every time that I save a new item, the system shows this message:

"Si è verificato un errore.
1054 Unknown column 'a.type' in 'where clause'
back to control panel"

In the product list, a padlock is visible next to the article title.
All written content is saved except for tags and labels.
in this situation it is very complicated to work. :-(

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43976
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error message after saving article

Post by Jan » 15 May 2021, 18:03

Hi, which latest version do you mean?

Do you use some Beta version for testing?

If yes, and some of the columns were not added to your database when installing, this needs to be done maually, the sql queries for 3.5.7 Beta updating can be found here:

administrator/componetns/com_phocacart/update/sql/mysql/3.5.7.sql

I don't see your full error message but this can be related to price history table:

Code: Select all

ALTER TABLE `#__phocacart_product_price_history` ADD COLUMN `type` tinyint(1) NOT NULL DEFAULT '0';
Jan
If you find Phoca extensions useful, please support the project

User avatar
Angelo.pe
Phoca Enthusiast
Phoca Enthusiast
Posts: 93
Joined: 02 May 2020, 12:42

Re: error message after saving article

Post by Angelo.pe » 17 May 2021, 09:53

Hi Jan,
sorry but I didn't understand your answer. At this point, what should I do?
I urgently need to insert a lot of articles and I've been at a standstill for 3 days. Please, I need your help.
Thank you

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43976
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error message after saving article

Post by Jan » 17 May 2021, 17:33

Hi, what exactly don't you understand? If your database misses some column in some table, such needs to be added manually.

Which version of Phoca Cart do you run?

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

User avatar
Angelo.pe
Phoca Enthusiast
Phoca Enthusiast
Posts: 93
Joined: 02 May 2020, 12:42

Re: error message after saving article

Post by Angelo.pe » 17 May 2021, 20:05

The version is 3.5.7Beta7.
The system does not allow the articles to be exported, so I do not understand which columns are missing.
If I click on the "export" button, nothing happens.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43976
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error message after saving article

Post by Jan » 17 May 2021, 20:31

Hi, first of all, development versions are ready only for testing - for testing server and testing purposes.

When you click on export button and nothing happen, this can also be problem in database - but when there is AJAX, you can find the error in javascript console, not directly in browser.

So first of all the missing column needs to be fixed in the database. See:


https://www.phoca.cz/support/16-joomla/ ... extensions
https://www.phoca.cz/blog/1100-solution ... components
https://www.phoca.cz/documents/16-jooml ... ase-column


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

User avatar
Angelo.pe
Phoca Enthusiast
Phoca Enthusiast
Posts: 93
Joined: 02 May 2020, 12:42

Re: error message after saving article

Post by Angelo.pe » 17 May 2021, 21:15

Sorry Jan for the trouble.Please, I need you to tell me exactly what to do. I have been working on this project for months and there are almost 1000 articles I have entered. I am afraid of making a big mistake.
The error message I see is this:
1054 Unknown column 'a.type' in 'where clause'.
I am able to access the phpmyadmin panel, now what string should I enter?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43976
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error message after saving article

Post by Jan » 18 May 2021, 13:18

Hi, didn't you read the guides?

- open:
administrator\components\com_phocacart\update\sql\mysql\3.5.7.sql
- copy:

Code: Select all

ALTER TABLE `#__phocacart_product_price_history` ADD COLUMN `type` tinyint(1) NOT NULL DEFAULT '0';
- change "#__" to your prefix
- open phpMyAdmin, the current database and into SQL query add this query and run.

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

Post Reply