3621 comments found.
Hello, I would like to know if I can handle error reporting via SIGNAL SQLSTATE from the database. In the examples I’ve seen that only SQLSTATE 45000 is visible blocking the execution, I would like to know if other warning codes such as 01000 (or others) are also handled in the interface. I didn’t find anything in the documentation. Thanks in advance.
Hello,
Our apologies for the waiting time on this reply.
We are checking about this with our Developer Team and waiting for their reply.
As soon as they advise, we will report back right away and going to let you know if they require more details from your end to clarify the query.
Thank you for your patience.
Hello again,
Thank you for all your patience, we have feedback from our developers about this.
They are not sure what you are trying to achieve exactly, but here is what they advised in general on the subject of SQL error handling in our Plugin.
Our Plugin is handling all types of general errors which an SQL database would return, but if you wish to create a custom SQL Query which would pull a table and for that Database call to contain “SQLSTATE”, that is not included in our Plugin currently.
In other words, wpDataTables is used to load the data from the database, not for handling ‘low level Database errors’.
You can achieve what you need via custom PHP, though.
Please be advised that this falls under custom solutions, so it is not covered by our Support, but here is an example to get you started.
You can try one of our hooks :
wpdatatables_filter_mysql_query( $query, $tableId )
This filter is applied to the MySQL query before it is sent to MySQL server.
$query is the query text.
$tableId is the table identifier from the MySQL table (wp_wpdatatables).
Here is the example :
add_filter(‘wpdatatables_filter_mysql_query’, ‘modify_wpdatatables_query’, 10, 2);
function modify_wpdatatables_query($query, $table_id) {
try {
// Put yout custom logic to handle errors or modify the query
} catch (Exception $e) {
// Handle the exception, e.g., display an error message
echo ‘ Error: ’ . $e->getMessage() . ‘ ’;
}
return $query;
}
We hope that helps as an idea to get you started.
Kind regards.
I upgraded from 6.3.1 to 6.3.2 and got a critical error on a page that uses the wpDataTables (https://www.newhollandrochester.com/parts/new-holland/resources/oil-capacities-and-filters/). I will note that I have other pages using wpDataTables that I did not have this happen to, so I’m not sure if it’s just because this is a different table type then the others maybe. Here is the error details I received on it:
An error of type E_ERROR was caused in line 4586 of the file /var/www/html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php. Error message: Uncaught Error: Call to a member function setFilterType() on bool in /var/www/html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php:4586 Stack trace: #0 /var/www/html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(4562): WPDataTable->prepareRenderingRules(Array) #1 /var/www/html/wp-content/plugins/wpdatatables/controllers/wdt_functions.php(1392): WPDataTable->fillFromData(Object(stdClass), Array) #2 /var/www/html/wp-includes/shortcodes.php(433): wdtWpDataTableShortcodeHandler(Array, ’’, ‘wpdatatable’) #3 [internal function]: do_shortcode_tag(Array) #4 /var/www/html/wp-includes/shortcodes.php(273): preg_replace_callback(’/\\[(\\[?)(wpdata…’, ‘do_shortcode_ta…’, ‘
Hello,
We apologise for the delay on this reply. Thank you for your patience.
We are unable to reproduce an error like that and it does seem to be isolated to some step you specifically might have done on that specific table, and perhaps setting a specific filter type/filter setting to a column.
Did you try what happens if you try to make a new/same table like that and try to ‘retrace’ your steps to try to isolate what was the last ‘action’ or ‘setting’ you tried to modify when that error happened to that table?
Also, does the table work OK in the back end preview and the issue only happens on front-end Page;
or is it the same error on the Table’s back end?
It will be best if you can open a private ticket on our Main Support Platform, because our Agents there can go in more details and help you do full troubleshooting, etc.
So, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly help you in full details there.
Just refer to this correspondence and send them more details as we asked here, to save time.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I finally got this issue resolved. So on the page that threw the error in question, I had 19 different datatables on it (all of which are hidden by default and requires user interaction first to view any of them).
It turns out that on version 6.3.1 when the page itself appeared to load fine, a couple of the tables themselves would not display and instead have an error “One or more columns doesn’t have a header. Please enter headers for all columns in order to proceed.”
When trying to view these tables from the backend, I would get the same error. So, I opened the Excel files that source the table data locally and saw that all the table columns did in fact have a header name. However, some of the columns had blank data in them, so I just put n/a in a cell so that every column had some data in it.
After reuploading the updated file to the server, the table still would not open, but I was then able to recreate the table successfully. I then updated the shortcode values to the new tables on the page, and it all worked successfully on both 6.3.1 and then also on version 6.5.
Just figured I’d update what happened here to help you or anyone else who may come across a similar issue.
Thanks,
Jesse
Hi, Probably after the last update of your plugin, I lost the ability to display and edit tables in “Excel-like” mode. In the “Standard view” mode, everything is displayed correctly and I can see all the rows of my tables, but after switching they look empty. Please advise how I could fix this?
Hello,
Firstly, we apologise for such long waiting time, we had a holiday break, but should be back to standard reply times going forward. Thank you for your patience.
You are right, this is a new bug which only happens in version 6.3.2 , it was not present before.
Our developers made a quick workaround fix as a temporary solution, but they will build the final fix version, it should be added in our next update.
Our main Support can send you the fix as two edited JS files for our Plugin as attachment, we are not able to send them here.
Could you please open a private pre-purchase category ticket on our Main Support by clicking here, and our agents will gladly send you the fix with instructions how to apply it there.
We sincerely apologize for this inconvenience.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello Tms-support!
Thank you very much for your answer and willingness to help. I just sent you a message via your support system. So I’m waiting for the promised two files 
Best regards!
Hello again,
Our Support found your ticket and they sent you the files along with the instructions.
They will keep following up to make sure that the issue is fixed.
Thank you.
Newbie here. Signed up for envato account just to get your plugin.
BUT: PRE-SALES QUESTION.
I saw that if I install two plugins (wpdatatable and powerful filters) I can have the filter form at the top of the table and I can hide the table before filtering that can be cascaded.
My question is, is it possible inherently to achieve a functionality where the filtering button can de placed anywhere independently and the table be loaded in a separate desired section? For instance, if I have Travel Destinations by country and the landing page contains banner with a call to action at the top which is mainly a filtering button in a separate section below the banner to have the table loaded showing the destinations based on the country chosen?
Thanks again for developing this impressive plugin.
Nadya, A.
Hi Nadya, A.
Firstly, our sincerest apologies for getting to your question just now.
We have been experiencing an unusually high number of tickets.
I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
At the moment, we don’t have an ‘out of the box’ solution for what you described, in terms of setting up a ‘call to action’ on a button which is placed independently from a Table.
Right now, the filters ‘in a form’ need to be right above the Table and the Powerful Filters Add-on just enhances the advanced column filtering features;
as you said, it adds the “Hide table before filtering” with the “search button” and the “Cascade filtering”, which can all be combined;
but it needs to be right above the Table.
You can add custom CSS to make a ‘visual separation’ between the elements, but we can not make a completely separate button as a ‘call to action’ anywhere on the Page/ or on another Page, etc.
If you wish to see the use-case as an ‘out of the box solution’ in the future, you can make a development suggestion.
Please feel free to search on our suggestions page, to see if someone may be already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Dear Team,
Thank you for elaborate response. I will ask my developer to check if he can safely modify the codes and still maintain compatibility with future updates.
I believe this is best on SQL functions and possibly he can produce something even if it means a separate addon that can replicate the functionality of the powerful filters and integrate with wpdatatable.
Thanks again, Nadya, A.
Hello Nadya,
Our sincerest apologies for replying to this just now, thank you for your patience.
You’re welcome, we are happy to advise.
When it comes to custom solutions, our Support does not cover them, even though we like to share any useful guidance we can for some specific workarounds;
for this specific use-case, we don’t have any custom idea available yet.
If you have coding skill or your own developer, you can try a custom solution, but if you modify some of our Plugin’s code/files, we can’t guarantee that will work the same for all future versions, since our developers change some pieces of code during major updates, depending on new features released/improvements, bug fixes etc.
And usually any code you change would get overwritten during updates.
Only for example, if you add some custom CSS or custom JSS to the Main Plugin settings ( Custom CSS can also be added to the Table Customize itself) or add CSS/JS to a WP Page itself, that does not get affected by our Plugin’s updates.
Kind regards.
I’m trying to create a simple table but it keeps giving me an error. I see in your changelog this issue was fixed but the version on envato is the outdated file. Can you please update or direct me on how to download this. I activated on the plugin settings but it wont give me an update.
Nevermind sorry it just took some time to run the update. Its working.
Hello,
Just a follow up, we are glad to see you managed to resolve everything in the end.
Wanted to double-check.
If you notice any issues, please don’t hesitate to open a ticket on our Support and one of our Agents will respond as quickly as possible.
Thank you.
Hello, I’m trying to create a wordpress table with fields from my ACF but I keep getting the error
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘FROM LIMIT 5 /* From
on the preview query screen after selecting my custom post type and fields.
Hello,
At the moment, we don’t have a native integration with ACF.
If you wish to see that in the future, you can make a development suggestion.
Please feel free to search on our suggestions page, to see if someone may be already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
As the custom posts/fields, are a part of the WordPress database, pulling this data can only be done through custom SQL Query based Tables.
Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need.
A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.
You can also try the other SQL Query helper Tool, Create a MySQL-query-based table by querying a database ,
that one has a wider range of all tables you can choose from your Database outside of WPDB.
- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible.
Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.
You can check out this this official page of WP codex, for help with writing custom Queries.
We hope that helps. If you have any additional questions on this subject, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly answer any additional questions there.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
The latest version of wpDataTables (6.2.1) is not appearing in my downloads
Hello,
We deeply apologize for any inconvenience stemming from the delayed release of the latest wpDataTables version on the Envato side.
Our team in charge of managing updates on Envato is currently working to hasten the release of the newest version.
Your understanding and patience throughout this process are invaluable to us.
Rest assured, we are exerting every effort to swiftly resolve this issue.
In the meantime, if you wish, we can send you a copy of the latest installation.
If that is the case, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice there, and our agents will gladly send you the installation there, if needed.
Once again, we sincerely apologize for the inconvenience of this delay.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello again,
Just following up to confirm our Team has updated the latest available wpDataTables 6.3 here on Envato, so you should be able to download it now.
If you encounter any issues, you can open the private pre-purchase ticket on our Ticksy/main Support, and one of our Agents can help you in more details.
Kind regards,
According to WordPress, version 6.3.1 is now available, but it isn’t yet on the Envato site. So I’m still unable to download the latest version.
Hello,
We apologise for any inconvenience caused by the Envato side’s delayed release of the most recent version of wpDataTables.
We’re now trying to expedite the publication of the most recent version with our team responsible for overseeing changes on Envato.
Your patience and understanding over this process have been really helpful to us.
You can be confident that we are working hard to find a quick solution to this problem.
In the meantime, if you wish, we can send you a copy of the latest 6.3.1 installation.
If that is the case, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly send you the installation there, if needed.
Once again, we sincerely apologize for the inconvenience of this delay.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello, Just following up to advise, our Envato Team has now updated it here to the latest 6.3.1 version, so you will also be able to download it directly from your Account. Apologies again for the delay. Thank you.
In string-type cells that start with ‘0’, the leading ‘0’ is automatically removed. The leading ‘0’ remains in the administrator screen, but is removed in the frontend. How should we preserve 0? I tried manipulating the options in every possible way but without success.
Hello,
If we understood, on the Back-End preview of the Table, it loads correctly with the leading zeroes, and the issue where the zero is removed only happens on the Front-End?
We are not able to reproduce this, so it is most probably some kind of a conflict on your Site. wpDataTables is a WYSIWYG (What You See Is What You Get) concept-based plugin.
This means that the table should look the same both in the back-end and in the front-end. If your front-end table looks and behaves differently than in the back-end, this usually implies that there is another plugin (or the current theme) that’s changing the behavior of our plugin.
Can you please change the theme and see if the issue is resolved?
If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be).
If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred.
Once it does reoccur, you will have found the plugin causing the issue.
Let us know if you isolate a conflict with these steps. Thank you.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Thank you for your kind reply.
I found the reason. I’m already using a skeleton-bones theme (underscore). I already tried disabling all plugins without any custom code, but the symptom was the same.
The problem was solved by unchecking the table option cache a while ago. In my case, when I checked the cache function, the leading 0 was removed even from the value of the string cell, and when I unchecked the cache function, the problem was solved. I don’t know if it’s just my problem.
+ Additional questions Can I have different cache updates for each table? Now, it seems like all tables’ caches are being purged at once. Did I understand correctly?
Hello again,
Firstly, thank you for reporting this bug with the ‘leading zero values’ as Strings and our Cache option.
We are able to reproduce it exactly as you described it.
For example, if we make a String Column in our source file ( Google Sheet/CVS or Excel) with values like 01, 02, 03 and so on;
At first, the Plugin reads that Field as ‘integer’ and removes the leading zeroes, then we manually change it to a String Type to render the full values.
Then, when we activate our “Cache option” on on the linked Table, the Front End of the Table somehow removes the leading zero from the String Value.
If the “Cache option” is disabled then the bug does not happen.
We passed this bug to our QA Team.
They are conducting further tests and our developers will do their best to isolate the root of the bug as quickly as possible.
We are not able to say an exact ETA when this will be fixed, but you can follow our ChangeLog Page (https://wpdatatables.com/help/whats-new-changelog/); it is also available in your Plugin Dashboard – so during each Update, we make patch notes about all the fixes added.
If our developers make a ‘temporary fix’ in between updates, we will let you know. Then, you could open a Private ticket on our Main Support, and we would send it to you.
Sorry for this inconvenience.
For the time being, the only solution is not to use our “Cache” option in the Table if you need to have values like that with the leading zero until we fix it.
2. In regards to your second question, for now we do not have a way to set a different Cron Schedule for individual tables to update their data via our “Auto Update Cache” Feature.
All the tables with the “Auto Update Cache” option enabled will be updated at the same time your “Cron Job” triggers.
If you wish to see a built-in option to set a different time interval for the “Auto Update Cache” for individual Tables; Please feel free to search on our suggestions page (https://features.wpdatatables.com/),
to see if someone may be already suggested this feature. If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog if you’d like(https://wpdatatables.com/help/whats-new-changelog/), where we state any changes/new features/bug fixes during updates;
and our newsletter(https://wpdatatables.com/newsletter/), so you’re informed about new features, bug fixes, freebies, etc.
I just wish to clarify something, about what the Cache option is used for.
This is not used to purge cache – it is used to store the Data from the Table as Cache in our Plugin’s Database for improved Performance;
And if you additionally activate the “Auto Update cache” option – it is used to automatically update the data in your linked Table ( without needing to hit “Save Changes” on back-end).
For example, if you add a new row on your Source File which is synced with the Table;
If you don’t set up the Cron Job and our “Auto Update Cache” option, then the only time the table updates to pick up the new rows/edited data is when an Admin clicks “Save Changes” on the Table Back-End.
With our “Auto Update Cache” option you can set the Cron Job schedule and choose the time interval when it will automatically trigger to update the Table data from the source.
You can see more detailes explained how it works here : https://wpdatatables.com/documentation/table-features/caching-data-and-auto-update-cache-in-wordpress-tables/.
So, we will report back if there is any workaround fix for the bug of the ‘leading zeroes’ issue with our Cache Option at any point in between two Updates;
Otherwise, you can follow our ChangeLog and we will write the patch Note there when the fix is added.
If you require any assistance or have any additional questions about how that Feature works, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I did not ask about cache settings for each table because of leading 0. Since each table has different contents, it is better to have different cache conditions. Yes your explanation, that’s the cache. Thank you for the long reply.
Apologies for only just now seeing this comment.
Thank you for the feedback; we will pass it on to our developers. Currently, it is not possible to have different cache conditions for each table. However, our developers will do their best to work on a solution in the future.
Regarding the bug with leading zeroes, they will strive to implement the fix as soon as possible.
I apologize for providing too many details about the caching functionality; that was unnecessary.
Thanks again.
It will be great if this will be possible:
I create wptable based on the data in google sheet. Then on the wptable I just need to add 2 columns. 1 column editable by frontend user entering only number and 2 column which will calculate that number * price from the table. Table will not be able to be saved but only to PRINT.
the whole idea is to use your plugin for B2B quotations and to not store any pricing in the wp database but rather on google sheets.
Hello,
We are sorry to disappoint you, but this will not be possible.
The main reason is, you can either ‘link/synchronize’ the Google Sheet as data source to output it in a Table;
or you can import the Data from your current state of the Spreadsheet in a new Manual Table.
1. A table which is linked/synced from the Google Sheet can not be made editable in our Plugin, and that does not make a Table in the SQL Database.
2. On the other hand, a table which is imported to make an editable Table, is editable from our Plugin’s end ( back and front-end), but it is not possible to then ‘pass this data back to the Sheet’ in an automated way, because in this case, the data is only taken from the Sheet in the moment of Table creation, it loses any ‘link/synchronization’ from the source, and all the data is then stored in the SQL Database.
Let us know if you have any additional question.
Thank you.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, Please consider this as pre-sale question.
My requirement is:
I have a data table , lets say students data of a city, the data table is public, anyone can view the table, but the table’s only one column is public, remaining columns are hidden.
The table has several types of filter , visitors can filter data to display results as per it.
Now, to get access/download/export to the restricted/hidden data there should be a payment button, so the visitors will have to make payment to export the data (payment gateway can be anything).
please let me know if this is possible ?
Hello,
1. When it comes to the first part of this scenario, in terms of showing one Column and hiding the remaining Columns, that is possible if you Hide the Columns from the Table’s Back-End Settings.
Please check this Page that shows how that is done.
And please note the current limitations on this feature at the bottom of that Documentation.
2. Regarding the filters, you can easily set up several Column filters for tables, please check more here.
3. Regarding the last point of your use-case, as you described, to have a payment button, then if a visitor pays, that triggers access for any function which was previously hidden;
Sorry to disappoint you, but at the moment, we do not have any built-in way to achieve that.
Generally speaking, our Plugin does not have the ability to restrict/hide access to any Table.
You can only try a custom workaround by hiding a specific Table version from ‘regular visitors’ and just reveal it for some Users that have a Custom User Role, but our Support does not cover custom solutions like this.
You can try restricting access with some Membership Plugin, and maybe you can also add “User Role Editor” Plugin in the mix to create Custom User Roles;
Then, for example, you can add some Payment Gateway to your site, such as WooCommerce or similar, and you can try to configure a setup in a way that, if a User pays, then their User Role “updates” or something like that;
then with a Membership Plugin you could set it up to only show a specific Page with a Table that has some “export” options enabled to only reveal for those Users, etc.
We hope that helps as a starting point/idea.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Please update to 6.0.1!
Hello,
We sincerely regret any inconvenience caused by the delayed release of the wpDataTables version 6.1.
Our dedicated team responsible for updating the Envato side is actively working to expedite the release of the latest version.
Your understanding and patience during this process are greatly appreciated.
We assure you that every effort is being made to resolve this matter promptly.
In the meantime, if you wish, we can send you a copy of the 6.1 installation.
If that is the case, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice there, and our agents will gladly send you the installation there, if needed.
Once again, we sincerely apologize for the inconvenience of this delay.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Pre-Sale Question
I’m looking at the demos, and reading the documentation, but I can’t seem to find the answer.. Is there a way to add a custom row ID? Like use post_id use as row ID? Thank you.
Hello,
We are not sure exactly what will be the purpose/functionality of that “row ID” column.
If you mean to choose what will be your unique row identifier for editing of a custom SQL Query based Table, you can do this if you first enable “Allow editing” under the “Editing” settings on your Table, then on that section you will see the option to choose which Column will be used as “ID column for editing”.
It is important to know that the column you choose as the “ID column for editing” should be set as a unique auto-increment integer type on your source SQL Table, otherwise you will most probably have editing issues.
Please check more details explained about how Editing with our Plugin works on this Documentation.
Also please make note of the limitations pointed out on that Page. We will copy the most important ones here :
Only one MySQL table can be edited at a time.
Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.
Server-side processing MUST be turned on for front-end editing
– Note: It will turn on automatically if you forget to enable it.
MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.
Before purchase, you can test the full features of our Plugin on our Demo Sandbox site here : https://sandbox.wpdatatables.com/.
If you have additional questions about this, please open a pre-purchase category ticket on our Main Support by clicking here, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello, thank you for responding. The idea is, I want to link each row to a modal/popup to show the complete details of the post that are not in the table. I can only achieve this if I can have a unique identifier on each row/tr like post_id. I tried working around on your demo but I can’t seem to find anything that would achieve this. Thank you
Hello,
If you wish to try with our Built-in Options to have an ‘initial Table view’ that does not show some Columns/has them hidden, but as part of the Table;
then when a user ‘clicks’ into a row, or clicks in a ‘more details’ button, to show a “PopUp Modal” that reveals the complete details ( all the Columns which you previously have hidden), for this you can try our Master-Details Add-on.
Please check more details with our example Table how it works here.
Before purchase, you can test the Master-Details Add-on features on this sandbox site.
Let us know if that helps, or if you need something else.
Thank you.
Does the plugin disable after the support period. I have my purchase code but the plugin will not activate (bought in 2021).
Hello.
The plugin will still work at its full functionalities.
After your Support period on Envato expires, you will still be able to manually download your latest Plugin installation from your Envato Marketplace Account and manually update the Plugin;
but you will not be able to activate the licence through the Plugin’s Activation settings and thus won’t be able to perform Auto-Updates of the Plugin after the Support Period has expired.
If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello, mike365.
We apologise for this initial detail about not being able to activate the Plugin/licence activation after the Premium Support expires; we double-checked with the developers and it should still work;
The only point that expires after 6 to 12 months is the Premium Support ( depending if you additionally purchased the extended Support on Envato or not).
So, you should be able to still activate your licence on the Plugin Activation settings.
If you still can’t update, our Main Support can ask you for some additional details, and they can help you troubleshoot.
If that is the case, If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, write your Licence key on the ticket, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
why is the plugin saying “Error You are trying to load a table of an unknown type. Probably you did not activate the addon which is required to use this table type.” – I’ve paid for the full version!
Nothing has given me a problem previous – the current version is 3.4.2.1
and nothing has given me aproblem previous – the current version is 3.4.2.1
Hi there.
Version 3.4.2.1 is the latest version of wpDataTables Lite so that’s not the full version of the plugin.
That’s probably the reason why you can’t load certain tables – they aren’t supported in Lite.
Please log into your account, download the latest version of wpDataTables (6.0), and update from Lite to full.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I need to modify the wpDataTables plugin. I want to make the data table hidden, so that the search information will appear only after pressing the search button.
How can I evaluate this by using the plugin?
Hello, You will be able to achieve this with our premium Add-on Powerful Filters. This add-on has one of the options called “Hide Table Before Filtering”. That allows you to set up one or more filters which the user has to choose, and then only after they hit “Search” button, the filtered Table will load.
Please check more about this add-on here.
https://wpdatatables.com/documentation/addons/powerful-filtering/Before purchase, you can test all plugin and Add-on features on our sandbox site here : https://sandbox.powerful.wpdatatables.com/.
Let us know if you have any additional questions.
If you require more details about a specific use-case, you can always open a Support Ticket on our Main Platform here and one of our Agents can advise you in more details : https://tmsplugins.ticksy.com/.
Kind regards.
is it possible on print button and pdf choose what columns to print or show ?
Hello, To begin, we want to extend our heartfelt apologies for the delayed reply,
which is due to an unexpectedly high volume of inquiries.
We truly value your patience during this period.
It is not possible to choose which Columns will be exported after you click in the “Print” or “Export as PDF” buttons.
It is just going to export all the Columns which are currently visible in the Table on the Page. You can only allow users to have the ‘Column visibility’ option in the Table Tools, then a user can toggle which Columns are Visible in that moment before they export the Table.
Please note that it also includes the columns that you’ve hidden from the back-end. You can un-select the button to hide the column and select it back to show it.
-
You can additionally see here how to Show/Hide Columns : https://wpdatatables.com/documentation/column-features/column-visibility/. Our Table Tools functionalities are based on a 3rd party HTML5 library and they are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
We will just point out a few limitations here:
- For tables with server-side processing enabled (https://wpdatatables.com/documentation/table-features/server-side-processing/), only the visible rows will be exported to any format.
If you want all the rows of the table, regardless of Pagination to be exported (or copied to a clipboard), for server-side processing tables you need to choose the “Show All rows” feature in the “show … entries” block, and then do the export.
- For other Tables that have server-side processing disabled, it exports all rows regardless of Pagination.
You can not export columns that are hidden – they will not be visible in any exporting or printing tool. Please check the full list of limitations on this Documentation : https://wpdatatables.com/documentation/table-features/table-tools/. -If you wish to try adding better PDF export functionality, our advice would be to acquire something similar to the WP Advanced PDF plugin (https://wordpress.org/plugins/wp-advanced-pdf/), which offers a lot more options when creating PDF files from our tables, along with other content on your website.
We hope this helps. If you have an idea how we can improve this in the future, Please feel free to search on our suggestions page (https://features.wpdatatables.com/), to see if someone may be already suggested this feature. If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog if you’d like(https://wpdatatables.com/help/whats-new-changelog/), where we state any changes/new features/bug fixes during updates;
and our newsletter(https://wpdatatables.com/newsletter/), so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
Hello, I need to create a platform that allows the consultation of projects and apartments sold by construction companies and real estate agents.
That is, a platform where the construction company places its sold projects and the agents and the client who is going to buy that particular unit can check if it is available or was sold.
The problem is that scammers are constantly appearing who sell the same property over and over again.
Is it possible with this plugin to achieve this? Do construction companies register and publish or record the units sold so that customers can consult from the front-end?
Hello, It depends on exactly how you plan to store this Data and if someone is going to manually input all the records about which units are sold and which are available, or if you plan to pull that from some live source data, which will be on some live server, for example maybe on some API, or on an SQL Database or maybe something else. And what will be the exact expected functionality of our Tables, such as for the editing, who should be allowed to edit the data, etc; how are they inputting the same property which was already sold ( if we understood that part correctly), so the best option going forward will be for you to consult in more details about your use-case with our Main Support.
We will also need more details about the scammers you mentioned,
If you can please open a ticket on our main Support platform here,
https://tmsplugins.ticksy.com/
and one of our Agents will respond as quickly as possible.
They will ask you some additional details about the use-case and they will then advise you further if the use-case is possible with our Plugin. It seems you still do not have a licence with us, so just choose the “Pre Purchase Questions” Category and it won’t make you input a licence key.
Thank you for understanding.
Kind regards.
Hi, After this update, the tabs inside the “Settings” are not shown. It shows on the url but does not get activated. Can you please check that please?
Hello, This is most probably some kind of conflict on your Site, your current Theme or another Plugin might be having a conflict with our Plugin, which prevents the tabs inside Settings to properly load.
Can you please change the theme and see if the issue is resolved? If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be). If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. Once it does reoccur, you will have found the plugin causing the issue. Let us know how it goes. Kind regards.
Hello,
I have 3 lakh data in CSV of the files, And I want to show this data in a page. Will it slow down the site? I installed the free version and checked and I see my website is very slow.
Will this be a problem if I take the premium version? And what configuration do I need for hosting?
Thanks
Hello, We would like to begin by extending our heartfelt apologies for the delay in our response, which is due to an unusually high volume of tickets. We sincerely regret any inconvenience this may have caused, and we truly appreciate your patience during this time.
In regards to your questions :
1. In regards to slow load, The loading speed depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at this SQL table on our documentation , which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time.
When it comes to tables linked to a CSV file specifically ( same goes for Excel, Google Sheet, basically all tables which are not SQL based), it depends how many rows that CSV has. You can try with our Cache and Auto Update cache feature (https://wpdatatables.com/documentation/table-features/caching-data-and-auto-update-cache-in-wordpress-tables/) this can help with the load time significantly for tables that have approximately between a thousand and 5 thousand rows, but we still recommend keeping the data in these files down to around 5.000 rows.
If your source data goes above that size, then we recommend to try with our Premium Plugin version and import the CSV data to make a new Manual Table. (https://wpdatatables.com/documentation/creating-new-wpdatatables-with-table-constructor/importing-data-to-editable-mysql-table-from-excel-or-csv-with-table-constructor/)
This table won’t be synchonized with your source CSV, but it is ediable in our Plugin. (https://wpdatatables.com/documentation/front-end-editing/creating-editable-tables/)
Tables like this have server-side processing, which helps with the loading time. (https://wpdatatables.com/documentation/table-features/server-side-processing/)
3. When it comes to a configuration from the Hosting’s End, there is no ‘universal’ configuration, but a general rule is that , the higher you can get their PHP Memory Limit, the more data your WordPress Page will be able to handle. Same goes for PHP TimeOut limit, the higher you set it , your WordPress will be able to handle any kind of a ‘time out’ error in general.
On this Page you can see a useful Article from wpBeginners, they advise what might be best as hosting configuration : https://www.wpbeginner.com/beginners-guide/how-to-host-a-website/ And here you can see their recommended list of Hosting Providers : https://www.wpbeginner.com/wordpress-hosting/We hope that helps. Kind regards.
Thanks 
Hello,
No problem, we are happy to advise.
If you encounter any issue with the subjects/points we wrote about here,
our Main Support Agents are always available to help you in more details,
so please don’t hesitate to reach out to them on our Main Support here. https://tmsplugins.ticksy.com/
Thank you,
Kind regards. 
Can’t update the theme, can’t get support. This is a mess. See me try to update theme – https://www.loom.com/share/Settings-Alaskit-WordPress-12-September-2023-fbd510284bab4930a9bc1dc918c98a85?sid=cbf223dd-f7c0-4227-b631-064c6a7e0a24
See me try to reset my password so I can submit a ticket – https://www.loom.com/share/Cant-update-password-da367646b9784b7b9b89c295d31845eb?sid=45d424cd-5f8b-4e18-bcc2-fbf11377b7ee
So… what am I suppose to do? What am I suppose to do? I can’t contact support. I can’t activate the theme. I can’t update it. This is ridiculous.
Hello, Firstly, we would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. We are sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
1. In regards to the activation with the Envato API : This happens because the Envato’s API is limited to linking 3 requests per second you will probably need to click on “Activate with Envato” a few times until the license is activated,
but once it is activated, it will stay active and you will be able to update the plugin through the Plugins page.
Can you please try now, and let me know if it works?
Just remember that you probably will need to click on “Activate with Envato” a few times before it actually activates the license.
2. In regards to the Ticksy issue for the password reset, we apologise for this inconvenience, our managers will help you, they can set up a password for you and they can send you the new password to resolve this issue. If you could please contact them on this email support@tmsproducts.io and they will help you resolve this issue.
Let us know if that sounds OK. Thank you. Kind regards.