Okay
  Public Ticket #1797195
data exchange
Closed

Comments

  •  1
    roaddoc started the conversation

    Got the latest version of WPDataTables and found that now it doesn't accept integers properly (a 10 turned to 0) and strings are presented in ' ' quotation marks which are quite disturbing as they do appear in report DOCs as well. They definitely need to be sanitized away.

    Any ideas?


    Kindest regards,


    Sven

  •  2,498
    Aleksandar replied

    Hello Sven.

    Thank You for Your purchase.

    Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1
    roaddoc replied

    Hello Aleksandar,


    the site is productive and I handle medical data of live patients, so under German jurisdiction along with GDPR there is no way I grant anybody admin access. Please establish a different mode of support, be it screenshots, tech detail request or whatsoever. Thank you.


    Sven

  •  1
    roaddoc replied

    Follow up:what is the preferred JQuery version for wpdatatables? As my site deviates from WP standard here JQuery might be involved in the problem at hand.

  •  2,498
    Aleksandar replied

    Hello again Sven.

    I understand the situation with confidentiality of data You're handling, but please note that it is very difficult to provide support without remote access, so I must ask for some patience in resolving the issue.

    wpDataTables uses the built-in jQuery version 1.12. 

    Can You, please, record the process of creating a table? Please be sure to record the whole process, along with the table and column settings, and main settings (where the number format is defined) so that we can try replicating the issue on our local server.

    Also, please check with Your hosting provider what's the libxml version, as that may also cause an issue similar to what You're describing.

    Kind regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1
    roaddoc replied

    Hallo Aleksandar,


    quick wins first: the libxml version used at hostpress.de is 2.9.1, which actually might be the cause of the problem as I moved to that hosting service shortly and problems appeared afterwards. At the moment it ain't possible for me to distinguish hoster change from version update as a cause. Your feedback on the libxml version is appreciated.

    I did experiment with use of current JQuery version instead of Wordpress standard via functions.php snippet, but switching back to WP standard didn't help the issue, so I rule out a JQuery version issue here.

    The table at hand is a SQL query table:

    SELECT AYk0J_probanden.ID,
           AYk0J_probanden.Vorname,
           AYk0J_probanden.Nachname,
           AYk0J_probanden.Strasse,
           AYk0J_probanden.hnr,
           AYk0J_probanden.PLZ,
           AYk0J_probanden.Ort,
           AYk0J_probanden.PA,
           AYk0J_probanden.PA_date,
           AYk0J_probanden.PA_office
    FROM AYk0J_probanden

    (server side processing active)

    DISPLAY: all options active and 1 row to be displayed in order to create only 1 file with report builder on front end.

    SORTING / FILTERING: all except 'filters in a form' active

    EDITING: 'front end editing" and 'inline editing' are active

    TABLE TOOLS: active at default config

    Some placeholders are set for report builder but the quotation mark issue does not depend on placeholder fields (only).


    It used to work 2 months ago. In the meantime I've been busy with page load optimization of the landing page and now on current use after two plugin updates and moving to another hosting service the thing appeared. Corrections on SQL database are being kept, so the quotation marks do NOT reappear somehow. That narrows it down to the input situation.



    Regards,


    Sven



  •  2,498
    Aleksandar replied

    Hello again Sven.

    We created the same table as You described in the previous reply, but we couldn't replicate the issue. Adding data is going smooth - integers and strings are showing correctly. So, can You please Help us reproduce the issue on our end? For example record the screen when the issue happens, or explain to us the input process step-by-step.

    Also, please try this: 

    • Deactivate wpDataTables plugin
    • Go to Editor under "Plugins"
    • Select wpDataTables from the drop-down menu in the top right corner of the screen and find class.wdttools.php

    Then, around line 825 find the following code:

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

    Comment that code and activate the plugin again, and see if the issue is still present.

    As I mentioned in the previous reply, it is very hard to find the issue without remote access, so please let me know if commenting the mentioned lines of code worked or not.

    Best regards.


    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1
    roaddoc replied

    Hello Aleksandar,


    commenting did not work.

    As requested here is a screenshot of the quotation marks.

  •  2,498
    Aleksandar replied

    Hello Sven.

    It looks like there was a misunderstanding. What I meant when I said "to record" the screen is, to create a video of Your actions on the screen (if at all possible), so that we can see what happens when You edit the table and view it from the website. The screenshot You sent doesn't help me much, other than visualizing the issue You described.

    As I said - when we created the jQuery file and created a table linked to an existing data source it doesn't show any errors and it is displaying data as entered. 

    Sorry for asking this much, but we need as much detail as can possibly be revealed when remote access isn't possible.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1
    roaddoc replied

    I understand but I seriously doubt that a video will offer any further insight: I click on "new". A popup opens so I can enter the data. I do so and finally click "ok". The popup closes. The spinning wheel does its job and then the data appears accompanied by quotation marks. I also got old data saved in the good old days that displays without quotation marks. But when I choose to edit those entries and click on "ok" .... they end up with quotation marks, too.

    Beyond that nothing special happens. If you got some sort of debug mode I shall be happy to run it.

    Another idea: Any database settings like data format or whatsoever that might cause wpdatatables to add marks?

  •  2,498
    Aleksandar replied

    OK Sven.

    I understand what You mean. Since You mentioned You have some placeholders, that got me thinking that it may be linked to them, but You said the quotation appears on every column, not just the ones that have placeholders active.

    There are no settings in the database that would cause this issue. I really tried to replicate the issue, but no matter how I set up the table or data, I can't.

    Given the fact that we cannot remote in, and we can't replicate the issue on our end, and also having in mind that everything worked fine before You updated wpDataTables, we can send You any of the previous versions of our plugin. Do You, maybe, remember what the version was before You updated it?

    I am sorry we couldn't figure it out, but we will keep an eye out on similar issues. If another customer reaches out to us with the same issue, and they don't have confidential data, so that we can remote in and see what happens in live environment, I'll send You the fix right away.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  1
    roaddoc replied

    Hello Aleksandar,


    problem solved, cause however still unclear. Now I added another instance of the same table via "Create a table linked to an existing data source" and placed its shortcode underneath the original shortcode.

    The new table works fine. Edits or new entries go without quotation marks. If I edit the same record using the first shortcode's table appearance on the same page, I get the marks again and, of course, they show up in the new table as well. While I can get rid of 'em using the new table, they remain persistent when edited in the first version.

    The only thing I can imagine is some sort of corruption in the database storage when the website has been migrated, which was accomplished using updraft plus. I'd like to compare the key-value contents for both tables. Are they stored in postmeta or where do I have to look?

  •  2,498
    Aleksandar replied

    Hello again Sven.

    I'm very glad to hear You solved the issue.

    We are not sure why this happened. There may have been a corruption when the website was migrated, but I cannot say with certainty.

    Since this table is an SQL query table, You can open it in any editor (Notepad++, PHP Storm, Sublime Text, etc.) and compare the values there. wpDataTables doesn't store the data from the table when You create a table using the first option (Table linked to an existing data source).

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables