Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

[2.1.11] Database error when giving badges or ratings

giopaulgiopaul New
in Vanilla 2.0 - 2.8

When I try to give people a badge or a rating the following error will occur:

https://i.gyazo.com/24be5bad31106f26b017b9202f476b94.png

Can you please tell me how to fix this?

Respect for the rest of the plugin btw, very well programmed. I dontated $10.

Comments

  • hgtonighthgtonight MVP

    Thanks for trying my addon!

    I truly appreciate your donation.

    What version of PHP are you using? Are you in mysql strict mode?

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • giopaulgiopaul New
    edited September 2015

    I'm running the following:

    • Microsoft-IIS/8.5
    • Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $
    • PHP extension: mysqli Documentation
    • PHP version: 5.6.0
    • Server connection collation: utf8mb4_unicode_ci
    • Strict mode is disabled

    When I log in to PhpMyAdmin it will display the following message.
    https://i.gyazo.com/9289adf205c04fd73ce7a5b4a0aeaba3.png

    Maybe this is related?

  • peregrineperegrine MVP
    edited September 2015

    When I log in to PhpMyAdmin it will display the following message.
    Maybe this is related?

    no, pma is totally unrelated to the other issue

    you obviously changed your date time format. do you have an issue when you revert to the standard date time formats before changing your definitions.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • hgtonighthgtonight MVP

    Is STRICT_TRANS_TABLES set in your sql_mode variable?

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • giopaulgiopaul New

    Oh stupid, stupid me. Yeah thank you for pointing that one out.

    I've removed that and ran a SET @@global.sql_mode= ''; query and now it works! Amazing support.

Sign In or Register to comment.