mariadb key work "lock" and won't create table. #691

New issue

Closed

opened 2026-02-25 21:35:41 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 21:35:41 +03:00

Owner

Originally created by @jeremiah on GitHub (Sep 5, 2025).
Original GitHub issue: https://github.com/cypht-org/cypht/issues/1658

Originally assigned to: @Baraka24 on GitHub.

🐛 Bug

https://github.com/cypht-org/cypht/blame/a5498a45e67525379aa9d1d17418f5534c00fef2/config/database.php#L78

The instructions for creating a table for MySQL / MariaDB / SQLite include the column name "lock" which is a reserved keyword in mysql. Has this schema been tested since MySQL / MariaDB on Debian 13 will not create this table.

Version & Environment

Rev: [master-cypht]

OS: [Debian 13]

Originally created by @jeremiah on GitHub (Sep 5, 2025). Original GitHub issue: https://github.com/cypht-org/cypht/issues/1658 Originally assigned to: @Baraka24 on GitHub. ## 🐛 Bug https://github.com/cypht-org/cypht/blame/a5498a45e67525379aa9d1d17418f5534c00fef2/config/database.php#L78 The instructions for creating a table for MySQL / MariaDB / SQLite include the column name "lock" which is a reserved keyword in mysql. Has this schema been tested since MySQL / MariaDB on Debian 13 will not create this table. ### Version & Environment Rev: [master-cypht] OS: [Debian 13]