As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Data from the counter column is not being displayed by the plug-in.
In the attachments you can see it when I run it straight against the DB but not when the plug-in parses it.
I didn't put the URL in because it is secured. If you have to have access I can set something up.
Here is the query source.
SELECT (@RankNum := @RankNum+1) AS Ranking ,wp_usermeta.meta_value AS MOCID ,MOCData.post_title AS MOCTitle ,fn.meta_value AS FirstName ,ln.meta_value AS LastName ,COUNT(wp_usermeta.meta_value) AS VoteCount FROM wp_usermeta LEFT JOIN wp_posts AS MOCData ON wp_usermeta.meta_value = MOCData.id LEFT JOIN wp_usermeta AS fn ON MOCData.post_author = fn.user_id LEFT JOIN wp_usermeta AS ln ON MOCData.post_author = ln.user_id WHERE wp_usermeta.meta_key = 'best_in_show_vote' AND MOCData.post_type='moc' AND fn.meta_key='first_name' AND ln.meta_key='last_name' GROUP BY wp_usermeta.meta_value ORDER BY Ranking
Hi MyWifesGeek,
This is probably caused by using variables in your query. Using AS could be a problem to because we are using it for built in plugin settings so please try to use "Displayed header" option instead.
If that doesn't help please create MySQL VIEW from your query and use that as data source