Question: Adding Product To A Store

Adding Product To A Store

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

L

Lucky

Asked

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

  • MS

    Mian Saleem

    Answered

    Hello,

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

    Thank you

  • L

    Lucky

    Answered

    How soon for the update?

  • MS

    Mian Saleem

    Answered

    Hello,

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

    Thank you

  • L

    Lucky

    Answered

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

  • MS

    Mian Saleem

    Answered

    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

  • L

    Lucky

    Answered

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

  • L

    Lucky

    Answered

    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

  • MS

    Mian Saleem

    Answered

    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

  • MS

    Mian Saleem

    Answered

    Hello,

    The feature column is already added to the products table. Please check now. If you still have issue, let me know.

    Thank you

  • MS

    Mian Saleem

    Answered

    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