[2026-10-03 16:02:39] local.INFO: =================================================  
[2026-10-03 16:02:39] local.INFO: PAYTM STATIC QR WEBHOOK RECEIVED  
[2026-10-03 16:02:39] local.INFO: =================================================  
[2026-10-03 16:02:39] local.INFO: PAYTM WEBHOOK REQUEST {"timestamp":"2026-10-03 16:02:39","method":"POST","url":"https://dashboardbbps.spay.live/api/paytm/static-qr/webhook","ip":"2a02:4780:12:d1a4::1","headers":{"x-https":["1"],"connection":["Keep-Alive"],"host":["dashboardbbps.spay.live"],"content-length":["215"],"x-forwarded-proto":["https"],"cf-visitor":["{\"scheme\":\"https\"}"],"cf-ipcountry":["IN"],"cdn-loop":["cloudflare; loops=1"],"content-type":["application/json"],"accept":["application/json"],"accept-encoding":["gzip, br"],"cf-ray":["a44b48bb5b474424-BOM"],"x-forwarded-for":["2a02:4780:12:d1a4::1"]},"query":[],"body":{"orderId":"QR20261003160214140005","status":"TXN_SUCCESS","txnId":"20261003010840000313173398285384498","bankTxnId":"627613979994","amount":"1.00","paymentMode":"UPI","txnDate":"2026-10-03","respMsg":"Txn Success"},"raw_body":"{\"orderId\":\"QR20261003160214140005\",\"status\":\"TXN_SUCCESS\",\"txnId\":\"20261003010840000313173398285384498\",\"bankTxnId\":\"627613979994\",\"amount\":\"1.00\",\"paymentMode\":\"UPI\",\"txnDate\":\"2026-10-03\",\"respMsg\":\"Txn Success\"}"} 
[2026-10-03 16:02:39] local.ERROR: MICRO LOG INSERT FAILED {"error":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dashboardbbps_db.micro_logs' doesn't exist (Connection: mysql, SQL: insert into `micro_logs` (`product_response`, `product_name`, `created_at`, `updated_at`) values ({\"orderId\":\"QR20261003160214140005\",\"status\":\"TXN_SUCCESS\",\"txnId\":\"20261003010840000313173398285384498\",\"bankTxnId\":\"627613979994\",\"amount\":\"1.00\",\"paymentMode\":\"UPI\",\"txnDate\":\"2026-10-03\",\"respMsg\":\"Txn Success\"}, EBOOK_PAYTM, 2026-10-03 16:02:39, 2026-10-03 16:02:39))"} 
[2026-10-03 16:02:39] local.INFO: PAYTM ORDER ID EXTRACTED {"order_id":"QR20261003160214140005"} 
[2026-10-03 16:02:39] local.ERROR: PAYTM WEBHOOK EXCEPTION {"message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mytxnid' in 'where clause' (Connection: mysql, SQL: select * from `reports` where `mytxnid` = QR20261003160214140005 limit 1)","file":"/home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php","line":829,"trace":"#0 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\\Database\\Connection->run('select * from `...', Array, Object(Closure))
#2 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2913): Illuminate\\Database\\Connection->select('select * from `...', Array, true)
#3 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2902): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3456): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2901): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(739): Illuminate\\Database\\Query\\Builder->get(Array)
#7 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(723): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)
#8 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\\Database\\Eloquent\\Builder->get(Array)
#9 /home/dashboardbbps/public_html/laravel_project/app/Http/Controllers/QR/QRServiceController.php(596): Illuminate\\Database\\Eloquent\\Builder->first()
#10 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\QR\\QRServiceController->paytmwebhook(Object(Illuminate\\Http\\Request))
#11 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('paytmwebhook', Array)
#12 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\QR\\QRServiceController), 'paytmwebhook')
#13 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#14 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->run()
#15 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#16 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#17 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#18 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(159): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#19 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(125): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array)
#20 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure))
#21 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api')
#22 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#23 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->Laravel\\Sanctum\\Http\\Middleware\\{closure}(Object(Illuminate\\Http\\Request))
#24 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#25 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(24): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#26 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Laravel\\Sanctum\\Http\\Middleware\\EnsureFrontendRequestsAreStateful->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#27 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#29 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#30 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#31 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#32 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#33 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#34 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#35 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#36 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#40 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#41 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#43 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#44 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#45 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middleware\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#46 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#47 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#50 /home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#51 /home/dashboardbbps/public_html/index.php(18): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#52 {main}"} 
[2026-10-03 16:14:10] local.INFO: PAYTM QR CALLBACK RECEIVED {"data":{"orderId":"QR20261003161345537915","status":"TXN_SUCCESS","txnId":"20261003010960000313176296323049412","bankTxnId":"627657375184","amount":"1.00","paymentMode":"UPI","txnDate":"2026-10-03","respMsg":"Txn Success"},"raw":"{\"orderId\":\"QR20261003161345537915\",\"status\":\"TXN_SUCCESS\",\"txnId\":\"20261003010960000313176296323049412\",\"bankTxnId\":\"627657375184\",\"amount\":\"1.00\",\"paymentMode\":\"UPI\",\"txnDate\":\"2026-10-03\",\"respMsg\":\"Txn Success\"}"} 
[2026-10-03 16:14:10] local.ERROR: MICRO LOG FAILED {"error":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dashboardbbps_db.micro_logs' doesn't exist (Connection: mysql, SQL: insert into `micro_logs` (`product_response`, `product_name`, `created_at`, `updated_at`) values ({\"orderId\":\"QR20261003161345537915\",\"status\":\"TXN_SUCCESS\",\"txnId\":\"20261003010960000313176296323049412\",\"bankTxnId\":\"627657375184\",\"amount\":\"1.00\",\"paymentMode\":\"UPI\",\"txnDate\":\"2026-10-03\",\"respMsg\":\"Txn Success\"}, EBOOK_PAYTM_QR, 2026-10-03 16:14:10, 2026-10-03 16:14:10))"} 
[2026-10-03 16:14:10] local.ERROR: PAYTM QR CALLBACK EXCEPTION {"message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product' in 'where clause' (Connection: mysql, SQL: select * from `reports` where `request_id` = QR20261003161345537915 and `product` = UPI limit 1)","file":"/home/dashboardbbps/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php","line":829}