Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Executing stored procedures in CB

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
9 years 3 months ago #267016 by eciudad
Replied by eciudad on topic Executing stored procedures in CB
Hi Krileon,

I did what you recommended and here is the message:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 18451621 bytes) in /home/content/50/5430750/html/comofamilia/plugins/system/debug/debug.php on line 1129.

Please advise if you can.

Thank you

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago #267024 by krileon
Replied by krileon on topic Executing stored procedures in CB
You're hitting your PHP memory limit, which is set to 64mb. I suggest contacting your host and having them increase it to 128mb or adjusting it your self using PHP.ini.


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.

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
9 years 3 months ago #267035 by eciudad
Replied by eciudad on topic Executing stored procedures in CB
Thank you Krileon,

Changed the php.ini to 128mb.

No errors, except messages from the system and still the store procedure does not trigger.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 3 months ago #267053 by nant
Replied by nant on topic Executing stored procedures in CB

eciudad wrote: Thank you Krileon,

Changed the php.ini to 128mb.

No errors, except messages from the system and still the store procedure does not trigger.


Please post the exact query action you have configured in CB Auto Actions.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago #267086 by krileon
Replied by krileon on topic Executing stored procedures in CB
Please provide screenshots of your auto action configuration. It doesn't make sense that direct firing of the action works, but triggering of it doesn't unless the trigger is not firing, which would only be the case if the trigger selected is wrong or CB login isn't being used or access/conditions failing.


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.

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
9 years 3 months ago #267093 by eciudad
Replied by eciudad on topic Executing stored procedures in CB
Thank you,

This is actions:

call proc_build_father_treeplus([id], '[lastname]');
call proc_build_mother_treeplus([id], '[cb_mothermaidenname]');

The screens are included for tabs.

Thanks.

File Attachment:

File Name: global.pdf
File Size:158 KB


File Attachment:

File Name: conditions.pdf
File Size:157 KB


File Attachment:

File Name: action.pdf
File Size:137 KB


File Attachment:

File Name: parameters.pdf
File Size:154 KB
Attachments:

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

Moderators: beatnantkrileon
Powered by Kunena Forum