Database Error

  • Resolved andiger

    (@andiger)


    2 years, 5 months ago

    Hi,

    i have a new installation from WordPress on my Server. So i see this Error in PHP Error Log:

    WordPress-Datenbank-Fehler Unknown column ‘device’ in ‘field list’ für Abfrage INSERT IGNORE INTO tr_statistics_visitor (last_counter, referred, agent, platform, version, device, model, ip, location, user_id, UAString, hits, honeypot) VALUES (‘2022-06-24’, ‘https://www.tanja-ruediger.de/mentoring/theta-healing/was-ist-theta-healing/’, ‘Safari’, ‘iOS’, ‘15.5’, ‘mobile:smart’, ‘iPhone’, ‘2003:cf:4f2a:dd00:59d3:2658:425a:4daf’, ‘DE’, 0, ”, ‘1’, ‘0’) von 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\Visitor::record, WP_STATISTICS\Visitor::save_visitor, QM_DB->query

Viewing 8 replies - 1 through 8 (of 8 total)
  • Reza

    (@reventon94)

    Hi,

    I hope you have a great day.

    The issue was detected by our developers and they have fixed it. The new version will release soon.
    https://github.com/wp-statistics/wp-statistics/commit/be6d3f296b5283f5383be4305b9b3a0f31d11c9e

    Best Regards

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Thank you for reporting, the issue has been fixed, please delete the plugin and install the new version (v13.2.4.1) again.

    I do have Version 13.2.4.1 and the error message persists…

    “Here is an error associated with Connecting WordPress Rest API
    Please Flushing rewrite rules or activate WordPress REST API for performance WP-Statistics Plugin Cache / Go Settings->Permalinks

    Since this message appeared, no visits at all are recorded in my site.

    I’m using WP 6.0.

    I do have 3 recommended improvements:

    “You should remove inactive plugins Security”
    “Your site is running an older version of PHP (7.3.33), which should be updated”
    “Not all recommended security headers are installed”

    …my theme is UNCODE.

    …and this are my plugins (all last version):

    Admin Columns Pro
    Akismet Anti-Spam
    Better Search
    Category Order and Taxonomy Terms Order Version
    Contact Form 7
    Default Twitter Image for Yoast
    Disable Gutenberg
    Flamingo
    Give – Donation Plugin
    Random Post on Refresh
    Really Simple SSL
    TaxoPress
    Uncode Core Version
    Uncode WPBakery Page Builder
    UpdraftPlus – Backup/Restore
    Wordfence Security
    WP-Optimize – Clean, Compress, Cache
    WP AutoTerms
    WPBakery Page Builder Clipboard Version
    WP Statistics
    WP ULike
    WP User Avatar
    Yoast Duplicate Post
    Yoast SEO

    …all worked fine before the update.

    For the record I moved from a VPS to a Shared Server but other sites work fine with the plugin’s last version.

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    @ign2009
    Can you please check what do you see when you go to this URL?

    /wp-json/wp-statistics/v2/hit

    Hi there,

    I see a JSON file like so:

    code	"rest_missing_callback_param"
message	"Missing parameter(s): browser, platform, version, ip, track_all, timestamp, page_uri, user_id"
data	
status	400
params	
0	"browser"
1	"platform"
2	"version"
3	"ip"
4	"track_all"
5	"timestamp"
6	"page_uri"
7	"user_id"

    What does it mean?
    Thanks for your support!

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    @ign2009 It means the REST API endpoint has been registered successfully, so the question is why the admin side can’t see this endpoint and shows that notice.

    This is what we’re currently working on.
    https://github.com/wp-statistics/wp-statistics/issues/405

    Ok thanks for your reply.
    I hope you find the culprit soon guys.
    Keep up the great work! ?? ??

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Thank you for your great feedback! @ign2009

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Database Error’ is closed to new replies.