[SOLVED] Avatar in CB Membership List causes error

None. It's a very basic Joomla installation, with CB and CBSubs used primarily to maintain a membership system.

The only additional software is JEvents and Akeeba Backup.

I've no idea how you're hitting REGEXP limits then. Try disabling non-core CB plugins 1 by 1 to see if issue eventually goes away.

Disbaling the plugins made no difference.

I've been playing a bit with different filters for a list and the error seems to be linked to the number of members who will appear on the list. For a list that will contain 350 list items the avatar displays OK and there is no error. Where the list has 732 list items which include the avatar the error happens, but if I remove the avatar from the display all 732 items display correctly.

As I've included all the table rows in one filtered list or another the problem doesn't seem to be data-related.

As our membership goes up I'm sure that we will hit this error again on one of the filtered lists so maybe I'll have a bit more information.

I think I'll close this post now, as I think more data is needed to get to the root of it and my immediate problem has been solved.

Many thanks for your time and help.

How many users are you displaying per page? More specifically what is "Number of entries per page" set to under Parameters > Paging or is "Show pagination" set to "No". It is not recommended to try and output more than 100 users per page as that's a lot of profile data to parse through and display on 1 page. I still have no idea why that's causing a REGEXP limit error, but without a callstack for the error (should be available in your servers error log) I've no idea where it's coming from exactly and can't suggest anything further.

Pagination is ON for all our lists.

However, no value was specified for number of entries per page (effectively unlimited) and this seems to be the cause of the problem. I tested the list with various levels of "Number of entries per page" and the list worked fine up to 625. Thereafter, the error occurred.

It was never to be intended to be a list with an unlimited page length, having been originally set to 50 entries, but it seems to have been changed somewhere along the way.

I have reset all our lists to have "Number of entries per page" set to 50, the problem has gone away and can be considered resolved

Perhaps the 100-per-page recommended limit could be added to the help information for this field, and maybe you could use 0 for unlimited rather than blank, preset the default (30) and make the field mandatory?

For the benefit of others, I think the 'limit' of 625 probably only applies to our particular list which has 4 columns and five fields. Those users with more fields and/or fewer columns would probably find their 'limit' to have a different value.

Many thanks for your help.