I broke OS Ticket

KevinTheJedi

You need to configure your PHP to no display errors. (PHP INI Directive: display_errors + display_startup_errors) You can also configure PHP to only log actual errors and ignore Warnings/Deprecations such as you are seeing.
The real issue is the last error: Call to undefined function mysqli_init() You are missing the php-mysqli extension so the application cannot connect to the database. You need to install/enable this extension, restart the webserver, and retest.

Cheers.

TimT

I'm having a very similar issue. Updated to 1.8 and am receiving a bunch of similar output:
Deprecated: Return type of BaseList::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/myaccount/public_html/tickets/include/class.util.php on line 101

KevinTheJedi

TimT

Please read my reply above.

Cheers.

TimT

KevinTheJedi

Yeah, I did that. Still was getting a page full of #[\ReturnTypeWillChange] text. I've since uninstalled osTicket and will be starting over.

KevinTheJedi

TimT

osTicket itself has a bootstrap.php file that has display_errors + display_startup_errors and error reporting settings. Please check these as well.

However, if that has no affect then there is a higher-level setting overriding this. Typically hierarchy is php.ini > then any site specific config files > then osTicket's settings in bootstrap.php but in some cases the global or site specific config can overwrite this.

Cheers.

gfunkjunkie

Hi Kevin,

It turns out I didn't have a php.ini (I added PHP8.2.8 and hadn't renamed the production ini).

With that in place I now get a 500 Internal Error.

I'm not sure if that's progress?

KevinTheJedi

gfunkjunkie

Now you need to check your PHP error logs for any related errors.

Cheers.

gfunkjunkie

Hi Kevin,

gfunkjunkie

[26-Jul-2023 12:16:25 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mysqli_init() in C:\inetpub\wwwroot\helpdesk\include\mysqli.php:28
Stack trace:
#0 C:\inetpub\wwwroot\helpdesk\bootstrap.php(197): db_connect()
#1 C:\inetpub\wwwroot\helpdesk\main.inc.php(28): Bootstrap::connect()
#2 C:\inetpub\wwwroot\helpdesk\client.inc.php(21): require_once('...')
#3 C:\inetpub\wwwroot\helpdesk\index.php(16): require('...')
#4 {main}
thrown in C:\inetpub\wwwroot\helpdesk\include\mysqli.php on line 28
[26-Jul-2023 12:17:57 UTC] PHP Warning: PHP Startup: apcu: Unable to initialize module
Module compiled with module API=20210902
PHP compiled with module API=20200930
These options need to match
in Unknown on line 0
[26-Jul-2023 12:17:57 UTC] PHP Warning: PHP Startup: Invalid library (appears to be a Zend Extension, try loading using zend_extension=php_opcache.dll from php.ini) in Unknown on line 0
[26-Jul-2023 12:17:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_gd2.dll' (tried: C:\PHP\ext\php_gd2.dll (The specified module could not be found), C:\PHP\ext\php_php_gd2.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:17:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_mysql.dll' (tried: C:\PHP\ext\php_mysql.dll (The specified module could not be found), C:\PHP\ext\php_php_mysql.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:17:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_xmlrpc.dll' (tried: C:\PHP\ext\php_xmlrpc.dll (The specified module could not be found), C:\PHP\ext\php_php_xmlrpc.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:22:57 UTC] PHP Warning: PHP Startup: apcu: Unable to initialize module
Module compiled with module API=20210902
PHP compiled with module API=20200930
These options need to match
in Unknown on line 0
[26-Jul-2023 12:22:57 UTC] PHP Warning: PHP Startup: Invalid library (appears to be a Zend Extension, try loading using zend_extension=php_opcache.dll from php.ini) in Unknown on line 0
[26-Jul-2023 12:22:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_gd2.dll' (tried: C:\PHP\ext\php_gd2.dll (The specified module could not be found), C:\PHP\ext\php_php_gd2.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:22:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_mysql.dll' (tried: C:\PHP\ext\php_mysql.dll (The specified module could not be found), C:\PHP\ext\php_php_mysql.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:22:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_xmlrpc.dll' (tried: C:\PHP\ext\php_xmlrpc.dll (The specified module could not be found), C:\PHP\ext\php_php_xmlrpc.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:27:57 UTC] PHP Warning: PHP Startup: apcu: Unable to initialize module
Module compiled with module API=20210902
PHP compiled with module API=20200930
These options need to match
in Unknown on line 0
[26-Jul-2023 12:27:57 UTC] PHP Warning: PHP Startup: Invalid library (appears to be a Zend Extension, try loading using zend_extension=php_opcache.dll from php.ini) in Unknown on line 0
[26-Jul-2023 12:27:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_gd2.dll' (tried: C:\PHP\ext\php_gd2.dll (The specified module could not be found), C:\PHP\ext\php_php_gd2.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:27:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_mysql.dll' (tried: C:\PHP\ext\php_mysql.dll (The specified module could not be found), C:\PHP\ext\php_php_mysql.dll.dll (The specified module could not be found)) in Unknown on line 0
[26-Jul-2023 12:27:57 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_xmlrpc.dll' (tried: C:\PHP\ext\php_xmlrpc.dll (The specified module could not be found), C:\PHP\ext\php_php_xmlrpc.dll.dll (The specified module could not be found)) in Unknown on line 0

KevinTheJedi

gfunkjunkie

You are missing the PHP mysqli extension. You need to install/enable this, restart the webserver and PHP fpm if you’re running it, and retest.

Cheers.

gfunkjunkie

Sorry - I'm a bit new to all this. I have removed the semi colon as below.

extension=mysqli

The full php.ini file is attached.

When testing the site I now get the following.

PHP Deprecated: Optional parameter $namespace declared before required parameter $key is implicitly treated as a required parameter in C:\inetpub\wwwroot\helpdesk\include\class.config.php on line 193 PHP Deprecated: Return type of BaseList::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 101 PHP Deprecated: Return type of BaseList::count($mode = COUNT_NORMAL) should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 106 PHP Deprecated: Return type of ListObject::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 220 PHP Deprecated: Return type of ListObject::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 198 PHP Deprecated: Return type of ListObject::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 207 PHP Deprecated: Return type of ListObject::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.util.php on line 227 PHP Deprecated: Return type of ModelMeta::offsetExists($field) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 242 PHP Deprecated: Return type of ModelMeta::offsetGet($field) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 236 PHP Deprecated: Return type of ModelMeta::offsetSet($field, $what) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 239 PHP Deprecated: Return type of ModelMeta::offsetUnset($field) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 245 PHP Deprecated: Return type of QuerySet::getIterator($iterator = false) should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1565 PHP Deprecated: Return type of QuerySet::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1596 PHP Deprecated: Return type of QuerySet::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1599 PHP Deprecated: Return type of QuerySet::offsetSet($a, $b) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1605 PHP Deprecated: Return type of QuerySet::offsetUnset($a) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1602 PHP Deprecated: Return type of QuerySet::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1371 PHP Deprecated: Return type of CachedResultSet::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1743 PHP Deprecated: Return type of CachedResultSet::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1747 PHP Deprecated: Return type of CachedResultSet::offsetSet($a, $b) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1754 PHP Deprecated: Return type of CachedResultSet::offsetUnset($a) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 1751 PHP Deprecated: Return type of ModelInstanceManager::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2002 PHP Deprecated: Return type of CallbackSimpleIterator::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2046 PHP Deprecated: Return type of CallbackSimpleIterator::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2051 PHP Deprecated: Return type of CallbackSimpleIterator::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2036 PHP Deprecated: Return type of CallbackSimpleIterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2040 PHP Deprecated: Return type of CallbackSimpleIterator::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2031 PHP Deprecated: Return type of FlatArrayIterator::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2076 PHP Deprecated: Return type of HashArrayIterator::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 2099 PHP Deprecated: Return type of BaseMessageStorage::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in C:\inetpub\wwwroot\helpdesk\include\class.message.php on line 186 PHP Fatal error: Uncaught Error: Call to undefined function mysqli_init() in C:\inetpub\wwwroot\helpdesk\include\mysqli.php:28 Stack trace: #0 C:\inetpub\wwwroot\helpdesk\bootstrap.php(197): db_connect() #1 C:\inetpub\wwwroot\helpdesk\main.inc.php(28): Bootstrap::connect() #2 C:\inetpub\wwwroot\helpdesk\client.inc.php(21): require_once('...') #3 C:\inetpub\wwwroot\helpdesk\index.php(16): require('...') #4 {main} thrown in C:\inetpub\wwwroot\helpdesk\include\mysqli.php on line 28

gfunkjunkie

php.zip

23kB

KevinTheJedi

gfunkjunkie

It seems you are still missing the mysqli extension as you are still getting: Call to undefined function mysqli_init()

Cheers.

gfunkjunkie

Good morning Kevin,

The PHP logs are as follows (on repeat).

[27-Jul-2023 07:52:58 UTC] PHP Warning: PHP Startup: apcu: Unable to initialize module
Module compiled with module API=20210902
PHP compiled with module API=20200930
These options need to match
in Unknown on line 0
[27-Jul-2023 07:52:58 UTC] PHP Warning: PHP Startup: Invalid library (appears to be a Zend Extension, try loading using zend_extension=php_opcache.dll from php.ini) in Unknown on line 0
[27-Jul-2023 07:52:58 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_gd2.dll' (tried: C:\PHP\ext\php_gd2.dll (%1 is not a valid Win32 application), C:\PHP\ext\php_php_gd2.dll.dll (The specified module could not be found)) in Unknown on line 0
[27-Jul-2023 07:52:58 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_mysql.dll' (tried: C:\PHP\ext\php_mysql.dll (%1 is not a valid Win32 application), C:\PHP\ext\php_php_mysql.dll.dll (The specified module could not be found)) in Unknown on line 0
[27-Jul-2023 07:52:58 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_xmlrpc.dll' (tried: C:\PHP\ext\php_xmlrpc.dll (%1 is not a valid Win32 application), C:\PHP\ext\php_php_xmlrpc.dll.dll (The specified module could not be found)) in Unknown on line 0

It does look like the php_mysql.dll is failing to load but weirdly it is trying to find it in C:\PHP\ext\ but the most recent version of PHP I've installed is in C:\Program Files\PHP\PHP8.2.8?

Kind regards,

Mat

ramrajone

gfunkjunkie
It appears that the PHP extension is not being installed correctly. Some components are still missing. Please review the installation guide for PHP on your operating system version to ensure a proper installation.

To load Extensions: Look for the ;extension lines in php.ini to load various PHP extensions. Remove the leading semicolon ; and add the correct extension names for extensions like 'gd2', 'mysql', and 'xmlrpc'.

Example:
extension=gd2
extension=mysql
extension=xmlrpc

To verify PHP Version: Double-check that you are running the correct PHP version by running php -v in the command line.

To restart Web Server: After making changes to php.ini, restart your web server (e.g., Apache or Nginx) to apply the changes.

gfunkjunkie

Hi all,

It seems something is definitely not right about my PHP installaltion. As mentioned extensions were trying to be loaded from a different PHP folder on the root of C rather than the PHP8.2.8 folder that I'd made in C:\Program Files\PHP.

I found another 6 PHP folders/versions in various places on the server during my investigations.

C:\Program Files\PHP\PHP8.2.8\ = 8.2.8
C:\Program Files\PHP\PHP8.1.11\ = 8.1.11.0
C:\Program Files (x86)\PHP\v8.1\ = 8.1.11.0
C:\PHP\ = 8.0.25
C:\Program Files (x86)\PHP\v7.3\ = 7.3.15
C:\Program Files (x86)\PHP\v5.6\ = 5.6.0.0
C:\Program Files (x86)\PHP\v5.4\ = 5.4.0.0

I copied the contents of the new PHP8.2.8 folder I made within program files and overwrote the files in the PHP folder on the root of C and now the helpdesk is back up and running!

This is no doubt all sorts of wrong but I'm not the guy who usually manages this sort of thing so hopefully the patch up job I've done will stick until their return from holiday.

Thanks all for your support folks.

Kind regards,

Mat