Installation gives always foreign key error

berkcel

PLEASE HELP, need to install urgently !
Instalation with Installer or with line composer shows always some errors about foreign key.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magentex_datenbank.ti_menu_item_options, CONSTRAINT ti_menu_item_options_menu_id_foreign FOREIGN KEY (menu_id) REFERENCES ti_menus (menu_id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into ti_menu_item_options (option_id, menu_id) values (4, 1))

xujiongze

Look like some error when you add a menu, do you installed with demo data ? Try to install TI only

And here has other way to install:
https://forum.tastyigniter.com/d/2625-update-from-308-to-311-crashed/17

berkcel

xujiongze I have installed TI without any data and theme. Only TI, then it is not possible to add any menu or or category. Not possible to create any user and place order.I have same message with line composer installation.

xujiongze

berkcel

What version mysql uses ? I remember TI only support mysql 8

ryanmitchell

TI requires mysql 5.7 or higher. I don’t experience this issue when I use it on 5.7 or 8.0

berkcel

ryanmitchell Last version 3.2 cannot be installed. It doesnt matter if you install with line composer or with installer. It doesnt matter with sample data or without. Has anyone an idea? (PHP 8, mysql 5.7 or higher)

PLEASE INSTALL AND ADD A CATEGORY AND A PRODUCT, YOU WILL SEE WHAT I MEAN !!

Thank you very much for any kind of suggestion.

kepos

berkcel The same happen to me. Did you fixed it?

berkcel

kepos Yes we have fixed. I followed the instructions of a developper, it is now working. He proposed me to make some steps in sql in database: You can try at your own risk. Good luck !

ALTER TABLE ti_menu_mealtimes DROP FOREIGN KEY ti_menu_mealtimes_menu_id_foreign;
ALTER TABLE ti_menus_specials DROP FOREIGN KEY ti_menus_specials_menu_id_foreign;
ALTER TABLE ti_menu_categories DROP FOREIGN KEY ti_menu_categories_menu_id_foreign;
ALTER TABLE ti_order_menus DROP FOREIGN KEY ti_order_menus_menu_id_foreign;

kepos

berkcel Thank you for your reply. I will try.