Title: FYI- SQL syntax error
Last modified: June 26, 2020

---

# FYI- SQL syntax error

 *  Resolved [gastronimo](https://wordpress.org/support/users/gastronimo/)
 * (@gastronimo)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/fyi-sql-syntax-error/)
 * I know you told me Advanced Visit Counter is not yet optimized for multisites,
   but so you know…in testing it it throws this error:
 * [26-Jun-2020 15:44:03 UTC] Error You have an error in your SQL syntax; check 
   the manual that corresponds to your MySQL server version for the right syntax
   to use near ‘ORDER BY last_date DESC’ at line 1 de la base de datos de WordPress
   para la consulta SELECT last_date FROM ANYsite_6_avc_page_visit_history WHERE
   ip_address=’00.249.66.204′ AND article_id= ORDER BY last_date DESC realizada 
   por require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array(‘wp’), WP_Hook-
   >do_action, WP_Hook->apply_filters, Advanced_Visit_Counter_Public->update_page_visit_stats
 * Thanks!

Viewing 1 replies (of 1 total)

 *  Plugin Author [Ankit Panchal](https://wordpress.org/support/users/ankitmaru/)
 * (@ankitmaru)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/fyi-sql-syntax-error/#post-13041684)
 * Hello [@gastronimo](https://wordpress.org/support/users/gastronimo/) ,
 * Thank you for your query.
    Yes, We are working on a major updates related to 
   Multisite. We will push it soon.
 * Thank you

Viewing 1 replies (of 1 total)

The topic ‘FYI- SQL syntax error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/advanced-page-visit-counter_004aad.
   svg)
 * [Advanced Page Visit Counter – Most Wanted Analytics Plugin for WordPress](https://wordpress.org/plugins/advanced-page-visit-counter/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-page-visit-counter/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-page-visit-counter/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-page-visit-counter/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-page-visit-counter/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-page-visit-counter/reviews/)

## Tags

 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [page](https://wordpress.org/support/topic-tag/page/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [visit](https://wordpress.org/support/topic-tag/visit/)

 * 1 reply
 * 2 participants
 * Last reply from: [Ankit Panchal](https://wordpress.org/support/users/ankitmaru/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/fyi-sql-syntax-error/#post-13041684)
 * Status: resolved