Installation problem during populate database osTicket 1.16

RaFFy91

Hello everyone,

I have a problem with a fresh installation of osTicket 1.16 on my:

Windows Server 2016 with IIS 10
PHP 8.1.3
MySQL 5.5

but I don't know why it takes this error after fill all of the information about the company, the admin, the database:

PHP Fatal error: Uncaught mysqli_sql_exception: Table 'osticket.ost_config' doesn't exist in C:\inetpub\wwwroot\TICKET\include\mysqli.php:189
Stack trace:
#0 C:\inetpub\wwwroot\TICKET\include\mysqli.php(189): mysqli->query()
#1 C:\inetpub\wwwroot\TICKET\setup\inc\class.installer.php(106): db_query()
#2 C:\inetpub\wwwroot\TICKET\setup\install.php(52): Installer->install()
#3 {main}
thrown in C:\inetpub\wwwroot\TICKET\include\mysqli.php on line 189

I have tried with PHP 8 but I have other errors.

Can you help me?
Best Regards

KevinTheJedi

RaFFy91

None of the osTicket versions support PHP 8.1. v1.16.1 only supports PHP 8.0. Install v1.16.1 with PHP 8.0 and retest. If you run into errors then look at the current patches on GitHub and apply them.

Cheers.

RaFFy91

Hello,

I have tried with PHP 8.0 but this is the new error:

PHP Fatal error: Uncaught InvalidArgumentException: List indices should be integers in C:\inetpub\wwwroot\TICKET\include\class.util.php:205
Stack trace:
#0 C:\inetpub\wwwroot\TICKET\include\class.forms.php(84): ListObject->offsetExists()
#1 C:\inetpub\wwwroot\TICKET\include\class.ticket.php(3986): Form->getField()
#2 C:\inetpub\wwwroot\TICKET\include\class.ticket.php(4178): Ticket::filterTicketData()
#3 C:\inetpub\wwwroot\TICKET\setup\inc\class.installer.php(312): Ticket::create()
#4 C:\inetpub\wwwroot\TICKET\setup\install.php(52): Installer->install()
#5 {main}
thrown in C:\inetpub\wwwroot\TICKET\include\class.util.php on line 205

Thanks

RaFFy91

I see that now the database is populated but still this error:

KevinTheJedi

RaFFy91

That’s an obscure issue I was never able to replicate. I would assume it’s something weird with your PHP/MySQL setup. Please retry a fresh install again with v1.16.1, PHP 8.0 (with all extensions installed/enabled), MySQL 8, and Apache/IIS.

Cheers.

RaFFy91

Goodmorning,

nothing... I have installed the MySQL 8 but nothing change..... I'm desperated:
PHP Fatal error: Uncaught InvalidArgumentException: List indices should be integers in C:\inetpub\wwwroot\TICKET\include\class.util.php:205
Stack trace:
#0 C:\inetpub\wwwroot\TICKET\include\class.forms.php(84): ListObject->offsetExists()
#1 C:\inetpub\wwwroot\TICKET\include\class.ticket.php(3986): Form->getField()
#2 C:\inetpub\wwwroot\TICKET\include\class.ticket.php(4178): Ticket::filterTicketData()
#3 C:\inetpub\wwwroot\TICKET\setup\inc\class.installer.php(312): Ticket::create()
#4 C:\inetpub\wwwroot\TICKET\setup\install.php(52): Installer->install()
#5 {main}
thrown in C:\inetpub\wwwroot\TICKET\include\class.util.php on line 205

RaFFy91

What can I do?

KevinTheJedi

RaFFy91

Yea it seems your installer isn't working right. Please make sure the site you're using is in-fact using PHP 8.0 and has all suggested/required PHP extensions installed/enabled. Create a php_info file in the site and visit it in the browser to make absolutely sure it's using PHP 8.0. Once you confirm it's using PHP 8.0 please re-download the v1.16.1 files from our website and do a fresh install.

I cannot trace the issue exactly as I cannot replicate this at all.

Cheers.

RaFFy91

The problem was the extensions of PHP.... I don't know why, I have swapped the extensions of re-downloaded PHP8 and now it works.

Really thanks for the support