=== Testing Notification Processing Workflow ===

Creating test schema...
Created user #1
Created study #1 with position 5
Created schedule #1 with position 10
Created notification #1 with due date: 2026-01-27 04:51:20 (past)

Initial State:
  - Notification #1 status: 1 (1=active)
  - Notification #1 due: 2026-01-27 04:51:20
  - Schedule #1 position: 10
  - Study #1 position: 5

Running cron...
Cron completed
Error processing notification 1: SQLSTATE[HY000]: General error: 1 no such column: phone
Error creating notification for schedule 1: SQLSTATE[HY000]: General error: 1 table notifications has no column named delivery_method
Starting Cron Job at 2026-01-27 05:51:20
Cron Job Finished at 2026-01-27 05:51:21


=== Verification Results ===

✓ Test 1 PASSED: Original notification marked as inactive (status=0)
✗ Test 2 FAILED: Email file not created at /home/memorize/public_html/Tests/API/../Files/Tmp/20260127_045120.txt
✗ Test 3 FAILED: Schedule position not incremented (expected 11, got 10)
✗ Test 4 FAILED: Study position not incremented (expected 6, got 5)
✗ Test 5 FAILED: New notification not created or has wrong status
✗ Test 6 FAILED: Cannot check due date - new notification not found
✗ Test 7 FAILED: Cannot check subject/content - new notification not found
✗ Test 8 FAILED: Expected 1 active notification for schedule, found 0

=== Test Summary ===
Passed: 1/8
Failed: 7/8

✗ Some tests failed.