WordPress.org

Forums

Football Pool
[resolved] TRUNCATE/DROP or DELETE rights (4 posts)

  1. SchultzDennis
    Member
    Posted 1 year ago #

    Hi,

    I have this error message, unfortunately i have 30 people filled in there stats. I have read the other solutions here but deleting and starting over is not an option. Can some one guide me on how i can fix this without data loss?

    many thanks in advance.

    Dennis

    https://wordpress.org/plugins/football-pool/

  2. AntoineH
    Member
    Plugin Author

    Posted 1 year ago #

    Try setting the debug settings in WordPress "on" to determine the exact error message. If you post the errors, or email them to me (see help page for contact details), I can have a look.

  3. AntoineH
    Member
    Plugin Author

    Posted 1 year ago #

    Problem was MySQL running in strict mode that caused some of my insert statements to fail. I will try to fix this in the next version (if I can get my install to work in strict mode so I can do some debugging).

  4. SchultzDennis
    Member
    Posted 1 year ago #

    Hi Antoine,
    Thanks for pointing out that it was the strict setting.
    for now I changed my serversetting to non strict.

    this line in my.ini:
    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

    to:
    sql-mode=""

    then restarted the service.

    when the tournament is over i will change it back :)

    Regards,
    Dennis

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Football Pool
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic