0
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
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
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?
0
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
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.