Skip to Content Skip to Menu

CB CONDITIONAL Fatal error: Allowed memory size of 134217728 bytes exhausted

  • conquist
  • conquist
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 0
9 years 10 months ago #255142 by conquist
Hi krileon, thanks for the answers.

I've uninstalled all the plugins not compatible except CB JDOWNLOAD: is there a CB PLUGIN compatible that give me the possibility to upload some files inside the profile ?

I was able to use the tab "field management" and the plugin "cb conditional".

I've understood the problem but i have found only a workaround but not the solution.

The problem is that i have over 50.000 row in the table comprofile_fields_value because i have many drop-down menu with many information: for example i have 5 fields for select the town with the name of all the town in Italy.

This table is not unhandled because the memory of PHP and of MYSQL is little.

The workaround is delete the table comprofile_fields_value, insert/modify the field conditions and then recreate the table comprofile_fields_value. It's not easy to use.

I'm waiting your suggestions.

Thanks.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48482
  • Thanks: 8283
  • Karma: 1443
9 years 10 months ago #255176 by krileon
Your issue is likely due to way too many field option rows for it to load in. That means you'd have a select input with 50,000 HTML options for the option conditioning. This is a pretty extreme and rare case though. I suggest modifying the following file, which will limit the amount of options that can load in.

IN: components/com_comprofiler/plugin/user/plug_cbconditional/cbconditional.php
ON: Line 1181
FROM:
Code:
$_CB_database->setQuery( $query );
TO:
Code:
$_CB_database->setQuery( $query, 0, 1000 );

Once the change is made see if your issue persists.


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 or Create an account to join the conversation.

  • conquist
  • conquist
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 0
9 years 10 months ago #255279 by conquist
The patch was OK thank you very much but the message "Fatal error: Allowed memory size" is always there.

I've decided to remove the drop-down menu of the town and replace it with a text field because the problem of memory.

Now It's all ok but I need another way to select the town.

Is there a way or a plugin to do this ?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48482
  • Thanks: 8283
  • Karma: 1443
9 years 10 months ago - 9 years 10 months ago #255284 by krileon
I suggest separating your town options from CB. Create a database table to hold all the town values. Next install CB Query Field and use its Query Select fieldtype. You'd then specify a query to your towns database table for it to pull its options. An example of this usage can be found below where a Country field is created using the Query Select fieldtype.

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin


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.
Last edit: 9 years 10 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • conquist
  • conquist
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 0
9 years 10 months ago #255295 by conquist
Thank you Kile. I'll try this solution as soon as possible.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum