[Plugin: Contact Form 7 to Database] Large exports yield inconsistent data

  • websymphonies

    (@websymphonies)


    13 years, 3 months ago

    I have a database with about 4000 entries. Every time I go to export the data, I receive a different amount of data in the export. Sometimes there are 200-300 entries, sometimes 3000, and rarely all 4000. It’s the same for all export options (CSV, Excel, Live data, etc) and multiple computers have been tested on different ISPs.

    Since there is such large data, I’m assuming that perhaps this has to do with mysql timeouts? Do I need to change a setting in my php.ini file? It seems to work better with faster internet/faster computer, but the results never seem the same, and it’s rare now that I get an export with all the data.

    http://ww.wp.xz.cn/extend/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    13 years, 3 months ago

    This may have to do with running out of memory. A quick thing to try is increasing WP’s memory limit. See this post.

    Thread Starter websymphonies

    (@websymphonies)

    13 years, 3 months ago

    That seemed to work. Thank you. I’ll let you know if I have any more difficulties.

    Thread Starter websymphonies

    (@websymphonies)

    13 years, 3 months ago

    So I set the memory to 2048M, and we are still getting inconsistent results. Sometimes it works, sometimes it doesn’t. Setting the memory to 4096 made the website crash, so I don’t think this is a memory issue.

    Any other suggestions? Sometimes the exports work in full, and other times they don’t export the full thing. (format doesn’t seem to matter, csv, excel, internet query, etc.)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Plugin: Contact Form 7 to Database] Large exports yield inconsistent data’ is closed to new replies.