Hello, Since yesterday, the application has been giving me trouble. 1: At pos, when you click submit to process payment and prints receipt,it will show loading for a long while then the screen goes white. if you refresh the page and try submitting it again, same thing happens. Problem is the number of times you try refreshing, it will record all the attempts as sells with payment “due” by them.
2: Other times am looking for a pos sales invoice or receipt and it will come up with “Ajax Call Failled”
3: How does the promo feature woeks? Is it possible to order10% reduction in prices as a promo to affect all or limited products?
Note: I have backed up database and files from Cpanel, deleted old database from phpMyAdmin, created new one and did new installation. After, restored the backup files today and after a while, the issue came up again.
- MSAnswered
Hello,
Is there any change on server? You can’t restore old version of database to new versions.
Please check your php error logs and let me know the error details so that I can suggest.
If you are not sure about php error logs, you can enable app logs by changing the
log_thresholdto 1 inapp/config/config.phpand then visit the page again to reproduce errors. Lastly check the latest log file inapp/logs/folder.POS Promo only have option for
buy 1 get 1Thank you
- CWAnswered
Hello Mian, Is the same version of the application 3.4.42 . when the issue started, i thought it could be due to some configuration problem so when i couldn’t get my hands around it, i backup files, deleted old installation and reinstall fresh application… same version and just restored backup files. Kindly checked attached file as the sever logs. I will be glad if you can respond to this issues for ASAP. Counting on your urgent assistance.
Attachments - MSAnswered
Hello,
Please check your
sma_purchase_itemstable. There are some rows withoutbase_unit_cost,unit_costandquantitythat is causing the issue.Query error: Unknown column 'NAN' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `purchase_item_id`, `quantity`, `purchase_net_unit_cost`, `purchase_unit_cost`, `sale_net_unit_price`, `sale_unit_price`, `quantity_balance`, `inventory`, `option_id`, `sale_id`) VALUES ('2021-03-07', '1616', 681, NULL, '3038', '10', '0.0000', NAN, '1.00', '1.00', 1346, 1, NULL, 210)Thank you
- NSAnswered
I have same issue although my screen goes white after loading on POS > payment > After pressing submit button my error log is here. please help me out…
Attachments - MSAnswered
Naveed Siddiqui Hello,
Please ask new question with your version number and if it’s update or new installation?
Thank you
- NSAnswered
i have installed 3.4.42, so can i fix it without updating it… plz let me know. i dont want to update some how. if you can help me with this version.
- MSAnswered
Naveed Siddiqui Please ask question as we will need some details of your installation. Thank you