WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Fatal error: Allowed memory size of 67108864 bytes (2 posts)

  1. lovelyjubbly
    Member
    Posted 1 year ago #

    I'm trying to upload an Excel csv file that's 1.8 MB in size, with about 20,000 rows, 15 columns.

    I'm getting the following error when I try to import:

    Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2 bytes) in /home/voiperne/public_html/choochoo/wp-content/plugins/tablepress/libraries/csv-parser.class.php on line 192

    Any way to fix this?

    What sort of limits are there to table size?

    Many thanks.

    http://wordpress.org/extend/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your post, and sorry for the trouble!

    This error means that the available PHP memory limit on your server is reached, so that the table import process could not run successfully.

    The only solution I see would be to increase that limit (e.g. by increasing the value of the WP_MEMORY_LIMIT constant with the instructions at http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP )

    Now, unfortunately, even if you do that and the table is imported successfully, you like won't have much fun with a table of this size in TablePress. The reason is that the "Edit" screen will basically be unusable (due to the large amount of input fields that the browser has to handle), and due to the large amounts of data (which will be in the area of 1.8 MB) that has to be transferred during EVERY request to edit or even view the table.

    So, while TablePress doesn't impose an direct limits on the table size, there are certain limits that arise from things like the PHP memory or speed considerations, as in this case. Therefore, for this table, I would not recommend to use TablePress, but instead look into a custom solution, e.g. based on PHP and mySQL directly.

    Regards,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic