Error connecting to the database on upgrade.

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
john@ncrs
Posts: 2
Joined: Sun Feb 21, 2010 8:20 pm

Error connecting to the database on upgrade.

Post 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.
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Error connecting to the database on upgrade.

Post 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?
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
john@ncrs
Posts: 2
Joined: Sun Feb 21, 2010 8:20 pm

Re: Error connecting to the database on upgrade.

Post 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
Post Reply