When we updated the plugin to the latest version of wpdatatables, some of our tables did not display. We rolled back to an earlier version to keep our site operational. We hope you can help us with this issue so we can update the plugin on our live site.
We are using a user defined variable to display row numbers in the first column. The tables using the numbered rows are having the issue. Please see the link to our dev server above.
Here is a sample query of a table that is no longer working.
select @position := @position + 1 as seed, school_name, team_wins, team_loses, sch_pts, bns_pts, rank FROM teams JOIN (SELECT @position := 0) r where classification = '%VAR1%' and league_id > 0 and sport = '%VAR2%' and season = '%VAR3%' order by rank desc, team_wins desc, team_ties desc
Can you please provide me temporary WP admin credentials to the dev site where the last version of our plugin is installed so we can take a look. You can write credentials here just check PRIVATE reply so nobody can see it except us.
Also point me to the table ID so I can investigate.
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 (happens rarely, 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″.
I tried the view but I am still receiving an error because of the variable needed to number the rows.
Here is the error: unknown [expr_type] = user_variable in "expression subtree" [0]
Is there a work around to get the rows numbered other than creating a variable? Otherwise we will continue to use version 1.7 since it works fine with variables.
Can you please tell me is it possible for you to send me the all necessary files here so I can import it to my database and try to make a table with your query below.
Hello,
When we updated the plugin to the latest version of wpdatatables, some of our tables did not display. We rolled back to an earlier version to keep our site operational. We hope you can help us with this issue so we can update the plugin on our live site.
We are using a user defined variable to display row numbers in the first column. The tables using the numbered rows are having the issue. Please see the link to our dev server above.
Here is a sample query of a table that is no longer working.
select @position := @position + 1 as seed, school_name, team_wins, team_loses, sch_pts, bns_pts, rank FROM teams JOIN (SELECT @position := 0) r where classification = '%VAR1%' and league_id > 0 and sport = '%VAR2%' and season = '%VAR3%'
order by rank desc, team_wins desc, team_ties desc
Thanks in advance for your help,
Bob
HI Bob Higgins,
Thank you for your purchase.
Can you please provide me temporary WP admin credentials to the dev site where the last version of our plugin is installed so we can take a look. You can write credentials here just check PRIVATE reply so nobody can see it except us.
Also point me to the table ID so I can investigate.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Sorry Bogdan,
districtscores.com
select the administrator button for the wp login.
HI Bob,
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 (happens rarely, 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″.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Bogdan,
I tried the view but I am still receiving an error because of the variable needed to number the rows.
Here is the error: unknown [expr_type] = user_variable in "expression subtree" [0]
Is there a work around to get the rows numbered other than creating a variable? Otherwise we will continue to use version 1.7 since it works fine with variables.
Bob
HI Bob Higgins,
Can you please tell me is it possible for you to send me the all necessary files here so I can import it to my database and try to make a table with your query below.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Bob,
Can you please try to update the plugin to 2.2 version 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.
Let me know if you have the issue with in this version.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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