Title: WordPress database error
Last modified: June 18, 2019

---

# WordPress database error

 *  Resolved [ethereumicoio](https://wordpress.org/support/users/ethereumicoio/)
 * (@ethereumicoio)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-136/)
 * 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 ‘rows, ref AS reference,
   SUM(creds) AS total, MAX(time) AS last_entry FROM wp_myC’ at line 1]
 * SELECT COUNT(*) AS rows, ref AS reference, SUM(creds) AS total, MAX(time) AS 
   last_entry FROM wp_myCRED_log WHERE user_id = 9 AND ctype = ‘mycred_default’ 
   GROUP BY ref ORDER BY rows DESC;
 * While creating a woocommerce order as a guest with create account checkbox enabled.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-136%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Thread Starter [ethereumicoio](https://wordpress.org/support/users/ethereumicoio/)
 * (@ethereumicoio)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-136/#post-11649280)
 * Hi [@wpexpertsio](https://wordpress.org/support/users/wpexpertsio/),
    Thank you
   for your answer! I do not need a support on that, this report is my contribution
   to the myCRED plugin stability and success.
 *  Plugin Author [WPExperts.io](https://wordpress.org/support/users/wpexpertsio/)
 * (@wpexpertsio)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-136/#post-11651967)
 * Hi [@ethereumicoio](https://wordpress.org/support/users/ethereumicoio/),
 * Thank you for notifying this to us, we will surely look into this issue and would
   love to make myCred more stable and user friendly.
 * Thanks!

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

The topic ‘WordPress database error’ is closed to new replies.

 * ![](https://ps.w.org/mycred/assets/icon-128x128.gif?rev=3512531)
 * [Points Management System For Gamification, Ranks, Badges, and Loyalty Rewards Program - myCred](https://wordpress.org/plugins/mycred/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mycred/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mycred/)
 * [Active Topics](https://wordpress.org/support/plugin/mycred/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mycred/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mycred/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [WPExperts.io](https://wordpress.org/support/users/wpexpertsio/)
 * Last activity: [6 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-136/#post-11651967)
 * Status: resolved