• Resolved gigasaurus

    (@gigasaurus)


    When I updated my site to PHP7, it broke my pages when viewed on iPad. Here is how my pages look on iPad. I deactivated WP_Statistics and the problem went away.

    WordPress database error Unknown column 'page_id' in 'field list' for query SELECTpage_idFROMwp1834_statistics_pagesWHEREdate= '2022-12-12' ANDtype= 'post' ANDid` = ‘1991’ 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->record_wp_hits, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record
    WordPress database error Unknown column ‘type’ in ‘field list’ for query INSERT IGNORE INTO wp1834_statistics_pages (uri, date, count, id, type) VALUES (‘/mypage/’, ‘2022-12-12’, 1, ‘1991’, ‘post’) 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->record_wp_hits, WP_STATISTICS\Hits::record, WP_STATISTICS\Pages::record, WP_STATISTICS\Pages::save_page
    WordPress database error Unknown column ‘user_id’ in ‘field list’ for query INSERT INTO wp1834_statistics_useronline (ip, timestamp, created, date, referred, agent, platform, version, location, user_id, page_id, type) VALUES (‘47.144.128.165’, ‘1670833519’, ‘1670833519’, ‘2022-12-12 08:25:19’, ‘https://mywebsite.com’, ‘Chrome’, ‘Windows’, ‘10.0’, ‘000’, 0, ‘1991’, ‘post’) 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->record_wp_hits, WP_STATISTICS\Hits::record, WP_STATISTICS\UserOnline::record, WP_STATISTICS\UserOnline::add_user_online`

Viewing 1 replies (of 1 total)
  • Plugin Author Mostafa Soufi

    (@mostafas1990)

    Hello,

    It seems to me the Database upgrader functionality didn’t work properly, not sure why.

    Anyway, to run it manually, first, disable the plugin, then remove this option on your database wp_statistics_plugin_version or run this query on your database

    DELETE FROM wp_options WHERE option_name = 'wp_statistics_plugin_version'

    Then, enable the plugin.

Viewing 1 replies (of 1 total)
  • The topic ‘update to PHP7 WP_Statistics causes page break on iPad’ is closed to new replies.