CODEWITHSUNDEEP
phpphpmyadmin
nashsclay
nashsclay

Reputation: 3

phpmyadmin - browse table option grayed out but browse distinct values shows table data

I'm making a website using php and using phpmyadmin manage mysql data. For some reason some of my tables as the "Browse" tab disabled. The table has data due to showing it on my website and when I insert a new record, I can browse the table usually for about an hour or so with the old insterts appearing as well with the new entry. Then it's grayed out again. I have another table that is working well though. Also not that when you select the table you want to manage then select "Browse Distinct Values", you can see the table data for that id. Any thoughts on this? I'm using iPage as a host which it's my first time with them. Thanks

Upvotes: 0

Views: 1145

Answers (3)

Christiam Mendoza
Christiam Mendoza

Reputation: 1

Go to the "Operations" tab and in the bottom you will find the maintenance options. Try "check table" and then the "defragmenting" option. The defragmenting worked for me after check table showed no errors.

Upvotes: 0

Isaac Bennetch
Isaac Bennetch

Reputation: 12462

I suggest upgrading your phpMyAdmin installation. 2.8.0 is approximately 10 years old and there are a host of reasons why it might not be working properly, but aren't really worth trying to figure out why until you try an updated version (if you really like 2.8.0, for some reason, just install a newer version in a different folder to test). It could be that a PHP function is deprecated, or changed the output order; it could be that MySQL changed something or the library that allows PHP and MySQL to communicate had a bug. That version of phpMyAdmin may have had a bug (although nothing like this sounds familiar). I'm surprised it even works with a modern MySQL installation; I would have thought the table structure and authentication plugin changes in MySQL would have left version 2 unable to even load from a modern MySQL server.

I have no idea what the problem actually is, but I think the first step toward resolving it is to indeed update your phpMyAdmin.

Upvotes: 1

tashworth19191
tashworth19191

Reputation: 27

Click the icon to the left of the table to open the list of columns, select all columns, and click "Browse" next to the text "with selected". Then, click the edit button in the sql code at the top of the page, and paste:

SELECT * FROM TABLE_NAME ORDER BY COLUMN_NAME DESC

This will make the default browse view for that table sort the table by COLUMN_NAME in descending order, overwriting the corrupt default sort.

Upvotes: 0

Related Questions