Okay
  Public Ticket #1630250
HTML Code Being Inserted Into String Type Column
Closed

Comments

  •  2
    Kenner82 started the conversation
    July 4, 2018 at 4:55am

    I was updating some rows in my database and found that after I saved the new information, extra HTML code was being inserted into the column. 

    The first column and row in the table I shared the URL to should have the data:

    <a href="https://www.paddedtushstats.com/SweetBottomsBabyBoutique">Sweetbottoms Baby Boutique</a>***


    And display: 

    Sweetbottoms Baby Boutique***

    When I save it, though, it turns into this:

    ><div>
<a href="https://www.paddedtushstats.com/SweetBottomsBabyBoutique">Sweetbottoms Baby Boutique</a>***</div><


    And then displays like this:
    >

    Sweetbottoms Baby Boutique***
    <

    The column is a string type, and it seems to do the same thing no matter if I put a link or any HTML code in the field. Current data displays just fine, but if I update it then I have this same problem. 

    I saw somebody a while back had a similar issue, but was a fix ever discovered?

  •  472
    Isidora replied
    July 4, 2018 at 8:43am

    Hi Kenner82,
    Thank you for your purchase.

    Can you please tell me which version of libxml do you use?

    You should find the libxml version in your php.info file.

    If is not possible to update it on latest version then, you have to make some code changes

    in file  wp-content/plugins/wpdatatables/source/class.wdttools.php and around line 809 I found this code 

    if (self::isHtml($string)) {
$string = self::stripJsAttributes($string);
}

    and commented it so the code look like this 

    //if (self::isHtml($string)) {
//$string = self::stripJsAttributes($string);
//}

    It should work now for your version of libxml. For next update you have to do it again.

    Best regards.



    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables

  •  2
    Kenner82 replied
    July 6, 2018 at 5:48am

    I could not find a php.info file.

    I found phpinfo.php, but all it says is 

    <? phpinfo() ?>

    Is there somewhere else I should be looking?

  •  472
    Isidora replied
    July 6, 2018 at 9:22am

    Hi Kenner82,

    My suggestion is to contact your hosting provider and check out where you can find this informations about php info.

    Did you try to comment code that I provide you in previous post and check is it working?

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables

  •  2
    Kenner82 replied
    July 6, 2018 at 5:16pm

    I made the code change and things are working now, I'd just rather not have to figure out how to redo those steps after every update ;) 

    My site is running libxml 2.7.8

  •  472
    Isidora replied
    July 9, 2018 at 8:42am

    Hi Kenner82,

    Sorry for late response. 

    We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    I am glad that now is working fine. If is possible to update libxml version to the latest(we are using 2.9.4) then you will not need to change this code on every update. If is not possible then you will have to change it manually after every update.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables