• Resolved arouault

    (@arouault)


    Hey, the plugin is amazing, exactly what we need. I’m using it in the admin side of WP, the functionalities of your plugin perfectly work except the csv’s export.
    A blank page appear with:
    Request-URI Too Long

    The requested URL’s length exceeds the capacity limit for this server.
    Apache/2.4.23 (Win64) PHP/5.6.25

    I’m not sure how to fix it, the table to display is quit big (1939 rows), I think that’s why it’s not working. Do you have any idea how could I fix it ?

    • This topic was modified 8 years, 11 months ago by arouault.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author bobbysmith007

    (@bobbysmith007)

    Perfect glad you like it and find it useful!

    I recently switched the CSV export from calculating the export server side to calculating the excerpt client side. So basically it is going to request a URL with every id from the table in it (?action=wp_ajax_dbte_export_csv&ids=1,2,3,4,5… so if that string gets long you can exceed the server/browsers URL / url param limit.

    Apache supports an 8000 char limit by default, perhaps the browser is blocking it.

    Maybe look here:
    http://stackoverflow.com/questions/7724270/max-size-of-url-parameters-in-get

    —-

    Its possible that I need to run the export as a post instead of an ajax request if the url parameter string is too long.

    You might try experimenting with changing the Definition of DBTableEditor.exportCSV to try posting to that URL instead of redirecting. I probably wont get to this today. But if you cannot get it resolved, I might be able to help soon.

    I am having the same issue, Request-URI Too Long, and unfortunately I am unable to increase the Request-URI limit at the server end. Is there a workaround for this? Thanks!

    Thread Starter arouault

    (@arouault)

    I haven’t been able to find one yet. I’ve tried the instructions bobby gave but I’m not exactly sure what to do with them.
    I’ve read on other forum that using post instead of get would fix the issue, but I’m not skilled enough to understand the plugin code and modify it by myself.

    Plugin Author bobbysmith007

    (@bobbysmith007)

    Alright, I just posted version 1.6.1 which creates a form and posts it instead of using a GET request. It seems to work for me and should resolve this issue.

    This is so awesome @bobbysmith007!! And it works perfectly! Thank you so much for this!

    Thread Starter arouault

    (@arouault)

    Thank you for your support @bobbysmith007 , it work now!

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

The topic ‘CSV’s export’ is closed to new replies.