5 Most Common Errors in PhpMyAdmin and Wordpress

1. Error (near “ON” at position 25) while importing Table for WORDPRESS

The Solution to this problem is:

Go to opt/lampp/etc/my.cnf or from xampp panel of mysql and edit max_allowed_packet.

max_allowed_packet = 1024M

2. Wordpress 500 Internal Server Error

The Solution to this problem is:

Solution 1. Rename the plugins folder which is in directory wp-contect/plugins, This will disable all the plugins.

If the problem still exists, rename the .htaccess file...

Solution 2. Rename the .htaccess file to .htaccess_whatever_you_like, This will create a new .htaccess file as sometimes the .htaccess file gets corrupted while moving from one server to another.

If the problem still exists, give permission to your directory...

Solution 3. Your directory might not have permission to access...

sudo chmod -R 777 /opt/lampp/htdocs/insuropedia

3. Increase the Import file sizelimit in PhpMyAdmin

The Solution to this problem is:

Step1: To increase the size of uploading file go to php.ini which is found in directory /opt/lampp/etc/php.ini

Step2: Give permission first to php.ini in order to edit the file

sudo chmod -R 777 /opt/lampp/etc/php.ini

Step3: Search for post_max_size and upload_max_filesize using (Ctrl+F)

Step4: Replace the size to 256m.

Step5: Restart xampp Server in order for phpmyadmin to refresh.

4. Error Establishing a database connection

The Solution to this problem is:

Go to wp-config file and check for credentials if they are correct.

define('DB_NAME', 'database_name');

define('DB_USER', 'database_username');

define('DB_PASSWORD', 'database_password');

define('DB_HOST', 'server_name');

5. The requested URL was not found on this server

Solution to this problem is,

Solution1:

There are 2 ways to update the homeUrl and SiteUrl ....

1. Go to phpmyadmin -> Select your database -> Search for wp_options table.

In wp_options table update the siteURl and homeUrl.

2. Login to wordpress dashboard-> Go to General -> Settings

Update the two field “WordPress Address (URL)” and “Site Address (URL)

If the problem still exists, then edit the apache2.confg file

Solution2:

Step1: Open the terminal: Change the directory to

cd /etc/apache2

Step2: Open the apache.confg file using command

sudo gedit apache2.conf

Step3:  In apache2.cong, search for <Directory var/www/>

Step4: Change the AllowOverride None to AllowOverride All.

Step5: Restart the Xampp and refresh the browser.