[SOLVED] Avatar in CB Membership List causes error

6 years 8 months ago - 6 years 8 months ago #296268 by autobahn
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.

Please Log in to join the conversation.

6 years 8 months ago #296272 by krileon
Replied by krileon on topic Avatar in CB Membership List causes error
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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

6 years 8 months ago #296274 by autobahn
Replied by autobahn on topic Avatar in CB Membership List causes error
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.

Please Log in to join the conversation.

6 years 8 months ago #296280 by krileon
Replied by krileon on topic Avatar in CB Membership List causes error
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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

6 years 8 months ago #296282 by autobahn
Replied by autobahn on topic Avatar in CB Membership List causes error
'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).

Please Log in to join the conversation.

6 years 8 months ago #296283 by krileon
Replied by krileon on topic Avatar in CB Membership List causes error
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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.316 seconds

Facebook Twitter LinkedIn