Question: I Cannot Enable Product Expiry And Variants

I Cannot Enable Product Expiry And Variants

Hello support, I don't know what's wrong, now I updated to a version 3.4.41 I have a problem when I want to enable product Variants because on previous version this option is already enable

PV

Prom Vongchann

Asked
Hello support,

I don't know what's wrong, now I updated to a version 3.4.41 I have a problem when I want to enable product Variants because on previous version this option is already enabled, but the products when I check it doesn't show variants so I check in setting it was disabled, so I try to change to Enable but it doesn't change.

also for product expiry when I change to enable also doesn't work. I haven't try to change other setting yet but I need those two options to be enabled so I can work on my inventory.

thank you for your support.
  • PV

    Prom Vongchann

    Answered
    **[Mian Saleem](/u/saleem)** I am sorry, I imported. I yeah I did import them all. I mean all the files start with ALL.***** in the folder I already imported.
  • EG

    Enyinnaya Gift

    Answered
    **[Prom Vongchann](/u/prom.vongchann)** There is **NO** major issue reported on this your last log. Is simply complaining about missing `subcategory` language line, which you can fix by adding the line in `sma_lang.php` file located in `app/language/english/admin/sma_lang.php`

    In one of the responses, you said that **you will upload again**, I don't what and what that you uploaded again, hence can you confirm that your error logging is still enabled, then delete previous logs, try again and let us see the error log.
  • PV

    Prom Vongchann

    Answered
    **[Enyinnaya Gift](/u/giftedhands4real)** I mean I will import, sorry I misuse the word upload for import the database.
  • PV

    Prom Vongchann

    Answered
    **[Enyinnaya Gift](/u/giftedhands4real)** here is my new log file. https://we.tl/t-ARjXdobILj
  • MS

    Mian Saleem

    Answered
    Hello,

    I did you run the query?

    ```sql
    ALTER TABLE `sma_settings` ADD `ws_barcode_type` varchar(10) NULL DEFAULT 'weight',
    ADD `ws_barcode_chars` tinyint NULL,
    ADD `flag_chars` tinyint NULL,
    ADD `item_code_start` tinyint NULL,
    ADD `item_code_chars` tinyint NULL,
    ADD `price_start` tinyint NULL,
    ADD `price_chars` tinyint NULL,
    ADD `price_divide_by` int NULL,
    ADD `weight_start` tinyint NULL,
    ADD `weight_chars` tinyint NULL,
    ADD `weight_divide_by` int NULL;
    ```
  • EG

    Enyinnaya Gift

    Answered
    **[Prom Vongchann](/u/prom.vongchann)** Kindly run the Query provided by @**Mian Saleem**. It should resolve the issue.

    Thanks
  • PV

    Prom Vongchann

    Answered
    **[Enyinnaya Gift](/u/giftedhands4real)** before I run I want to verify that, I copy the code above and go in to my phpmyadmin and run these codes on my sql command, correct?
  • EG

    Enyinnaya Gift

    Answered
    **[Prom Vongchann](/u/prom.vongchann)** Yes
  • PV

    Prom Vongchann

    Answered
    **[Enyinnaya Gift](/u/giftedhands4real)** OK. I did it and now I test changing the setting. and I check the logs I see like this : https://we.tl/t-P2G1qfqq2L

    does that means we still have to fix anything?
  • EG

    Enyinnaya Gift

    Answered
    **[Prom Vongchann](/u/prom.vongchann)** No on the SMA, but your host server, Module sqlite3 and fsockopen services.
  • Login to Reply