2025-09-08 21:59:29,663 - INFO - Starting comprehensive loan_id column fixes...
2025-09-08 21:59:29,664 - INFO - Fixing repayments table...
2025-09-08 21:59:29,672 - INFO - repayments.loan_id column already exists
2025-09-08 21:59:29,672 - INFO - Fixing mpesa_transactions table...
2025-09-08 21:59:29,682 - INFO - mpesa_transactions.loan_id column added successfully
2025-09-08 21:59:29,713 - INFO - Index added for mpesa_transactions.loan_id
2025-09-08 21:59:29,747 - INFO - Foreign key constraint added for mpesa_transactions.loan_id
2025-09-08 21:59:29,747 - INFO - Populating existing loan_id data...
2025-09-08 21:59:29,747 - WARNING - Manual data migration may be required for existing repayments
2025-09-08 21:59:29,748 - INFO - Please review existing repayment records and populate loan_id manually
2025-09-08 21:59:29,748 - ERROR - Error populating existing data: (1054, "Unknown column 'mt.repayment_id' in 'on clause'")
2025-09-08 21:59:29,748 - WARNING - Data population completed with warnings
2025-09-08 21:59:29,749 - INFO - Verifying fixes...
2025-09-08 21:59:29,756 - INFO - All fixes applied successfully!