Database warning message after recent update

  • Resolved mohammedkadhim

    (@mohammedkadhim)


    5 months, 3 weeks ago

    Hello,

    After the most recent update, I started seeing this warning message in WordPress dashboard:

    “It seems your database user doesn’t have permission to ALTER TABLE. Please ensure the necessary permissions are in place or contact your hosting provider”

    And there is a button that says “Check if already fixed” which when pressed I get another message “Specified key was too long; max key length is 1000 bytes“.

    Kindly note the following:

    1. The problem is related to QSM because deactivating the plugin makes the message disappear.
    2. I had the issue after the recent QSM update.
    3. The database user does have all required permissions including ALTER TABLE.
    4. With regards to max key 1000 bytes limit, I don’t think it is practical to index such long VARCHAR columns anyway.

    Any idea?

    Kind regards,

    Mohammed Kadhim

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

    (@charlyaes32)

    Same problem here.
    After recent update (WordPres 6.5.4), I have this warnong message :
    It seems your database user doesn’t have permission to ALTER TABLE. Please ensure the necessary permissions are in place or contact your hosting provider

    But if I click on “Check button”, nothing happen.
    Just “#” after URL…

    Plugin Support sadiyakhanam

    (@sadiyakhanam)

    Hello,

    Thank you for bringing this to our attention.

    I want to assure you that our team is actively looking into the matter, and we will keep you updated. While we investigate, please know that the notification you’ve encountered is harmless. If your quizzes are functioning correctly, you can safely ignore them.

    If you have any other concerns, please feel free to reach out.

    Warm regards,
    Sadiya

    I just updated the quiz on a website and saw the same error message. Any way to fix this?

    “It seems your database user doesn’t have permission to ALTER TABLE. Please ensure the necessary permissions are in place or contact your hosting provider. Check If Already Fixed”

    If the button is pressed it says fixed but then the dashboard has the same message with a new button with a strange link saying Fixed!

    • This reply was modified 5 months, 3 weeks ago by a4jp.

    Hi @mohammedkadhim @charlyaes32 @a4jpcom

    First of all, we are thankful for your support in highlighting your experience with our previous release.

    We understand your situation and are excited to inform you that we have improved our notification management system. We’ve fixed the notification about database ALTER permissions to ensure it’s handled more effectively.

    Additionally, we’ve made several improvements to enhance your experience with the QSM plugin, making it smoother and more reliable.

    We apologize for any confusion caused by the alert notification in our previous release. Rest assured, it was not harmful and could be ignored if your quizzes were working fine.

    We encourage you to update to the latest QSM version 9.0.3 to benefit from recent improvements. If you have any questions, we are always here to help.

    Thank you for your continued support!

    Avi

    Arnaud

    (@charlyaes32)

    Hi there, 9.0.3 fix it.
    Many thanks !

    Thread Starter mohammedkadhim

    (@mohammedkadhim)

    Hello @avi25

    Appreciate your help. Yesterday I updated the plugin and the issue was fixed.

    Thank you for quickly addressing the issue and keeping us notified.

    Kind regards,

    Mohammed Kadhim

    Plugin Support sadiyakhanam

    (@sadiyakhanam)

    Hi @mohammedkadhim

    We’re so glad to hear that everything is working smoothly for you now. If you need any further assistance or have any questions, please don’t hesitate to reach out. We’re here to help!

    Best regards,
    Sadiya

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.