error message after saving article

[Angelo.pe]

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.

[Jan]

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

[Angelo.pe]

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

[Jan]

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

[Angelo.pe]

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.

[Jan]

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

[Angelo.pe]

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?

[Jan]

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