CFDB Shortcode Memory Fatal Error trying to export. Please Help!

  • mccintranet

    (@mccintranet)


    7 years, 3 months ago

    Hello
    I’m suddenly having an issue with exporting my All Forms data with the shortcode. I’ve been using it for over a year with no problems, pulling a month to date report on all of the data from all of the forms that have been submitted (we use it for our business and have several forms). However, just a few days ago, rather than downloaded the excel file I’m trying to export it to, it now suddenly started giving a white screen with the following error across the top: Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 72 bytes) in /home1/mccnet/public_html/wp-includes/wp-db.php on line 2202
    Can you please please help? We need this for our business. I did some research on the net and saw that it may by I need to raise my PHP memory. But my host raised it to 256mb and it still doesn’t work. I don’t understand why this is suddenly an issue. I”m actually only pulling half the data (half a month worth instead of full month) that I have always pulled.
    Please help 🙁
    Trevor
    ps: the way I’ve been pulling it is as follows:
    Go to the CFDB Shortcode page

    Select Export tab

    Select from Export File

    Go to From tab

    Select the last in the list, * All Forms *

    Go to Rows tab

    In the filter expression field, you can just type in something like:
    submit_time>January 1, 2017&&submit_time<January 14, 2017

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    7 years, 3 months ago

    If you look at the number, it is trying to use over 268 MB. Raise it to 512 MB.

    Thread Starter mccintranet

    (@mccintranet)

    7 years, 3 months ago

    Hi Michael,
    Thanks for the fast reply! I called my host provider Friday (HostGator) and I think they can only raise my php memory to 256, unfortunately. I think anything more than that, and they said I would need a VPS or dedicated server … which would be a really big pain with potential downtime of my site and risk (and expensive).
    Know of any other ways that we may be missing? Like I said it is really strange. I’m only pulling half a months worth of data … when up until last week, I was pulling full months of data with no problems at all.

    thanks
    Trevor

    Thread Starter mccintranet

    (@mccintranet)

    7 years, 3 months ago

    Hi Michael,

    Just wondering if you had any idea on why it just started doing this?
    Like I said, it has pulled significantly more data than this in the past months.

    I need to figure this out, as right now, we have to split up the reports when pulling, then try to combine them all in one excel sheet.
    I can’t imagine I would have to move my site to a dedicated server just to be able to do this.

    thanks
    Trevor

    Plugin Author Michael Simpson

    (@msimpson)

    7 years, 3 months ago

    On the Security/Performance tab, click the “unbuffered” option. That might help.

    I don’t know why it is getting so large. It might be related to pulling all the forms at once. You can indicate form=”form1,form2,form3″ instead of “*” to pull just a few forms, maybe leaving a form with lots of entries for a separate export.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CFDB Shortcode Memory Fatal Error trying to export. Please Help!’ is closed to new replies.