No taxonomies showing on Stats Page settings
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hello
I set up a database for research stats, and I started configuring the settings.
I managed to choose"Post" as main statistical parameter, but nothing shows in the meta keys of taxonomies.
I couldn't retrieve any data, with or without specifying the taxonomies.
Am I missing anything?
After further investigation, I found out that the database that I created for the search is empty. It has no tables at all!
Hello
What plugin version number are you using?
Do you mean these fields? - https://share.pluginus.net/image/i20250421112540.png
Version 2.3.3.7
I think the problem comes from the entirely empty database that I created for the search.
It has structure in it. No tables!
Hello
Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png and wp-admin access - https://share.pluginus.net/image/i20230222134615.png I will check it
I got the license key from the download link, I hope it's the right one?!
I can't provide wp-admin access unfortunately. Is there a way that we could coordinate and I share my screen with you directly?
Hello
Ok! Please drop me screenshots of statistic options - https://share.pluginus.net/image/i20250425104358.png
Just shared with you on the Private Support Data box
Hello
Ok! The plugin must generate two statistics tables - xx_mdf_stat_buffer and xx_mdf_stat_tmp - This is a temporary storage of search queries before they are processed. Check these tables in the site database
as I stated above, those tables do not exist.
The database I created for the plugin is empty
Hello
Ok! These two tables should be in your website's database.
It doesn't seem to be the case ...
Would you please give me a solution to have the tables in the database? Can you give me a script to run on MySQL backend?
Hello
First, the plugin collects daily data into these two tables - xx_mdf_stat_buffer and xx_mdf_stat_tmp - in your site's database.
Next, the plugin analyzes the data from these tables and makes a record in the database of the database you specified in the plugin settings.
Code to create these tables - plugins\meta-data-filter\ext\mdf_stat\views\tabs_content.php - https://share.pluginus.net/image/i20250501112329.png
Would you please share the SQL code with me via text here, or via email: maccrv33@gmail.com
Thanks
Hello
Ok!
global $wpdb;
$table_stat_buffer = $wpdb->prefix . 'mdf_stat_buffer';
$table_stat_tmpp = $wpdb->prefix . 'mdf_stat_tmp';
$charset_collate = '';
if (method_exists($wpdb, 'has_cap') AND $wpdb->has_cap('collation')) {
if (!empty($wpdb->charset)) {
$charset_collate ="DEFAULT CHARACTER SET $wpdb->charset";
}
if (!empty($wpdb->collate)) {
$charset_collate .=" COLLATE $wpdb->collate";
}
}
$sql1 ="CREATE TABLE IF NOT EXISTS `{$table_stat_buffer}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hash` text COLLATE utf8_unicode_ci NOT NULL,
`user_ip` text COLLATE utf8_unicode_ci NOT NULL,
`post_type` text COLLATE utf8_unicode_ci NOT NULL,
`type` text COLLATE utf8_unicode_ci NOT NULL,
`filter_id` int(11) NOT NULL,
`key_id` text COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM {$charset_collate};";
$wpdb->query($sql1);
$sql2 ="CREATE TABLE IF NOT EXISTS `{$table_stat_tmp}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_ip` text COLLATE utf8_unicode_ci NOT NULL,
`post_type` text COLLATE utf8_unicode_ci NOT NULL,
`tax_data` text COLLATE utf8_unicode_ci NOT NULL,
`meta_data` text COLLATE utf8_unicode_ci NOT NULL,
`hash` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL,
`is_collected` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM {$charset_collate};";
$wpdb->query($sql2);
Thank you, Pablo.
I can see the tables being filled now, and they seem to work well (consolidating from tmp to buffer)
However, I see nothing when I request the report for a specific range of dates. It says"No data found for the period", even though I checked the database and data is there!
What would you suggest please?
Hello
These are temporary databases that store data before processing.
Then this data is processed and stored in the database that you specified in the settings. and this data is used for statistics
To check the statistics you need to wait more than a day