資料庫寫入測試

步驟 1：檢查資料庫檔案

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

步驟 2：連接資料庫

✅ 資料庫連接成功

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

✅ 資料表 'rise_auto_sales_tracking_events' 存在

步驟 4：查看現有記錄

目前記錄數量: 176 筆

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

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

步驟 6：再次查看記錄數

目前記錄數量: 177 筆

最近 5 筆記錄：
Array
(
    [0] => Array
        (
            [id] => 177
            [campaign_id] => 999
            [lead_id] => 999
            [tracking_id] => debug-test-1778390175
            [event_type] => open
            [event_time] => 2026-05-10 05:16:15
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            [ip_address] => 216.73.217.67
            [clicked_url] => 
        )

    [1] => Array
        (
            [id] => 176
            [campaign_id] => 99999
            [lead_id] => 99999
            [tracking_id] => diagnostic-test-1778345812
            [event_type] => open
            [event_time] => 2026-05-09 16:56:52
            [user_agent] => Diagnostic Tool
            [ip_address] => 57.141.0.60
            [clicked_url] => 
        )

    [2] => Array
        (
            [id] => 175
            [campaign_id] => 99999
            [lead_id] => 99999
            [tracking_id] => diagnostic-test-1777990711
            [event_type] => open
            [event_time] => 2026-05-05 14:18:31
            [user_agent] => Diagnostic Tool
            [ip_address] => 57.141.0.16
            [clicked_url] => 
        )

    [3] => Array
        (
            [id] => 174
            [campaign_id] => 88888
            [lead_id] => 88888
            [tracking_id] => web-test-1774907038
            [event_type] => open
            [event_time] => 2026-03-30 21:44:05
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)
            [ip_address] => 74.7.227.184
            [clicked_url] => 
        )

    [4] => Array
        (
            [id] => 173
            [campaign_id] => 1
            [lead_id] => 1
            [tracking_id] => test456
            [event_type] => click
            [event_time] => 2026-03-30 21:44:04
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)
            [ip_address] => 74.7.227.184
            [clicked_url] => https://google.com
        )

)

除錯完成

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