[SOLVED] Avatar in CB Membership List causes error

After the last update of CB to 2.1.3 our default List, which is a members list, threw the following error:

#0 PHP regular expression limit reached (pcre.backtrack_limit)

I fixed it by removing the avatar field from the CB List Columns.

Thought I'd let you know about the problem.

The last nightly builds was purely jQuery improvements. Beyond that no other code was touched. The few nightly builds before that were all "Install from Web". I find it hard to believe updating caused your issue, but rather something else is going on.

You're basically hitting REGEXP limits, but I've no idea how on a userlist. Please check the _comprofiler table and ensure you don't have any users with an avatar column that's extremely long. Best I can gather is if it's only affecting that field then somehow an extremely long string was stored to someones avatar column causing the preg_match for gallery images to fail, but it'd have to be thousands of characters to do that.

In all fairness I can't pin this down to any specific update - the problem may have appeared any time this year as this is a list that is not often accessed and I just happened to need to look at it today.

However, I have checked the avatar field in _comprofiler and there are no long strings. Everything is of the format/length '2341_5408a22d854e8.jpg' except for one member who uses 'gallery/car.gif'. Most members haven't set up an avatar, and all the image files are less than 100KB.

I've checked the file names in the avatar field against the actual content of the folder and all seems OK.

So unless there's something going on within one of the image files I'm going to leave this for now and maybe get back to it later.

Thanks for your help and I'm sorry if I've wasted your time.

Are you displaying any large textarea, editor textarea, or Custom HTML fields on your userlist that may have Joomla content prepare enabled for them? It could be a Joomla content plugin doing it as the way they replace shorttags is using REGEXP, which is executed on the entire content string.

'Fraid not. All that is displayed is lastname, firstname, membership number INT) and location (county) (VARCHAR max 255 selected from a dropdown but up to about 30 in practice).

Very strange. Are there any Joomla content plugins installed? If so try disabling them to see if issue resolves. Example of a Joomla content plugins is CB Content Bot.