HTTP ERROR 500

JerbyYT

When I have completed the installation setup and entered all data with MySQL data etc then HTTP 500 comes up.
I already looked in the Apache log, it says so:

AH01071: Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Table 'TicketWebseite.ticket_config' doesn't exist in /var/www/aromicmc/support/include/mysqli.php:189\nStack trace:\n#0 /var/www/aromicmc/support/include/mysqli.php(189): mysqli->query()\n#1 /var/www/aromicmc/support/setup/inc/class.installer.php(106): db_query()\n#2 /var/www/aromicmc/support/setup/install.php(52): Installer->install()\n#3 {main}\n thrown in /var/www/aromicmc/support/include/mysqli.php on line 189', referer: https://support.aromicmc.net/setup/install.php

And that means that there is no table named ticket_config in TicketWebseite.
There are also none created. This should be done by the installer that I run.
What can I do?

Sincerely,
JerbyYT

KevinTheJedi

JerbyYT

I've seen a few people report this. I'll see if I can replicate it. Until then just clear the database and retry the install.

Cheers.

KevinTheJedi

I just tested a new install for v1.16.3 with PHP 8.0.13, MySQL 8.0.28, and Apache 2.4.51 on CentOS Stream 9. I could not replicate this issue so I'm unsure what's going on exactly.

Can you please list your installed system packages (PHP, Apache, and MySQL) with the exact version numbers? Also, list what distribution of linux you are using.

Cheers.

JerbyYT

KevinTheJedi
PHP 8.1.7
Apache 2.4.53
10.5.15-MariaDB-0+deb11u1

KevinTheJedi

JerbyYT

Ahhh, that's your issue. 1.16.x requires PHP 8.0.x. Please always check the requirements before installing/upgrading. You must downgrade your PHP to 8.0.x and you should be good.

Cheers.

JerbyYT

Okay, still finishing my Fallguys round, then I'll test it.
Thanks in advance.

KevinTheJedi

JerbyYT

OFF TOPIC:
Did you happen to watch the recent Twitch Rivals event with Fall Guys? Super fun to watch.

JerbyYT

No, unfortunately not

JerbyYT

KevinTheJedi

JerbyYT

Did you download v1.16.3 from our website?

Cheers.

JerbyYT

KevinTheJedi
From github

KevinTheJedi

JerbyYT

Always use the packaged version available on our website if possible. Retest using the packaged version on our website and see if that works.

Cheers.

JerbyYT

KevinTheJedi
No, did not help

JerbyYT

KevinTheJedi
Can I contact you via Discord and you set it up for me?

KevinTheJedi

JerbyYT

On the installer page where it checks your prerequisites do you see it saying PHP 8.0.20 or PHP 8.1.7? It could be that your site is still running PHP 8.1.

Cheers.

JerbyYT

KevinTheJedi
Oh yea, it say 8.1 how can i change it?

JerbyYT

KevinTheJedi

JerbyYT

You probably have an Apache config that is pointing to a specific version of PHP. You most likely need to update that config to point to PHP 8.0 and then restart Apache.

I don’t know what distro of Linux you are running but you should be able to do a quick search on how to change the PHP version for Apache on your distro.

Cheers.

JerbyYT

KevinTheJedi
I made it, thank you 😃
Is there an osTicket Discord?

KevinTheJedi

JerbyYT

If there is it’s not an official one. We used to have an IRC chat for a short period but not anymore.

Cheers.