1452 Cannot add or update a child row: a foreign key constraint fails

artkrutt

When trying to register a new customer user following error appears.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`databasenameredacted`.`ti_customers`, CONSTRAINT `ti_customers_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `ti_customer_groups` (`customer_group_id`) ON DELETE SET NUL) (SQL: insert into `ti_customers` (`first_name`, `last_name`, `email`, `password`, `remember_token`, `telephone`, `newsletter`, `status`, `customer_group_id`, `updated_at`, `created_at`) values (Test, Test, test@test.com, $2y$10$mDHMaEBjQLOI6uKPRr1iRO20len4C.OgM0t7eb0XOIHrSV6qjIGVq, ?, 123456, 1, 1, 11, 2021-11-28 18:37:53, 2021-11-28 18:37:53))

Same issue from some other user on github tastyigniter/TastyIgniter894

abdulrazak-zakieh

Facing the same problem. How to solve it?

artkrutt

abdulrazak-zakieh

Fix was pushed a few hours ago tastyigniter/ti-ext-user6f54914
Just check for extension update

abdulrazak-zakieh

Thanks. I will check

abdulrazak-zakieh

It worked. Thanks again.

adminkk

hi there .
please help. the final setup it’s not working this is the message that show up (Setting up your application… 🍲
Finishing site setup failed. See setup log.)

berkcel

adminkk To install V3.2 make following:

Install TI without any DemoData, any theme or any Extention, only TI.
Once installed, go to admin
Put your key and “System-extention-Install Recommended Extentions”
Activate your Theme
Installation and update is succesfull. Now you can add Category BUT you cannot add any ITEM and you cannot make any Order. You get foreign key error. For this you need to make some steps in your sql:

go to your php admin (in your cpanel) and execute following commands:

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;

After all this you can use your Installation. After some days efforts, it was good with me !
Good Luck 🙂

adminkk

HI there
i tried many time still not working . still the same . please help

berkcel

adminkk How did you install TI? You have removed all features, no data, no theme, no extention?
remove all this options and install only TI first