資料庫寫入測試

步驟 1：檢查資料庫檔案

✅ 資料庫檔案存在
檔案大小: 147456 bytes
檔案權限: 0666
✅ 檔案可讀
✅ 檔案可寫

步驟 2：連接資料庫

✅ 資料庫連接成功

步驟 3：檢查資料表是否存在

✅ 資料表 'rise_auto_sales_tracking_events' 存在

步驟 4：查看現有記錄

目前記錄數量: 269 筆

步驟 5：嘗試寫入測試資料

✅ 測試資料寫入成功
Tracking ID: debug-test-1794270894
Array
(
    [id] => 270
    [campaign_id] => 999
    [lead_id] => 999
    [tracking_id] => debug-test-1794270894
    [event_type] => open
    [event_time] => 2026-11-10 00:34:54
    [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    [ip_address] => 216.73.216.182
    [clicked_url] => 
)

步驟 6：再次查看記錄數

目前記錄數量: 270 筆

最近 5 筆記錄：
Array
(
    [0] => Array
        (
            [id] => 270
            [campaign_id] => 999
            [lead_id] => 999
            [tracking_id] => debug-test-1794270894
            [event_type] => open
            [event_time] => 2026-11-10 00:34:54
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            [ip_address] => 216.73.216.182
            [clicked_url] => 
        )

    [1] => Array
        (
            [id] => 269
            [campaign_id] => 99999
            [lead_id] => 99999
            [tracking_id] => diagnostic-test-1794270873
            [event_type] => open
            [event_time] => 2026-11-10 00:34:33
            [user_agent] => Diagnostic Tool
            [ip_address] => 46.4.162.180
            [clicked_url] => 
        )

    [2] => Array
        (
            [id] => 268
            [campaign_id] => 88888
            [lead_id] => 88888
            [tracking_id] => web-test-1794270641
            [event_type] => open
            [event_time] => 2026-11-10 00:30:47
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.4; +https://openai.com/gptbot)
            [ip_address] => 74.7.227.135
            [clicked_url] => 
        )

    [3] => Array
        (
            [id] => 267
            [campaign_id] => 1
            [lead_id] => 1
            [tracking_id] => test456
            [event_type] => click
            [event_time] => 2026-11-10 00:30:46
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.4; +https://openai.com/gptbot)
            [ip_address] => 74.7.227.135
            [clicked_url] => https://google.com
        )

    [4] => Array
        (
            [id] => 266
            [campaign_id] => 99999
            [lead_id] => 99999
            [tracking_id] => diagnostic-test-1794270641
            [event_type] => open
            [event_time] => 2026-11-10 00:30:41
            [user_agent] => Diagnostic Tool
            [ip_address] => 74.7.227.135
            [clicked_url] => 
        )

)

除錯完成

如果以上所有步驟都顯示 ✅，請訪問：