search

dboehmer / coocook

👨‍🍳🦉 Web application for collecting recipes and making food plans
https://coocook.org/
Other
11 stars 2 forks source link

Internal server error when deleting project #92

Closed ChristinaSi closed 5 years ago

ChristinaSi commented 5 years ago

When you try to delete a project and click the button delete an error message appears "Internal server error". screenshot_server_error

dboehmer commented 5 years ago

This was often triggered by a series of DELETE FROM SQL statements for deleting all the project data. Unfortunately the database layer didn't correctly just JOIN the related tables but retrieved all row IDs and then sent them back to delete them. It al blew up when the SQL statement became longer than allowed.

This should be solved with the major database fixups in the fix-cascade-delete branch that was merged in 76a9558b38fe7a84606f56e97ef737809f33b6aa.