ERROR - 2020-07-15 10:16:56 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
 D:\xampp\htdocs\telemarketing\system\database\drivers\mysqli\mysqli_driver.php 201
ERROR - 2020-07-15 10:16:57 --> Unable to connect to the database
ERROR - 2020-07-15 10:17:24 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
 D:\xampp\htdocs\telemarketing\system\database\drivers\mysqli\mysqli_driver.php 201
ERROR - 2020-07-15 10:17:24 --> Unable to connect to the database
ERROR - 2020-07-15 10:17:28 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
 D:\xampp\htdocs\telemarketing\system\database\drivers\mysqli\mysqli_driver.php 201
ERROR - 2020-07-15 10:17:28 --> Unable to connect to the database
ERROR - 2020-07-15 10:18:10 --> Severity: Notice --> Trying to get property 'master_password' of non-object D:\xampp\htdocs\telemarketing\application\libraries\Fx.php 91
ERROR - 2020-07-15 11:48:57 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 11:48:57 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 11:49:57 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 11:49:58 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 11:51:04 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 11:51:04 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 12:01:33 --> Query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHEN t.status_type=7 THEN 'Cancelled' ELSE '', WHEN t.status_type=8 THEN 'RTO' E' at line 2 - Invalid query: SELECT `t`.*, CASE WHEN t.status=1 THEN 'Active' ELSE 'Inactive' END as status, CASE WHEN t.order_editable=1 THEN 'Yes' ELSE 'No' END as order_editable, CASE WHEN t.mark_as_default_complete=1 THEN 'Mark As Initial' WHEN t.mark_as_default_complete=2 THEN 'Mark As Completed' ELSE '' END as  mark_as_default_complete, CASE WHEN t.status_type=1 THEN 'Invoice' WHEN t.status_type=2 THEN 'Dispatch'  WHEN t.status_type=3 THEN 'Payment' WHEN t.status_type=4 THEN 'Delivery' WHEN t.status_type=5 THEN 'Hold' WHEN t.status_type=6 THEN 'Item Verify' ELSE ''
		WHEN t.status_type=7 THEN 'Cancelled' ELSE '', WHEN t.status_type=8 THEN 'RTO' ELSE '', WHEN t.status_type=9 THEN 'Multi Action' ELSE ''		
		END  as status_type
FROM `tel_order_status` as `t`
WHERE  1=1
ORDER BY `t`.`id` DESC
 LIMIT 10
ERROR - 2020-07-15 12:42:41 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 12:42:41 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 12:43:42 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 12:43:42 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 12:47:18 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 12:47:18 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 12:49:32 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 12:49:32 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 12:49:46 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 12:49:46 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 13:10:47 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 13:10:47 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 13:44:39 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 13:44:39 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 13:46:27 --> Severity: Notice --> Trying to get property 'master_password' of non-object D:\xampp\htdocs\telemarketing\application\libraries\Fx.php 91
ERROR - 2020-07-15 17:53:05 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 17:58:06 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 17:58:13 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 17:58:13 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 17:59:03 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 17:59:15 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 17:59:31 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:00:14 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:00:14 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:00:37 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:00:37 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:00:38 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:00:47 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:00:59 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:01:14 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:01:14 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:01:52 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:01:52 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:02:40 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:02:40 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:17:07 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:17:20 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\order_list.php 34
ERROR - 2020-07-15 18:17:45 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:36:22 --> Query error: Unknown column 'st.status_name' in 'field list' - Invalid query: SELECT COUNT(*) AS `numrows`
FROM (
SELECT `t`.`id` AS `order_id`, `customer_order_id`, `customer_detail`, `customer_address`, date_format(booking_time, '%d-%m-%Y') as booking_date, `gross_amt`, `discount_amt`, `round_off_amt`, `net_amt`, `tax_amt`, SUM(IF(tax_name='CGST', `tax_amount`, 0)) AS 'CGST', SUM(IF(tax_name='IGST', `tax_amount`, 0)) AS 'IGST', SUM(IF(tax_name='NO GST', `tax_amount`, 0)) AS 'NO GST', SUM(IF(tax_name='SGST', `tax_amount`, 0)) AS 'SGST', `total_tax_per`, `st`.`state_name`, `t`.`invoice_number`, `st`.`status_name`, `c`.`customer_name`, `c`.`mobile_number`, date_format(payment_date, '%d-%m-%Y') as payment_date, date_format(rto_date, '%d-%m-%Y') as rto_date
FROM `tel_order_master` as `t`
LEFT JOIN `tel_customer_master` as `c` ON `c`.`id`=`t`.`customer_id`
LEFT JOIN `tel_order_status` as `s` ON `s`.`id`=`t`.`current_order_status`
LEFT JOIN `tel_branch_master` as `b` ON `t`.`branch_id`=`b`.`branch_id`
LEFT JOIN `tel_customer_address_master` as `a` ON `a`.`id`=`t`.`address_id`
LEFT JOIN `tel_location_pincode` as `p` ON `p`.`pincode`=`a`.`address_pincode` and `p`.`city_id`=`a`.`address_city_id`
LEFT JOIN `tel_location_state` as `st` ON `st`.`id`=`a`.`address_state_id`
LEFT JOIN `tel_order_taxlist` as `tx` ON `tx`.`order_id`=`t`.`id`
JOIN (select order_id,sum(tax_percentage) total_tax_per from (SELECT DISTINCT order_id,tax_id,tax_percentage FROM tel_order_taxlist 
GROUP BY tax_id,tax_percentage,order_id) t10 group by order_id) as t_tax ON `t_tax`.`order_id`=`t`.`id`
WHERE  1=1 and t.branch_id='1' and (t.invoice_date is not null and t.invoice_date!='')
GROUP BY `t`.`id`, `customer_order_id`, `customer_detail`, `customer_address`, `booking_date`, `gross_amt`, `discount_amt`, `round_off_amt`, `net_amt`, `tax_amt`, `total_tax_per`, `st`.`state_name`, `t`.`invoice_number`, `st`.`status_name`, `c`.`customer_name`, `c`.`mobile_number`, `payment_date`, `rto_date`
) CI_count_all_results
ERROR - 2020-07-15 18:38:27 --> Query error: Unknown column 't10.courier_name' in 'field list' - Invalid query: SELECT COUNT(*) AS `numrows`
FROM (
SELECT `t`.`id` AS `order_id`, `customer_order_id`, `customer_detail`, `customer_address`, date_format(booking_time, '%d-%m-%Y') as booking_date, `gross_amt`, `discount_amt`, `round_off_amt`, `net_amt`, `tax_amt`, SUM(IF(tax_name='CGST', `tax_amount`, 0)) AS 'CGST', SUM(IF(tax_name='IGST', `tax_amount`, 0)) AS 'IGST', SUM(IF(tax_name='NO GST', `tax_amount`, 0)) AS 'NO GST', SUM(IF(tax_name='SGST', `tax_amount`, 0)) AS 'SGST', `total_tax_per`, `st`.`state_name`, `t`.`invoice_number`, `s`.`status_name`, `c`.`customer_name`, `c`.`mobile_number`, date_format(payment_date, '%d-%m-%Y') as payment_date, date_format(rto_date, '%d-%m-%Y') as rto_date, `t10`.`courier_name`
FROM `tel_order_master` as `t`
LEFT JOIN `tel_customer_master` as `c` ON `c`.`id`=`t`.`customer_id`
LEFT JOIN `tel_order_courier` as `t10` ON `t`.`courier_id`=`t10`.`id`
LEFT JOIN `tel_order_status` as `s` ON `s`.`id`=`t`.`current_order_status`
LEFT JOIN `tel_branch_master` as `b` ON `t`.`branch_id`=`b`.`branch_id`
LEFT JOIN `tel_customer_address_master` as `a` ON `a`.`id`=`t`.`address_id`
LEFT JOIN `tel_location_pincode` as `p` ON `p`.`pincode`=`a`.`address_pincode` and `p`.`city_id`=`a`.`address_city_id`
LEFT JOIN `tel_location_state` as `st` ON `st`.`id`=`a`.`address_state_id`
LEFT JOIN `tel_order_taxlist` as `tx` ON `tx`.`order_id`=`t`.`id`
JOIN (select order_id,sum(tax_percentage) total_tax_per from (SELECT DISTINCT order_id,tax_id,tax_percentage FROM tel_order_taxlist 
GROUP BY tax_id,tax_percentage,order_id) t10 group by order_id) as t_tax ON `t_tax`.`order_id`=`t`.`id`
WHERE  1=1 and t.branch_id='1' and (t.invoice_date is not null and t.invoice_date!='')
GROUP BY `t`.`id`, `customer_order_id`, `customer_detail`, `customer_address`, `booking_date`, `gross_amt`, `discount_amt`, `round_off_amt`, `net_amt`, `tax_amt`, `total_tax_per`, `st`.`state_name`, `t`.`invoice_number`, `s`.`status_name`, `c`.`customer_name`, `c`.`mobile_number`, `payment_date`, `rto_date`, `t10`.`courier_name`
) CI_count_all_results
ERROR - 2020-07-15 18:39:41 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:39:41 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:39:43 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 18:39:44 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 18:39:44 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 18:54:24 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:02:08 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:03:57 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:04:36 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:05:13 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:06:04 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:06:19 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:06:24 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:06:41 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:07:05 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:07:13 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:07:22 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:10:00 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:10:05 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:10:28 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:10:42 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:10:49 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:10:52 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:11:33 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:12:17 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1049
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1051
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1053
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1055
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1059
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1063
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: dataList D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1069
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Trying to get property 'data' of non-object D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1069
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: dataList D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1071
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Trying to get property 'count' of non-object D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1071
ERROR - 2020-07-15 19:12:19 --> Severity: Notice --> Undefined variable: report_by D:\xampp\htdocs\telemarketing\application\controllers\Report.php 1077
ERROR - 2020-07-15 19:12:36 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:12:52 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:13:06 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:13:11 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:13:11 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:13:31 --> Severity: Warning --> Division by zero D:\xampp\htdocs\telemarketing\application\libraries\Html.php 60
ERROR - 2020-07-15 19:14:34 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:14:42 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:14:42 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:15:23 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:15:23 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:15:23 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:15:38 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:15:44 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:15:44 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:17:17 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:17:17 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:17:17 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:18:53 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:18:53 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:18:54 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:19:36 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:19:37 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:19:37 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:20:07 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:20:27 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:21:51 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:22:03 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:22:22 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:22:35 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:22:57 --> 404 Page Not Found: Html/js
ERROR - 2020-07-15 19:22:57 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:28:08 --> Severity: Notice --> Undefined variable: customer_type D:\xampp\htdocs\telemarketing\application\views\report\gst_report.php 36
ERROR - 2020-07-15 19:28:08 --> 404 Page Not Found: Html/css
ERROR - 2020-07-15 19:28:08 --> 404 Page Not Found: Html/js
