phpMyAdmin doesn't show added columns

Question

Since I got phpMyAdmin 3.5.2.2 there is a strange problem. When I add a new column to a particular table it is not shown in the overview. This problem occurs only one table, all other are fine. Couldn't find something in the settings :/

Answer 1

I have experienced this as well. (XAMPP 1.8.1, PHP 5.4.7, PMA 3.5.2.2).

Ugly method to solve this problem:

1. Export table as text (SQL dump)
2. Drop table
3. Restore table (with the SQL dump backup)

Answer 2

I've found a slightly less ugly answer to this problem! You can go to the "Operations" tab and copy the table to another database, and then you could drop the original table and copy back, or just switch the code. I have my database connections all set with one variable, so changing the code is really easy for me personally. Hope it helps!