Question: Add Products To Sales

Add Products To Sales

When I open a new invoice and enter the product there, a blue loop constantly returns and no product is added.

M

Mustafa

Asked

When I open a new invoice and enter the product there, a blue loop constantly returns and no product is added.

  • MS

    Mian Saleem

    Answered

    Hello,

    Please check your server error logs and let me know the error details so that I can suggest.

    If you are not sure about server then you can enable app logs by modify the app/config/config.php and set log_threshold to 1. After that perform action again to produce errors and lastly check the latest log file in the app/logs/ folder.

    Thank you

  • M

    Mustafa

    Answered

    log files cant be attached.

    ERROR - 2024-09-26 15:52:28 --> Could not find the language line “shop” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “toggle_alignment” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “add_adjustment” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “stock_counts” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “count_stock” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “list_expenses” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “returns” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “list_returns” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “add_return” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “promos” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “list_printers” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “add_printer” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “price_groups” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “expense_categories” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “units” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “brands” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “site_logs” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “best_sellers” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “adjustments_report” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “brands_report” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “returns_report” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “tax_report” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “daily_purchases” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “monthly_purchases” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “expenses_report” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “front_end” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “shop_settings” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “slider_settings” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “api_keys” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “list_pages” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “add_page” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “sms_settings” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “send_sms” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “sms_log” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “best_sellers” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “best_sellers” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “download” ERROR - 2024-09-26 15:52:28 --> Could not find the language line “required_invalid” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “shop” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “toggle_alignment” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “add_adjustment” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “stock_counts” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “count_stock” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “list_expenses” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “list_returns” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “add_return” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “promos” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “list_printers” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “add_printer” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “price_groups” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “expense_categories” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “units” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “brands” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “site_logs” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “best_sellers” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “adjustments_report” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “brands_report” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “returns_report” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “tax_report” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “daily_purchases” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “monthly_purchases” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “expenses_report” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “front_end” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “shop_settings” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “slider_settings” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “api_keys” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “list_pages” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “add_page” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “sms_settings” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “send_sms” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “sms_log” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “brand” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “set_avg_cost” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “brand” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “download” ERROR - 2024-09-26 15:52:34 --> Could not find the language line “required_invalid” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “shop” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “toggle_alignment” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “add_adjustment” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “stock_counts” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “count_stock” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “list_expenses” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “returns” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “list_returns” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “add_return” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “promos” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “list_printers” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “add_printer” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “price_groups” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “expense_categories” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “units” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “brands” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “site_logs” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “best_sellers” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “adjustments_report” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “brands_report” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “returns_report” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “tax_report” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “daily_purchases” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “monthly_purchases” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “expenses_report” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “front_end” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “shop_settings” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “slider_settings” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “api_keys” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “list_pages” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “add_page” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “sms_settings” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “send_sms” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “sms_log” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “attachments” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “adjust_subtotal” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “nearest_subtotal” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “download” ERROR - 2024-09-26 15:52:41 --> Could not find the language line “required_invalid” ERROR - 2024-09-26 15:52:45 --> Severity: Warning --> Undefined property: stdClass::$ws_barcode_chars /home/.sites/437/site5064964/web/neu/app/libraries/Sma.php 355 ERROR - 2024-09-26 15:52:45 --> Query error: Unknown column ‘base_unit_cost’ in ‘field list’ - Invalid query: SELECT id, purchase_id, product_name, transfer_id, quantity, quantity_balance, net_unit_cost, unit_cost, item_tax, base_unit_cost FROM sma_purchase_items WHERE product_id = ‘46’ AND warehouse_id = ‘1’ AND quantity_balance != 0 AND option_id = ‘237’ AND ( status = ‘received’ OR status = ‘partial’ ) GROUP BY id ORDER BY date ASC, purchase_id ASC ERROR - 2024-09-26 15:52:45 --> Severity: error --> Exception: Call to a member function num_rows() on false /home/.sites/437/site5064964/web/neu/app/models/Site.php 655 ERROR - 2024-09-26 15:53:02 --> Severity: Warning --> Undefined property: stdClass::$ws_barcode_chars /home/.sites/437/site5064964/web/neu/app/libraries/Sma.php 355

  • M

    Mustafa

    Answered

    i have already fix it, problem at theline No. 655 on the “base_unit_cost”.

  • MS

    Mian Saleem

    Answered

    Hello,

    Is it new installation or you updated from old version? If updated then did you update the database as mention in step 8?

  • Login to Reply