Hi. I purchased wpDataTables, installed it, and succesfully created several tables. Those have been relatively small tables, maxing out at around 9 columns and a few rows. I have created all my tables using the "Generate a query to Wordpress database" option. I am now trying to create a table that has about 15 columns. Its still has only a few rows. After selecting the data I want in the table it seems like if it tries to create the table, but it takes a long time and then I get the error shown in the attached image. I know for sure that all data selected is valid, as it is data currently used in the other smaller tables. What could be happening?
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 provide me a query that you are trying to use to make table, so I can take a look
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Sorry for misunderstanding, I will try to explain in little more details.
When you are making table with option Create a MySQL-query-based table by generating a query to WordPress database and when you choose properties that you need, wpdatatables constructs a suggestion of a query. When you are choose many of them there is the chance that it will not return exactly what you need and if query is complicated like in your case server need more time to process the data, build the query and return the data.
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need.
So my suggestion is to prepare a MySQL view (from query that I provide you in previous post), 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″.
So, I understand what you say that sometimes when tables get complicated it might not work. What I don't understand is the solution you suggest.
I don't know how to do this:
So my suggestion is to prepare a MySQL view (from query that I provide you in previous post), 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 am not a programmer, that is the reason I payed for the plugin. I looked around on the internet how to prepare a MySQL view, but I just don't get it. Could you do it from your end, or at least give me a more step by step kind of instructions on how to do what you are suggesting me to do?
Please note that on Monday, November 12th was non-working day due to the National holiday. Because of this, there will be likely a delay in reply to your tickets, possibly until Tuesday the 13th of November. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days
My suggestion to increase it as higher that hosting can provide it.
So I talked to bluehost and said that those things couldn't be changed because I am on shared hosting. So, what other options do I have. I know I could manually create a "master" table. The problem is that each post I make must have several "subtables" which would need to pull data from that "master" table. Not only that, these subtables should only contain one specific entry of that "master" table, so the URL pre-filtering method would not work. What can I do?
I am sorry to hear that, because executing query that you need require better hosting. You can make those table manually and If I understand you right you can connect sub tables with Foreign keys. You can read more about this in our documentation on this link and check is this what you look for.
Hi. I purchased wpDataTables, installed it, and succesfully created several tables. Those have been relatively small tables, maxing out at around 9 columns and a few rows. I have created all my tables using the "Generate a query to Wordpress database" option. I am now trying to create a table that has about 15 columns. Its still has only a few rows. After selecting the data I want in the table it seems like if it tries to create the table, but it takes a long time and then I get the error shown in the attached image. I know for sure that all data selected is valid, as it is data currently used in the other smaller tables. What could be happening?
Hi Anton,
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 provide me a query that you are trying to use to make table, so I can take a look
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 Anton,
Can you please provide me that query that you use for that table with which you have issue, so I can reproduce it and see what is going on?
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
Sorry, I did't understand what I need to do to make it work. Could you explain again with a little more detail please.
HI Anton,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Sorry for misunderstanding, I will try to explain in little more details.
When you are making table with option Create a MySQL-query-based table by generating a query to WordPress database and when you choose properties that you need, wpdatatables constructs a suggestion of a query. When you are choose many of them there is the chance that it will not return exactly what you need and if query is complicated like in your case server need more time to process the data, build the query and return the data.
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need.
So my suggestion is to prepare a MySQL view (from query that I provide you in previous post), 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″.
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 Milan,
So, I understand what you say that sometimes when tables get complicated it might not work. What I don't understand is the solution you suggest.
I don't know how to do this:
So my suggestion is to prepare a MySQL view (from query that I provide you in previous post), 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 am not a programmer, that is the reason I payed for the plugin. I looked around on the internet how to prepare a MySQL view, but I just don't get it. Could you do it from your end, or at least give me a more step by step kind of instructions on how to do what you are suggesting me to do?
Hi Anton,
Sorry for late response.
Please note that on Monday, November 12th was non-working day due to the National holiday. Because of this, there will be likely a delay in reply to your tickets, possibly until Tuesday the 13th of November. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days
My suggestion to increase it as higher that hosting can provide it.
Best reagrds.
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
So I talked to bluehost and said that those things couldn't be changed because I am on shared hosting. So, what other options do I have. I know I could manually create a "master" table. The problem is that each post I make must have several "subtables" which would need to pull data from that "master" table. Not only that, these subtables should only contain one specific entry of that "master" table, so the URL pre-filtering method would not work. What can I do?
Hi Anton,
I am sorry to hear that, because executing query that you need require better hosting. You can make those table manually and If I understand you right you can connect sub tables with Foreign keys. You can read more about this in our documentation on this link and check is this what you look for.
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