Error on initial configuration

bill_w

I am doing a new installation of 1.15 and I am getting an error when submitting setup/install.php.

Ubuntu 20.04, Apache 2.4.41 and HAProxy 2.0.13 (ssl terminating), PHP 7.4.3, MySQL 8.0.22

Fatal error: Uncaught Error: Call to a member function getDefaultDeptId() on null in /srv/osticket/include/class.dept.php:867 Stack trace: #0 /srv/osticket/include/class.dept.php(748): Dept->update() #1 /srv/osticket/include/class.i18n.php(82): Dept::__create() #2 /srv/osticket/setup/inc/class.installer.php(174): Internationalization->loadDefaultData() #3 /srv/osticket/setup/install.php(52): Installer->install() #4 {main} thrown in /srv/osticket/include/class.dept.php on line 867

The apache error log provides slightly more:
[proxy_fcgi:error] [pid 2830004:tid 140253583087360] [client 127.0.0.1:36002] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to a member function getDefaultDeptId() on null in /srv/osticket/include/class.dept.php:867\nStack trace:\n#0 /srv/osticket/include/class.dept.php(748): Dept->update()\n#1 /srv/osticket/include/class.i18n.php(82): Dept::__create()\n#2 /srv/osticket/setup/inc/class.installer.php(174): Internationalization->loadDefaultData()\n#3 /srv/osticket/setup/install.php(52): Installer->install()\n#4 {main}\n thrown in /srv/osticket/include/class.dept.php on line 867', referer: https://mywebsite/setup/install.php

Any suggestions?
Thanks!

ntozier

bill_w getDefaultDeptId()

Hrm. So this looks like the system tried to look up a department (or you tried to create one) and the when the system tried to find the id for the department it failed ands resulted in a null response. This should not be possible. Did you perhaps delete the default department some how?

bill_w

It doesn't seem likely. I just cloned the git repo, copied the sample config to the running config, and then opened the website. The database is empty and I have dropped and recreated it several times while troubleshooting. I have never gotten past the initial config screen, so I don't think I have had an opportunity to configure departments.

mysql> use osticket;
Database changed
mysql> show tables;
Empty set (0.00 sec)

bill_w

The departments table is still empty after an aborted installation:

mysql> use osticket;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

mysql> select * from ost_department;
Empty set (0.00 sec)

KevinTheJedi

@bill_w

I noticed you said you cloned the git repo. What branch are you trying to install from? I have a near identical setup (minus HAProxy) so I should be able to replicate this pretty easily.

Cheers.

bill_w

Ah. That proved to be the crucial clue. I followed a tutorial for installation that just checked out the default branch, which was the development branch. I changed to 1.15.x and now the installation is working fine. Dumb mistake. Thanks!

KevinTheJedi

@bill_w

So, the develop branch is our "development" branch that reflects the latest stable version with new commits being prepared for the next release. The 1.15.x branch is the stable versioned branch that reflects the latest stable version of the 1.15.x series (currently v1.15.1 at the time of writing this).

We do not recommend using develop to run in production, etc. as it might have issues that haven't been worked out yet. With this being said you actually found a new bug introduced with one of the latest commits. I am submitting a patch soon and will link it here to finish the thread off.

Cheers.