Skip to content Skip to main navigation Skip to footer

Query bug

Welcome to QSM Support Forum. › Forums › QSM Pro Support › Query bug

Tagged: 

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • May 13, 2020 at 1:19 pm #3871
    martin@lovingpenguin.com[email protected]
    Participant

    Hi,

    About a month ago (aprox around the 20th of April), a new version of the QSM plugin was released. Unfortunately, this has caused a lot of load on our Database and also caused several hundred dollars of AWS traffic costs. The problem is that the QSM plugin constantly seems to be executing the query ‘SELECT * FROM wp_mlw_results’.

    As we were having more than 12000 results in our DB, this query took almost a minute to execute each time and all the data from the table was submitted from our RDS instance to our web servers constantly. We are talking about many GB of additional traffic every day.

    Once I disable QSM, the problem is fixed.

    As a (temporary) workaround we jsut deleted all results from the wp_mlw_results table now. They query is still executed all the time, but as there are no (and soon few) results only, it will be affecting much less.

    Can you please have a look into this? I imagine this probably affects all QSM users in a way.

    Cheers,
    Martin

    May 13, 2020 at 11:06 pm #3883
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Martin, I need to talk to the development team regarding this issue. I will get back to you as soon as I hear back from them.

    Regards,
    Kriti

    May 21, 2020 at 10:22 am #4087
    Kriti SharmaKriti Sharma
    Keymaster

    Hi,

    Please use the following zip copy for testing.

    https://drive.google.com/open?id=10qM9o7c5fbGLjsiwy-LGjagUcFXkNA8C

    Please upload using FTP to overwrite existing copy on your server.

    NOTE: Do not do a manual update from WordPress admin, because deleting QSM from WordPress admin will delete all of the quiz!

    Please do tell me whether this fix works for you in reducing database load or not.

    Regards,
    Kriti

    March 18, 2025 at 9:25 am #12757
    Owens Helene OwensOwens Helene Owens
    Participant

    I need a friend to compete with for score in block blast unblocked. Is anyone here ready?

    March 19, 2025 at 7:32 am #12768
    rob harrisrob harris
    Participant

    Check out Weby’s Amazon Sales Estimator – good option to understand what your projected sales on Amazon gonna be!

    April 1, 2025 at 6:40 am #12866
    Dean SanfordDean Sanford
    Participant

    Okay, Martin, this sounds like a seriously critical issue with the QSM plugin! The constant execution of SELECT * FROM wp_mlw_results is definitely not ideal, especially with a large dataset like yours. sprunki phase 5

    July 16, 2025 at 2:28 pm #14193
    Mary PeoplesMary Peoples
    Participant

    The plugin may have an error due to the difference between the local environment (openserver) and the actual hosting environment. Try checking the file write permissions and PHP configuration on the hosting. While handling this error, I often play Basket Random to relax a bit and then come back to check more carefully.

    May 5, 2026 at 8:26 am #21047
    Sara AdamSara Adam
    Participant

    Subway Surfers is clear proof that a simple yet cleverly designed and creative game can become a beloved global entertainment icon across generations.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.