I am getting the attached error when trying to add a product to a store. Kindly assist
- MSAnsweredHello, The error is for the photos, I will fix this and update the error message. Thank you 
- LAnsweredHow soon for the update? 
- MSAnsweredHello, Please download file now and perform update. The product validation errors should be fixed. Thank you 
- LAnsweredI 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
- MSAnsweredHello, 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 
- LAnsweredYou want me to run about SQL in the database after updating the app with the latest version? 
- LAnsweredI am getting the following error when i try to run the above queries in the database Error SQL query: Copy ALTER TABLE productsADDfeaturedtinyint(1) DEFAULT NULL; MySQL said: Documentation#1146 - Table ‘dailypulse_devautohavendbs.products’ doesn’t exist 
- MSAnsweredHello, 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 
- MSAnsweredHello, The feature column is already added to the products table. Please check now. If you still have issue, let me know. Thank you 
- MSAnsweredHello, 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