Jump to content

Community

Database compact mode how to change for this on cPanel ?


Marco Junior
 Share

Go to solution Solved by Sirmadsen,

Recommended Posts

Hello dears,

I have a warning on my admincp this warning show-me a information refers to my database mode.

What's this ? Compact mode ?

 

Error:

Your server does not meet our recommendations. This may prevent you from upgrading to future versions of Invision Community.

You have one or more InnoDB tables that are using the `Compact` row format. This may limit the amount of data that can be stored within the table. We recommend changing it to 'Dynamic'. If you are not sure how to do this, you should contact your hosting provider or system administrator for assistance.
You should contact your hosting provider or system administrator and ask them to resolve these issues.

 

Link to comment
Share on other sites

51 minutes ago, Marco Junior said:

What's this ? Compact mode ?

There are over half a dozen topics already started discussing this topic.   This platform is deceptively easy to install but does require an understanding of the underlying hardware and operating system/software stack in order to ensure it's secure and operates efficiently.  The knowledge is readily attained through extensive internet searching but requires a great deal of one's time to master it all.

Unless you have a "very" small userbase and traffic you will likely encounter issues like the one described above that may be beyond one's ability to easily figure out or take more time than you readily have. 

Most of the problems you will likely encounter will be beyond the scope of support here and with your service provider(s). When that happens and they will, you need to secure the expertise of someone that has mastered the requisite skills, unfortunately such skills come at a price.  

There are lots of hidden expenses running a successful internet site. Everyone needs to ensure they have sufficient funds in their budget to be able to hire "experts" to address issues that are beyond one's ability to readily deal with on their own.  Hosting plans that most folks can readily afford do not have the requisite power and configurability to be both secure and support a sufficiently large enough user base that you can generate enough revenue to offset your expenses.  

There is an old saying, "It takes money to make money".  If you want any chance of earning a profit on your site you will need to spend some money on consultants and upgraded hosting and other products and services in order to have a platform that can support rapid user growth.  Scaling a website using this software platform isn't cheap or easy but can offer a great return on one's investment of time and money "if" it is done correctly. 

Link to comment
Share on other sites

  • Solution
15 hours ago, Chris Anderson said:

There are over half a dozen topics already started discussing this topic.   This platform is deceptively easy to install but does require an understanding of the underlying hardware and operating system/software stack in order to ensure it's secure and operates efficiently.  The knowledge is readily attained through extensive internet searching but requires a great deal of one's time to master it all.

Unless you have a "very" small userbase and traffic you will likely encounter issues like the one described above that may be beyond one's ability to easily figure out or take more time than you readily have. 

Most of the problems you will likely encounter will be beyond the scope of support here and with your service provider(s). When that happens and they will, you need to secure the expertise of someone that has mastered the requisite skills, unfortunately such skills come at a price.  

There are lots of hidden expenses running a successful internet site. Everyone needs to ensure they have sufficient funds in their budget to be able to hire "experts" to address issues that are beyond one's ability to readily deal with on their own.  Hosting plans that most folks can readily afford do not have the requisite power and configurability to be both secure and support a sufficiently large enough user base that you can generate enough revenue to offset your expenses.  

There is an old saying, "It takes money to make money".  If you want any chance of earning a profit on your site you will need to spend some money on consultants and upgraded hosting and other products and services in order to have a platform that can support rapid user growth.  Scaling a website using this software platform isn't cheap or easy but can offer a great return on one's investment of time and money "if" it is done correctly. 

That's not a very helpful answer. I'm having the same error @Marco Junior Compact mode is basically a less efficient format and can't store as much information as Dynamic. You can change this in your database settings (phpadmin for example) if your database supports it and depending if you are hosting the server yourself or if you are using a web-host which might not support it or only support in a higher tier payment (as in my case) . However since it's not a critical issue you don't have to worry about it unless you have a really big community.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy