search

yungifez / skuul

A multi school management system
https://yungifez.github.io/skuul.org/
MIT License
325 stars 97 forks source link

Migration Issue #355

Closed itsmemanoj closed 11 months ago

itsmemanoj commented 11 months ago

SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'timetable_time_slot_weekday_timetable_time_slot_weekdayable_id_foreign' is too long (Connection: mysql, SQL: alter table timetable_time_slot_weekday add constraint timetable_time_slot_weekday_timetable_time_slot_weekdayable_id_foreign foreign key (timetable_time_slot_weekdayable_id) references timetable_time_slot_weekdayables (id) on delete cascade on update cascade)

Actually above is second error, First error was column renaming, timetable_time_slot_weekday on this table, column renaming from subject_id to timetable_time_slot_weekdayable_id. Error said: key is required for foreign key and can not be renamed. I solved that by alterting table migration, After that above was second error.

To Reproduce Steps to reproduce the behavior:

  1. AFter completeing setup process, just start migration and you get error

Device: Windows 10 Laragon PHP 8.2 Apache

yungifez commented 11 months ago

What version of mysql are you on?

yungifez commented 11 months ago

Hello is this still happening or can I close this issue?