search

alextselegidis / easyappointments

:date: Easy!Appointments - Self Hosted Appointment Scheduler
https://easyappointments.org
GNU General Public License v3.0
3.33k stars 1.27k forks source link

DB Issue #913

Closed wvdvegt closed 4 years ago

wvdvegt commented 4 years ago

Using PHP Version 7.3.11 and trying to do a fresh install of the prerelease i get the following error during database creation:

Error Number: 1005

Can't create table `easyappointments`.`ea_users` (errno: 150 "Foreign key constraint is incorrectly formed")

ALTER TABLE `ea_users` ADD CONSTRAINT `ea_users_ibfk_1` FOREIGN KEY (`id_roles`) REFERENCES `ea_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

Filename: C:/xampp/htdocs/easyappointments/vendor/codeigniter/framework/system/database/DB_driver.php

Line Number: 691
wvdvegt commented 4 years ago

Cause seems to be related to foreign key issues deleting the old tables (phpMyadmin needs to be instructed to ignore foreign keys during dropping the tables).