Don’t work stats counters of visits

Hi! Only with new update or even with previous versions?
I have 6.1.40 version, just tested and works Ok. Waiting for @ilenstudio

• This reply was modified 4 years, 10 months ago by nickpapag.

I have 6.1.41 ver. Just tested: counters are not updated. By zeros.

Or it takes time to update?

BTW, “Views” stat update instant and works well.

• This reply was modified 4 years, 10 months ago by tihjawi.

Did u have the issue with previous version?

Yes. In all prev versions stats are not updated.

All posts have 0.

• This reply was modified 4 years, 10 months ago by tihjawi.

yo tb

• This reply was modified 4 years, 10 months ago by WP major.

Hello ????, if you do not count the clicks on the posts it is because you may not have the yuzoclicks table in your database, one way that this is added to your database is deactivating and activating the plugin again after this check in your database data if the yuzoclick table was created but was created please let me know to let you know the script for the creation of the table.

I wait for your soon response… ??

Yes, I don’t have table yuzoclicks in DB, just yuzoviews.

But I disabled and enabled the plugin, the table did not appear anyway.

• This reply was modified 4 years, 10 months ago by tihjawi.

Within your Mysql run this code.

CREATE TABLE wp_yuzoclicks (
ID int(11) NOT NULL COMMENT ‘ID autoincrement’,
post_id int(15) NOT NULL COMMENT ‘ID post’,
date_click datetime NOT NULL COMMENT ‘Date and time when the click was made’,
timestamp_click int(15) NOT NULL COMMENT ‘Timestamp when the click was made’,
ip varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Ip of the click’,
la varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Latitude of the click’,
lo varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Longitude of the click’,
country varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Country name of the click’,
country_code varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Country code of the click’,
region varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Region code of the click’,
city varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘City code of the click’,
device varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ‘Device that was clicked (d=desktop,m=mobile,t=tablet)’,
url varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
where_is varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
browser_details varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
type_click char(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘c’ COMMENT ‘c=conten,s=shortcode,w=widget’,
post_from char(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘Save the ID of the post from where the click was made’,
yuzo_list_id int(11) NOT NULL COMMENT ‘Save the ID yuzo’,
price_per_click decimal(10,2) DEFAULT ‘0.00’ COMMENT ‘Calculate the price per click based on the item level’,
level_click int(2) DEFAULT ‘1’ COMMENT ‘Level of the article that was clicked, this helps calculate how much each click costs’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE wp_yuzoclicks
ADD UNIQUE KEY ID (ID);

ALTER TABLE wp_yuzoclicks
MODIFY ID int(11) NOT NULL AUTO_INCREMENT COMMENT ‘ID autoincrement’;

Note: This script is for the wp_ prefix if you use this prefix run it, but you will have to change the prefix of how you use your table.

• This reply was modified 4 years, 10 months ago by ilenstudio.

Don’t works. PHPmyAdmin says what this code with errors

Could you show the error it shows?

My PhpMyAdmin in Russian lang. I thinks this is a problem to show an error

• This reply was modified 4 years, 10 months ago by tihjawi.

And I have MariaDB btw

Nah. Dont works

Fatal error: Uncaught Error: Class ‘Y_PostType’ not found in /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/admin/options/custom-post-type/cpt-yuzo.php:42 Stack trace: #0 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/admin/options/init.php(17): require_once() #1 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/include/classes/class-init.php(223): require_once(‘/home/u110805/d…’) #2 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/include/classes/class-init.php(210): YUZO\Core\YUZO_Core::load_file(‘/home/u110805/d…’) #3 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/include/classes/class-init.php(153): YUZO\Core\YUZO_Core->load_files_core() #4 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/include/classes/class-init.php(136): YUZO\Core\YUZO_Core->init() #5 /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/include/classes/class-init.php(474): YUZO\Core\YUZO_Core::instance() #6 /home/u110805/doomguyru/w in /home/u110805/doomguyru/www/wp-content/plugins/yuzo-related-post/admin/options/custom-post-type/cpt-yuzo.php on line 42

update to the current version so you can work, tonight I send an update so you can add that table.

@tihjawi update to version 6.1.42 and after Deactivate and Activate the plugin again, this could correct the problem and create the missing table.

I wait for your soon response… ??