Fix door sensor endpoint #105

New Issue

oysteikt · 2026-01-09T19:04:36+01:00

oysteikt commented

2026-01-09 19:04:36 +01:00

There is likely a mismatch between the expected schema and the schema used in the prod database

Screenshot sent by @berntjd in maintenance discord channel

There is likely a mismatch between the expected schema and the schema used in the prod database Screenshot sent by @berntjd in maintenance discord channel

Screenshot_20260108-163503.png

253 KiB

oysteikt added the bug crash report labels 2026-01-09 19:04:36 +01:00

felixalb commented

2026-01-11 21:43:38 +01:00

It looks like the correct payload format for https://git.pvv.ntnu.no/Projects/nettsiden/src/branch/main/www/door/index.php#L64-L81, and used to work fine.

There is likely a mismatch between the expected schema and the schema used in the prod database

Has the door table been dropped or altered, and if so, why? Taking a look.

It looks like the correct payload format for https://git.pvv.ntnu.no/Projects/nettsiden/src/branch/main/www/door/index.php#L64-L81, and used to work fine. > There is likely a mismatch between the expected schema and the schema used in the prod database Has the door table been dropped or altered, and if so, why? Taking a look.

felixalb commented

2026-01-11 21:48:10 +01:00

MariaDB [www-data_nettside]> SELECT * FROM door ORDER BY time DESC LIMIT 3;
+------------+------+
| time       | open |
+------------+------+
| 1767079800 |    0 |
| 1767078900 |    0 |
| 1767078000 |    0 |
+------------+------+
3 rows in set (0.000 sec)

Well, the table exists and looks sane, and stops at 1767079800, which is Tuesday, December 30, 2025 8:30:00 AM (Norwegian time)

``` MariaDB [www-data_nettside]> SELECT * FROM door ORDER BY time DESC LIMIT 3; +------------+------+ | time | open | +------------+------+ | 1767079800 | 0 | | 1767078900 | 0 | | 1767078000 | 0 | +------------+------+ 3 rows in set (0.000 sec) ``` Well, the table exists and looks sane, and stops at 1767079800, which is `Tuesday, December 30, 2025 8:30:00 AM` (Norwegian time)

Sign in to join this conversation.

No Assignees

2 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Projects/nettsiden#105