AA
Asked
thank you
i have other issue after i installed on pose screen when i click the payment button system will not do any thing it displays blank page
please help for this issue
i have other issue after i installed on pose screen when i click the payment button system will not do any thing it displays blank page
please help for this issue
- MSAnsweredHello,
Please check server error log and let me know the error details so that I can suggest.
Thank you - AAAnsweredhello thank you for your response , i am not getting any server error on pose screen when i tray to make payment and fish this sale system will direct men on this url(""http://shop.globalsts.net/admin/pos) where your demo one direct me on this ("https://sma.tecdiary.net/admin/pos/view/5"") and shows me print page
- MSAnsweredHello,
I am not sure what is causing the issue. Did you check your server error logs?
If you need to enable app logs you can change `log_threshold` to 1 in `app/config/config.php` and the perform action again to reproduce error. Lastly check the latest log file in `app/logs/` folder.
For the after sale page, please check your post settings.
Thank you - AAAnsweredthank you sir i have enabled app logs and now i see this error from server log error
I see the error on the query we are sending purchase_id but the database column is sale_id that is the issue let me confirm if i change this sale_id to a purchase_id would it effect other sides ?
ERROR - 2020-07-29 11:55:21 --> Query error: Unknown column 'purchase_id' 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 ('2020-07-29', '65', 732, NULL, '71', '1', '25.0000', '25.0000', '40.00', '40.00', 14, 1, NULL, 366)
ERROR - 2020-07-29 11:55:21 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
thank you - MSAnsweredHello,
I have checked the database, sma_costing table has the purchase_id column. When did you install the item?
Please try to run the query below after selecting your database
```
ALTER TABLE `sma_costing` ADD COLUMN `purchase_id` int NULL;
```
It should add the column.
Thank you - AAAnsweredthank you Eng Now is working but i want to know if you made changes all other tables to avoid other errors
- MSAnsweredHello,
**What other errors are you having?**
If you follow the install/update instructions the change will be applied.
Thank you - Login to Reply