(pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES ('2026-08-26 06:22:59', '', 'grid_cbvinvdetails_daily_cheque_bouncing_report_harshit', 'Scriptcase', '192.168.0.21', 'access', '')

(pdo-mysql): select count(*) from (SELECT * FROM ( ( SELECT COUNT(*) AS cnt, SUM(a.InvAmt) AS total, a.SlDivCd, b.LocCd, b.SubLdCd, 0 AS sort_order, 'DETAIL' AS grp ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd, b.LocCd, b.SubLdCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, b.LocCd, NULL, 1, 'LOC_TOTAL',d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd, b.LocCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 2, 'MONTH_START_TO_FROMDATE' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt, c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= DATE_FORMAT('', '%Y-%m-01') AND b.VchDate <= '' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'FROMDATE_TO_TODATE' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt, c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'GRAND_TOTAL' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd ) ) AS summary_data ORDER BY SlDivCd, LocCd, FIELD(grp, 'DETAIL', 'LOC_TOTAL', 'MONTH_START_TO_FROMDATE', 'FROMDATE_TO_TODATE', 'GRAND_TOTAL') ) nm_sel_esp

1146: Table 'yashutilitty.vchd' doesn't exist

            ADOConnection._Execute(select count(*) from (SELECT * FROM (   (     SELECT COUNT(*) AS cnt, SUM(a.InvAmt) AS total, a.SlDivCd, b.LocCd, b.SubLdCd, 0 A..., false) % line 1206, file: adodb.inc.php
         ADOConnection.Execute(select count(*) from (SELECT * FROM (   (     SELECT COUNT(*) AS cnt, SUM(a.InvAmt) AS total, a.SlDivCd, b.LocCd, b.SubLdCd, 0 A...) % line   52, file: grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_total.class.php
      grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_total.quebra_geral_sc_free_total() % line  891, file: grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_grid.class.php
   grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_grid.inicializa() % line  156, file: grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_grid.class.php
grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_grid.monta_grid(0) % line 4196, file: index.php

Warning

Error while accessing the database
Table 'yashutilitty.vchd' doesn't exist
select count(*) from (SELECT * FROM ( ( SELECT COUNT(*) AS cnt, SUM(a.InvAmt) AS total, a.SlDivCd, b.LocCd, b.SubLdCd, 0 AS sort_order, 'DETAIL' AS grp ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd, b.LocCd, b.SubLdCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, b.LocCd, NULL, 1, 'LOC_TOTAL',d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd, b.LocCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 2, 'MONTH_START_TO_FROMDATE' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt, c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= DATE_FORMAT('', '%Y-%m-01') AND b.VchDate <= '' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'FROMDATE_TO_TODATE' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt, c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'GRAND_TOTAL' ,d.City,d.CustName,b.VchId,b.VchDate,b.ChequeNo,b.ChequeDate,a.IGpId,a.InvDt,c.DbCrRsnCd FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN .vchd c ON c.VchId = b.VchId JOIN .custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = '' AND b.VchDate >= '' AND b.VchDate <= '' GROUP BY a.SlDivCd ) ) AS summary_data ORDER BY SlDivCd, LocCd, FIELD(grp, 'DETAIL', 'LOC_TOTAL', 'MONTH_START_TO_FROMDATE', 'FROMDATE_TO_TODATE', 'GRAND_TOTAL') ) nm_sel_esp

Script: /var/www/html/yperputility/grid_cbvinvdetails_daily_cheque_bouncing_report_harshit/grid_cbvinvdetails_daily_cheque_bouncing_report_harshit_total.class.php (54)