Okay
  Public Ticket #2737281
Bug
Closed

Comments

  • ECA started the conversation
    March 31, 2021 at 9:40am

    Hello,

    Bug with column name in Excel, title as Let's go or Nb. d'appel etc...
    with the character ' the generation of Chart crash in Google Chart (nothing append after 5 minutes)

    In french we have a lot of word like d'appel, d'abord, d'intervention etc...
    You must escape the character ' in your code

  • [deleted] replied
    April 1, 2021 at 11:11am

    Hi ECA

    Thank you for reaching out to us.

    Please try replacing the code in file wp-content/plugins/wpdatatables/controllers/wdt_admin_ajax_actions.php around line 583

    you will find this

    $tableData = $_POST['tableData'];

    and replace it with

    $tableData = stripslashes_deep($_POST['tableData']);

    the same file around line 850

    you will find this

    $chartData = $_POST['chart_data'];

    replace it with this

    $chartData = stripslashes_deep($_POST['chart_data']);

    also in the same file around line 866 you will find this

    $chartData = $_POST['chart_data'];

    replace it with this

    $chartData = stripslashes_deep($_POST['chart_data']);

    This will have to be tested but please try creating new charts since these ones were not saved properly in the base.


  • ECA replied
    April 6, 2021 at 9:50am

    Hi,

    Thank you very much. Code is ok
    Is it possible to integrate this code in the next release ?
    Because we don't like to modify the core of the plugin each time you made a new release of this plugin.

    Best regards

    Eddie

  • [deleted] replied
    April 6, 2021 at 10:03am

    Hi Eddie

    You are most welcome, I'm glad to hear it helpssmile.png

    Our developers are still testing this but they will most certainly include it in one of our future releases as soon as they make sure it can be applied globally.

    If there is anything else we can assist you with please don't hesitate to contact us.

    Have a wonderful day!