Thread

Hi, suddenly after providing the username and the password I am getting this error:

MySQL ERROR:

Error Number: 2006

Description: MySQL server has gone away

Query: SELECT DISTINCT exp_weblog_titles.weblog_id, exp_weblog_titles.author_id, exp_weblog_titles.entry_id, exp_weblog_titles.title, exp_weblog_titles.comment_total, exp_weblog_titles.trackback_total FROM exp_weblog_titles, exp_weblogs WHERE is_user_blog = ‘n’ ORDER BY entry_date desc LIMIT 10

If I give incorrect username and password, it says invalid login error but this happends only when providing the correct username and password.

Also I can successfully run this query in the phpmyadmin.

Thanks in Advance

crazynp, I looked through the threads with this error message, and one suggestion was to repair your tables.

That’s what I’d do first.

The second suggestion was to contact your webhost.

Can you repair the tables and see if that helps?

Thanks for the reply 😊

Yes I repaired and optimized the database both from the EE Admin and phpmyadmin. After giving the correct username and password I see this error and if I hit the back button of the browser and click the forgot password link I am already logged in ( I will see the admin tabs and can go there and work.)

I contacted the hosting company and they say its the programming issue.

Also, I can successfully run this query from phpmyadmin.

SELECT DISTINCT exp_weblog_titles.weblog_id, exp_weblog_titles.author_id, exp_weblog_titles.entry_id, exp_weblog_titles.title, exp_weblog_titles.comment_total, exp_weblog_titles.trackback_total FROM exp_weblog_titles, exp_weblogs WHERE is_user_blog = ‘n’ ORDER BY entry_date desc LIMIT 10

Hi, crazy - if you search Google for “Description: MySQL server has gone away” you’ll get a lot of great posts - including this one which outilnes common and uncommon explanations.

What version and build of ExpressionEngine do you happen to be on?

Hi,

Thanks for the reply.

I am using the following EE Version:

ExpressionEngine 1.5.1
Build:  20061016

Yes , I understand this error can be produced by timeouts, greater packet size and by few other things. But I think in my case this is not with hosting because I can successfully run this query from phpmyadmin and its only in EE admin page that the query produces error.

I would strongly, strongly recommend that you upgrade. That build date translates to October 16, 2006 - there have been all sorts of changes since then, and it would rule out any file corruption or fixed bugs.

Hi, crazy - if you search Google for “Description: MySQL server has gone away” you’ll get a lot of great posts - including this one which outilnes common and uncommon explanations.

What version and build of ExpressionEngine do you happen to be on?

Thanks for the info.  But very overwhelming!  Not for the novice MySQL-er.

I have similar problems.  The site:  http://focusfusion.org - Very slow site upload, intermittent page loading, but often the message:

MySQL ERROR:

Error Number: 2013

Description: Lost connection to MySQL server during query

Query: SELECT * FROM exp_member_groups WHERE group_id = ‘3’

And sometimes:

Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.

And sometimes:

504 Gateway Time-out
nginx

And sometimes the pages show up.  Sometimes the same page that got an error message before.  Intermittent, as I said, but uniformly SLOW.

Steps I took:

I told the host.  They’re looking into it.

Optimized in phpmyadmin and in ee. 

Changed my password.

QUESTIONS:

Where exactly do I make sure that the connection settings are OK?  They seem OK in the config.php file - and I assume that this info is correct because, as mentioned, various pages do show up once in a while.  Most of the trouble is with the forum pages.  The gallery shows up fine.

MOST IMPORTANT QUESTION: 

Re:  updating to current version of EE.  This site is still running on 1.4.2.  Ancient.  Given the database problems I’m having, is it a good idea to upgrade right now, without resolving the database problems and seeing if it that will fix the slowness?

RR, there is a Server Wizard file you can download and use to find out more information about your database connection.

EEDocs:// Requirements and Server Wizard

You need to iron out the database connection problems first.

Nifty feature.

Done.  Here, check it out.  http://focusfusion.org/wizard.php/page_one/  It’s all supported.

And going through to page two:

The MySQL server test was successful. You MySQL user was able to connect to your database properly and all permission were found to be correct. Congratulations, your server is ready for ExpressionEngine!

So that’s not the problem.  I did notice a weird new folder on the site called jtqoi, which I don’t recall putting there.  It has inside it an index.php file with lots of gibberish and an htaccess file that says:

RewriteEngine on
RewriteRule ^(.*)/(.*)\.html$ index.php?version=$1&name;=$2
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

That doesn’t look like it was made for EE. What’s in the jtquoi directory anyway?

That doesn’t look like it was made for EE. What’s in the jtquoi directory anyway?

 
Just that .htaccess file and a weird index.php file with gibberish.  I deleted it.

Anyway, back to the matter at hand, I give up.  ipower is just not working out here.  The site is down AGAIN, and they haven’t resolved it in 5 days.  Time to switch servers.

It certainly sounds like the server is at least partly to blame, so a move is probably a good idea. Let us know if you need additonal assiatance with that. Thanks 😊

OMG I am getting this same error on an Ipower-run client’s site.

504 Gateway Time-out
nginx

I am on hold with them now. The site has had issues since last week, though I don’t recall the 504 page. Will keep posted.

So this makes my list of hosting companies I will NOT install EE on to two now…GoDaddy, and Ipower. Ug.

OK, but is this a recent phenomenon?  And is it an EE problem?  EE + MySQL + ipower, or is it just MySQL +Ipower?  Because if it’s EE + etc., then the question is why is EE incompatible with 2 popular servers?

I really want to get to the bottom of this error.  It’s no fun switching servers, especially going to a more expensive one.

ericlerner- are you getting the same

504 Gateway Time-out
nginx

Did you contact ipower and get any details from them?  Does it work sometimes and then stop?