Allowed memory size exhausted

  • Resolved standalljohn

    (@standalljohn)


    2 years, 3 months ago

    We have over 22000 orders, and I tried exporting them all to an excel sheet, but once the progress bar reaches 100%, an error message appears.

    <NI> <b> Fatal error</b>: Allowed memory size of 536870912 bytes exhausted (tried to allocate 67108872 bytes) in <b>/home/ eurocosmetics/public_html/wp-content/plugins/woocommerce-order-export/classes/PHPExcel/CachedObjectStorage/ CacheBase.php</b> on line <b>164</b><br I> <p>There has been a critical error on this website.</p> <p> Learn more about troubleshooting WordPress. </p>

    .

    We have a dedicated server with no resource limitations. This only occurs when exporting to Excel and does not occur when exporting to CSV. Also, the export takes about 15 minutes, is it possible to speed it up?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author algol.plus

    (@algolplus)

    Hello

    Please, add this code to section “Misc Settings”

    add_action( 'woe_xls_PHPExcel_setup', function($objPHPExcel, $settings ){
  ini_set( 'memory_limit', '8192M' );
},10,2);?

    if you use pro version – you can set “AJAX progressbar exports orders per step” = 100 to speed up export. More details https://docs.algolplus.com/algol_order_export/general/

    thanks, Alex

    Thread Starter standalljohn

    (@standalljohn)

    Hello Alex!

    Worked like charm! Everything works fine now even the export speed has been increased from 15min to 3mins.

    Thank you!

    • This reply was modified 2 years, 3 months ago by standalljohn.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Allowed memory size exhausted’ is closed to new replies.

Tags