About a year ago I had migrated a site and had a similar problem with tables getting hung on the backend as I was trying to create them from mySql queries.
I tried a few of the tricks from the previous troubleshooting but was not able to solve the issue.
I do have some debugging plugins active and it seems like these are the errors I'm getting:
At the end of last week we didn't work because of the national holiday.We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Can you please tell me which version of plugin you use?
Also can you sent me that query so we can take a look?
We can see that you are using very complicated query. Business logic for parsing queries is changed from older version to speed up their execution. Because of this new parser this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes).If your query returns data that you need in phpmyadmin, please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
I suggest you a solution in previous post. If your query works when you execute him in phpmyadmin and it return data that you need you can make a view like I describe to you in previous post. If query is not working in phpmyadmin also will not work in our plugin.
I'm still having massive problems with this plugin, even putting things into views, I can't get most of my queries to work.
I have to make a decision whether or not to stay with this plugin or go with an outside table and chart builder. I would rather stick with wpDataTables as I have multiple sites using it (the non-updated version).
Can I pay for you guys to do a professional review of my site and help me get your plugin back up and running?
For example i have a table that stores around 250k records, i currently have that table filtered to return value i only need to return that is around 75k records. But if i want to return all the records i get a error (failed to load data response) ajax error. Is there a work around? or is there a way to retain the same query but set a limit to how many records return until the request is met? for example i wouldn't want to display all 250K records on one page, i would set the show 50, then allow paging, so the next 50 records and so on... here is a good demo to help visualize what i am saying.
We lunch update 2.2.1 of our plugin recently. Can you please update wpdatatables and check are you still have issues. After update please clear server and browser cache.
HI purcepa,
When you have questions or issues which are not related to the title of the active ticket or ticket is not yours can you please open a new one and we will help you there. In that way, issues and questions which are related to different subjects will be in different tickets so other customers can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is describe already.
Hello,
About a year ago I had migrated a site and had a similar problem with tables getting hung on the backend as I was trying to create them from mySql queries.
I tried a few of the tricks from the previous troubleshooting but was not able to solve the issue.
I do have some debugging plugins active and it seems like these are the errors I'm getting:
PHP Error
Count
Location
Call Stack
Component
Warning
Invalid argument supplied for foreach()
1
wp-content/plugins/wpdatatables/templates/admin/table-settings/add_column_modal.inc.php:72
1. do_action('wpdatatables_page_wpdatatables-constructor') wp-admin/admin.php:224
2. wdtConstructor() wp-includes/class-wp-hook.php:286
3. wdtEdit() wp-content/plugins/wpdatatables/controllers/wdt_admin.php:376
Plugin: wpdatatables
Invalid argument supplied for foreach()
1
wp-content/plugins/wpdatatables/templates/admin/table-settings/remove_column_modal.inc.php:40
1. do_action('wpdatatables_page_wpdatatables-constructor') wp-admin/admin.php:224
2. wdtConstructor() wp-includes/class-wp-hook.php:286
3. wdtEdit() wp-content/plugins/wpdatatables/controllers/wdt_admin.php:376
Please help, thank you.
PHP
Overridden at runtime from 300
Database
~64 MB
~256 MB
~1 MB
~32 MB
WordPress
Hi Alexramo,
Thank you for your purchase.
Sorry for late response.
At the end of last week we didn't work because of the national holiday.We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Can you please tell me which version of plugin you use?
Also can you sent me that query so we can take a look?
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 Alexramo,
We can see that you are using very complicated query. Business logic for parsing queries is changed from older version to speed up their execution. Because of this new parser this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes).If your query returns data that you need in phpmyadmin, please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
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 Alexramo,
I suggest you a solution in previous post. If your query works when you execute him in phpmyadmin and it return data that you need you can make a view like I describe to you in previous post. If query is not working in phpmyadmin also will not work in our plugin.
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
my query and my view both work in php admin, but both get hung and/or take extremely long times to load in the plugin.
I'm more than happy to pay for a professional review, I've used your plugin for quite a few years and always been happy with it in the past.
Please advise, thank you
okay I whitelisted you on the production server.
Thank you Milan, will try that and report back.
I'm still having massive problems with this plugin, even putting things into views, I can't get most of my queries to work.
I have to make a decision whether or not to stay with this plugin or go with an outside table and chart builder. I would rather stick with wpDataTables as I have multiple sites using it (the non-updated version).
Can I pay for you guys to do a professional review of my site and help me get your plugin back up and running?
HI Alexramo,
Can you please tell me did you update mysql version as I suggested in previous post?
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
For example i have a table that stores around 250k records, i currently have that table filtered to return value i only need to return that is around 75k records. But if i want to return all the records i get a error (failed to load data response) ajax error. Is there a work around? or is there a way to retain the same query but set a limit to how many records return until the request is met? for example i wouldn't want to display all 250K records on one page, i would set the show 50, then allow paging, so the next 50 records and so on... here is a good demo to help visualize what i am saying.
Yes I've updated the plugin and have a server running latest version of mysql.
I am still getting hung even when I put some of the queries in views.
HI Alexramo,
We lunch update 2.2.1 of our plugin recently. Can you please update wpdatatables and check are you still have issues. After update please clear server and browser cache.
HI purcepa,
When you have questions or issues which are not related to the title of the active ticket or ticket is not yours can you please open a new one and we will help you there. In that way, issues and questions which are related to different subjects will be in different tickets so other customers can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is describe already.
Thank you for understanding.
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
Thank you Milan,
I will run some tests here on one of the dev servers in the next couple days and report back, thank you.
Hi Alexramo,
Let me know the results.
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