Pos Sale Submition Get Blank After Submit

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.?

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 10 Answers 22.6k Views
Asked by Asanka Ekanayake 2 years ago

0

Answered by Mian Saleem 2 years ago

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

Answered by Asanka Ekanayake 2 years ago

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

Answered by Mian Saleem 2 years ago

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

Answered by Asanka Ekanayake 2 years ago

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

Answered by Mian Saleem 2 years ago

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

Answered by Asanka Ekanayake 2 years ago

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

Answered by Mian Saleem 2 years ago

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

Answered by Asanka Ekanayake 2 years ago

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

Answered by Mian Saleem 2 years ago

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.