Geek Answers Handbook

Columns do not appear on Structure tab in phpmyadmin

I installed phpmyadmin for the first time, and everything works fine, except that none of the columns are displayed on the Structure tab. This turns out to be problematic as I want to reset / change some of my columns. I could not find any information on why this is happening.

+4
source share
3 answers

I had this problem and rebooting Mysql Server helped.

I have no idea what the real problem was ...

-Ft

+2
source

I had the same problem. The reason was a change in write permissions in the /tmp .

When I ran the Describe TABLENAME; on the phpmyadmin SQL tab, she failed with the error message that she could not write to the /tmp .

So, I changed the permissions on /tmp to chmod , and the problem disappeared.

+1
source

I had the same problem when the type column contained a ű or ő character. For example, an enumeration ('műszaki', 'stb'). Other characters, such as áíóé, do not make this mistake. And, as I saw, everything was configured as UTF-8. Therefore, the solution for me was:

In phpMyAdmin verison 4.0.4, I changed Util.class.php on line 3018.

 //$displayed_type .= substr($printtype, 0, $GLOBALS['cfg']['LimitChars']); $displayed_type .= mb_substr($printtype, 0, $GLOBALS['cfg']['LimitChars']);

In the old phpMyAdmin version, I changed the line 276 tbl_structure.php.

 //$type = '<abbr title="' . $type . '">' . substr($type, 0, $GLOBALS['cfg']['LimitChars']) . '</abbr>'; $type = '<abbr title="' . $type . '">' . mb_substr($type, 0, $GLOBALS['cfg']['LimitChars']) . '</abbr>';
0
source

More articles:


All Articles