Thread

Whenever I try to publish a new article in a weblog I receive the following error.

MySQL ERROR:

Error Number: 2006

Description: MySQL server has gone away

Query: SELECT entry_id, title FROM exp_weblog_titles WHERE weblog_id = ‘22’ ORDER BY title asc LIMIT 25

I noticed that this query is for the relationship field that pulls in the titles of another weblog. When I run the query in my desktop database client (Sequel Pro) it runs without any problems.

Hi, Michael.

Does this same thing happen if you try and post an entry that doesn’t have a relationship field?

Tell us more about your server. Is this site hosted on a professional server?

Any third party add-ons installed? If so, which ones?

Hi Sue,

Does this same thing happen if you try and post an entry that doesn’t have a relationship field?

No. Not even other entries that have different relationship fields. It’s just this one weblog.

Tell us more about your server. Is this site hosted on a professional server?

(dv) Dedicated-Virtual 3.5 - Rage with 1.7 GB of memory.
PHP Version 5.2.6
MySQL Version 5.0.45

Any third party add-ons installed? If so, which ones?

Yes
Image Sizer (v.2.5.6)
FieldFrame (v.1.3.5)

Can you get this to error out every time, or just occasionally?

Every time.

If you put this query in an exp:query loop, does it render then?

{exp:query sql="SELECT entry_id, title FROM exp_weblog_titles WHERE weblog_id = '22' ORDER BY title asc LIMIT 25"}
{title}
{/exp:query}

If 25 doesn’t work, what about 10?

It worked perfectly, even at 500.

So there is something else going on besides just trying to display the content. (Which is a good thing to know.)

How many entries are in this weblog? How much memory is allocated to PHP?

Have you seen: EEWiki:// HowTo Determine Memory Limits

-and-

EEWiki:// HowTo Override Memory Limitations

How many entries are in this weblog?

109

How much memory is allocated to PHP?

64M

I had previously upped my php memory.

Hi, Michael,

Are you using the built in relationship system, or is this a custom extension/custom field?

Also, if you go to Admin > Utilities and clear out your relationship caches, does that help alleviate the issue?

Thank you.

Are you using the built in relationship system, or is this a custom extension/custom field?

Yes, built in relationship system

Also, if you go to Admin > Utilities and clear out your relationship caches, does that help alleviate the issue?

I cleared it, but it didn’t help.

As a test, can you try upping your PHP memory to 128M? I don’t know if that will make a difference, but it’s the easiest thing to try.

I upped it to 128M, but to no avail.

Michael, I don’t suspect this is the immediate issue, but if you try removing the Image Sizer tags from your templates, do you see this issue with publishing go away? It seems a bit counter-intuitive, I realize, but it’s worth a shot.

Also, have you asked your host if they have any logs and can see what might be causing this?

Thanks Lisa, turns out it was an error with Image Sizer. Certainly was counter-intuitive but worked.

Thanks for the help!