CW
Asked
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.
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.
Attachments
- MSAnsweredHello,
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_threshold` to 1 in `app/config/config.php` and then visit the page again to reproduce errors. Lastly check the latest log file in `app/logs/` folder.
POS Promo only have option for `buy 1 get 1`
Thank you - CWAnsweredHello 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 - MSAnsweredHello,
Please check your `sma_purchase_items` table. There are some rows without `base_unit_cost`, `unit_cost` and `quantity` that is causing the issue.
```txt
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 - NSAnsweredI 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](/u/naveedsid)** Hello,
Please ask new question with your version number and if it's update or new installation?
Thank you - NSAnsweredi 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](/u/naveedsid)** Please ask question as we will need some details of your installation. Thank you