%&**^%$##$^& = SiteName

Ok, I am starting to get really PO'd now. I cannot resolve this issue and it's driving me NUTS! I keep getting this one specific error message. I have treid everything I know to resolve it and I can't get it done.

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/skyforum/public_html/inc/classes/BxDolEmailTemplates.php' at line 31.
Called 'getOne' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/skyforum/public_html/inc/classes/BxDolDb.php
            [line] => 236
            [function] => error
            [class] => BxDolDb
            [type] => ->
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => skyforum_dol
                    [user] => xxxxx_xxx
                    [password] => xxxxxxxxxxxx
                    [link] => Resource id #31
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object

I get this email from the site email address as well as the same error reported in a different email from the server itself...

It's driving me insane. Can someone here with more talent please step up and help me resolve this?

This doesn't help but when I manually execute the command I return one row and it executes fine.  Have you tried uploading a new BxDolDb.php or restoring an old backup?

Question, how many languages do you have?

only the default english that came with it. No, I haven't reinstalled that file. I have never changed it as far as I know....

Can you run the query manually via telnet or similar to see if it will run standing alone?

Mysql error: MySQL server has gone away

this generally means that the connection to mysql has failed. have you inquired of your hosting provider to look at the logs to help assist in troubleshooting and addressing this issue? either the database is timing out for some reason, or something else is going on. for the error to come up that.

running a query on google i came up with this:

MySQL server gone away error explained

Well Mr Dos Dawg, you got us on the right track. I got hold of HostForWeb and what they are telling me is the database is closing the connection before all the queries that have been requested can finish.

As per Tony K at HFW:

The issue with the "MySql server has gone away" shows when your script can not execute all queries in the defined time frame (defined in the MySql configuration file my.cnf) and then MySql closes the connection and sends the error "MySql server has gone away". It can be resolved by raising the wait_timeout value in the my.cnf file. Your (my) current setting is set that MySql waits 20 seconds. I would recommend that you set that value to 30-40 seconds.

Well. I guess I can't avoid it any longer. Time to learn how to use the "shell"

I honestly don't know why people are against using the command line. I prefer it, as I have far more power than with any other interface.

Eh, must be due to the way some are raised. *Shrugs.*

 Like Dos Dawg, I grew up in a DOS environment but that was many eyars ago. Since then, I've taken the short cut gooey interface route. I don't have a clue to the commands or even how to start the session and I am NOT a Linux (pronounced Lynux) man at all. I will Google it and get the basic command list and see if I can't fumble my way into the my.cnf file. Might take me a week or two or even an hour....

 I was thinking. Some of these problems take weeks to find a fix for. Then powers that be should create a thread just for the explanation of errors and a list of the ways different members have come up with to fix them.

Keep it simple. Just list the erro, then a quick explanation of what was found to fix it without having to search this forum.

Good idea Sky, but I don't know if they will do it or have the time to implement it.

What about starting an offsite wiki ourselves that is member contributed.  There are so many fixes and workarounds that it would fillup quite quickly.  I bet we can also get a pretty awesome manual going and documentation from all our independent work.

happy to provide this if everyone's interested

Anyone have a wiki mod for dolphin? I would have no trouble hosting it on my server for the communities use. Of course, if it requires SSH ACCESS! Forget it! I have been making keys, managing keys, downloading keys till I'm FRIKKIN BLUE IN THE FACE!

Sorry, gettin a little frustrated. Who thought this security s___ up anyway? What happened tio just entering a frikkin password?

Odd, I just type:

ssh accountname@accountssite.com

Accept and permanently store key? (not the exact words): y

Password: passwordforaccount

$Hey, I'm in!

Try permanently storing the key, and then you only need worry about it once. Hey, maybe you can automate all the login, etc, but I'm not in the mood to explain (sorry).

Now I am quoting myself. LOL.

I wanted to finish this thread by letting everyone know that changing the default wait_timeout of 20 seconds to 40 seconds so the database doesn't close in the middle of processing multiple queries has completely eliminated the error message:

MySQL server has gone away

Just wanted to post this so the error was searchable.