rudolphi / open_enventory

PHP/MySQL-based chemical inventory/Electronic Lab Notebook for chemistry
https://sourceforge.net/projects/enventory/
GNU Affero General Public License v3.0
9 stars 6 forks source link

Fixes for mariadb 10.6 #15

Closed srtlg closed 2 years ago

srtlg commented 2 years ago

Hello, I've had problems getting it running at all on Alpine 3.15 (MariaDB 10.6.4, PHP 7.4). It seems to enforce all foreign keys. As such, you can only refer to existing tables. In order to make it simpler, foreign key constraints are usually added after all tables have been created, which is what I changed. The remaining changes follow, because some column names were created incorrectly. Furthermore the root/admin user with person_id=0 which is called on startup in lib_server_cache.php:writeCache