MySQL has gone away

snakeyez.us · September 8th, 2008, 1:26 AM

Throughout my time using Simple Machines Forum (SMF) my most frequent aggravation has been the error "Database Error: MySQL server has gone away".

I'm not real keen on what causes this. In the past it has occurred when I attempted to apply a modification to the forum. Lately it occurs at random when I do something very simple like attempting to view a forum member's profile. Surely this isn't so taxing on the server that it would cause an error?

I've done a little bit of research and I'm curious as to what the max_allowed_packet value is set to default on shared servers and I'm also curious as to if this value can be changed on shared servers?

I'd really like to do something, anything, to make this error show up less frequently or go away completely. Any suggestions?

**Mark** · September 8th, 2008, 12:59 PM

max_allowed_packet is set to 1047552 bytes, or about 1 meg. I can't imagine that wouldn't be enough for your uses. Your best bet would be to put in a ticket, and tech support can go through the sql error log and see if they can find a more descriptive error

September 8th, 2008, 1:26 AM	#1 (permalink)
snakeyez.us Registered User Comfy Contributor Joined in Jan 2006 Lives in Mississippi Hosted on SH142 104 posts Gave thanks: 12 Thanked 4 times	MySQL has gone away Throughout my time using Simple Machines Forum (SMF) my most frequent aggravation has been the error "Database Error: MySQL server has gone away". I'm not real keen on what causes this. In the past it has occurred when I attempted to apply a modification to the forum. Lately it occurs at random when I do something very simple like attempting to view a forum member's profile. Surely this isn't so taxing on the server that it would cause an error? I've done a little bit of research and I'm curious as to what the max_allowed_packet value is set to default on shared servers and I'm also curious as to if this value can be changed on shared servers? I'd really like to do something, anything, to make this error show up less frequently or go away completely. Any suggestions? __________________ LanceDean.com An index to my many domains and places on the web, hosted on SH142 (66.7.205.59)

September 8th, 2008, 12:59 PM	#2 (permalink)
Mark Surpass Developer Excelling Contributor Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 509 posts Gave thanks: 20 Thanked 78 times	max_allowed_packet is set to 1047552 bytes, or about 1 meg. I can't imagine that wouldn't be enough for your uses. Your best bet would be to put in a ticket, and tech support can go through the sql error log and see if they can find a more descriptive error __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)