Can't checkout any orders after update

firmsites270

Hi again, after updating to latest version the other day I’ve just found out as the cafe opened this morning that no orders will process.

Every time I try and press confirm at the checkout page I get the following pop up:

"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (ix000089_mannadelivery.ti_order_menus, CONSTRAINT order_menus_menu_id_foreign FOREIGN KEY (menu_id) REFERENCES ti_menus (menu_id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into ti_order_menus (order_id, menu_id, name, quantity, price, subtotal, comment, option_values) values (960, 205, 6oz Jurassic Burger, 1, 3.7, 3.7, , O:34:“Igniter\Flame\Cart\CartItemOptions”:2:{s:8:“items”;a:0:{}s:28:“escapeWhenCastingToString”;b:0;}))
"

Please advise how to fix as I am getting people trying to order and no data coming in 🙁

firmsites270

Can anyone help please? I followed the advised steps to upgrade and now I have no usable ordering system for a live location

ryanmitchell

Did you do a search for the answer? There are some other posts with this answered… see:

Dec 23, 2021
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;

firmsites270

I have seen others reference this when using demo data, but this is not the case for my issue. This is a live site with real data that was working perfectly prior to the update. Hence asking in here what the best course of action is.

If you think the above is safe to run then I am happy to try it but I did search extensively prior to posting and could find no other post that seemed to be the same situation.

Many thanks

ryanmitchell

This will remove the foreign key constraint which is what you need