[24-Dec-2025 14:05:08 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pa.days_to_expiry' in 'field list' in /home/ebatekor/public_html/pharmacy/modules/dashboard.php:170
Stack trace:
#0 /home/ebatekor/public_html/pharmacy/modules/dashboard.php(170): PDO->prepare('SELECT \r\n      ...')
#1 {main}
  thrown in /home/ebatekor/public_html/pharmacy/modules/dashboard.php on line 170
[24-Dec-2025 14:05:28 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pa.days_to_expiry' in 'field list' in /home/ebatekor/public_html/pharmacy/modules/dashboard.php:170
Stack trace:
#0 /home/ebatekor/public_html/pharmacy/modules/dashboard.php(170): PDO->prepare('SELECT \r\n      ...')
#1 {main}
  thrown in /home/ebatekor/public_html/pharmacy/modules/dashboard.php on line 170
[24-Dec-2025 14:05:47 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pa.days_to_expiry' in 'field list' in /home/ebatekor/public_html/pharmacy/modules/dashboard.php:170
Stack trace:
#0 /home/ebatekor/public_html/pharmacy/modules/dashboard.php(170): PDO->prepare('SELECT \r\n      ...')
#1 {main}
  thrown in /home/ebatekor/public_html/pharmacy/modules/dashboard.php on line 170
[21-Jan-2026 21:28:13 UTC] Dashboard Stats for shop 1:
[21-Jan-2026 21:28:13 UTC] - Total Stock Units: 6364
[21-Jan-2026 21:28:13 UTC] - Purchased Units: 17194
[21-Jan-2026 21:28:13 UTC] - Sold Units: 10830
[21-Jan-2026 21:28:13 UTC] - Purchases Today: 0
[21-Jan-2026 21:28:13 UTC] - Purchases This Month: 1858405.6
[21-Jan-2026 21:28:13 UTC] - Active Batches: 22
[21-Jan-2026 21:28:13 UTC] - Unique Products: 10
[21-Jan-2026 21:29:33 UTC] Dashboard Stats for shop 1:
[21-Jan-2026 21:29:33 UTC] - Total Stock Units: 6364
[21-Jan-2026 21:29:33 UTC] - Purchased Units: 17194
[21-Jan-2026 21:29:33 UTC] - Sold Units: 10830
[21-Jan-2026 21:29:33 UTC] - Purchases Today: 0
[21-Jan-2026 21:29:33 UTC] - Purchases This Month: 1858405.6
[21-Jan-2026 21:29:33 UTC] - Active Batches: 22
[21-Jan-2026 21:29:33 UTC] - Unique Products: 10
[21-Jan-2026 21:30:51 UTC] Dashboard Stats for shop 1:
[21-Jan-2026 21:30:51 UTC] - Total Stock Units: 6365
[21-Jan-2026 21:30:51 UTC] - Purchased Units: 17195
[21-Jan-2026 21:30:51 UTC] - Sold Units: 10830
[21-Jan-2026 21:30:51 UTC] - Purchases Today: 1800
[21-Jan-2026 21:30:51 UTC] - Purchases This Month: 1860205.6
[21-Jan-2026 21:30:51 UTC] - Active Batches: 23
[21-Jan-2026 21:30:51 UTC] - Unique Products: 10
[21-Jan-2026 21:31:21 UTC] PHP Deprecated:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/ebatekor/public_html/pharmacy/modules/sales_view.php on line 310
[21-Jan-2026 21:31:21 UTC] PHP Deprecated:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/ebatekor/public_html/pharmacy/modules/sales_view.php on line 314
[21-Jan-2026 21:36:47 UTC] Dashboard Stats for shop 1:
[21-Jan-2026 21:36:47 UTC] - Total Stock Units: 6365
[21-Jan-2026 21:36:47 UTC] - Purchased Units: 17195
[21-Jan-2026 21:36:47 UTC] - Sold Units: 10830
[21-Jan-2026 21:36:47 UTC] - Purchases Today: 1800
[21-Jan-2026 21:36:47 UTC] - Purchases This Month: 1860205.6
[21-Jan-2026 21:36:47 UTC] - Active Batches: 23
[21-Jan-2026 21:36:47 UTC] - Unique Products: 10
[21-Jan-2026 21:41:38 UTC] Dashboard Stats for shop 1:
[21-Jan-2026 21:41:38 UTC] - Total Stock Units: 6364
[21-Jan-2026 21:41:38 UTC] - Purchased Units: 17195
[21-Jan-2026 21:41:38 UTC] - Sold Units: 10831
[21-Jan-2026 21:41:38 UTC] - Purchases Today: 1800
[21-Jan-2026 21:41:38 UTC] - Purchases This Month: 1860205.6
[21-Jan-2026 21:41:38 UTC] - Active Batches: 22
[21-Jan-2026 21:41:38 UTC] - Unique Products: 10
[22-Jan-2026 04:46:42 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 04:46:42 UTC] - Total Stock Units: 6144
[22-Jan-2026 04:46:42 UTC] - Purchased Units: 16784
[22-Jan-2026 04:46:42 UTC] - Sold Units: 10640
[22-Jan-2026 04:46:42 UTC] - Purchases Today: 0
[22-Jan-2026 04:46:42 UTC] - Purchases This Month: 1860205.6
[22-Jan-2026 04:46:42 UTC] - Active Batches: 16
[22-Jan-2026 04:46:42 UTC] - Unique Products: 7
[22-Jan-2026 04:49:02 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 04:49:02 UTC] - Total Stock Units: 6144
[22-Jan-2026 04:49:02 UTC] - Purchased Units: 16784
[22-Jan-2026 04:49:02 UTC] - Sold Units: 10640
[22-Jan-2026 04:49:02 UTC] - Purchases Today: 0
[22-Jan-2026 04:49:02 UTC] - Purchases This Month: 1860205.6
[22-Jan-2026 04:49:02 UTC] - Active Batches: 16
[22-Jan-2026 04:49:02 UTC] - Unique Products: 7
[22-Jan-2026 04:50:22 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 04:50:22 UTC] - Total Stock Units: 6144
[22-Jan-2026 04:50:22 UTC] - Purchased Units: 16784
[22-Jan-2026 04:50:22 UTC] - Sold Units: 10640
[22-Jan-2026 04:50:22 UTC] - Purchases Today: 0
[22-Jan-2026 04:50:22 UTC] - Purchases This Month: 1860205.6
[22-Jan-2026 04:50:22 UTC] - Active Batches: 16
[22-Jan-2026 04:50:22 UTC] - Unique Products: 7
[22-Jan-2026 04:52:35 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 04:52:35 UTC] - Total Stock Units: 6144
[22-Jan-2026 04:52:35 UTC] - Purchased Units: 16784
[22-Jan-2026 04:52:35 UTC] - Sold Units: 10640
[22-Jan-2026 04:52:35 UTC] - Purchases Today: 0
[22-Jan-2026 04:52:35 UTC] - Purchases This Month: 1860205.6
[22-Jan-2026 04:52:35 UTC] - Active Batches: 16
[22-Jan-2026 04:52:35 UTC] - Unique Products: 7
[22-Jan-2026 04:59:28 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 04:59:28 UTC] - Total Stock Units: 6144
[22-Jan-2026 04:59:28 UTC] - Purchased Units: 16784
[22-Jan-2026 04:59:28 UTC] - Sold Units: 10640
[22-Jan-2026 04:59:28 UTC] - Purchases Today: 0
[22-Jan-2026 04:59:28 UTC] - Purchases This Month: 1860205.6
[22-Jan-2026 04:59:28 UTC] - Active Batches: 16
[22-Jan-2026 04:59:28 UTC] - Unique Products: 7
[22-Jan-2026 05:07:02 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 05:07:02 UTC] - Total Stock Units: 6174
[22-Jan-2026 05:07:02 UTC] - Purchased Units: 16814
[22-Jan-2026 05:07:02 UTC] - Sold Units: 10640
[22-Jan-2026 05:07:02 UTC] - Purchases Today: 54000
[22-Jan-2026 05:07:02 UTC] - Purchases This Month: 1914205.6
[22-Jan-2026 05:07:02 UTC] - Active Batches: 17
[22-Jan-2026 05:07:02 UTC] - Unique Products: 7
[22-Jan-2026 05:15:22 UTC] Dashboard Stats for shop 1:
[22-Jan-2026 05:15:22 UTC] - Total Stock Units: 6174
[22-Jan-2026 05:15:22 UTC] - Purchased Units: 16814
[22-Jan-2026 05:15:22 UTC] - Sold Units: 10640
[22-Jan-2026 05:15:22 UTC] - Purchases Today: 54000
[22-Jan-2026 05:15:22 UTC] - Purchases This Month: 1914205.6
[22-Jan-2026 05:15:22 UTC] - Active Batches: 17
[22-Jan-2026 05:15:22 UTC] - Unique Products: 7
[23-Jan-2026 16:58:32 UTC] Dashboard Stats for shop 5:
[23-Jan-2026 16:58:32 UTC] - Total Stock Units: 0
[23-Jan-2026 16:58:32 UTC] - Purchased Units: 0
[23-Jan-2026 16:58:32 UTC] - Sold Units: 0
[23-Jan-2026 16:58:32 UTC] - Purchases Today: 0
[23-Jan-2026 16:58:32 UTC] - Purchases This Month: 0
[23-Jan-2026 16:58:32 UTC] - Active Batches: 0
[23-Jan-2026 16:58:32 UTC] - Unique Products: 0
[23-Jan-2026 16:59:04 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 16:59:04 UTC] - Total Stock Units: 5783
[23-Jan-2026 16:59:04 UTC] - Purchased Units: 16247
[23-Jan-2026 16:59:04 UTC] - Sold Units: 10464
[23-Jan-2026 16:59:04 UTC] - Purchases Today: 0
[23-Jan-2026 16:59:04 UTC] - Purchases This Month: 1914205.6
[23-Jan-2026 16:59:04 UTC] - Active Batches: 16
[23-Jan-2026 16:59:04 UTC] - Unique Products: 7
[23-Jan-2026 17:05:01 UTC] Dashboard Stats for shop 5:
[23-Jan-2026 17:05:01 UTC] - Total Stock Units: 0
[23-Jan-2026 17:05:01 UTC] - Purchased Units: 0
[23-Jan-2026 17:05:01 UTC] - Sold Units: 0
[23-Jan-2026 17:05:01 UTC] - Purchases Today: 0
[23-Jan-2026 17:05:01 UTC] - Purchases This Month: 0
[23-Jan-2026 17:05:01 UTC] - Active Batches: 0
[23-Jan-2026 17:05:01 UTC] - Unique Products: 0
[23-Jan-2026 17:07:33 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 17:07:33 UTC] - Total Stock Units: 5783
[23-Jan-2026 17:07:33 UTC] - Purchased Units: 16247
[23-Jan-2026 17:07:33 UTC] - Sold Units: 10464
[23-Jan-2026 17:07:33 UTC] - Purchases Today: 0
[23-Jan-2026 17:07:33 UTC] - Purchases This Month: 1914205.6
[23-Jan-2026 17:07:33 UTC] - Active Batches: 16
[23-Jan-2026 17:07:33 UTC] - Unique Products: 7
[23-Jan-2026 19:02:10 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:02:10 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:02:10 UTC] - Purchased Units: 16247
[23-Jan-2026 19:02:10 UTC] - Sold Units: 10464
[23-Jan-2026 19:02:10 UTC] - Purchases Today: 0
[23-Jan-2026 19:02:10 UTC] - Purchases This Month: 1914205.6
[23-Jan-2026 19:02:10 UTC] - Active Batches: 16
[23-Jan-2026 19:02:10 UTC] - Unique Products: 7
[23-Jan-2026 19:03:19 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:03:19 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:03:19 UTC] - Purchased Units: 16247
[23-Jan-2026 19:03:19 UTC] - Sold Units: 10464
[23-Jan-2026 19:03:19 UTC] - Purchases Today: 0
[23-Jan-2026 19:03:19 UTC] - Purchases This Month: 1914205.6
[23-Jan-2026 19:03:19 UTC] - Active Batches: 16
[23-Jan-2026 19:03:19 UTC] - Unique Products: 7
[23-Jan-2026 19:18:35 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:18:35 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:18:35 UTC] - Purchased Units: 16247
[23-Jan-2026 19:18:35 UTC] - Sold Units: 10464
[23-Jan-2026 19:18:35 UTC] - Purchases Today: 0
[23-Jan-2026 19:18:35 UTC] - Purchases This Month: 1914205.6
[23-Jan-2026 19:18:35 UTC] - Active Batches: 16
[23-Jan-2026 19:18:35 UTC] - Unique Products: 7
[23-Jan-2026 19:21:25 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:21:25 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:21:25 UTC] - Purchased Units: 16247
[23-Jan-2026 19:21:25 UTC] - Sold Units: 10464
[23-Jan-2026 19:21:25 UTC] - Purchases Today: 180000
[23-Jan-2026 19:21:25 UTC] - Purchases This Month: 2094205.6
[23-Jan-2026 19:21:25 UTC] - Active Batches: 16
[23-Jan-2026 19:21:25 UTC] - Unique Products: 7
[23-Jan-2026 19:22:01 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:22:01 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:22:01 UTC] - Purchased Units: 16247
[23-Jan-2026 19:22:01 UTC] - Sold Units: 10464
[23-Jan-2026 19:22:01 UTC] - Purchases Today: 180000
[23-Jan-2026 19:22:01 UTC] - Purchases This Month: 2094205.6
[23-Jan-2026 19:22:01 UTC] - Active Batches: 16
[23-Jan-2026 19:22:01 UTC] - Unique Products: 7
[23-Jan-2026 19:29:50 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:29:50 UTC] - Total Stock Units: 5783
[23-Jan-2026 19:29:50 UTC] - Purchased Units: 16247
[23-Jan-2026 19:29:50 UTC] - Sold Units: 10464
[23-Jan-2026 19:29:50 UTC] - Purchases Today: 180000
[23-Jan-2026 19:29:50 UTC] - Purchases This Month: 2094205.6
[23-Jan-2026 19:29:50 UTC] - Active Batches: 16
[23-Jan-2026 19:29:50 UTC] - Unique Products: 7
[23-Jan-2026 19:32:07 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:32:07 UTC] - Total Stock Units: 5883
[23-Jan-2026 19:32:07 UTC] - Purchased Units: 16347
[23-Jan-2026 19:32:07 UTC] - Sold Units: 10464
[23-Jan-2026 19:32:07 UTC] - Purchases Today: 185000
[23-Jan-2026 19:32:07 UTC] - Purchases This Month: 2099205.6
[23-Jan-2026 19:32:07 UTC] - Active Batches: 17
[23-Jan-2026 19:32:07 UTC] - Unique Products: 7
[23-Jan-2026 19:39:25 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:39:25 UTC] - Total Stock Units: 5883
[23-Jan-2026 19:39:25 UTC] - Purchased Units: 16347
[23-Jan-2026 19:39:25 UTC] - Sold Units: 10464
[23-Jan-2026 19:39:25 UTC] - Purchases Today: 185000
[23-Jan-2026 19:39:25 UTC] - Purchases This Month: 2099205.6
[23-Jan-2026 19:39:25 UTC] - Active Batches: 17
[23-Jan-2026 19:39:25 UTC] - Unique Products: 7
[23-Jan-2026 19:39:38 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:39:38 UTC] - Total Stock Units: 5883
[23-Jan-2026 19:39:38 UTC] - Purchased Units: 16347
[23-Jan-2026 19:39:38 UTC] - Sold Units: 10464
[23-Jan-2026 19:39:38 UTC] - Purchases Today: 185000
[23-Jan-2026 19:39:38 UTC] - Purchases This Month: 2099205.6
[23-Jan-2026 19:39:38 UTC] - Active Batches: 17
[23-Jan-2026 19:39:38 UTC] - Unique Products: 7
[23-Jan-2026 19:42:37 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:42:37 UTC] - Total Stock Units: 6883
[23-Jan-2026 19:42:37 UTC] - Purchased Units: 17347
[23-Jan-2026 19:42:37 UTC] - Sold Units: 10464
[23-Jan-2026 19:42:37 UTC] - Purchases Today: 235000
[23-Jan-2026 19:42:37 UTC] - Purchases This Month: 2149205.6
[23-Jan-2026 19:42:37 UTC] - Active Batches: 18
[23-Jan-2026 19:42:37 UTC] - Unique Products: 7
[23-Jan-2026 19:47:20 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:47:20 UTC] - Total Stock Units: 6883
[23-Jan-2026 19:47:20 UTC] - Purchased Units: 17347
[23-Jan-2026 19:47:20 UTC] - Sold Units: 10464
[23-Jan-2026 19:47:20 UTC] - Purchases Today: 235000
[23-Jan-2026 19:47:20 UTC] - Purchases This Month: 2149205.6
[23-Jan-2026 19:47:20 UTC] - Active Batches: 18
[23-Jan-2026 19:47:20 UTC] - Unique Products: 7
[23-Jan-2026 19:51:04 UTC] Dashboard Stats for shop 1:
[23-Jan-2026 19:51:04 UTC] - Total Stock Units: 6884
[23-Jan-2026 19:51:04 UTC] - Purchased Units: 17348
[23-Jan-2026 19:51:04 UTC] - Sold Units: 10464
[23-Jan-2026 19:51:04 UTC] - Purchases Today: 240000
[23-Jan-2026 19:51:04 UTC] - Purchases This Month: 2154205.6
[23-Jan-2026 19:51:04 UTC] - Active Batches: 19
[23-Jan-2026 19:51:04 UTC] - Unique Products: 8
[24-Jan-2026 18:53:37 UTC] Dashboard Stats for shop 1:
[24-Jan-2026 18:53:37 UTC] - Total Stock Units: 6884
[24-Jan-2026 18:53:37 UTC] - Purchased Units: 17348
[24-Jan-2026 18:53:37 UTC] - Sold Units: 10464
[24-Jan-2026 18:53:37 UTC] - Purchases Today: 0
[24-Jan-2026 18:53:37 UTC] - Purchases This Month: 2154205.6
[24-Jan-2026 18:53:37 UTC] - Active Batches: 19
[24-Jan-2026 18:53:37 UTC] - Unique Products: 8
[24-Jan-2026 18:55:44 UTC] Dashboard Stats for shop 1:
[24-Jan-2026 18:55:44 UTC] - Total Stock Units: 6884
[24-Jan-2026 18:55:44 UTC] - Purchased Units: 17348
[24-Jan-2026 18:55:44 UTC] - Sold Units: 10464
[24-Jan-2026 18:55:44 UTC] - Purchases Today: 0
[24-Jan-2026 18:55:44 UTC] - Purchases This Month: 2154205.6
[24-Jan-2026 18:55:44 UTC] - Active Batches: 19
[24-Jan-2026 18:55:44 UTC] - Unique Products: 8
[24-Jan-2026 18:56:38 UTC] Dashboard Stats for shop 1:
[24-Jan-2026 18:56:38 UTC] - Total Stock Units: 6884
[24-Jan-2026 18:56:38 UTC] - Purchased Units: 17348
[24-Jan-2026 18:56:38 UTC] - Sold Units: 10464
[24-Jan-2026 18:56:38 UTC] - Purchases Today: 0
[24-Jan-2026 18:56:38 UTC] - Purchases This Month: 2154205.6
[24-Jan-2026 18:56:38 UTC] - Active Batches: 19
[24-Jan-2026 18:56:38 UTC] - Unique Products: 8
[27-Jan-2026 06:17:52 UTC] Dashboard Stats for shop 1:
[27-Jan-2026 06:17:52 UTC] - Total Stock Units: 6884
[27-Jan-2026 06:17:52 UTC] - Purchased Units: 17348
[27-Jan-2026 06:17:52 UTC] - Sold Units: 10464
[27-Jan-2026 06:17:52 UTC] - Purchases Today: 0
[27-Jan-2026 06:17:52 UTC] - Purchases This Month: 2154205.6
[27-Jan-2026 06:17:52 UTC] - Active Batches: 19
[27-Jan-2026 06:17:52 UTC] - Unique Products: 8
[30-Jan-2026 14:18:19 UTC] Dashboard Stats for shop 1:
[30-Jan-2026 14:18:19 UTC] - Total Stock Units: 6884
[30-Jan-2026 14:18:19 UTC] - Purchased Units: 17348
[30-Jan-2026 14:18:19 UTC] - Sold Units: 10464
[30-Jan-2026 14:18:19 UTC] - Purchases Today: 0
[30-Jan-2026 14:18:19 UTC] - Purchases This Month: 2154205.6
[30-Jan-2026 14:18:19 UTC] - Active Batches: 19
[30-Jan-2026 14:18:19 UTC] - Unique Products: 8
[30-Jan-2026 15:02:58 UTC] Dashboard Stats for shop 1:
[30-Jan-2026 15:02:58 UTC] - Total Stock Units: 6884
[30-Jan-2026 15:02:58 UTC] - Purchased Units: 17348
[30-Jan-2026 15:02:58 UTC] - Sold Units: 10464
[30-Jan-2026 15:02:58 UTC] - Purchases Today: 0
[30-Jan-2026 15:02:58 UTC] - Purchases This Month: 2154205.6
[30-Jan-2026 15:02:58 UTC] - Active Batches: 19
[30-Jan-2026 15:02:58 UTC] - Unique Products: 8
[31-Jan-2026 10:31:59 UTC] Dashboard Stats for shop 1:
[31-Jan-2026 10:31:59 UTC] - Total Stock Units: 6884
[31-Jan-2026 10:31:59 UTC] - Purchased Units: 17348
[31-Jan-2026 10:31:59 UTC] - Sold Units: 10464
[31-Jan-2026 10:31:59 UTC] - Purchases Today: 0
[31-Jan-2026 10:31:59 UTC] - Purchases This Month: 2154205.6
[31-Jan-2026 10:31:59 UTC] - Active Batches: 19
[31-Jan-2026 10:31:59 UTC] - Unique Products: 8
