Question: Error When Changing Version

Error When Changing Version

I updated the SMA version to 3.5.2 and when updating a field in settings it does not save the changes, nor does it load the products in the POS when making a sale. I checked the error log a

MS

Michael Salcedo

Asked

I updated the SMA version to 3.5.2 and when updating a field in settings it does not save the changes, nor does it load the products in the POS when making a sale. I checked the error log and found this

ERROR - 2023-11-29 21:59:50 --> Could not find the language line “today” ERROR - 2023-11-29 21:59:50 --> Could not find the language line “display_all_products” ERROR - 2023-11-29 21:59:50 --> Query error: Unknown column ‘ws_barcode_type’ in ‘field list’ - Invalid query: UPDATE sma_settings SET site_name = ‘DROGUERIA Y VARIEDADES’, rows_per_page = ‘25’, dateformat = ‘5’, timezone = ‘America/Bogota’, mmode = ‘0’, iwidth = ‘800’, iheight = ‘800’, twidth = ‘150’, theight = ‘150’, watermark = ‘0’, accounting_method = ‘0’, default_email = ‘[email protected]’, language = ‘spanish’, default_warehouse = ‘1’, default_tax_rate = ‘1’, default_tax_rate2 = ‘4’, sales_prefix = ‘VENTA’, quote_prefix = ‘COTIZ’, purchase_prefix = ‘CP’, transfer_prefix = ‘TR’, delivery_prefix = ‘DP’, payment_prefix = ‘RPG’, ppayment_prefix = ‘PAG’, qa_prefix = ‘’, return_prefix = ‘DEVOL’, returnp_prefix = ‘DN’, expense_prefix = ‘GAS’, auto_detect_barcode = ‘1’, theme = ‘default’, product_serial = ‘0’, customer_group = ‘1’, product_expiry = ‘1’, product_discount = ‘1’, default_currency = ‘PES’, bc_fix = ‘4’, tax1 = 1, tax2 = 1, overselling = ‘0’, reference_format = ‘3’, racks = ‘0’, attributes = ‘0’, restrict_calendar = ‘0’, captcha = ‘0’, item_addition = ‘1’, protocol = ‘mail’, mailpath = ‘/usr/sbin/sendmail’, smtp_host = ‘pop.gmail.com’, smtp_user = ‘[email protected]’, smtp_port = ‘25’, smtp_crypto = NULL, decimals = ‘2’, decimals_sep = ‘.’, thousands_sep = ‘,’, default_biller = ‘4’, invoice_view = ‘0’, rtl = ‘0’, each_spent = NULL, ca_point = NULL, each_sale = NULL, sa_point = NULL, sac = ‘0’, qty_decimals = ‘2’, display_all_products = ‘0’, display_symbol = ‘0’, symbol = ‘$’, remove_expired = ‘0’, barcode_separator = ‘-’, set_focus = ‘0’, disable_editing = ‘90’, price_group = ‘1’, barcode_img = ‘1’, update_cost = ‘1’, apis = NULL, pdf_lib = ‘dompdf’, state = ‘AN’, use_code_for_slug = ‘0’, ws_barcode_type = ‘weight’, ws_barcode_chars = ‘’, flag_chars = ‘’, item_code_start = ‘’, item_code_chars = ‘’, price_start = ‘’, price_chars = ‘’, price_divide_by = ‘’, weight_start = ‘’, weight_chars = ‘’, weight_divide_by = ‘’, ksa_qrcode = ‘0’, smtp_pass = ‘12345678’ WHERE setting_id = ‘1’ ERROR - 2023-11-29 21:59:50 --> Could not find the language line “toggle_alignment” ERROR - 2023-11-29 21:59:50 --> Could not find the language line “quantity_alerts” ERROR - 2023-11-

I want to know how I can solve that, could you guide me to the solution?

  • MS

    Mian Saleem

    Answered

    Hello,

    Did you update the database as mentioned in the step 8?

    The column ws_barcode_type was added in the v3.4.38 You need to import all the database updates to your database starting from the version you updated from.

    Thank you

  • Login to Reply