To make it work as expected, WordPress Portal requires some functions and modes that need to be enabled and configured on your server. And because these configurations vary from server to server, you might get an error when you are trying to access a page that uses one of these functions.
The required configurations:
One of the most common configurations that cause an error 500 on the first user home screen is the ONLY_FULL_GROUP_BY mode. If you have ONLY_FULL_GROUP_BY mode is enabled on your system (MySQL Config), that will cause a server error (error 500) because the server cannot handle the code on this page because that function is not allowed.
To fix this, you need to login to your server first and choose one of the following solutions to set the proper configs:
Solution 1
Remove ONLY_FULL_GROUP_BY from MySQL console by running the following command
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Solution 2
Remove ONLY_FULL_GROUP_BY from PHPMyAdmin
- Go to your cPanel account or any control panel you might be using and from there open PHPMyAdmin or the MySQL database manager you use.
- From PHPMyAdmin, go to the Variables tab and search for the variable “sql_mode” and click to edit its value
- From the value field, highlight “ONLY_FULL_GROUP_BY,” and delete it. Then, hit enter on your keyboard to save.
That’s it you are all set and now you should see the user home page loading and work without any error.
If you still encountering an issue, please reach out to our support team and open a support ticket using our Support Portal