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 ErrorDuplicate entry '914' for key 'PRIMARY'
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 ('914',
'2026-04-06T18:34:39.000000Z',
'2026-04-06T18:34:45.000000Z',
'Pay Bill',
'UD6PBBP2PA',
'20260406213437',
'100.00',
'4130421',
'58103904148',
'',
'803546.00',
'',
'254708187768',
'86f612a460968ff1a0e902fc0bdfd6cbf8e0312ab1fc7411234f1f046fafba12',
'JOSEPH',
'OKOTH ODHIAMBO',
'',
'Pending',
'',
'',
'Y',
'Y',
'',
'2026-04-06 21:34:45'
)