Title: Database Error
Last modified: June 24, 2022

---

# Database Error

 *  Resolved [andiger](https://wordpress.org/support/users/andiger/)
 * (@andiger)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/)
 * 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/&#8217](https://www.tanja-ruediger.de/mentoring/theta-healing/was-ist-theta-healing/&#8217);,‘
   > 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](https://wordpress.org/support/users/reventon94/)
 * (@reventon94)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15769569)
 * 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](https://github.com/wp-statistics/wp-statistics/commit/be6d3f296b5283f5383be4305b9b3a0f31d11c9e)
 * Best Regards
 *  Plugin Author [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15769624)
 * Thank you for reporting, the issue has been fixed, please delete the plugin and
   install the new version (v13.2.4.1) again.
 *  [Jan444](https://wordpress.org/support/users/ign2009/)
 * (@ign2009)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15813616)
 * 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](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15818491)
 * [@ign2009](https://wordpress.org/support/users/ign2009/)
    Can you please check
   what do you see when you go to this URL?
 * /wp-json/wp-statistics/v2/hit
 *  [Jan444](https://wordpress.org/support/users/ign2009/)
 * (@ign2009)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15826471)
 * 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](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15830698)
 * [@ign2009](https://wordpress.org/support/users/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](https://github.com/wp-statistics/wp-statistics/issues/405)
 *  [Jan444](https://wordpress.org/support/users/ign2009/)
 * (@ign2009)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15831301)
 * Ok thanks for your reply.
    I hope you find the culprit soon guys. Keep up the
   great work! 👍 👍
 *  Plugin Author [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15831960)
 * Thank you for your great feedback! [@ign2009](https://wordpress.org/support/users/ign2009/)

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

The topic ‘Database Error’ is closed to new replies.

 * ![](https://ps.w.org/wp-statistics/assets/icon.svg?rev=3081064)
 * [WP Statistics – Simple, privacy-friendly Google Analytics alternative](https://wordpress.org/plugins/wp-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-statistics/reviews/)

 * 8 replies
 * 4 participants
 * Last reply from: [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/database-error-368/#post-15831960)
 * Status: resolved