0
Hi Milan,
I have raised this issue sometimes back also, But it has not resolved yet. Once submit the POS sale nothing reflect except blank screen. even that sale is not recorded in system . cannot see any error log even. Any reason for this.?
0
Hello,
If you have already asked the question before then you should follow up there.
You need to check your server error logs and let know the erorr details so that I can suggest.
Thank you
0
Hi Milan, Apologies as i couldn't follow up , I'm using 2 tecdiary systems in same server. But this issue is having only for one system. in the same time i can submit POS sale for one system but other system show blank screen once submit the POS sale. Do you really think this can be a server error. I have sent you my user details ( as a staff only msg), Any possibility log and check this?
0
Hello,
I am not sure but just suspecting it's something with server config. The error details in server error logs should have the exact reason.
I can't check it from installation.
Thank you
0
Hi Milan,
Please find below error log details.
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
ERROR - 2021-09-14 06:03:47 --> Could not find the language line "subcategory"
ERROR - 2021-09-14 07:33:47 --> Could not find the language line "subcategory"
ERROR - 2021-09-14 13:22:03 --> Query error: Column 'biller' cannot be null - Invalid query: INSERT INTO `sma_sales` (`date`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `total_items`, `sale_status`, `payment_status`, `payment_term`, `rounding`, `suspend_note`, `pos`, `paid`, `created_by`, `hash`, `reference_no`) VALUES ('2021-09-14 13:22:03', '1', 'Walk-in Customer', '3', NULL, '1', '', '', 2000, 0, '', 0, '0.0000', 0, '0', 0, '0.0000', '0.00', '2000.0000', '1', 'completed', 'due', 0, 0, NULL, 1, 0, '2', 'c2582a30d75f12c068f38fa622dc2e67fe299e2c2209fefdb1d51c52df90f22b', 'SALE/POS2021/09/0001')
ERROR - 2021-09-14 13:22:03 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:22:10 --> Query error: Column 'biller' cannot be null - Invalid query: INSERT INTO `sma_sales` (`date`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `total_items`, `sale_status`, `payment_status`, `payment_term`, `rounding`, `suspend_note`, `pos`, `paid`, `created_by`, `hash`, `reference_no`) VALUES ('2021-09-14 13:22:10', '1', 'Walk-in Customer', '3', NULL, '1', '', '', 2000, 0, '', 0, '0.0000', 0, '0', 0, '0.0000', '0.00', '2000.0000', '1', 'completed', 'due', 0, 0, NULL, 1, 0, '2', '7f9e1e6e5b25541a554e02511c5ff25b29f59a9296add6390b399cb5d9e4b7ff', 'SALE/POS2021/09/0001')
ERROR - 2021-09-14 13:22:10 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:22:52 --> Query error: Column 'biller' cannot be null - Invalid query: INSERT INTO `sma_sales` (`date`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `total_items`, `sale_status`, `payment_status`, `payment_term`, `rounding`, `suspend_note`, `pos`, `paid`, `created_by`, `hash`, `reference_no`) VALUES ('2021-09-14 13:22:52', '1', 'Walk-in Customer', '3', NULL, '1', '', '', 3000, 0, '', 0, '0.0000', 0, '0', 0, '0.0000', '0.00', '3000.0000', '1', 'completed', 'due', 0, 0, NULL, 1, 0, '2', '4294c3396c20e5fe9024793e998cf69c8292c763c9c44e77e5200402ab0437e8', 'SALE/POS2021/09/0001')
ERROR - 2021-09-14 13:22:52 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:24:06 --> Query error: Column 'biller' cannot be null - Invalid query: INSERT INTO `sma_sales` (`date`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `total_items`, `sale_status`, `payment_status`, `payment_term`, `rounding`, `suspend_note`, `pos`, `paid`, `created_by`, `hash`, `reference_no`) VALUES ('2021-09-14 13:24:06', '1', 'Walk-in Customer', '3', NULL, '1', '', '', 2000, 0, '', 0, '0.0000', 0, '0', 0, '0.0000', '0.00', '2000.0000', '1', 'completed', 'due', 0, 0, NULL, 1, 0, '2', '573d513d9d09f3ab0fe9cee50bfe10ec97925b6a29965bcbd4db7eceab17acbb', 'SALE/POS2021/09/0001')
ERROR - 2021-09-14 13:24:06 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:24:12 --> Query error: Column 'biller' cannot be null - Invalid query: INSERT INTO `sma_sales` (`date`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `total_items`, `sale_status`, `payment_status`, `payment_term`, `rounding`, `suspend_note`, `pos`, `paid`, `created_by`, `hash`, `reference_no`) VALUES ('2021-09-14 13:24:12', '1', 'Walk-in Customer', '3', NULL, '1', '', '', 2000, 0, '', 0, '0.0000', 0, '0', 0, '0.0000', '0.00', '2000.0000', '1', 'completed', 'due', 0, 0, NULL, 1, 0, '2', '29df6b5ddae938941334c3d27f440b84c1d7400619d84772a30ee03f8164c84a', 'SALE/POS2021/09/0001')
ERROR - 2021-09-14 13:24:12 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:30:47 --> Query error: Unknown column 'transfer_id' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `transfer_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-09-14', '12', 27, '2', NULL, '21', '1', '1000.0000', 1000, '2000.00', '2000.00', 8, 1, NULL, 22)
ERROR - 2021-09-14 13:30:47 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 13:30:54 --> Query error: Unknown column 'transfer_id' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `transfer_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-09-14', '12', 28, '2', NULL, '21', '1', '1000.0000', 1000, '2000.00', '2000.00', 8, 1, NULL, 23)
ERROR - 2021-09-14 13:30:54 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
ERROR - 2021-09-14 19:48:38 --> Query error: Unknown column 'transfer_id' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `transfer_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-09-14', '3', 29, '1', NULL, '17', '1', '1750.0000', 1750, '3000.00', '3000.00', 1, 1, NULL, 24)
ERROR - 2021-09-14 19:48:38 --> An errors has been occurred while adding the sale (Add:Pos_model.php)
0
Hello,
Please try to save the billers again. Looks like your database is not up to date too. The step 8 in update instruction is for the database changes. If you have updated from previous versions, please import the sql files too.
Thank you
0
Hi Milan,
I checked with my developer again regarding the step 8 in latest version update ( Please import files/db_updates/POS files too, if you have purchased SMA with POS) But he advised me that there is no any file name "POS" in db_updates. Please find the attached screen shot also. He has used the latest file which is downloaded from codecanyon.net for the version update. Kindly advise this further ? Thank you.
0
Hello,
You have SMA with All modules and it will only have All.x.x.xx.sql
file with all changes.
Just a though, you can't restore old backup to the latest version. Those will cause such issue too. You only can import contents.
Thank you
0
Hi Milan,
As you mentioned above, we cant restore old back up to the latest version. Then what about if we have a large data base of back up in our previous version ( Sales, purchase, products. customer / supplier details etc) . How we can export our old data to system once update latest version. If we cant restore back up, I think its a big issue ? Kindly clarify.
0
Hello,
You can export the contents only and import to new database.
Full backup will change the schema too while contents will only backup the data. You can check with your server admin/host or google to know more.
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.