Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' ){"id":168,"created_at":"2026-04-06T16:47:16.000000Z","updated_at":"2026-04-06T16:47:23.000000Z","TransactionType":"Pay Bill","TransID":"UD67KBT5ET","TransTime":"20260406194714","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58105023913","InvoiceNumber":null,"OrgAccountBalance":"693564.00","ThirdPartyTransID":null,"MSISDN":"254795681096","hashed_msisdn":"b639f6112997b0ceb5716911ec7b3b466af0fe192da6f1fa662a8330ccb7aad2","FirstName":"ETHYLE","MiddleName":"PATIENCE AMOIT OJIAMBO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 19:47:23","remote_synced_id":1256257}{"id":1203,"created_at":"2026-04-06T19:37:36.000000Z","updated_at":"2026-04-06T19:37:42.000000Z","TransactionType":"Pay Bill","TransID":"UD64G0EFJP","TransTime":"20260406223734","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58103905939","InvoiceNumber":null,"OrgAccountBalance":"872132.00","ThirdPartyTransID":null,"MSISDN":"254725858470","hashed_msisdn":"8371223215fc91bc1614242836c4632daabdef1ba10a565afba47f5085742c29","FirstName":"LINET","MiddleName":"MORAA OSOGO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 22:37:42","remote_synced_id":1257295}{"id":1256,"created_at":"2026-04-06T19:51:30.000000Z","updated_at":"2026-04-06T19:51:35.000000Z","TransactionType":"Pay Bill","TransID":"UD6K2BTEE4","TransTime":"20260406225127","TransAmount":"25.00","BusinessShortCode":"4130421","BillRefNumber":"58102455266","InvoiceNumber":null,"OrgAccountBalance":"879287.00","ThirdPartyTransID":null,"MSISDN":"254706552393","hashed_msisdn":"d1743d4ef591baa4bbf37af5f6120c3dd6a5d1b6adb4bed2601cb0e92d2a2aef","FirstName":"ALLAN","MiddleName":"GICHOHI NGEI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 22:51:35","remote_synced_id":1257348}{"id":366,"created_at":"2026-04-06T17:12:13.000000Z","updated_at":"2026-04-06T17:12:19.000000Z","TransactionType":"Pay Bill","TransID":"UD6OX01ZVR","TransTime":"20260406201210","TransAmount":"25.00","BusinessShortCode":"4130421","BillRefNumber":"22001009186","InvoiceNumber":null,"OrgAccountBalance":"723132.00","ThirdPartyTransID":null,"MSISDN":"254708347871","hashed_msisdn":"9cf8b2e863d12b1749bfebd5b8c2063ef249282b32507e7eafda26bc9e12c8f6","FirstName":"EDWIN","MiddleName":"KIPKOGEI KIBET","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 20:12:19","remote_synced_id":1256457}{"id":936,"created_at":"2026-04-06T18:37:53.000000Z","updated_at":"2026-04-06T18:37:59.000000Z","TransactionType":"Pay Bill","TransID":"UD6JSBS2U4","TransTime":"20260406213751","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"22000891832","InvoiceNumber":null,"OrgAccountBalance":"806932.00","ThirdPartyTransID":null,"MSISDN":"254112867207","hashed_msisdn":"dd87b3430b79967f44f8820380934b380fa28b16fb1b6d80e74eec4064de2d35","FirstName":"JAQUELINE","MiddleName":"AKOTH ONYANGO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 21:37:59","remote_synced_id":1257028}{"id":1311,"created_at":"2026-04-06T20:07:26.000000Z","updated_at":"2026-04-06T20:07:32.000000Z","TransactionType":"Pay Bill","TransID":"UD6DF0467G","TransTime":"20260406230724","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"22000911440","InvoiceNumber":null,"OrgAccountBalance":"886936.00","ThirdPartyTransID":null,"MSISDN":"254701831066","hashed_msisdn":"958688d21d3e4353a8cd6e001924bf7211262b6f05e971a343ca4300a76eee2a","FirstName":"ESTHER","MiddleName":"MADADI MUSALIA","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 23:07:32","remote_synced_id":1257403}{"id":951,"created_at":"2026-04-06T18:40:03.000000Z","updated_at":"2026-04-06T18:40:10.000000Z","TransactionType":"Pay Bill","TransID":"UD64004XFR","TransTime":"20260406214001","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"22001034184","InvoiceNumber":null,"OrgAccountBalance":"809867.00","ThirdPartyTransID":null,"MSISDN":"254700277521","hashed_msisdn":"0b19ec27171b49b3bacdebc14f3cd5cdd6d079a5918724272526585339a767f2","FirstName":"BENDETTA","MiddleName":"MWENDE KIMULI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 21:40:10","remote_synced_id":1257043}{"id":135,"created_at":"2026-04-06T16:14:04.000000Z","updated_at":"2026-04-06T16:14:05.000000Z","TransactionType":"Pay Bill","TransID":"UD61EBODS0","TransTime":"2026-04-06 19:12:46","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"22000517627","InvoiceNumber":null,"OrgAccountBalance":"0.00","ThirdPartyTransID":null,"MSISDN":"254714586142","hashed_msisdn":"0b1560cd1d1fd0fa45ea6080e2483f29534237a950fd93452dc6291810cde491","FirstName":null,"MiddleName":null,"LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"N","is_synced":"Y","date_synced":"2026-04-06 19:14:05","remote_synced_id":1255942}{"id":1842,"created_at":"2026-04-07T04:48:50.000000Z","updated_at":"2026-04-07T04:48:56.000000Z","TransactionType":"Pay Bill","TransID":"UD7PLBLG0U","TransTime":"20260407074848","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58103861934","InvoiceNumber":null,"OrgAccountBalance":"92773.00","ThirdPartyTransID":null,"MSISDN":"254722572905","hashed_msisdn":"b5e1f522359288e991d90479a6c042203c983f92f6de201ae634c882b86f0e4d","FirstName":"FATMA","MiddleName":"ZULFIKAR WALLY","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 07:48:56","remote_synced_id":1257938}{"id":1711,"created_at":"2026-04-07T04:06:29.000000Z","updated_at":"2026-04-07T04:06:35.000000Z","TransactionType":"Pay Bill","TransID":"UD7DDBTARI","TransTime":"20260407070627","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58103767669","InvoiceNumber":null,"OrgAccountBalance":"69677.00","ThirdPartyTransID":null,"MSISDN":"254720488918","hashed_msisdn":"ad348233abf1df08ffdd211e83a3955f1d42095aa1d9db586c22854304c415c3","FirstName":"JOSHUA","MiddleName":"M'MAILUTHA","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 07:06:35","remote_synced_id":1257806}{"id":1886,"created_at":"2026-04-07T05:01:59.000000Z","updated_at":"2026-04-07T05:02:05.000000Z","TransactionType":"Pay Bill","TransID":"UD71O0997I","TransTime":"20260407080156","TransAmount":"200.00","BusinessShortCode":"4130421","BillRefNumber":"58103842843","InvoiceNumber":null,"OrgAccountBalance":"104688.00","ThirdPartyTransID":null,"MSISDN":"254720379453","hashed_msisdn":"7641e2e29021e1b3785cf7bc21137f2991a4f92600851eb4ec1bb146bb636d22","FirstName":"LUCY","MiddleName":"WAMBUI NJOKI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 08:02:05","remote_synced_id":1257982}{"id":490,"created_at":"2026-04-06T17:29:26.000000Z","updated_at":"2026-04-06T17:29:32.000000Z","TransactionType":"Pay Bill","TransID":"UD62B06542","TransTime":"20260406202924","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"22000775738","InvoiceNumber":null,"OrgAccountBalance":"743745.00","ThirdPartyTransID":null,"MSISDN":"254742441596","hashed_msisdn":"d624bdd7752d4180d6cf73f49b4647fa55f1e018d58447310cea03b38c83203f","FirstName":"KEN","MiddleName":"NDIRITU WAMBUGU","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 20:29:32","remote_synced_id":1256581}{"id":2689,"created_at":"2026-04-07T09:02:27.000000Z","updated_at":"2026-04-07T09:02:33.000000Z","TransactionType":"Pay Bill","TransID":"UD7HD04PTA","TransTime":"20260407120225","TransAmount":"200.00","BusinessShortCode":"4130421","BillRefNumber":"58103646251","InvoiceNumber":null,"OrgAccountBalance":"272024.00","ThirdPartyTransID":null,"MSISDN":"254717028884","hashed_msisdn":"e35b1fbd8aff0ce894b84d175c94dc0c129142fb9014ef83db0c7b50c418f29c","FirstName":"JEFF","MiddleName":"O OPOLLO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 12:02:33","remote_synced_id":1258787}{"id":2189,"created_at":"2026-04-07T06:35:23.000000Z","updated_at":"2026-04-07T06:35:29.000000Z","TransactionType":"Pay Bill","TransID":"UD7FQBWI8M","TransTime":"20260407093521","TransAmount":"1000.00","BusinessShortCode":"4130421","BillRefNumber":"22001027063","InvoiceNumber":null,"OrgAccountBalance":"167642.00","ThirdPartyTransID":null,"MSISDN":"254726878378","hashed_msisdn":"f8f8548ef547aba80fef1138d69d82f814883a22863c54aa419a667f9016d55c","FirstName":"SAMUEL","MiddleName":"MURAGURI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 09:35:29","remote_synced_id":1258286}{"id":1801,"created_at":"2026-04-07T04:40:15.000000Z","updated_at":"2026-04-07T04:40:21.000000Z","TransactionType":"Pay Bill","TransID":"UD7L105VLP","TransTime":"20260407074012","TransAmount":"30.00","BusinessShortCode":"4130421","BillRefNumber":"22000781397","InvoiceNumber":null,"OrgAccountBalance":"85547.00","ThirdPartyTransID":null,"MSISDN":"254716011144","hashed_msisdn":"613e577765c1eec13346217ca0e53ae48071e24a827ad4af9d07806c72b56ce4","FirstName":"ESTHER","MiddleName":"WANGOI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 07:40:21","remote_synced_id":1257897}{"id":2664,"created_at":"2026-04-07T08:52:39.000000Z","updated_at":"2026-04-07T08:52:45.000000Z","TransactionType":"Pay Bill","TransID":"UD7CK04MRX","TransTime":"20260407115237","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"22000519185","InvoiceNumber":null,"OrgAccountBalance":"265293.00","ThirdPartyTransID":null,"MSISDN":"254797359680","hashed_msisdn":"6e4da3c511e4d98b8c5edf829eee23e810297b42050386f659e1f1ade787c148","FirstName":"TRACY","MiddleName":"IRENE AKINYI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 11:52:45","remote_synced_id":1258762}{"id":656,"created_at":"2026-04-06T17:52:30.000000Z","updated_at":"2026-04-06T17:52:36.000000Z","TransactionType":"Pay Bill","TransID":"UD6A50AP0Y","TransTime":"20260406205228","TransAmount":"35.00","BusinessShortCode":"4130421","BillRefNumber":"58103760698","InvoiceNumber":null,"OrgAccountBalance":"763202.00","ThirdPartyTransID":null,"MSISDN":"254759189162","hashed_msisdn":"d3108facbf305125414576d0d7f9263826f4b2b15b4e713f08dcda328b94dd13","FirstName":"RENSON","MiddleName":"AKULA","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 20:52:36","remote_synced_id":1256747}{"id":2476,"created_at":"2026-04-07T08:02:09.000000Z","updated_at":"2026-04-07T08:02:15.000000Z","TransactionType":"Pay Bill","TransID":"UD7FN01ORQ","TransTime":"20260407110207","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"58103865448","InvoiceNumber":null,"OrgAccountBalance":"232215.00","ThirdPartyTransID":null,"MSISDN":"254716509357","hashed_msisdn":"191bad8427358b7057eb19d33f8b5140b992cb01cf7228b43a72ea11e7ed40fa","FirstName":"PURHTY","MiddleName":"WANJIRU GAKONO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 11:02:15","remote_synced_id":1258573}{"id":1715,"created_at":"2026-04-07T04:07:32.000000Z","updated_at":"2026-04-07T04:07:38.000000Z","TransactionType":"Pay Bill","TransID":"UD7RSBRQZ4","TransTime":"20260407070730","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"58102452958","InvoiceNumber":null,"OrgAccountBalance":"70512.00","ThirdPartyTransID":null,"MSISDN":"254700145925","hashed_msisdn":"35ee4b846385823e3536eaac7a08d2c544d5afd8b9470381db74a75617659872","FirstName":"MARTIN","MiddleName":"KIOGORA MURUGU","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 07:07:38","remote_synced_id":1257810}{"id":2939,"created_at":"2026-04-07T10:15:36.000000Z","updated_at":"2026-04-07T10:15:42.000000Z","TransactionType":"Pay Bill","TransID":"UD7360EBOW","TransTime":"20260407131534","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"58103649057","InvoiceNumber":null,"OrgAccountBalance":"305588.00","ThirdPartyTransID":null,"MSISDN":"254703493045","hashed_msisdn":"37c29adfd90b541b52327b4b4d11bf0e7df6265c15f7a2709ae1eb2fa6fdb33a","FirstName":"HESBON","MiddleName":"ONTUGA NGITI","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 13:15:42","remote_synced_id":1259037}{"id":771,"created_at":"2026-04-06T18:10:57.000000Z","updated_at":"2026-04-06T18:11:04.000000Z","TransactionType":"Pay Bill","TransID":"UD62O0DLY9","TransTime":"20260406211055","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58102443940","InvoiceNumber":null,"OrgAccountBalance":"778926.00","ThirdPartyTransID":null,"MSISDN":"254707313780","hashed_msisdn":"52f7025dd82be9ae9203bf40314550c7b48cd01ac431aa3e55ee99a2ce898b53","FirstName":"GRACE","MiddleName":"NEEMA KEAH","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 21:11:04","remote_synced_id":1256862}Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`astra_responses`.`id` at row 1
INSERT INTO astra_responses (id, created_at, updated_at, created_by, updated_by, external_reference, internal_reference, request_status, request_code, request_body, request_message, response_status, response_code, error_description, response_description, service_reference, token, units, request_type, kplc_identifier, token_amount, debt_account, current_balance, transaction_cost, total_cost, after_balance, is_synced, date_synced, remote_sync_id, nais_is_synced, nais_date_synced, nais_remote_sync_id) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorUnknown column 'created_by' in 'INSERT INTO'
INSERT INTO mpesa_transactions (id, created_at, updated_at, created_by, updated_by, external_reference, internal_reference, request_status, request_code, request_body, request_message, response_status, response_code, error_description, response_description, service_reference, token, units, request_type, kplc_identifier, token_amount, debt_account, current_balance, transaction_cost, total_cost, after_balance, is_synced, date_synced, remote_sync_id, nais_is_synced, nais_date_synced, nais_remote_sync_id) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorUnknown column 'created_by' in 'INSERT INTO'
INSERT INTO mpesa_transactions (id, created_at, updated_at, created_by, updated_by, external_reference, internal_reference, request_status, request_code, request_body, request_message, response_status, response_code, error_description, response_description, service_reference, token, units, request_type, kplc_identifier, token_amount, debt_account, current_balance, transaction_cost, total_cost, after_balance, is_synced, date_synced, remote_sync_id, nais_is_synced, nais_date_synced, nais_remote_sync_id) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorUnknown column 'created_by' in 'INSERT INTO'
INSERT INTO mpesa_transactions (id, created_at, updated_at, created_by, updated_by, external_reference, internal_reference, request_status, request_code, request_body, request_message, response_status, response_code, error_description, response_description, service_reference, token, units, request_type, kplc_identifier, token_amount, debt_account, current_balance, transaction_cost, total_cost, after_balance, is_synced, date_synced, remote_sync_id, nais_is_synced, nais_date_synced, nais_remote_sync_id) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' ){"id":944,"created_at":"2026-04-06T18:39:21.000000Z","updated_at":"2026-04-06T18:39:27.000000Z","TransactionType":"Pay Bill","TransID":"UD6H701QHV","TransTime":"20260406213919","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58102382973","InvoiceNumber":null,"OrgAccountBalance":"808317.00","ThirdPartyTransID":null,"MSISDN":"254715410293","hashed_msisdn":"864e9bf2eaed0b016e45db2c539157ff7b9fc1eb9405573b4232d2385eadfaee","FirstName":"SIMON","MiddleName":"KIMEU MWANGE","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 21:39:27","remote_synced_id":1257036}Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ...' at line 26
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES (, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect integer value: '=168' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('=168', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorIncorrect decimal value: '' for column `umskenya_appdb`.`mpesa_transactions`.`TransAmount` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('168', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )Insert ErrorYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 51
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('944', '2026-04-06T18:39:21.000000Z', '2026-04-06T18:39:27.000000Z', 'Pay Bill', 'UD6H701QHV', '20260406213919', '100.00', '4130421', '58102382973', '', '808317.00', '', '254715410293', '864e9bf2eaed0b016e45db2c539157ff7b9fc1eb9405573b4232d2385eadfaee', 'SIMON', 'KIMEU MWANGE', '', 'Pending', '', '', 'Y', 'Y', '', '2026-04-06 21:39:27', )Insert ErrorYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 51
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('944', '2026-04-06T18:39:21.000000Z', '2026-04-06T18:39:27.000000Z', 'Pay Bill', 'UD6H701QHV', '20260406213919', '100.00', '4130421', '58102382973', '', '808317.00', '', '254715410293', '864e9bf2eaed0b016e45db2c539157ff7b9fc1eb9405573b4232d2385eadfaee', 'SIMON', 'KIMEU MWANGE', '', 'Pending', '', '', 'Y', 'Y', '', '2026-04-06 21:39:27', )Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`remote_sync_id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('944', '2026-04-06T18:39:21.000000Z', '2026-04-06T18:39:27.000000Z', 'Pay Bill', 'UD6H701QHV', '20260406213919', '100.00', '4130421', '58102382973', '', '808317.00', '', '254715410293', '864e9bf2eaed0b016e45db2c539157ff7b9fc1eb9405573b4232d2385eadfaee', 'SIMON', 'KIMEU MWANGE', '', 'Pending', '', '', 'Y', 'Y', '', '2026-04-06 21:39:27' ){"id":914,"created_at":"2026-04-06T18:34:39.000000Z","updated_at":"2026-04-06T18:34:45.000000Z","TransactionType":"Pay Bill","TransID":"UD6PBBP2PA","TransTime":"20260406213437","TransAmount":"100.00","BusinessShortCode":"4130421","BillRefNumber":"58103904148","InvoiceNumber":null,"OrgAccountBalance":"803546.00","ThirdPartyTransID":null,"MSISDN":"254708187768","hashed_msisdn":"86f612a460968ff1a0e902fc0bdfd6cbf8e0312ab1fc7411234f1f046fafba12","FirstName":"JOSEPH","MiddleName":"OKOTH ODHIAMBO","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-06 21:34:45","remote_synced_id":1257005}{"id":2375,"created_at":"2026-04-07T07:32:45.000000Z","updated_at":"2026-04-07T07:32:51.000000Z","TransactionType":"Pay Bill","TransID":"UD7BWBTXWH","TransTime":"20260407103242","TransAmount":"50.00","BusinessShortCode":"4130421","BillRefNumber":"22001022775","InvoiceNumber":null,"OrgAccountBalance":"207187.00","ThirdPartyTransID":null,"MSISDN":"254757854923","hashed_msisdn":"8e5695e94fd96a9d3aabd8060d603b07b45ba4485c7e07347bc142bf8b5e0505","FirstName":"IAN","MiddleName":"MKAWA OGUTU","LastName":null,"resolved_status":"Pending","resolved_date":null,"resolved_remarks":null,"msisdn_confirmed":"Y","is_synced":"Y","date_synced":"2026-04-07 10:32:51","remote_synced_id":1258472}Insert ErrorIncorrect integer value: '' for column `umskenya_appdb`.`mpesa_transactions`.`id` at row 1
INSERT INTO mpesa_transactions (id, created_at, updated_at, TransactionType, TransID, TransTime, TransAmount, BusinessShortCode, BillRefNumber, InvoiceNumber, OrgAccountBalance, ThirdPartyTransID, MSISDN, hashed_msisdn, FirstName, MiddleName, LastName, resolved_status, resolved_date, resolved_remarks, msisdn_confirmed, is_synced, remote_sync_id, date_synced ) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' )