Error while sending QUERY packet. PID=752804

Hi

I've been searching to get to the bottom of this error log. I've never encountered it before.


PHP Warning: Error while sending QUERY packet. PID=752804 in /home/USER-NAME/public_html/includes/classes/db/mysql/query_factory.php on line 43

What I have found relates to max_allowed_packet setting for MySQL. Is this something that can be changed in one of the files or is this something the host needs to do?

thanks for any help.

Quote:

---

Originally Posted by buildingblocks

Hi

I've been searching to get to the bottom of this error log. I've never encountered it before.


PHP Warning: Error while sending QUERY packet. PID=752804 in /home/USER-NAME/public_html/includes/classes/db/mysql/query_factory.php on line 43

What I have found relates to max_allowed_packet setting for MySQL. Is this something that can be changed in one of the files or is this something the host needs to do?

thanks for any help.

---

That looks like a limit that someone has put on your hosting/server try turning on the query count in the footer and see at what level it does that I suspect your server/host either can't handle the number of queries or is throttling it.

Quote:

---

Originally Posted by buildingblocks

Hi

I've been searching to get to the bottom of this error log. I've never encountered it before.


PHP Warning: Error while sending QUERY packet. PID=752804 in /home/USER-NAME/public_html/includes/classes/db/mysql/query_factory.php on line 43

What I have found relates to max_allowed_packet setting for MySQL. Is this something that can be changed in one of the files or is this something the host needs to do?

thanks for any help.

---

That looks like a limit that someone has put on your hosting/server try turning on the query count in the footer and see at what level it does that I suspect your server/host either can't handle the number of queries or is throttling it.

Quote:

---

Originally Posted by bislewl

That looks like a limit that someone has put on your hosting/server try turning on the query count in the footer and see at what level it does that I suspect your server/host either can't handle the number of queries or is throttling it.

---

Hi

are you referring to

configuration > logging - Log Database Queries ?

Number of Queries: 542 - Query Time: 0.337355304611

thanks for responding

Quote:

---

Originally Posted by buildingblocks

Hi

are you referring to

configuration > logging - Log Database Queries ?

Number of Queries: 542 - Query Time: 0.337355304611

thanks for responding

---

There is your problem, what page is this happening on?

homepage....what do you see is the problem? This is a new one for me

You shouldn't have that many queries, what template are you using?

Quote:

---

Originally Posted by bislewl

You shouldn't have that many queries, what template are you using?

---

Er, well, it's not totally uncommon to have a few hundred depending on what's being shown on the page.

I don't think it had anything to do with "number" of queries. Feels like a server misconfiguration to me.
Ask your host for the contents of the MySQL my.cnf file (and any sub files it loads)

I had to set this aside for a few days.

I did a fresh install of zen cart 1.5.4 with demo products and found the classic template was generating just a little less queries than our template. I don't think the template is the problem.

The hosts response to our inquiry about the error was,

"That particular error would be related to a problem with the content on the site and possibly with the configuration of the server. I would recommend having your developer look into this issue as it would be a bit outside of what we can help you with."

Since I don't manage the server I don't believe that would be my responsibility, but as I had to set this aside for a few days I just checked back in the log folder tonight and found that yesterday was the last time the error was generated. I'm hoping this means the host has resolved the issue. I'll keep watch on the logs and if it comes up again I'll request the my.cnf file.

Thanks