rubbeldiekatz
Forum Replies Created
-
Good Morning Matthew
Yes, it works now. Thank you very much for the help.
Have a nice day.
Thanks for the research. I am excited.
Best regards
Hi Matth?us
On the page https://berliner-baer-koepenick.de/wohnen/wohngebiet-hirschgarten/
[28-Oct-2024 12:31:13 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROMJlh8WI4a_statistics_pages
WHEREtype
= ” made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Statistics->plugin_setup, WP_Statistics->includes, require_once(‘/plugins/wp-statistics/includes/class-wp-statistics-install.php’), WP_STATISTICS\Install->__construct, WP_STATISTICS\Install::init_page_type_updater, WP_STATISTICS\Install::is_require_update_page, WP_STATISTICS\Install::get_require_number_update
[28-Oct-2024 12:31:14 UTC] WordPress database error Unknown column ‘pages.type’ in ‘where clause’ for query SELECT SUM(count
) AScount
FROM Jlh8WI4a_statistics_pages AS pages WHERE pages.id = ’64’ AND pages.type IN (‘page’) AND DATE(date) BETWEEN ‘2024-09-29’ AND ‘2024-10-28’ GROUP BY id made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/tiffany/page.php’), get_footer, locate_template, load_template, require_once(‘/themes/tiffany/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, wp_admin_bar_render, do_action_ref_array(‘admin_bar_menu’), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\AdminBar->admin_bar, WP_Statistics\Models\ViewsModel->countViewsFromPagesOnly, WP_Statistics\Utils\Query->getVar[28-Oct-2024 12:31:15 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT
page_id
FROMJlh8WI4a_statistics_pages
WHEREdate
= ‘2024-10-28’ ANDuri
= ‘/wohnen/wohngebiet-hirschgarten/’ ANDtype
= ‘page’ ANDid
= 64 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record
[28-Oct-2024 12:31:15 UTC] WordPress database error Unknown column ‘type’ in ‘field list’ for query INSERT IGNORE INTOJlh8WI4a_statistics_pages
(uri
,date
,count
,id
,type
) VALUES (‘/wohnen/wohngebiet-hirschgarten/’, ‘2024-10-28′, 1, ’64’, ‘page’) 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record, WP_STATISTICS\Pages::save_page
[28-Oct-2024 12:31:15 UTC] [WP STATISTICS] [WARNING]: Unknown column ‘type’ in ‘field list’
[28-Oct-2024 12:31:15 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT page_id FROMJlh8WI4a_statistics_pages
WHEREtype
= ‘page’ andid
= 64 ORDER BY date DESC 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Hits::recordOnline, WP_STATISTICS\UserOnline::record, WP_STATISTICS\UserOnline::add_user_online, WP_STATISTICS\Pages::getPageId
that is current.Good Morning Matth?us
I have edit config.php.// Enable Debug logging to the /wp-content/debug.log file
define( ‘WP_DEBUG_LOG’, true );
// Enable display of errors and warnings
define( ‘WP_DEBUG_DISPLAY’, false );I had to disable WP_DEBUG_DISPLAY because a lot of warnings were issued by other plugins that I’m currently cleaning up.
The crucial error message for WP_Statistics is the following:
[28-Oct-2024 07:55:41 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROMJlh8WI4a_statistics_pages
WHEREtype
= ” made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Statistics->plugin_setup, WP_Statistics->includes, require_once(‘/plugins/wp-statistics/includes/class-wp-statistics-install.php’), WP_STATISTICS\Install->__construct, WP_STATISTICS\Install::init_page_type_updater, WP_STATISTICS\Install::is_require_update_page, WP_STATISTICS\Install::get_require_number_update
[28-Oct-2024 07:55:43 UTC] WordPress database error Unknown column ‘pages.type’ in ‘where clause’
for query SELECT SUM(count
) AScount
FROM Jlh8WI4a_statistics_pages AS pages WHERE pages.id = ‘290’ AND pages.type IN (‘page’) AND DATE(date) BETWEEN ‘2024-09-29’ AND ‘2024-10-28’ GROUP BY id made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/tiffany/page.php’), get_footer, locate_template, load_template, require_once(‘/themes/tiffany/footer.php’), wp_footer, do_action(‘wp_footer’), WP_Hook->do_action, WP_Hook->apply_filters, wp_admin_bar_render, do_action_ref_array(‘admin_bar_menu’), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\AdminBar->admin_bar, WP_Statistics\Models\ViewsModel->countViewsFromPagesOnly, WP_Statistics\Utils\Query->getVar[28-Oct-2024 07:55:44 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT
page_id
FROMJlh8WI4a_statistics_pages
WHEREdate
= ‘2024-10-28’ ANDuri
= ‘/wohnen/wohngebiet-friedrichshagen-ost/’ ANDtype
= ‘page’ ANDid
= 290 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record
[28-Oct-2024 07:55:44 UTC] WordPress database error Unknown column ‘type’ in ‘field list’ for query INSERT IGNORE INTOJlh8WI4a_statistics_pages
(uri
,date
,count
,id
,type
) VALUES (‘/wohnen/wohngebiet-friedrichshagen-ost/’, ‘2024-10-28’, 1, ‘290’, ‘page’) 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record, WP_STATISTICS\Pages::save_page
[28-Oct-2024 07:55:44 UTC] [WP STATISTICS] [WARNING]: Unknown column ‘type’ in ‘field list’
[28-Oct-2024 07:55:44 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT page_id FROMJlh8WI4a_statistics_pages
WHEREtype
= ‘page’ andid
= 290 ORDER BY date DESC 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, WP_STATISTICS\Api\v2\Hit->hit_callback, WP_STATISTICS\Hits::record, WP_STATISTICS\Hits::recordOnline, WP_STATISTICS\UserOnline::record, WP_STATISTICS\UserOnline::update_user_online, WP_STATISTICS\Pages::getPageIdThe table
Jlh8WI4a_statistics_pages
exists and is empty- This reply was modified 3 weeks, 3 days ago by rubbeldiekatz.
Hi Matth?us
Unfortunately there are still no records, even after you visit the pages.
https://ibb.co/LJDjGmd
It says action=wp_statistics_admin_meta_box&name=pages no match found.
https://ibb.co/qNW9Rpz
Maybe it would be better if I gave them a temporary login over a secure line and they took a look at it?
I hope you can help me.
Best RegardsPS: I do this: Statistics > Settings > Filtering & Exceptions > User Role Exclusions, Admin deactivate
- This reply was modified 4 weeks, 1 day ago by rubbeldiekatz.
- This reply was modified 4 weeks, 1 day ago by rubbeldiekatz.
Hi Matthew
Thanks for the help. Ah, I did it from the fontend. That was a misunderstanding. Now I did it from the Statistic dashboard.
The page url is https://berliner-baer-koepenick.de/Attached is a screenshot.
https://ibb.co/w6f4bpP
https://ibb.co/BBvd5nx
kind regardsGood morning
The table exists, but is empty.
I followed your screenshot instructions. but the term “admin-ajax.php?action=wp_statistics_admin….” does not result in a hit. I tried with just admin-ajax.php. See the screenshot.
https://ibb.co/WzqXq0X
ThanksHere a Screenshot https://ibb.co/bP0DD0W
Forum: Everything else WordPress
In reply to: Es gab einen kritischen Fehler auf einer Backend SeiteGuten Morgen
Vielen Dank für die DEBUG Hinweise.
Es lag am memory_limit 512M bei PHP. Ich habe es auf 512M erh?ht. Nun l?uft die Backendseite wiederThat’s a good idea. I wouldn’t have thought of that. Thank you.
I still had the problem that there is an image folder that is not part of WordPress and is filled with webcam images every day. It is now 6GB in size. I excluded it from the backup. now the backup works again.
best regardsForum: Plugins
In reply to: [Friendly Captcha for WordPress] Anzeige ist nicht in DeutschHi
Ich habe es nun herausbekommen.
L?sung:
<div class=”frc-captcha” data-sitekey=”<mySiteKey>” data-lang=”de”></div>Forum: Plugins
In reply to: [WooCommerce] WooCommerce – Display total in boldok, thank you and happy holidays.
Forum: Plugins
In reply to: [WooCommerce] WooCommerce – Display total in boldHey
thanks for the tip.
I edited the woocommerce-de_DE.po with poedit and then copied / overwritten both files .po and .mo into the folder wp-content / languages ??/ plugins.
It works.Another question.
With the next update of woocommerce it will probably not work anymore.
I created a child from Storefront where I have other changes in it.
Where do I save the .po and .mo file in my child theme?Forum: Plugins
In reply to: [WooCommerce] WooCommerce – Display total in boldGood Morning Remi
I try this, but dosn’t work.
The Code:
if ( 1 === $total ) { _e( 'Showing the single result', 'woocommerce' ); } elseif ( $total <= $per_page || -1 === $per_page ) { /* translators: %d: total results */ printf( _n( 'Showing all %d result', 'Showing all %d results', $total, 'woocommerce' ), $total ); } else { $first = ( $per_page * $current ) - $per_page + 1; $last = min( $total, $per_page * $current ); /* translators: 1: first result 2: last result 3: total results */ printf( _nx( 'Showing %1$d–%2$d of %3$d result', 'Showing %1$d–%2$d of %3$d results', $total, 'with first and last result', 'woocommerce' ), $first, $last, $total ); }
I edit this Code:
printf( _nx( 'Showing %1$d–%2$d of %3$d result', 'Showing %1$d–%2$d of %3$d results', $total, 'with first and last result', 'woocommerce' ), $first, $last, $total );
to
printf( _nx( 'Showing %1$d–%2$d of <b>%3$d</b> result', 'Showing %1$d–%2$d of <b>%3$d</b> results', $total, 'with first and last result', 'woocommerce' ), $first, $last, $total );
But when I do that, is total result bold but the Translation no longer works.
befor:
Ergebnisse 1 – 12 von 1230 werden angezeigt
after:
Showing 1–12 of 1230 resultsWhen i edit this Code, then Display it in english. German dosn’t work.
- This reply was modified 4 years, 7 months ago by rubbeldiekatz.
- This reply was modified 4 years, 7 months ago by rubbeldiekatz.
Forum: Plugins
In reply to: [WooCommerce] WooCommerce – Display total in boldHi
No only this 1230.
The total number.thx
- This reply was modified 4 years, 7 months ago by rubbeldiekatz.