hamil

Hi @hesseldejong

Installed and the problem is solved. The “Acquisition” table now shows the referrers.

Thank you.

Hi @roxannestoltz

Thank you for your excellent reply.

I added the code to the function.php of the child theme and it works. Great!

I don’t want to use the search widget because the two search fields can be confusing for visitors.

Thank you for your help.

• This reply was modified 1 year, 8 months ago by hamil.

Hi?@hesseldejong,

the problem is the language version. If the site interface is in English referrers are displayed. When it is in Czech referrers are not displayed.

Hi @hesseldejong,
I installed Burst version 1.2.3. I left this version on the site for about 30 hours. No referrers today, yesterday, for the last 90 days, for the whole period.

Hi @hesseldejong,
I installed the Health Check plugin, disabled all plugins. Only Burst 1.3.4 is active. Template Twenty Twenty-Two. I left it like this for some time.
11 visitors came, 64 pages viewed, referrers 0.
I set up 90 days of stats. No referrers.
Sometime later, maybe tomorrow, I’ll try installing an older version of Burst.

Hi @hesseldejong,
information sent.

Hi @hesseldejong,

Yes, all these tables are in the database.

No one else is reporting this problem? I don’t understand why it only appears on my sites. I have everything updated, I use simple templates with a large number of installs. I also have the usual plugins. I don’t interfere with the site code.
I recently switched from php 7.4 to php 8.0. Could this be somehow related?

I’m adding an error message:

[05-Feb-2023 08:58:32 UTC] WordPress database error Table ‘ahmodelycz6.substring’ doesn’t exist for query SHOW FULL COLUMNS FROM substring made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, burst_get_data, burst_statistics->get_today_data

[06-Feb-2023 02:28:24 UTC] Burst Statistics: All date ranges are cached
[06-Feb-2023 02:28:24 UTC] Burst Statistics: Cached data for year-to-date in 0.0026838779449463 seconds

• This reply was modified 1 year, 9 months ago by hamil.

Hi @hesseldejong,
new installation of the Burst plugin on https://www.pribrat.cz/. Referrers are also not showing up. Database version 5.6.51 not updated. When the site was created a few years ago, the database prefix was changed.
I cannot provide an error message because the debug.log file is not being written to. I will address this with hosting support.

Hi @hesseldejong,

I did not change the database prefix. However, I have converted the MySQL database from version 5.6.51 to 5.7.21.
On the other site, I converted the MariaDB database from version 10.1.44 to 10.3.32. Here is the error message:

[03-Feb-2023 15:18:52 UTC] WordPress database error Table ‘d51126_kocka4.substring’ doesn’t exist for query SHOW FULL COLUMNS FROM substring made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, burst_get_data, burst_statistics->get_today_data

The sites are on different hosting and have a different type of database. Yet the same error occurred.
Is there any way to modify the database?

Today I installed the Burst plugin on another site with an old version of the database. I will report tomorrow if the referrers are showing up.

I activated debug.log:

[02-Feb-2023 08:30:15 UTC] WordPress database error Table ‘plochebrichocz11.substring’ doesn’t exist for query SHOW FULL COLUMNS FROM substring made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, burst_get_data, burst_statistics->get_referrers_data

[02-Feb-2023 08:38:54 UTC] WordPress database error Table ‘plochebrichocz11.substring’ doesn’t exist for query SHOW FULL COLUMNS FROM substring made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, burst_get_data, burst_statistics->get_today_data

• This reply was modified 1 year, 10 months ago by hamil.

Hi @hesseldejong
I don’t see any bugs in the console.

JQMIGRATE: Migrate is installed, version 3.3.2
index.js?ver=e9e0936e2ffbff49069a:382 ———————Please copy and paste the below on the WP forums:———————
index.js?ver=e9e0936e2ffbff49069a:382 dateRange: {startDate: ‘2023-01-26’, endDate: ‘2023-02-01’, range: ‘last-7-days’}endDate: “2023-02-01″range: “last-7-days”startDate: “2023-01-26”Prototype: Objectconstructor: ? Object()hasOwnProperty: ? hasOwnProperty()isPrototypeOf: ? isPrototypeOf()propertyIsEnumerable: ? propertyIsEnumerable()toLocaleString: ? toLocaleString()toString: ? toString()valueOf: ? valueOf()defineGetter: ? defineGetter()defineSetter: ? defineSetter()lookupGetter: ? lookupGetter()lookupSetter: ? lookupSetter()proto: (…)get proto: ? proto()set proto: ? proto()
index.js?ver=e9e0936e2ffbff49069a:382 gmt_offset: 1
index.js?ver=e9e0936e2ffbff49069a:382 sql_timezone: SYSTEM
index.js?ver=e9e0936e2ffbff49069a:382 wp_time: 1675328908
index.js?ver=e9e0936e2ffbff49069a:382 server_time: 1675325308
index.js?ver=e9e0936e2ffbff49069a:382 sql_time 2023-02-02 09:08:28
index.js?ver=e9e0936e2ffbff49069a:382 sql_time_utc: 2023-02-02 08:08:28
index.js?ver=e9e0936e2ffbff49069a:382 device_time: 1675325310281
index.js?ver=e9e0936e2ffbff49069a:382 device_timezone: Europe/Prague
index.js?ver=e9e0936e2ffbff49069a:382 ———————Copy till here——————————————————–

How do I find referrers in the database?

The problem persists. I have activated burst-remove-caching. Cleared the cache with the WP Super Cache plugin and then with the link https://vareni.edilo.cz/wp-admin/index.php?page=burst#statistics&burst_clear_cache=1. Referrers are not showing up.

Hi @rogierlankhorst,
I don’t know why, but the referrers aren’t back on today. I still have burst-cast-timestamp-to-int active. I didn’t make any changes to the site. I only recorded an update to the Easy Table of Contents plugin and published one post. After deactivating the Easy Table of Contents plugin, the referrers did not show up. That won’t be the problem.

Yes, with the modified version the problem is solved. The referrers are displayed. Thank you.