Install failing

dfite

I'm installing osTicket on Debian 11 with Apache2, PHP 8.1.2, MariaDB 15.1 and osT 1.16. I've run into a dead stop error during the setup phase after inputting database credentials and clicking the "Install Now" button I get an error 500.

The apache logs show this:
[Tue Feb 08 18:40:55.678100 2022] [proxy_fcgi:error] [pid 983] [client 192.168.113.4:49539] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Table 'osticket.ost_config' doesn't exist in /var/www/html/support/upload/include/mysqli.php:189\nStack trace:\n#0 /var/www/html/support/upload/include/mysqli.php(189): mysqli->query()\n#1 /var/www/html/support/upload/setup/inc/class.installer.php(106): db_query()\n#2 /var/www/html/support/upload/setup/install.php(52): Installer->install()\n#3 {main}\n thrown in /var/www/html/support/upload/include/mysqli.php on line 189', referer: https://support.....com/setup/install.php

It almost appears this version of osTicket is too new for prime time now that I see the forum is completely empty! Any advice?

KevinTheJedi

@dfite

I am unable to replicate this issue using Apache, PHP 8.0, MySQL 8.0, and v1.16. Downgrade to PHP 8.0 and retest.

Cheers.

dfite

Looks like that did it. Removing php8.1 and installing php8.0 making sure all the extensions were installed and passed the precheck and boom it's installed. Thanks Kevin! I think the documentation says "PHP 8.0+" and should be updated to reflect 8.0 ONLY for now.

Cheers.

KevinTheJedi

dfite

Here is the update for that:

https://github.com/osTicket/osTicket/pull/6066

This will be merged soon.

Cheers.

dfite

Unrelated directly to the above but more so about the readiness for 1.16 as a "stable" edition: even after downgrading to PHP8.0 I'm getting a lot of bugs, plugins not working, etc. I think I'm going to tear it all apart and restart this exploration project with 1.15 for the foreseeable future.

KevinTheJedi

@dfite

Can you add the errors here? I'm interested at what you are seeing as I don't see any errors.

Also, with plugins we added PHP 8 support yesterday. The newly built plugins are available on our website.

Cheers.

jil7003

I got same error:
Uncaught mysqli_sql_exception: Table 'osTicket.ost_confi
g' doesn't exist in /var/www/html/osTicket/include/mysqli.php:189\nStack trace:\
n#0 /var/www/html/osTicket/include/mysqli.php(189): mysqli->query()\n#1 /var/www
/html/osTicket/setup/inc/class.installer.php(106): db_query()\n#2 /var/www/html/
osTicket/setup/install.php(52): Installer->install()\n#3 {main}\n thrown in /va
r/www/html/osTicket/include/mysqli.php on line 189, referer: http://192.168.112.
129/setup/install.php

php -v
PHP 8.1.3 (cli) (built: Feb 16 2022 01:00:24) (NTS gcc x86_64)
Copyright (c) The PHP Group
Zend Engine v4.1.3, Copyright (c) Zend Technologies

mysql Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

version: Apache/2.4.6 (CentOS)

Any advice? Thanks!

jil7003

osTicket version: osTicket-v1.16.1

KevinTheJedi

jil7003

Please read the minimum requirements before installing/upgrading. You must downgrade to PHP 8.0. None of the current osTicket versions support PHP 8.1 at this time.

Cheers.

jil7003

Thanks Kevin, it works after I downgrade PHP 8.1 to PHP 7.4

KevinTheJedi

@jil7003

If you are running v1.16.1 then you must use PHP 8.0 as it does not support PHP 7.4 or below nor PHP 8.1. If you use PHP 7.4 then you will run into issues.

Cheers.