[FIXED] Why are PHPMyAdmin actions displaying on some tables, and not others?

Issue

I have two databases. "members" and "verified_emails"

Now, in members I have the regular actions menu:

However, in the verified_emails database, it is a different story:

There is no actions menu when PHPMyAdmin views the verified_emails database.

After digging around on StackOverflow, I heard it would help to add this to my config.

$cfg['ActionLinksMode'] = 'both';

It didn't make any difference.

I am running PHPMyAdmin v4.1.14

Now that the info is laid out, here is my question.

My question is, why is this happening? Is there a fix for this, and if there is, how do I fix this?

Solution

The problem is caused by there not being an index column.

This is why I'll never be a database manager.

If a database is like my verified_emails database, I could have an id column that automatically increases its value.

Here is how I fixed this problem.

This is easier with MySQL, but i'll just do it with PHPMyAdmin in case someone looks for this in the future.

First, I went to columns.

Next, I went to add a new column at the beginning of the table.

I made it an integer, and called it id. (Note, in this I forgot to check AI, MAKE SURE YOU CHECK AI)

I set it to the index by clicking the index button.

Also set it to Unique and Primary!

Now, let's go back to browse!

It's done!
Now there is an automatically increasing id, and the tools!

Answered By - jinglebug

Answer Checked By - Gilberto Lyons (PHPFixing Admin)