資料庫寫入測試

步驟 1：檢查資料庫檔案

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

步驟 2：連接資料庫

✅ 資料庫連接成功

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

✅ 資料表 'rise_auto_sales_tracking_events' 存在

步驟 4：查看現有記錄

目前記錄數量: 186 筆

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

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

步驟 6：再次查看記錄數

目前記錄數量: 187 筆

最近 5 筆記錄：
Array
(
    [0] => Array
        (
            [id] => 187
            [campaign_id] => 999
            [lead_id] => 999
            [tracking_id] => debug-test-1787819918
            [event_type] => open
            [event_time] => 2026-08-27 08:38:38
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            [ip_address] => 216.73.216.232
            [clicked_url] => 
        )

    [1] => Array
        (
            [id] => 186
            [campaign_id] => 999
            [lead_id] => 999
            [tracking_id] => debug-test-1786760483
            [event_type] => open
            [event_time] => 2026-08-15 02:21:23
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.4; +https://openai.com/gptbot)
            [ip_address] => 74.7.243.247
            [clicked_url] => 
        )

    [2] => Array
        (
            [id] => 185
            [campaign_id] => 99999
            [lead_id] => 99999
            [tracking_id] => diagnostic-test-1786196039
            [event_type] => open
            [event_time] => 2026-08-08 13:33:59
            [user_agent] => Diagnostic Tool
            [ip_address] => 17.241.219.203
            [clicked_url] => 
        )

    [3] => Array
        (
            [id] => 184
            [campaign_id] => 999
            [lead_id] => 999
            [tracking_id] => debug-test-1786123894
            [event_type] => open
            [event_time] => 2026-08-07 17:31:34
            [user_agent] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)
            [ip_address] => 17.22.237.218
            [clicked_url] => 
        )

    [4] => Array
        (
            [id] => 183
            [campaign_id] => 88888
            [lead_id] => 88888
            [tracking_id] => web-test-1783876888
            [event_type] => open
            [event_time] => 2026-07-12 17:21:34
            [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.4; +https://openai.com/gptbot)
            [ip_address] => 74.7.227.45
            [clicked_url] => 
        )

)

除錯完成

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