Adding Product To A Store

0

I am getting the attached error when trying to add a product to a store. Kindly assist

Question Unresolved For: Stock Manager Advance with All Modules 0 Votes 9 Answers 67 Views
Asked by Lucky 1 week ago

0

Answered by Mian Saleem 1 week ago

Hello,

The error is for the photos, I will fix this and update the error message.

Thank you

0

Answered by Lucky 1 week ago

How soon for the update?

0

Answered by Mian Saleem 6 days ago

Hello,

Please download file now and perform update. The product validation errors should be fixed.

Thank you

0

Answered by Lucky 6 days ago

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))

0

Answered by Mian Saleem 5 days ago

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

0

Answered by Lucky 5 days ago

You want me to run about SQL in the database after updating the app with the latest version?

0

Answered by Lucky 5 days ago

I am getting the following error when i try to run the above queries in the database

Error
SQL query: Copy

ALTER TABLE products ADD featured tinyint(1) DEFAULT NULL;
MySQL said: Documentation

#1146 - Table 'dailypulse_devautohavendbs.products' doesn't exist

0

Answered by Mian Saleem 4 days ago

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

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.