In data tables the totals under the column are not calculating. The result is zero. The most interesting fact is that when it is loading in backend it shows the correct calculations for a few seconds. After the loading is ready the results are turning to zero.?
In front end the calculated result is always zero..
see pictures below. The first column being an example of this problem.
Can you 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.
Like you said if you turn on bootstrap.js on front end show entries button will work. Clear button on the first table id 45 was not checked and that is the reason why they didn't show up. I do that and now that part is working fine.
The major problem why you have all the issue is probably because of complicated SQL queries.
Can you please try to create MySQL View for all tables in phpMyAdmin from that query and try to use that MySQL View as Data Input Source. When you create MySQL View you should create wpDataTable from this query:
I found temporary solution. Now is working fine, because i turn of server side processing on tables that you have this issue. The logic is changed from version 1.7.2. If you want to enable server side you must make simple view of that sql queries like
SELECT * FROM view_name
Also i notice you have some js errors on admin panel, and that is from plugin Date and Time Widget.(attachment)
If you deactivate him error disappear.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Hi,
In data tables the totals under the column are not calculating. The result is zero. The most interesting fact is that when it is loading in backend it shows the correct calculations for a few seconds. After the loading is ready the results are turning to zero.?
In front end the calculated result is always zero..
see pictures below. The first column being an example of this problem.
HI ilkkaH,
Thank you for your purchase.
Can you 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.
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
Hi ilkkaH,
Like you said if you turn on bootstrap.js on front end show entries button will work. Clear button on the first table id 45 was not checked and that is the reason why they didn't show up. I do that and now that part is working fine.
The major problem why you have all the issue is probably because of complicated SQL queries.
Can you please try to create MySQL View for all tables in phpMyAdmin from that query and try to use that MySQL View as Data Input Source. When you create MySQL View you should create wpDataTable from this query:
SELECT * FROM view_name
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
Hi ilkkaH,
Yes its working now, and i am just writing you.
I found temporary solution. Now is working fine, because i turn of server side processing on tables that you have this issue. The logic is changed from version 1.7.2. If you want to enable server side you must make simple view of that sql queries like
SELECT * FROM view_name
Also i notice you have some js errors on admin panel, and that is from plugin Date and Time Widget.(attachment)
If you deactivate him error disappear.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
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
Hi ilkkaH,
You are welcome. Glad that we solved the issue.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
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
I have exactly the same issue, but I can't work with views in MYSQL and I can't disable server side processing, because the table has to be editable.
Is there any other solution for this issue?
Thanks a lot in advance!
best regards
Tobias