close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQL server has gone away

Thread began 11/20/2011 10:41 pm by dave315749 | Last modified 12/02/2011 12:19 pm by Jason Byrnes | 1115 views | 6 replies |

dave315749

MySQL server has gone away

Getting alot of these on a new project, using DW 5.5 and and seem to create new reocrds and remove files is what makes it hold on a wait and say "MySQL server has gone away"

what do i do ?

Sign in to reply to this post

Jason ByrnesWebAssist

is this happening on your remote server or on the local server?


i dont understand what you mean in this part of the problem report:
"and seem to create new reocrds and remove files"

remove fiels? are you using a the delete or upload file behaviors? how are you removing files?

how many columns are in your table?

I need more details on the nature of the problem to be able to offer assistance.

Sign in to reply to this post

dave315749

Hi,

There are 57 columns in the table, and sometimes i upload 1 to 3 images, but that doesnt seem to make a difference.

I am uploading stories in a text field in 2 of the columns, the rest are simple varchar 255 columns.

This happens at very random times, like when deleting a record, updating and or inserting a record.

I asked the server company, i have a dedicated box and they said they dont see anything in the logs.


Dont know what to check next.. Adjust memory settings and timeouts?

Sign in to reply to this post

dave315749

Where do i go from here?

I have had applications i have built on other servers and randomly they have issues also..

anything you can suggest i look at?

Sign in to reply to this post

Jason ByrnesWebAssist

the most common cause of the MtSQL Server Has Gone Away error message is that the server has timed out and closed the connection

see the mysql documentation for details on increasing the wait_timeout variable.
gone-away.html

If you continue to have problems, double check with the host on the MYSQL Version being used, if it is mysql 4 ask to have it upgraded to mysql 5

Sign in to reply to this post

dave315749

Ok but the mysql timed out is really just a symptom of the the problem of not keeping the connection open or closing it too soon?

when i insert 2 to 6 rows fairly quick into the database, it waits over a minute to connect back to the website.. why would it do that? i thought it might have just been webassist, but it also does this with regular dreamweaver insert records..

Sign in to reply to this post

Jason ByrnesWebAssist

if it is taking that long to process an insert, It sounds like there is an issue with the php server connecting to the mysql server.

It sounds to me like the 2 issues would be symptoms of the same problem. Not really sure what the issue could be, but it sounds like a server configuration issue.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...