Installation available Version in TI

sonnmatt

I was so excited to discover such a Website for food order. Thanks a lot to all who has worked for such a nice site.

I wanted to install last available Version of TI from Website with installer. It installs v 3.2
.
Tested to install with Installer and Line composer: Installation with theme and extention is not possible, it shows us always foreign key issue. I have installed without theme and extention, installation is possible without anything, in somewehere it shows me always foreign key message:

Addint new item
Adding menu option
Place order

I would like to use TI, please advice me, what am i doing wrong? Or any issue in code?
Regards
Sonnmatt

ryanmitchell

Can you advise on the environment you are installing to? I did a fresh install this morning on MySQL 5.7 and Ubuntu 20.20 without any issues.

I didnt include the automation extension or broadcast events from the suggested plugins.

sonnmatt

ryanmitchell Thanks for your answer. I have following infos: (get from server)

Server: Localhost via UNIX socket
Server-Typ: MariaDB
Server-Verbindung: SSL wird nicht verwendet Dokumentation
Server-Version: 10.3.32-MariaDB - MariaDB Server
Protokoll-Version: 10
Benutzer: cpses_mac6o03z07@localhost

Server-Zeichensatz: cp1252 West European (latin1)

cpsrvd 11.100.0.5
Datenbank-Client Version: libmysql - 5.6.43
PHP-Erweiterung: mysqliDokumentation curlDokumentation mbstringDokumentation

PHP-Version: 7.3.33

And in Cpanel i have choosed php 8.

I will test now without automation extension or broadcast events with same environnment.

ryanmitchell

If it doesnt work without those extensions it may be worth trying MySQL rather than MariaDB

sonnmatt

ryanmitchell WIthout those extention (apdate after installation) i have same issue. MYSQL and MariaDB need to be changed from Server. I will write to them.

in your installation you can add Items and option to any menu? With my installation it is not possible.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (maestropizzalupf_database.ti_menu_categories, CONSTRAINT ti_menu_categories_menu_id_foreign FOREIGN KEY (menu_id) REFERENCES ti_menus (menu_id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into ti_menu_categories (category_id, menu_id) values (1, 2))

I have spoken with server support, he said me that it is not possible to change it, in fact they are the same.
that mean i need to use my Server as it is, with this Setting i sent you before. A friend of mine has installed TI version 3.1 some Month ago, it is working . He has same Server. Installer install only V3.2, not 3.1
Possible to have always 3.1 ?

sonnmatt

ryanmitchell I am now almost sure that Problem is in Version 3.2 . My Friend has installed several times v3.1 it is working well on same Server with same setting. To use extentions, it is necessary to update system otherweise it is not possible to install Extentions.

it is not possible to do with V3.2:

install with theme and demo Data
-Add new Item
-Add menu option
-Place order

Can you pls suggest me a way?
Regards
Sonnmatt