I get the following error:

user warning: Got a packet bigger than 'max_allowed_packet' bytes query:[really long message here]

It seems to happen in this line:

cache_set('advanced_forum_alllasttopics', 'cache', serialize($topics), time() + 60);

Comments

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented

Sigh. Ok, that's it, that cache code is going. It's horribly unreliable anyway. I thought I had it working for 5.x and then it started breaking again. And it's never worked on 6.x. I tried to make it work because that's an expensive query to be running on every forum view but I give up. If someone good with performance tweaking wants to write something that works, I'll take a patch. :) In the mean time, I'm just taking it out.

Michelle

nath’s picture

nath commented

Removing the cache_set line removes the error as expected.
It seems to allow caching, the line has to be much shorter. Perhaps the query can be optimized or split (and those subqueries can be cached).

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented

Possibly, but that's not something I know how to do. I didn't even write the query to begin with.

Michelle

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented
Status: Active » Fixed

Committed.

Michelle

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.