So I managed to setup a table with Woocommerce products succesfully.
However there were a few smaller hickups, the problem is I am absolutely new to the MySql Database editing. Furthest I've ever come is to login to my phpmyadmin and have a peek at a wordpress table.
Now I've read the FAQ and managed to turn off the Server Side rendering which fixed the filtering system. But it appears that Woocommerce products with server side rendering turned on do not work.
Now the only issue remaining is that the product thumbnails do not load. I have set the field to "image" and it renders a broken image icon.
I do need these images to work though because I'm working on a very visual site for a Mobile Game. However I'm not quite sure how to go about it. The FAQ described something about a ' possibly being an issue but I'm not sure if that's the case.
I've already ruled out any plugin incompatabilies or theme issues. By installing a test environment with only Woocommerce and WpDataTables installed with the standard wordpress theme. In there the same happened, the product image is rendered broken. My guess is the same reason why the filtering does not work with the Server Side Rendering on is also why the product thumbnail image does not show.
Okay I managed to fix the image thumbnails by putting the data on url instead of image. That fixed them.
Still would like to find out though why the render server side option disables my filters when I use products as custom post. Because I might need that option in the future since I'll be working with approx 2500 products in one table.
And with the render server side option on my filtering breaks.
So I could still use some help with that question the image issue is solved.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this 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″.
Please note some this when working with the server-side processing feature:
Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.
You need to do this from PHPMyAdmin. For example, if your table is named "table1", when you expand the database in PHPMyAdmin on the left, you need to click on SQL tab on the right and create a view like this:
CREATE VIEW `table1_view` AS SELECT * FROM `table1`;
Then, when you create a new table in wpDataTables, using the first option, you need to use this query:
SELECT
* FROM table1_view
Please try this, and let me know if filtering works.
So I tried to follow the intructions you provided, but as I said I'm very new to the whole MySql editing.
I have a table named : Bestiary so I tried the following command
CREATE VIEW `bestiary_view` AS SELECT * FROM `bestiary`;
But it gives me the error saying there is no such table in my wp database
u4346p2664_wp2.bestiary does not exist.
My tables are stored in the same database as my wordpress is, perhaps that information is relevant to the command I'm supposed to type in the SQL Query.
CREATE VIEW `bestiary_view` AS SELECT * FROM `u4346p2664_wp2`.`bestiary`;
If that doesn't help, 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.
Also, PHPMyAdmin access would be great so that I can do it for you, and in all show you how to do it in the future.
Hello again!
So I managed to setup a table with Woocommerce products succesfully.
However there were a few smaller hickups, the problem is I am absolutely new to the MySql Database editing. Furthest I've ever come is to login to my phpmyadmin and have a peek at a wordpress table.
Now I've read the FAQ and managed to turn off the Server Side rendering which fixed the filtering system. But it appears that Woocommerce products with server side rendering turned on do not work.
Now the only issue remaining is that the product thumbnails do not load. I have set the field to "image" and it renders a broken image icon.
I do need these images to work though because I'm working on a very visual site for a Mobile Game. However I'm not quite sure how to go about it. The FAQ described something about a ' possibly being an issue but I'm not sure if that's the case.
I've already ruled out any plugin incompatabilies or theme issues. By installing a test environment with only Woocommerce and WpDataTables installed with the standard wordpress theme. In there the same happened, the product image is rendered broken. My guess is the same reason why the filtering does not work with the Server Side Rendering on is also why the product thumbnail image does not show.
Oh PS, the table is rendered on the site under the Monsters > Bestiary page if you need to take a look.
Okay I managed to fix the image thumbnails by putting the data on url instead of image. That fixed them.
Still would like to find out though why the render server side option disables my filters when I use products as custom post. Because I might need that option in the future since I'll be working with approx 2500 products in one table.
And with the render server side option on my filtering breaks.
So I could still use some help with that question the image issue is solved.
Hello Charlene.
Thank you for your purchase.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this 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″.
Please note some this when working with the server-side processing feature:
You need to do this from PHPMyAdmin. For example, if your table is named "table1", when you expand the database in PHPMyAdmin on the left, you need to click on SQL tab on the right and create a view like this:
Then, when you create a new table in wpDataTables, using the first option, you need to use this query:
Please try this, and let me know if filtering works.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
So I tried to follow the intructions you provided, but as I said I'm very new to the whole MySql editing.
I have a table named : Bestiary so I tried the following command
CREATE VIEW `bestiary_view` AS SELECT * FROM `bestiary`;
But it gives me the error saying there is no such table in my wp database
u4346p2664_wp2.bestiary does not exist.
My tables are stored in the same database as my wordpress is, perhaps that information is relevant to the command I'm supposed to type in the SQL Query.
Best Regards,
Charlene
Hi again Charlene.
Yeah, you can try this:
If that doesn't help, 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.
Also, PHPMyAdmin access would be great so that I can do it for you, and in all show you how to do it in the future.
Best regards.
Kind Regards,
Aleksandar Vuković
[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 again Charlene.
I responded to the other ticket earlier today.
Would it be OK if we were to continue on that one? Seems like both tickets have a similar issue.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Absolutely thnx for the help