I have an error:
DataTables warning: table id=table_2 - Requested unknown parameter '42' for row 0, column 42. For more information about this error, please see http://datatables.net/tn/4
But the table with ID 2 doesn't even have 42 columns and I have no idea which row has number 0?
Sorting feature doesn't work correctly. It takes into account consecutivenumbers rather than the numbers before the comma.
Also I can't add in editor anything to cells in the columns which are not visible in the front-end but I'm not sure if it is how it works?
I had the same type of tables on my demo site with the same plugins, theme, the same version of PHP and there were no problems.
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.
Also point me to the table ID so I can take a look.
I noticed that you are using 1.7.2 version of our plugin and the 2.0.2 version is released. So can you please update the plugin to the latest version and I will investigate if you have that issue again.
You can auto-update the plugin by entering the purchase key in the wpdatatables settings page or you can manually update the plugin by following this steps:
Can you please check in your database are the column type for that columns is the same like in the plugin. For example if we take a look at column "Liczba klientow" that column type is set to float, please check in database is it set to float also.
For the editing invisible columns: I will need some more details so can you please point me out on the table ID and give me some example of the column which is invisible so I can reproduce the issue.
Indeed most columns have type varchar(255) in the database.
And about editing invisible columns:
for example in table with ID 4 a column 'Liczba klientów A' can't be edited in excel-like editor (I can't put anything in that column). The same problem is with all invisible columns. I had the same problem with a column "Obroty ogólne A' and I made it visible to edit it. This is not a very big problem, but this sorting issue is important to solve.
Ok lets first solve the issue with the sorting. As I can see the most of the columns are float so can you please change in your database the column type for that columns to be FLOAT column type.
Unfortunately i cant't change the type in my database, there is an error which says that the specification of the column isn't right. But what I've just noticed is that if I change column type to (for example) STRING and then to FLOAT again, sorting works like it should (I've done that with columns "Obroty ogolne A", "obroty ogólne B", "Liczba klientów B"). So I think that will fix my problem. :)
Hi,
I have multiple problems with my tables.
I had the same type of tables on my demo site with the same plugins, theme, the same version of PHP and there were no problems.
Will be grateful for any help.
Jola
This is how "sorting" looks like
Hi Jola,
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.
Also point me to the table ID so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[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
Hi Jola,
I noticed that you are using 1.7.2 version of our plugin and the 2.0.2 version is released.
So can you please update the plugin to the latest version and I will investigate if you have that issue again.
You can auto-update the plugin by entering the purchase key in the wpdatatables settings page or you can manually update the plugin by following this steps:
1.) Download zip from this link
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables, and then activate it again.
About that error you have maybe the best option is to check your server log and see if there are some errors.
Best regards.
Kind Regards,
Miloš Jovanović
[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
I've updated the plugin but problems still exist: sorting in front end and editing invisible columns in back end.
Hi Jola,
Ok I can see the issue about the sorting:
Can you please check in your database are the column type for that columns is the same like in the plugin.
For example if we take a look at column "Liczba klientow" that column type is set to float, please check in database is it set to float also.
For the editing invisible columns:
I will need some more details so can you please point me out on the table ID and give me some example of the column which is invisible so I can reproduce the issue.
Thank you.
Kind Regards,
Miloš Jovanović
[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
Hello,
Indeed most columns have type varchar(255) in the database.
And about editing invisible columns:
for example in table with ID 4 a column 'Liczba klientów A' can't be edited in excel-like editor (I can't put anything in that column). The same problem is with all invisible columns. I had the same problem with a column "Obroty ogólne A' and I made it visible to edit it. This is not a very big problem, but this sorting issue is important to solve.
Thank you.
Jola
Hi Jola,
Ok lets first solve the issue with the sorting.
As I can see the most of the columns are float so can you please change in your database the column type for that columns to be FLOAT column type.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Unfortunately i cant't change the type in my database, there is an error which says that the specification of the column isn't right. But what I've just noticed is that if I change column type to (for example) STRING and then to FLOAT again, sorting works like it should (I've done that with columns "Obroty ogolne A", "obroty ogólne B", "Liczba klientów B"). So I think that will fix my problem. :)