Everytime we post a new or edited record using wpDataTable, every field gets wrapped in single quotes. If we edit the record twice, there are two single quotes on the right and left of every field. Three edits means three single quotes, etc... In addition, email fields are getting preceeded with a double bar (||) on top of the quotes. Something like: ||'[email protected]'
I don't know if this has anything to do with it but it seemed to start happening after we changed the setting for "Separate DB Connection" to off.
Thanks Aleksander. Since posting this question to you, we've reinstalled wpDataTables and the problem went away. Thanks for the tip though. I'm going to check on it anyway and implement your suggestion if necessary.
If you were to go with commenting that line of code, you're correct - you would need to do it again when the plugin updates. That is - if that resolved the issue, it would indicate your libxml version is outdated, and if you don't update it, you would need to comment the line of code in our plugin, to resolve it after every update.
However, since reinstalling the plugin fixed the issue, I don't think that's the case on your website.
Everytime we post a new or edited record using wpDataTable, every field gets wrapped in single quotes. If we edit the record twice, there are two single quotes on the right and left of every field. Three edits means three single quotes, etc... In addition, email fields are getting preceeded with a double bar (||) on top of the quotes. Something like: ||'[email protected]'
I don't know if this has anything to do with it but it seemed to start happening after we changed the setting for "Separate DB Connection" to off.
Thanks for any help you can provide.
Hello Pat
Can you please tell me which version of libxml do you use.
You should find the libxml version in your php.info file.
If the version is less than 2.7.8
In file wp-content/plugins/wpdatatables/source/class.wdttools.php and around line 1302 find this code
and comment it so the code look like this
It should work now for your version of libxml.
You will need to edit the affected entries, though.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Thanks Aleksander. Since posting this question to you, we've reinstalled wpDataTables and the problem went away. Thanks for the tip though. I'm going to check on it anyway and implement your suggestion if necessary.
If I were to implement your suggestion though, wouldn't i have to do it every time I updated the plugin?
Hello Pat
I'm glad to hear the issue was resolved.
If you were to go with commenting that line of code, you're correct - you would need to do it again when the plugin updates. That is - if that resolved the issue, it would indicate your libxml version is outdated, and if you don't update it, you would need to comment the line of code in our plugin, to resolve it after every update.
However, since reinstalling the plugin fixed the issue, I don't think that's the case on your website.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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