Page 1 of 1

Error connecting to the database on upgrade.

Posted: Tue Sep 03, 2013 1:38 pm
by john@ncrs
Script URL: http://www.ncrs.org/helpdesk
Version of script: 2.4.2 trying to upgrade to 2.5.1
Hosting company: 1and1.com
URL of phpinfo.php: none
URL of session_test.php: http://www.ncrs.org/helpdesk/session_test.php
What terms did you try when SEARCHING for a solution: Upgrade

Write your message below:

I attempted to upgrade from version 2.4.2 to 2.5.1. 2.4.2 is working just fine. When I ran the install script in upgrade mode it got an error each time it tried to connect to the database. Our server uses socket: localhost:/tmp/mysql5.sock instead of just plain localhost. Each time I ran the script it gave me an error and reverted the Host to localhost instead of the "localhost:/tmp/mysql5.sock" that I had entered.

Is the script defaulting to localhost regardless of what is entered in the form?

I reverted everything back to version 2.4.2 to keep it running until this is resolved.

Re: Error connecting to the database on upgrade.

Posted: Tue Sep 03, 2013 3:02 pm
by Klemen
The problem is the ":" char in your host - HESK expects anything after ":" to be port number.

Could you try this:

1. Download these two files
2. Start 2.5.1 upgrade steps according to documentation
3. Before running the upgrade.php script, upload the two new files to the server ("database_mysqli.inc.php" inside "inc" folder, the other one inside "install" folders).

Did that do the trick?

Re: Error connecting to the database on upgrade.

Posted: Thu Sep 05, 2013 12:48 pm
by john@ncrs
Thanks. The two files let me complete the install. The install did overwrite my localhost in hesk_settings.inc.php but I went in and corrected that to complete the upgrade. :D