Database error

  • Resolved koupmi

    (@koupmi)


    5 months, 1 week ago

    When i turn debug log, i got this error:

    [08-Oct-2024 08:37:08 UTC] [WP STATISTICS] [WARNING]: Unknown column ‘type’ in ‘field list’

    [08-Oct-2024 08:37:08 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT page_id FROM wp433_statistics_pages WHERE type = ‘page’ and id = 1985 ORDER BY date DESC made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Hits::trackServerSideCallback, WP_STATISTICS\Hits::record, WP_STATISTICS\Hits::recordOnline, WP_STATISTICS\UserOnline::record, WP_STATISTICS\UserOnline::update_user_online, WP_STATISTICS\Pages::getPageId

    [08-Oct-2024 08:37:12 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROM wp433_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

    [08-Oct-2024 08:37:13 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT page_id FROM wp433_statistics_pages WHERE type = ‘unknown’ and id = 0 ORDER BY date DESC made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Hits::trackServerSideCallback, WP_STATISTICS\Hits::record, WP_STATISTICS\Hits::recordOnline, WP_STATISTICS\UserOnline::record, WP_STATISTICS\UserOnline::update_user_online, WP_STATISTICS\Pages::getPageId

    [08-Oct-2024 08:37:32 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROM wp433_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

    [08-Oct-2024 08:37:44 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROM wp433_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

    [08-Oct-2024 08:37:47 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROM wp433_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

    [08-Oct-2024 08:37:50 UTC] WordPress database error Unknown column ‘type’ in ‘where clause’ for query SELECT COUNT(*) FROM wp433_statistics_pages WHERE type = ” made by require_once(‘wp-admin/admin.php’), 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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Matthew

    (@mhdizmni)

    Hello @koupmi,

    Thank you for opening the thread!

    Could you please provide more details about the issue you’re experiencing? On which specific page do you encounter the errors? Providing screenshots/screencasts can significantly help us investigate the issue and provide you with more accurate answers.

    Additionally, could you share your site info with us? You can find it under Tools > Site Health > Info in your WordPress admin area.

    Thank you for your cooperation!

    Best regards

    Plugin Support Matthew

    (@mhdizmni)

    Hi @koupmi,

    After reviewing the issue, it appears that the “type” column is missing from the statistics_pages table, which is causing this issue.

    To resolve it, please run the following SQL command in your database to add the column:

    ALTER TABLE wp433_statistics_pages ADD COLUMN type VARCHAR(180) AFTER id;

    This should fix the error, and data should be recorded without any issues moving forward.

    We would appreciate it if you could let us know the results.

    Regards

    Plugin Support Matthew

    (@mhdizmni)

    Dear @koupmi,

    We will mark this thread as “resolved” since we haven’t heard back from you in a while.

    Please feel free to reopen it or create a new one if you still need help or have any further questions.

    Thank you!

    Regards,
    Matthew

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.