loss of access to mysql database

[agsvs88]

Script URL: http://thealexangroup-viralspiral.com/helpdesk1
Version of script: 2.0
Hosting company: hostmonster
URL of phpinfo.php: http://thealexangroup-viralspiral.com/h ... hpinfo.php
URL of session_test.php: http://thealexangroup-viralspiral.com/h ... sion_test/
What terms did you try when SEARCHING for a solution:
hesk mysql database problem
hesk lost connection to mysql database

Write your message below:

i don't get many queries at my helpdesk and it seems to run okay...but, i would say every 3 months or so i will lose my connection to the mysql database. so i would just use a new mysql 'username' (everything else remained the same) and that would fix it. however now, with the new 2.0 version, i try the same 'fix' but it would say "tables exist..." etc., etc., so i couldn't do it that way anymore. as of now, i just re-installed using a new mysql database setup and is running ok again...but for how long before the problem rears it's ugly head again??

i googled around and got some answers ranging from the problem having to do with:

1. BLOBs
2. Client Timeouts
3. Server's wait_timeout

i'm not a "techie' so before i 'delve' into this any further, i would like to check if anyone here has seen this problem..and possibly have a remedy.

cheerz,

alex

[Klemen]

I don't know what the problem is, but if MySQL connection works and then stops it must be a server issue. Maybe too many connections on the server (MySQL can have a limited amount of connections)? It's really hard to troubleshoot such issues without server access and as much info about the problem as possible.

Next time you get the error I suggest you turn debug mode on (you can do that by manually editing the "hesk_settings.inc.php" file, just change $hesk_settings['debug_mode']=0; to $hesk_settings['debug_mode']=1; and upload the modified file) and post the exact error message you get here. That should give more info about the problem, but again it's most likely something your host will need to fix.