Sql Problems With Ee

[Funkalicious]

I have sent numerous tickets about this issue and have also posted this question on the board over at pMachine and have yet to get any helpful response.

 

The last 24 hours, I have been seeing the following error off and on on my domain:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/wxzgjty/public_html/system/db/db.mysql.php on line 252

MySQL ERROR:

 

Query: SELECT exp_members.weblog_id, exp_members.tmpl_group_id, exp_members.username, exp_members.screen_name, exp_members.member_id, exp_members.email, exp_members.url, exp_members.location, exp_members.last_visit, exp_members.total_entries, exp_members.total_comments, exp_members.language, exp_members.timezone, exp_members.daylight_savings, exp_members.time_format, exp_members.last_email_date, exp_members.notify_by_default, exp_members.upload_id, exp_members.theme, exp_members.quick_links, exp_members.template_size,exp_member_groups.* FROM exp_members, exp_member_groups WHERE unique_id = '148214c01fdd078a0542f5e3db5281b260d04302' AND password = '4e07e2fc3d7cc6240a28193ddca33e70d286ad83' AND exp_members.group_id = exp_member_groups.group_id

 

I sent two tickets last night...the first one, I was told the problem was resolved, the second one, I got this:

 

Hi,

 

as far as I can tell from a little research - this is an error with ExpressionEngine, and the configuration.

 

It appears that the PHP timeout figures for your site are causing the problems.

 

I am not familiar enough with the configuration parameters for Expression Engine.

 

I have absolutely NO idea what that means and when I asked for further explanation, I received no answer.

 

I would also like to add that the server I am hosted on suffers from painful slowness (at times) and has had weird issues like the time being 15 minutes off, which also messes with blog functioning. And yes, I sent tickets on those issues, which were resolved (although the time problem had to be corrected twice).

 

The current issue would have to be a server problem, as I configured my blog seven months ago and although I am no server expert, I have a hard time believing the configuration would suddenly be an issue to the point where it stands now.

 

If someone could look into this problem or advise me as to how to resolve it, I would be most grateful.

 

Thank you.

 

*Update*-Got a response over at pMachine:

 

Supplied argument is not a valid MySQL-Link resource

 

Generally, there are two possibile causes for this error. MySQL is down or it has run out of database connections. If it is the former, there is little you can do about it apart from contact your Host/server admin.

 

There was also a suggestion to change something in the config, which i am going to try now. But you might want to look into the SQL on server 74.

[Funkalicious]

I did make one small tweak that was suggested over at pMachine, on the Knowledge blog, but it didn't help.

 

My site is just one big SQL error now and is completely crippled.

 

I am NOT happy.

[Deverill]

I don't know specifics about EE but here are a couple of things I found and I hope something helps.

OK problem solved. I had localhost in config php not 127.0.0.1.

You might try opening your config.php and set it to use non-persistent connections:

$conf['db_conntype'] = "0";

 

I did a search on the error and found another site with the same situation so you're not alone - although that's no consolation.

[LisaJill]

localhost is correct for TCH servers. =) The dbtype connection you pointed to is what the original poster mentioned he tried. I did that via the admin and it appears to have cleared up the error, but time will tell... =)

[Deverill]

Told ya I didn't know anything about it.

[Head Guru]

I tried helping you last night with your funk site, but you banned my IP!

 

So I quit helping you.

 

Bill

[Head Guru]

67.38.20.17, using Ameritech.net...your attempt to ping me to death last night didn’t cause the current issues. So don’t knock yourself over self-patting your back, k?

 

Was me, and thanks for those nice comments.

[Head Guru]

And finally.

 

If we are having issues, your screaming and yelling at us will not get the issue fixed any faster.

 

Your site is up and running ATM. If you have any further issues please contact me VIA AOL IM or submit a help desk ticket.

 

Bill

[Head Guru]

Ok, I am simply beat today. Working way to many hours this week.

 

I am sorry for snapping at you in this thread, and furthermore, I am sorry for closing the thread.

 

You had no idea I was working on your site and I should have contacted you. It was late, I was tired and well I wasn't working on all 8 cylinders.

 

Anyways, I have reopened the thread. Let the bashing begin.

 

Bill

[Funkalicious]

Apology accepted. I'll close the post with the comments.

 

I would like to say I don't feel I was screaming and yelling. I was frustrated, as well, and after this thread was closed, it just added to it. I apologize to anyone I may have offended, though.

 

TCH *is* a good host. You guys have great uptime and you're very affordable and quite honestly, I don't want to move somewhere else.

 

Let's put this behind us and move on.

[Head Guru]

./grouphug.pl

 

 

bill

[LisaJill]

Funkalicious - did you resolve your EE problem, btw? I haven't seen another instance of that SQL thing since I disabled persistant connections. I'm curious what success you'e had.

[Funkalicious]

It seems to be fine since an adjustment was made on the server yesterday. I *did* try the non-persistent connection thing prior to that and it did not seem to make any difference.

 

But all is well now.

[Funkalicious]

./grouphug.pl

 

 

bill

 

Right back at ya.

 

That's pretty funny...I'm gonna have to remember that.

[LisaJill]

Hrm. btw - in a post (that I have copied to the EEWiki, Nevin said that turning off Persisant Queries can help with load times - depending on server config. So you may want to play with it anyway. It seems to have helped my site in general terms.