updater error

Gianluca

Hello guys,
I move from a linux instance to IIS istance my osticket.
At the same time I updated from 1.14 to 1.16 but I have 2 problem.
1)While importing the database, I get an error message from the table 'ost_search' (error # 1214 the table used does not support indexes FULL TEXT);
2) After login users are unable to open new ticket because they get the message "Unable to create a ticket. Correct any errors below and try again." but all fields are complete.
I also tried using version 1.14 but I always get the same errors.
I usage IIS 10, MardiaDB5.5 e PHP 8 (for 1.14 PHP 7.4)
Thank for all

KevinTheJedi

Gianluca

IIS is deprecating PHP 8 and not providing any support for it. So I wouldn't rely on IIS too much longer.

1.) It appears your instance of MySQL is older than 5.5 which cannot handle FULL TEXT for ost__search table. If you upgrade MySQL to 5.5+ this error will go away.

2.) You probably had other issues that is causing this issue. Please review all logs (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.) for any related errors.

Cheers.

Gianluca

Thank,
I tried to move everything to a windows instance with wampserver but the problems are still the same.
p.s. I have the 5.5 because that version is required among the requirements.
On the linux machine I have no errors. if I try to do anything everything is fine.
I thought it was a DB export problem.
I tried with the mysqldump command and with phpmyadmin but the problem reoccurs as it is

KevinTheJedi

Gianluca

Then you could either import without that table and rebuild and setup a cron to reindex or you could try editing the SQL file and changing the engine for that table to MyISAM and import.

Cheers.