Title: Incorrect sql queries
Last modified: September 1, 2016

---

# Incorrect sql queries

 *  [marekkaczanowicz](https://wordpress.org/support/users/marekkaczanowicz/)
 * (@marekkaczanowicz)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/incorrect-sql-queries/)
 * Hi, I think you do not need the database name within all sql queries – it is 
   producing errors:
 * WordPress database error: [You have an error in your SQL syntax; check the manual
   that corresponds to your MariaDB server version for the right syntax to use near‘-
   wordp-3r.wp_1_datafeed WHERE price > 0’ at line 1]
    SELECT COUNT(*) FROM a-wordp-
   3r.wp_1_datafeed WHERE price > 0
 * [https://wordpress.org/plugins/awin-data-feed/](https://wordpress.org/plugins/awin-data-feed/)

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

 *  Thread Starter [marekkaczanowicz](https://wordpress.org/support/users/marekkaczanowicz/)
 * (@marekkaczanowicz)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/incorrect-sql-queries/#post-7513331)
 * also:
    $wpdb->get_var(“SHOW TABLES LIKE ‘wp_datafeed_analytics'”);
 * Should be
 * $wpdb->get_var(“SHOW TABLES LIKE ‘”.$this->analyticsTable.”‘”);
 *  Plugin Author [digitalwindow](https://wordpress.org/support/users/digitalwindow/)
 * (@digitalwindow)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/incorrect-sql-queries/#post-7513634)
 * Hi marekkaczanowicz,
 * Thank you very much for your support ticket.
 * We will update and release a fix very soon.
 * Regards,
    Development team, Digital Window Ltd
 *  Plugin Author [digitalwindow](https://wordpress.org/support/users/digitalwindow/)
 * (@digitalwindow)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/incorrect-sql-queries/#post-7513641)
 * Hi Marek,
 * To understand the issue clearly we need to know your server resources. i.e OS,
   wordpress version, mysql version etc.
 * Seems you are using mariadb, which the plugin is not tested with.
 * Thanks for the code improvement tips on your second commit. This will be reflected
   on our next release of the plugin.
 * Please try the plugin with mysql database and let us know if you still have the
   issue.
 * Thanks.

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

The topic ‘Incorrect sql queries’ is closed to new replies.

 * ![](https://ps.w.org/awin-data-feed/assets/icon-128x128.png?rev=1608656)
 * [Awin Data Feed](https://wordpress.org/plugins/awin-data-feed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/awin-data-feed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/awin-data-feed/)
 * [Active Topics](https://wordpress.org/support/plugin/awin-data-feed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/awin-data-feed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/awin-data-feed/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [digitalwindow](https://wordpress.org/support/users/digitalwindow/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/incorrect-sql-queries/#post-7513641)
 * Status: not resolved