I have an error showing in Joomla v3.10.5, while accessing the modules under extensions

Out of sort memory, consider increasing server sort buffer size Out of sort memory, consider increasing server sort buffer size

I'm new to Joomla, anyone can help?

enter image description here

  • Welcome to JSE, Joel. Please take our tour. If you are able ti provide more diagnostic information, this may help volunteers to give you the most appropriate solution. Increasing memory may fix the problem, but perhaps there is a deeper issue to resolve.
    – mickmackusa
    Feb 13 at 8:33
  • As @Irata points out, you may need to make some changes in your hosting environment as per stackoverflow.com/a/63933161/1983389. If you don't have access to edit the mysql configuration file, then your hosting provider may be able to help. Feb 14 at 0:38

1 Answer 1


A quick search brings up this result which has a lot of seemingly good comments about how to increase the memory for the SQL query, however there is also advice suggesting to review the Query you are running.


So I would check what size memory you already and unless it is below the default look at the query.

As the message is a SQL issue it is not something you can expect to change in the Joomla options.

If you are just looking at the list of modules under the Admin view then it is possible you have too many modules created and that the default Query is running out of storage. I worked on a problem a few years back where the site had over 1'000 modules created and that would run out of memory when they tried to update some modules.

If you need more help you will need to provide more information about your environment.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.