Could not connect to MYSQL database

Helpdesk for my helpdesk software

Moderator: mkoch227

Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Could not connect to MYSQL database

Post by Klemen »

Also, I see your help desk look has been customized a lot.

Do you get the same error if you do a clean installation of HESK (using nothing but original files) in a test folder?

It's more than likely that the error is related to the customizations since it's not been reported anywhere else.
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
vinman57
Posts: 65
Joined: Thu Jan 17, 2008 4:13 am

Re: Could not connect to MYSQL database

Post by vinman57 »

I have hesk on 2 different web sites, 2 different hosts - same issue occurs on both
-----------------------------------
These are the steps
1. Log in
2. click on settings.

it defaults to the general tab. The whole page starts to load but refreshes and shows this:

www.pianowizardacademy.com/helpdesk/hesk-step1.png

3. Click on help Desk (2nd tab) and click SAVE SETTINGS. Results in:

www.pianowizardacademy.com/helpdesk/hesk-step2.png

4. Click on "go back" - now everything is fine

www.pianowizardacademy.com/helpdesk/hesk-step3.png
----------------------

www.pianowizardacademy.com/helpdesk/phpinfo.php
www.pianowizardacademy.com/helpdesk/session_test.php
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Could not connect to MYSQL database

Post by Klemen »

I am 99.99% sure this is caused by third party Javascript in HESK (Javascript not included with original HESK).

Try following these steps precisely:

1. Download original hesk from www.hesk.com

2. Upload all unmodified files to
www.pianowizardacademy.com/hesktest

3. Copy the hesk_settings.inc.php file from inside "helpdesk" to the new "hesktest" folder

4. Login as an administrator to
www.pianowizardacademy.com/hesktest/admin


Does the same problem occur?
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
vinman57
Posts: 65
Joined: Thu Jan 17, 2008 4:13 am

Re: Could not connect to MYSQL database

Post by vinman57 »

No, the problem does NOT occur - it works good.
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Could not connect to MYSQL database

Post by Klemen »

This indeed proves some of the custom changes (probably Javascript) you have is causing the problem.

What exactly is causing problem in your case I don't know as I don't know what has been modified. What I would do is I would modify the working help desk step by step testing each time if the same error occurs. When it does you will know the last change you did is the cause of the problem.
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
vinman57
Posts: 65
Joined: Thu Jan 17, 2008 4:13 am

Re: Could not connect to MYSQL database

Post by vinman57 »

The only changes are header.inc and footer.inc to add the header and footer. That's all.
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Could not connect to MYSQL database

Post by Klemen »

And some code in there (or some Javascript called form the header) is exactly what is causing the problems.
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
lupolo
Posts: 214
Joined: Mon Apr 20, 2009 2:12 pm

Re: Could not connect to MYSQL database

Post by lupolo »

i have found my problem!

I used my over-all user account for mySQL.

I now have create a user within the hesk table of mySQL and now it works.
Post Reply