Hi, I am getting the following error on my forum when browsing pages. I think that the process is being killed by my web host as it takes too long to perform. Not really sure where to start?
http://www.talkwebcasting.com/
It's been happening for ages now, but nothing really happened to start with which should have caused it. (I haven't installed anything, etc)
Database Error: MySQL server has gone away
File: /home/talk/public_html/Sources/Load.php
Line: 890Database Error: MySQL server has gone away
File: /home/talk/public_html/Sources/Load.php
Line: 2020
You need to refer to your host - it appears their mysql db is too busy to handle all the connections
Lainaus käyttäjältä: Tony Reid - toukokuu 20, 2011, 09:38:34 AP
You need to refer to your host - it appears their mysql db is too busy to handle all the connections
Ok. so you think that the site would need a dedicated server (or at least a server which allows for a greater use of MySQL, etc)? Rather than there actually being some intrinistly wrong with SMF?
That's good to know.
Not necessarily,
What sort of traffic does your site have?
Lainaus käyttäjältä: Tony Reid - toukokuu 20, 2011, 11:12:50 AP
Not necessarily,
What sort of traffic does your site have?
2,937 Visits, 5,220 Pageviews in past month.
You most certainly do not need a dedicated box.
Speak with your hosts helpdesk, they either have a problem with mysql, or they have too many websites on their server.
I have spoken to them and they were saying that this was the query which is being killed by their script.
LainaaSELECT
b.ID_BOARD, b.name, b.description, b.numTopics, b.numPosts,
m.posterName, m.posterTime, m.subject, m.ID_MSG, m.ID_TOPIC,
IFNULL(mem.realName, m.posterName) AS realName, " . (!$user_info['is_guest'] ? "
(IFNULL(lb.ID_MSG, 0) >= b.ID_MSG_UPDATED) AS isRead," : "1 AS isRead,") . "
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, IFNULL(mem2.ID_MEMBER, 0) AS ID_MODERATOR,
mem2.realName AS modRealName
FROM {$db_prefix}boards AS b
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = b.ID_LAST_MSG)
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest'] ? "
LEFT JOIN {$db_prefix}log_boards AS lb ON (lb.ID_BOARD = b.ID_BOARD AND lb.ID_MEMBER = $ID_MEMBER)" : '') . "
LEFT JOIN {$db_prefix}moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER = mods.ID_MEMBER)
WHERE b.ID_PARENT = $board
AND $user_info[query_see_board]", __FILE__, __LINE__);
and that....
LainaaIt looks like this is coming from Sources/MessageIndex.php. There are also a number of references in SSI.php. I hope this helps. Let us know if you have any other needs.
I don't really know what to do with this information though.
I think maybe as I'm on a budget plan they are just killing MySQl requests outside of some limit (with Host Gator). Any recommendations on where I could move the site so that it would work? I'm looking at selling the website in the coming months so need it to work to show to prospective buyers (and don't want to sell it if faulty).
http://whois.domaintools.com/talkwebcasting.com (http://whois.domaintools.com/talkwebcasting.com)
hostgator = oversellers
Any recommendations for where to move to?
thanks guys.
I have my own servers so havent used shared hosting in a while, but in the past I have used rshosting.com
There are a few others on here in the hosting board who might be worth checking out.
http://www.simplemachines.org/community/index.php?board=4.0
I have a problem like it..
mysql server has gone away..
it comes from:
subs-portal.php
line 961
// Load the data.
$request = $smcFunc['db_query']('','
SELECT
mem.id_member, mem.member_name, mem.real_name, mem.id_group,
mg.online_color AS member_group_color, pg.online_color AS post_group_color
FROM {db_prefix}members AS mem
LEFT JOIN {db_prefix}membergroups AS pg ON (pg.id_group = mem.id_post_group)
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = mem.id_group)
WHERE mem.id_member '.((count($users) == 1) ? '= {int:current}' : 'IN ({array_int:users})'),
array(
'users' => $users,
'current' => (int) current($users),
)
);
Im hosted at hostgator.com
Capion, the same above applies....
Lainaus käyttäjältä: Tony Reid - toukokuu 20, 2011, 09:38:34 AP
You need to refer to your host - it appears their mysql db is too busy to handle all the connections
It may be that you need to move hosts to solve the issue - but speak with your helpdesk first.
*hmm* 3 other mysql databasen on the same account havent got any problems.
but ok, hostgator.com can take a look at the services.
Hostgator is notoriously bad for forums - Sad but true. The same applies to GoDaddy, and many other cheap shared hosts...