Hallo all,
I am trying to install osTicket on my local maching (xammp - on macOS) und getting the following errors while installing.
Fatal error: Uncaught mysqli_sql_exception: Table 'osticket.os_config' doesn't exist in /opt/lampp/htdocs/helpdesk/include/mysqli.php:189
I want to install osticket on my localmachine to test it first before I think of using it on a live server.
System requirements are met as follows.
Mac Os 12.4
xampp (VM) - version 8.1.6.0
PHP - version 8.1.6
MariaDB - version 10.4.24
Apache - version 2.4.53
osTicket version 1.16.3 downloaded , unzipped and the "upload" folder moved to htdocs (html / www).
The initial script from osticket confirmed all requirements except 2 recommended (to increase speed of app) were not installed.
Permissions for ost-config.php changed as mentioned and bootstrap.php edited as mentioned in documentation to show errors while installing.
A new database using phpmyadmin created and a new user with all permissions including GRANT created for this new database.
After submitting I am getting an Error 500 on the browser. I have tried using brave, safari, chrome and firefox in normal and incognito mode.
I get the same following error in the Browser: Fatal error: Uncaught mysqli_sql_exception: Table 'osticket.os_config' doesn't exist in /opt/lampp/htdocs/helpdesk/include/mysqli.php:189 Stack trace: #0 /opt/lampp/htdocs/helpdesk/include/mysqli.php(189): mysqli->query('SELECT * FROM ...', 0) #1 /opt/lampp/htdocs/helpdesk/setup/inc/class.installer.php(106): db_query('SELECT * FROM...', false) #2 /opt/lampp/htdocs/helpdesk/setup/install.php(52): Installer->install(Array) #3 {main} thrown in /opt/lampp/htdocs/helpdesk/include/mysqli.php on line 189
Why am I getting this error? Why is the table os_config being tried to be found when it has not been created it in the first place? The database is empty. Nowhere in the documentation is it mentioned that I need to create empty tables first or use a template.
The php error log in XAMPP is also hinting to the same situation:
[17-Jul-2022 21:54:00 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'osticket.os_config' doesn't exist in /opt/lampp/htdocs/helpdesk/include/mysqli.php:189
Stack trace:
#0 /opt/lampp/htdocs/helpdesk/include/mysqli.php(189): mysqli->query('SELECT * FROM ...', 0)
#1 /opt/lampp/htdocs/helpdesk/setup/inc/class.installer.php(106): db_query('SELECT * FROM...', false)
#2 /opt/lampp/htdocs/helpdesk/setup/install.php(52): Installer->install(Array)
#3 {main}
thrown in /opt/lampp/htdocs/helpdesk/include/mysqli.php on line 189
Apache doesn’t log any errors.
I am totally confused.
Would like get some help for this situation.
-Sidd
