SQL syntax error with MariaDB and Woocommerce Analytics

  • Resolved aigar

    (@aigar)


    6 years ago

    After latest update (2.0.2 Woocommerce Analytics stopped working.

    In debug log following error and Woocommerce Analytics does not display any data.

    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 ‘) wcpbc_rates ON wcpbc_rates.currency = meta__order_currency.meta_value
    WHERE’ at line 15

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Oscar Gare

    (@oscargare)

    6 years ago

    Hi,
    how many pricing zones do you have? (at WooCommerce > Settings > Zone pricing)

    Plugin Author Oscar Gare

    (@oscargare)

    6 years ago

    And, are you using multiple currencies?

    Thread Starter aigar

    (@aigar)

    6 years ago

    Hi,

    We have only two pricing zones and one currency.

    Plugin Author Oscar Gare

    (@oscargare)

    6 years ago

    Hi,
    I found a problem when the currency of the pricing zones is the same of the shop currency.

    We’ll solve asap.

    Thanks for the feedback.

    Thread Starter aigar

    (@aigar)

    6 years ago

    Thank you. Will be waiting for update.

    Plugin Author Oscar Gare

    (@oscargare)

    6 years ago

    Hi, 2.0.3 should fix the issue. After updating, run the “Database updater” (you’ll see a notice in your admin dashboard) to refresh the WooCommerce Analytics cache.

    Thread Starter aigar

    (@aigar)

    6 years ago

    All is working now and no error.
    Thank you.

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

The topic ‘SQL syntax error with MariaDB and Woocommerce Analytics’ is closed to new replies.

  • 7 replies
  • 2 participants
  • Last reply from: aigar
  • Last activity: 6 years ago
  • Status: resolved