search

jan-vandenberg / cruddiy

No-code Bootstrap PHP CRUD generator
http://cruddiy.com
GNU Affero General Public License v3.0
252 stars 80 forks source link

Uncaught mysqli_sql_exception: Duplicate key name '<tablename>_ibfk_1' #102

Closed germain-italic closed 11 months ago

germain-italic commented 11 months ago

In a fresh install, after adding the second relationship in the same table:

Fatal error: Uncaught mysqli_sql_exception: Duplicate key name '<tablename>_ibfk_1' in D:\Sites\xxxx\www\crud\core\relations.php:142 Stack trace: #0 D:\Sites\xxxx\www\crud\core\relations.php(142): mysqli_query(Object(mysqli), 'ALTER TABLE pro...') #1 {main} thrown in D:\Sites\xxxx\www\crud\core\relations.php on line 142

The id is hard-coded, it looks like it's by design since the begining:

Will throw a quickfix as I need it working now.

germain-italic commented 11 months ago

Details on the fix in #103