[FIXED] Columns hidden/missing inside phpmyadmin

Issue

When I click on the "explore" tab it would normally show me the data inside my table, but for some reason it wont show me all the columns. It only shows me 5 columns and the rest are hidden. The exact same thing happens when I use this query:

SELECT * FROM `tabs`

However, I do find the column and the data inside it when I specifically search for it:

SELECT `prevpage` FROM `tabs`

When I click on the dropdown arrow on the < T > column above the edit options I can choose which columns I want to show. There are two empty column names inside the list (exactly like two columns are missing), and when I choose to view them all the content inside them says NULL while its not.

Any idea's on how to solve this?

Solution

I had a similar issue. However, the resolution was a lot different and EASIER to apply.

The issue was actually caused by 'Storage Engine'. All you need to do to clear this error is to:

     - Go to the table that is having the trouble of hidden column-> 
     - Got to 'Operation' Tab->
     - Under 'Table Options' ->
     - For 'Storage Engine' Option, select the one that is consistent with
       the one that you are   using throughout the table. 
     - Refresh the table-> Wala! The missing column reappear in browse tab!

In the case for myself, I am using 'MyISAM' as default but was using 'InnoDB' for that specific troubled table.

It has took my an hour to figure out what happened and NOTHING was available online for this situation. Hope it helps one who has the same problem.

Answered By - weia design