Fails with a big CSV

  • Resolved tiotrom

    (@tiotrom)


    4 years ago

    This CSV might be an exaggeration in terms of how much it contains https://backend.deqar.eu/static/daily-csv/deqar-reports.csv but my server is more than capable of handling it. Can you test it and see if we can find a way to import it? I increased the PHP values to be able to import it and I guess it broke that table:

    

    Fatal error: Uncaught Error: Call to a member function setFilterType() on bool in /var/www/wordpress/wp-content/plugins/wpdatatables/source/class.wpdatatable.php:2116 Stack trace: #0 /var/www/wordpress/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(2094): WPDataTable->prepareRenderingRules(Array) #1 /var/www/wordpress/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(2630): WPDataTable->fillFromData(Object(stdClass), Array) #2 /var/www/wordpress/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(92): WPDataTable::loadWpDataTable(7, NULL) #3 /var/www/wordpress/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(601): WDTConfigController::loadTableConfig(7) #4 /var/www/wordpress/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(638): wdtEdit() #5 /var/www/wordpress/wp-includes/class-wp-hook.php(303): wdtConstructor('') #6 /var/www/wordpress/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters('', Array) #7 /var/www/wordpress/wp-includes/plugin.php(470): WP_Hook- in /var/www/wordpress/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 2116

There has been a critical error on this website. Please check your site admin email inbox for instructions.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tiotrom

    (@tiotrom)

    4 years ago

    Probably that error is because I get “There was an error while trying to save the table! Gateway Timeout” because of Nginx. “504 Gateway Timeout Error “. I tried increasing some values in my Nginx but nothing fixes it.

    Plugin Author wpDataTables

    (@wpdatatables)

    4 years ago

    Hello there.

    The file you’re attaching is too big for wpDataTables to handle. As mentioned in our documentation, using tables linked to an existing source (CSV in this case) can work up to 3.000 – 5.000 cells, and since your file has around 76.000 rows, it can’t be handled by wpDataTables.

    You would need to acquire the full version of the plugin, and use MySQL or import this file to generate a manual table (both of which are Server-Side Processing tables) that could handle data this big.

    Kind regards.

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

The topic ‘Fails with a big CSV’ is closed to new replies.