Forum Replies Created

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Good Morning Matthew

    Yes, it works now. Thank you very much for the help.

    Have a nice day.

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Thanks for the research. I am excited.

    Best regards

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    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(*) FROM Jlh8WI4a_statistics_pages WHERE type = ” 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) AS count 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 FROM Jlh8WI4a_statistics_pages WHERE date = ‘2024-10-28’ AND uri = ‘/wohnen/wohngebiet-hirschgarten/’ AND type = ‘page’ AND id = 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 INTO Jlh8WI4a_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 FROM Jlh8WI4a_statistics_pages WHERE type = ‘page’ and id = 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.

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    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(*) FROM Jlh8WI4a_statistics_pages WHERE type = ” 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) AS count 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 FROM Jlh8WI4a_statistics_pages WHERE date = ‘2024-10-28’ AND uri = ‘/wohnen/wohngebiet-friedrichshagen-ost/’ AND type = ‘page’ AND id = 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 INTO Jlh8WI4a_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 FROM Jlh8WI4a_statistics_pages WHERE type = ‘page’ and id = 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::getPageId

    The table Jlh8WI4a_statistics_pages exists and is empty

    Thread Starter rubbeldiekatz

    (@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 Regards

    PS: I do this: Statistics > Settings > Filtering & Exceptions > User Role Exclusions, Admin deactivate

    Thread Starter rubbeldiekatz

    (@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 regards

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Good 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

    Thanks

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Here a Screenshot https://ibb.co/bP0DD0W

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Guten 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 wieder

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    That’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 regards

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Hi

    Ich habe es nun herausbekommen.

    L?sung:
    <div class=”frc-captcha” data-sitekey=”<mySiteKey>” data-lang=”de”></div>

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    ok, thank you and happy holidays.

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Hey

    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?

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Good 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&ndash;%2$d of %3$d result', 'Showing %1$d&ndash;%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&ndash;%2$d of %3$d result', 'Showing %1$d&ndash;%2$d of %3$d results', $total, 'with first and last result', 'woocommerce' ), $first, $last, $total );

    to
    printf( _nx( 'Showing %1$d&ndash;%2$d of <b>%3$d</b> result', 'Showing %1$d&ndash;%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 results

    When i edit this Code, then Display it in english. German dosn’t work.

    Thread Starter rubbeldiekatz

    (@rubbeldiekatz)

    Hi

    No only this 1230.
    The total number.

    thx

    • This reply was modified 4 years, 7 months ago by rubbeldiekatz.
Viewing 15 replies - 1 through 15 (of 19 total)