t=1（不含任何变量），保存参数 → 断电重启 → 等 2 分钟：...&imei=...&t=1 ⇒ 上报通道正常，问题是 GPS 没定位（看 1PPS LED 是否 1 秒闪、天线朝天）lon=${GPSLON}&lat=${GPSLAT}&lont=${GPSLONT}&latt=${GPSLATT}&csq=${CSQ}。
&lon= 才对；
若是 862323084278467lon=118.043（黏在一起）⇒ Url 与上报内容之间少了一个 &，
去「网络通道 → 请求的Url」末尾补一个 &（见下表第 2 行）| 日志表现 | 含义与处理 |
|---|---|
qs 带 &lon=...&lat=... → OK |
✅ 坐标已入库，一切正常 |
qs 里 imei=862...467lon=118.043 黏在一起（imei 后面少了 &）→ OK(GLUE) 或 CONFIG ERROR |
❌ Url 与「主动上报内容」之间少了一个 &。DTU 是把上报内容直接拼在「请求的Url」后面的，不会自动补分隔符： Url 末尾 ...&imei=862323084278467 ＋ 上报内容 lon=118.043...
⇒ ...imei=862323084278467lon=118.043...，结果 imei 的值被污染、lon 参数根本不存在，服务器只能回 OK(NO FIX)。 ✅ 推荐改法（最安全）：在「网络通道 → 请求的Url」末尾补一个 &/gps/api/upload.php?key=gps2026&imei=862323084278467& ← 末尾这个 &「主动上报内容」保持原样，不要在它开头加 &。⚠️ 2026-09-13 实测：往「主动上报内容」开头加 & 之后，定位上报整条静默（改那个框容易连带动坏「是否启动」）。新版 upload.php 已能自动容错（坐标照样救回来入库、响应标 OK(GLUE)），但仍请按上面改配置根治。 |
qs 带 {"imei":...,"csq":..} → OK(REG) |
🟡 设备已连上服务器（这是注册包，不含坐标，属正常现象）。 若长期只有注册包、没有任何带坐标的记录：① 看设备 1PPS/GPS 指示灯是否 1 秒闪烁（闪=定位成功，不闪=未定位）； ② 设备必须移到室外空旷处，无源陶瓷天线正面朝天（室内定位不了，冷启动 23~35 秒，首次可能几分钟）； ③ 再检查「定位 → GPS定位」是否启动=启动、格式=自定义、上报网络通道=网络通道1 |
qs 里出现两个 imei=（或两个 key=）→ CONFIG ERROR |
❌ 你把 imei=${IMEI}（或 key=）填进了「定位 → GPS定位 → 主动上报内容」。该框只能填 GPS 变量： &lon=${GPSLON}&lat=${GPSLAT}&lont=${GPSLONT}&latt=${GPSLATT}&csq=${CSQ}key / imei 属于「网络通道 → 请求的Url」，两个框不要混。 |
qs 只有 key=&imei= → OK(NO FIX) |
❌ 设备能连但没有坐标。新版 upload.php 会把日志再细分，看日志尾部有没有内容： ① 尾部还有内容（例 &imei=...&csq=22、&lon=&lat=）
⇒ 定位上报确实在跑，就是 GPS 没定位 → 看 1PPS LED 是否 1 秒闪 + 天线朝天；② 尾部什么都没有、只有 key+imei
⇒ 「定位」页的上报根本没在跑 → 查「是否启动=启动」「上报网络通道=网络通道1」，改完必须保存参数 + 断电重启；③ 若 imei 与 lon 黏成一条 ⇒ 见上面第 2 行（缺 &） |
| KEY ERROR | ❌ Url 里漏了 key=gps2026 |
| 日志一片空白 | ❌ 请求根本没进 PHP：DTU 必须配 https:// + 端口443 + 支持SSL=加密（服务器已强制 http→https 跳转，DTU 不跟随重定向）；也可能设备离线/SIM 欠费 |
| 时间 | 客户端IP | QueryString 原始内容 | 响应 / 判定 |
|---|---|---|---|
| 2026-09-28 07:25:45 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9793&lat=24.59531&lont=E&latt=N&csq=29 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:44 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9794&lat=24.59526&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:43 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9794&lat=24.59522&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:42 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59519&lont=E&latt=N&csq=27 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:41 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59515&lont=E&latt=N&csq=27 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:40 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59512&lont=E&latt=N&csq=25 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:39 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59508&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:38 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59505&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:37 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59503&lont=E&latt=N&csq=26 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:36 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59502&lont=E&latt=N&csq=29 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:35 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59501&lont=E&latt=N&csq=26 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:34 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.97960662800&lat=24.595123291000&lont=E&latt=N&csq=22&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:34 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59500&lont=E&latt=N&csq=30 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:33 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59500&lont=E&latt=N&csq=28 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:32 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59499&lont=E&latt=N&csq=26 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:31 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59500&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:30 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59500&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:29 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.97964477500&lat=24.595104218000&lont=E&latt=N&csq=22&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:29 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59500&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:28 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59499&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:27 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9795&lat=24.59497&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:26 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9796&lat=24.59494&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:25 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9796&lat=24.59491&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:24 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.97966766400&lat=24.595085144000&lont=E&latt=N&csq=25&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:24 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9797&lat=24.59486&lont=E&latt=N&csq=28 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:23 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9797&lat=24.59481&lont=E&latt=N&csq=28 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:22 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9798&lat=24.59476&lont=E&latt=N&csq=27 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:21 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9799&lat=24.59469&lont=E&latt=N&csq=25 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:20 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9799&lat=24.59462&lont=E&latt=N&csq=25 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:19 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.97995758100&lat=24.594833374000&lont=E&latt=N&csq=21&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:19 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9800&lat=24.59454&lont=E&latt=N&csq=24 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:18 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9800&lat=24.59444&lont=E&latt=N&csq=27 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:17 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9801&lat=24.59436&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:16 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9801&lat=24.59431&lont=E&latt=N&csq=28 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:15 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9802&lat=24.59429&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:14 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.98023986800&lat=24.594669342000&lont=E&latt=N&csq=29&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:14 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9803&lat=24.59429&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:12 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9803&lat=24.59430&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:11 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9804&lat=24.59432&lont=E&latt=N&csq=28 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:10 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9805&lat=24.59436&lont=E&latt=N&csq=29 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:09 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9805&lat=24.59441&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:09 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.98047637900&lat=24.594869614000&lont=E&latt=N&csq=28&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:08 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9806&lat=24.59447&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:07 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9807&lat=24.59453&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:06 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9808&lat=24.59461&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:05 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9809&lat=24.59470&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:04 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9812&lat=24.59490&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:04 | 223.104.55.2 | key=gps2026&imei=862323084278467&lon=117.98091125500&lat=24.595264435000&lont=E&latt=N&csq=31&alt=${GPSALT}&spd=${GPSSPEED} | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:03 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9813&lat=24.59502&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
| 2026-09-28 07:25:02 | 223.104.55.171 | key=gps2026&imei=866965083944899&lon=117.9815&lat=24.59515&lont=E&latt=N&csq=31 | FAIL | stmt:Column 'alt_wgs84' cannot be null | conn:Column 'alt_wgs84' cannot be null |
仅显示最近 50 条