I am getting the attached error when trying to add a product to a store. Kindly assist
- MSAnswered
Hello,
The error is for the photos, I will fix this and update the error message.
Thank you
- LAnswered
How soon for the update?
- MSAnswered
Hello,
Please download file now and perform update. The product validation errors should be fixed.
Thank you
- LAnswered
I just updated the app, and I am getting another error. Find attached the error.
500: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘features’ in ‘field list’ (Connection: mysql, SQL: insert into
products
(type
,name
,code
,symbology
,category_id
,subcategory_id
,brand_id
,unit_id
,cost
,price
,min_price
,max_price
,max_discount
,features
,details
,featured
,hide_in_pos
,hide_in_shop
,tax_included
,can_edit_price
,has_expiry_date
,dont_track_stock
,alert_quantity
,has_variants
,variants
,has_serials
,noindex
,nofollow
,slug
,company_id
,sku
,updated_at
,created_at
) values (Standard, Front Brake Pads, KDY9-33-28Z, CODE39, 2, 5, 1, 4, 4.5, 15, 15, 20, ?, Front brake pads for Cx5, old and new shape, Atenza and Axela, Front brake pads for Cx5, old and new shape, Atenza and Axela, 0, 0, 0, 0, 0, 0, 0, ?, 0, ?, 0, 0, 0, front-brake-pads, 1, 01k3bn6e56ztg948xk5e64zm92, 2025-08-23 14:26:52, 2025-08-23 14:26:52))Attachments - MSAnswered
Hello,
Please run the following queries after selecting your database.
ALTER TABLE `products` ADD `featured` tinyint(1) DEFAULT NULL; ALTER TABLE `addresses` ADD `default` tinyint(1) DEFAULT NULL;
I recommend, if you can re-install and start again as database migrations were not tracked till beta 2. We will start add migration to the download file from beta 3.
Thank you
- LAnswered
You want me to run about SQL in the database after updating the app with the latest version?
- LAnswered
I am getting the following error when i try to run the above queries in the database
Error SQL query: Copy
ALTER TABLE
products
ADDfeatured
tinyint(1) DEFAULT NULL; MySQL said: Documentation#1146 - Table ‘dailypulse_devautohavendbs.products’ doesn’t exist
- MSAnswered
Hello,
The products table should be there if you have already installed. Please double check that the database id correct.
If you want me to check, please let me know the installation url and server url with login details for both in private reply.
Thank you
- MSAnswered
Hello,
The feature column is already added to the products table. Please check now. If you still have issue, let me know.
Thank you
- MSAnswered
Hello,
There is a product already added for that code. I will update the validation error in the next update. Please try with different code. If you have single store then the products are only shown once they were purchase to have quantity in the store. I will show all the products in the next update.
Thank you
- Login to Reply