Missing Checkbox in phpMyAdmin

Fix the Missing Checkbox in MySQL Database Table Rows using PHPMyAdmin

In Web Hosting by Fathi Arfaoui0 CommentsLast Updated: September 15th, 2017

Sometimes, problems with the database happen especially if you’re a beginner. That happened to me once with a WordPress database that looked broken in some tables. So, when I wanted to check a table and export or edit it, or even remove it, there was no option at all. Even, the check box was missing.

If that’s your case, then, follow this step by step tutorial to solve the missing database table selection box and all the available options like edit, delete, export.

No Checkbox and Options in phpMyAdmin

Solutions

1. Set a primary key field

One of the main causes for this problem is that the database table rows don’t have a primary key field, so, to fix the mission tables check box, just click on the table name you need, then, you’ll see all the related fields. From there, click on Structure at the top are like the following screenshot.

Fix the database table missing checkbox

For the wp-options table, for example, you can set option-id as the primary key, that way, you can fix things.

As phpMyAdmin itself inform you that there are no options available to delete, select or even edit the table content, you need a way to organize the tables, so, they look ordered based on ranking or similar thing. So, if the above solution doesn’t work, you need to try the next one.

2. Reset AUTO_INCREMENT

This is one of the best solutions for many cases that include the situation where readers are unable to post a comment on WordPress or other.

The MySQL AUTO_INCREMENT organize the data clearly, so, there will be a clear structure for queries and operations.

To enable auto_incremnet in your phpMyAdmin tool, we need to create a new table, so, click on your database name on the left area, and then, you’ll find New at the top of the tables as the following example, when you click on it, you’ll create a new database table.

add new database table

Now, you can name the table anything you want, but you need to have two important things, set the type to INT, and also check the box A_I which means AUTO_INCREMENT, see the next image.

table options

To save the changes click the Save button at the right bottom corner of that page.

3. Check for Uppercase in database table name

This can happen for many reasons, even if there is a primary key and everything is okay, with some database engines and cases, the problem can appear with Uppercase used in the database table name. So, you’ll be unable o export any row in phpMyAdmin. For that, if you have an upper case in your database table name, changing to lowercase and verify is that solves the problem.

Now, you should get the tables organized and you’ll be able to check any table in MySQL with phpMyAdmin.

4. Ask your Web host

Sometimes, we forgot that some hosting company may disable some functions or that they have old versions of PHP and MySQL and so on, so, there are chances that the database engine work with missed functionalities or slowly especially with shared web hosting. The tables grid options like edit, delete, and copy functions will not be available for you. For that reason, check with your web hosting provider if they can help.

Meantime, why not switching to a premium quality hosting like Liquid Web for any application, or choose WP Engine, the best WordPress managed hosting I recommend and use for this site.

If none of these solutions worked, you may be facing another case with specific database types and even languages. You can try changing the database engine to InnoDB as there are some differences between that and MyISAM.

You can also try updating your MySQL to the latest version, that can help.

If you fixed your missing table rows selection box in phpMyAdmin using another solution, let me know or add it in your comment, so, everyone gets a fix.

About Fathi Arfaoui

Fathi Arfaoui: A Physicist, Blogger, and the founder and owner of Trustiko.com. He shares Business, Blogging, WordPress, Web Safety, and Blogging tips to build better websites and blogs. Also, he shares online marketing strategies and recommendations.

Leave a Comment