Database error - unknown column

Database error - unknown column

Hi there.
How to solve this problem:
1054 - Unknown column 'prod.min_count_product' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.min_count_product FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id=1 AND prod.product_publish=1 AND prod.access IN (1,1,5) ORDER BY name ASC

---

Aw: Database error - unknown column

Problem in addon / plugin.

addon / plugin installed?

Aw: Database error - unknown column

I am having the same type of error:
Error: 1054 - Unknown column 'category_id' in 'field list' SQL=INSERT INTO `#__jshopping_order_item` (`order_id`,`product_id`,`product_ean`,`product_name`,`product_quantity`,`product_item_price`,`product_tax`,`product_attributes`,`product_freeattributes`,`attributes`,`freeattributes`,`extra_fields`,`files`,`weight`,`thumb_image`,`manufacturer`,`delivery_times_id`,`vendor_id`,`category_id`) VALUES ('37','19','','Perspective grids Set of 8','1','24.95','19.00','','','a:0:{}','a:0:{}','','a:0:{}','0.0000','thumb_normalpersp2.jpg','','0','1','2')

I updated the addon to test database structure.

Any help would be appreciated.

---

Aw: Database error - unknown column

Update need STEP to STEP!

inastal Component Update 4.14.3 -> 4.15.0

Aw: Database error - unknown column

That worked!

Thank you so much.

Aw: Database error - unknown column

Hi there, have a simular problem after updating from 4.6.0 - think I took all the update steps till 4.16.2 but maybe I skipped a step - can not figure out which one. Error: 1054 Unknown column 'scriptname' in 'field list'.
Should I go back to a backup and start all over or do you have a more simple solution?
Thanks,
kind regards,
Meindert

---

Aw: Database error - unknown column

Simple - Add filter in database

Use phpMyAdmin
add
fileld scriptname

Aw: Database error - unknown column

Ok, thanks. But to which table should I add field scriptname? Which datatype?

Aw: Database error - unknown column

Search in Update
https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html

Example
Component Update 4.14.3 -> 4.15.0

update.sql

alter table `#__jshopping_order_item` add column `category_id` int(11) NOT NULL;

Aw: Database error - unknown column

Thanks again for your quick reply but sorry, it is not that clear. Error is:
Error: 1054 Unknown column 'scriptname' in 'field list'. I asked if I should redo the complete update process (from 4.6.0 - step by step - as I have done) or if there is a more simple solution.
You replied I should add a filter or field (?) 'scriptname' - my question was: to which table. After this you adviced me to go through the list of updates (throught the complete list from 4.6.0 ?) and seek for 'scriptname' in de update.sql file? This would mean: download the complete list of updates from 4.6.0 - unzip and open all update.sql and seek for 'scriptname'? And: should I install this update if I find 'scripname or should I just import or run the update.sql. Isn't it easier to re-run the complete update process? Or did I totally misunderstand your advice?
Hope to hear from you,
kind regards

---

Aw: Database error - unknown column

Went through complete list and searched in update.sql (not in all archives present) and could not find any 'scriptname'.

Aw: Database error - unknown column

Ok, think I solved it - found solution in the install.sql - not in the update.sql - in install.sql I found:
"CREATE TABLE IF NOT EXISTS `#__jshopping_payment_method` (
`payment_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`payment_code` VARCHAR(32) NOT NULL ,
`payment_class` VARCHAR(100) NOT NULL,
`scriptname` VARCHAR(100) NOT NULL,\
......
"
So manually added filed `scriptname` after `payment_class` with data type VARCHAR in table #__jshopping_payment_method and the orders are back. Hope this will help someone else.
Kind regards,
Meindert