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.