purityboy83

Hi

Just updated.
Now there is no error.

Thanks for the correction and thanks for the help~!

Hi

Could you give me your email address?
I will send you a link by email

Thanks

Best Regards,
Hyunho

Hi
@osamaesh

Is the plugin updated right?

The version seems to be the same (3.9)

However, I deleted the old plugin and reinstalled it.

But I still get the error.

said into stderr: "NOTICE: PHP message: PHP Warning:  Attempt to read property "num_rows" on array in ..../wp-content/plugins/visitors-traffic-real-time-statistics/functions.php on line 2501

Thanks

Hi

Now the “Traffic by title (all time)” indicator is starting to show.
Thank you so much~!!

When I check the log, it seems that a minor warning is recorded.

ARNING: said into stderr: “NOTICE: PHP message: PHP Warning: Attempt to read property “num_rows” on array in …/wp-content/plugins/visitors-traffic-real-time-statistics/functions.php on line 2501″

My PHP Version is 8.0.x

Thanks~!!

Hi

Error occur

child 15061 said into stderr: "NOTICE: PHP message: do_action('wp_ajax_traffic_by_title'), WP_Hook->do_action, WP_Hook->apply_filters, ahcfree_traffic_by_title_callback, ahcfree_get_traffic_by_title?(?) SELECT til_page_id, til_page_title, til_hits "
child 15061 said into stderr: "                      FROM ahc_title_traffic where 1=1  "
child 15061 said into stderr: "                      GROUP BY til_page_id , til_page_title, til_hits"
child 15061 said into stderr: "                      ORDER BY til_hits DESC limit %d, %d WordPress database error in query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%d, %d' at line 4"
child 15061 said into stderr: "NOTICE: PHP message: PHP Warning:  Attempt to read property "num_rows" on array in .../wp-content/plugins/visitors-traffic-real-time-statistics/functions.php on line 2500"

thanks

Hi

I sent you a mail.

Thanks

Hi

First, Thank you for help

As you know, queries in other places also seem to be subject to the limitations of MySQL 8.0 sql_mode.

if($cnt==true)
        {
                $sql2 = "SELECT sum(cnt) from (SELECT count(*) as cnt FROM ahc_title_traffic where 1=1 $cond GROUP BY til_page_id ORDER BY til_hits DESC) as res";
                $count = $wpdb->get_var($sql2);
                return $count;
        }

Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘ahc_title_traffic.til_hits’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Thanks

Hi

visitors-traffic-real-time-statistics/functions.php

line 2502

$sql2 query is

SELECT til_page_id, til_page_title, til_hits 
FROM ahc_title_traffic where 1=1 $cond 
GROUP BY til_page_id 
ORDER BY til_hits DESC limit %d, %d

error is
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘ahc_title_traffic.til_page_title’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

In mysql8 version, sql error occurs due to group by syntax.

That sql doesn’t match the syntax
I think it needs correction.

All columns described in the select clause must be described in the group by clause.

I think the query should be modified as below.

SELECT til_page_id, til_page_title, til_hits 
FROM ahc_title_traffic where 1=1 $cond 
GROUP BY til_page_id, til_page_title, til_hits 
ORDER BY til_hits DESC limit %d, %d

thanks

• This reply was modified 3 years, 5 months ago by purityboy83.

HI

Is the related DB table “ahc_title_traffic” correct?

CREATE TABLE ahc_title_traffic (
  til_id int unsigned NOT NULL AUTO_INCREMENT,
  til_page_id varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  til_page_title varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  til_hits int unsigned NOT NULL,
  PRIMARY KEY (til_id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

Is there any problem with the table structure?

The data seems to be there.
Ref img
https://ibb.co/Gpwvv6G

ADD

Something was confirmed in the log.

Can you please check this part?

stderr: “NOTICE: PHP message: PHP Warning: Undefined variable $sql2 in …/wp-content/plugins/visitors-traffic-real-time-statistics/functions.php on line 2516”

stderr: “NOTICE: PHP message: PHP Warning: foreach() argument must be of type array|object, null given in …/wp-content/plugins/visitors-traffic-real-time-statistics/functions.php on line 2524”

Thanks

Hi
@osamaesh

How do I check again?

The problem remains the same.

Please tell me how to tracking
Let’s check.

Thanks

Hi @alxmedia

Version is 1.0.6 Ref img
https://ibb.co/gRBxCQF

That the problem I’m talking about continues,
It means that the keyboard disappears when you try to search in the Search Widget.

The search bar for the theme you updated this time works normally.

The rest will be communicated via email.

Thanks

Hi @alxmedia

First of all, thank you for your urgent help.

In order to rule out problems with plugins or settings on my site,

I have installed new wordpress(Fresh Install) , only themes have been installed

Newly created site (only theme installed) has the same problem

We will send you the test site address by email.

Thanks

First, workaround was processed as follows.

.related-thumbnail img {
  display: none;
}

• This reply was modified 3 years, 6 months ago by purityboy83.

Hi

I’ve found the cause (plugin) causing the problem, like the one sent by email. – ad plugin

Thank you very much for your help in resolving the problem.

I will solve the problem with ad plugin.

thank you.

Best Regards,
Hyunho

HI!
@alxmedia

When I look at my mobile chrome, there seems to be no problem.

But please see the image below

My guess is that the profile image size is empty

Ref img
https://ibb.co/6rBvMHh

I have not set a profile image.
Ref img
https://ibb.co/SRfT3Wh

If you wish, I can email you the address of my test site.

Thanks