Strange memory issue

  • Resolved rsteinhoff

    (@rsteinhoff)


    9 years, 5 months ago

    Hi Tobias!

    I’m encountering a strange memory issue with Tablepress. I have two tables, ID-5 and ID-13. I periodically replace these tables using the Excel import function. These Excel files are quite big, approx 250 rows with 1 column but lots of data in each cell. The two Excel files used to update ID-5 and ID-13 are exactly the same size with the same number of rows/content.

    When I import & replace ID-13 everything goes smoothly. When I import & replace ID-5 I get this message:

    Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7403573 bytes) in /XXXXX/formatting.php on line 4623.

    I know these memory issues can be tricky to figure out but was wondering if you have any insight into this issue. By the way, sometimes the import works despite the memory error message–sometimes it doesn’t.

    Thanks,

    Ronald

    • This topic was modified 9 years, 5 months ago by rsteinhoff.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter rsteinhoff

    (@rsteinhoff)

    9 years, 5 months ago

    Hi Tobias,

    I think I figured it out. I have a master table with 500 rows that I split into two tables with 250 rows each. ID-5 is one 250-row table and ID-13 is the other. I had to split the 500 row table into two tables since I was getting the memory error. All was good until I recently got a memory error for ID-5, even though it’s 250 rows. However, even though I deleted 250 rows from ID-5, Excel was still thinking it was a 500 row table, triggering the memory error upon importing. Rather than deleting the rows I copied the 250 rows to a new excel files to make sure it would be seen as a 250 row table, not a 500 row table with 250 rows missing. Anyways, it’s working now.

    Hope this makes sense 😛 Thanks again for best WordPress plugin!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 5 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Yeah, the Excel format can be tricky with memory, as it sometimes “hides” data internally.

    The best workaround that I know is to simply save the table to a CSV file in Excel and then import that .csv file into TablePress. That should require much less memory.

    Regards,
    Tobias

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

The topic ‘Strange memory issue’ is closed to new replies.