Page 2 of 2
Re: Could not connect to MYSQL database
Posted: Sat May 11, 2013 8:03 am
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.
Re: Could not connect to MYSQL database
Posted: Sat May 11, 2013 12:55 pm
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
Re: Could not connect to MYSQL database
Posted: Sat May 11, 2013 5:47 pm
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?
Re: Could not connect to MYSQL database
Posted: Sat May 11, 2013 6:30 pm
by vinman57
No, the problem does NOT occur - it works good.
Re: Could not connect to MYSQL database
Posted: Sun May 12, 2013 7:38 am
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.
Re: Could not connect to MYSQL database
Posted: Sun May 12, 2013 1:21 pm
by vinman57
The only changes are header.inc and footer.inc to add the header and footer. That's all.
Re: Could not connect to MYSQL database
Posted: Sun May 12, 2013 3:47 pm
by Klemen
And some code in there (or some Javascript called form the header) is exactly what is causing the problems.
Re: Could not connect to MYSQL database
Posted: Mon May 13, 2013 7:04 am
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.