LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-20-2004, 05:04 PM   #1
brandnewbie
LQ Newbie
 
Registered: Jan 2004
Location: Virginia
Distribution: Fedora Core 2
Posts: 27

Rep: Reputation: 15
phpMyAdmin error: cannot browse tables, other functions work fine


Hi everyone,

I recently installed phpMyAdmin 2.6.0.pl1 I changed the settings in config.inc.php to point to my MySQL server and I can login to phpMyAdmin as expected. While most of the features work correctly, when I click on the 'browse' tab for a table, the screen goes blank. Now it appears from the URL (and this is just wide speculation on my part) that it is processing a SELECT query but times-out. I am able to alter the structure of the databases and tables fine, and insert data into the tables, I just can't browse the tables. When I access mysql from the command prompt, SELECT, INSERT, UPDATE, DROP, etc. commands all work as expected.

I upgraded from phpMyAdmin 2.6.0.pl1 to 2.6.0.pl3 and nothing seemed to change.

My specs:
-fedora core 2 box
-apache 2.0.51
-php4.3.9
-MySql 3.23.58

I've searched far and wide with no sucess, and now turn to the LQ community for any help you have to offer. Thanks.
 
Old 12-22-2004, 02:23 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 79
Can you run a select command from the command line client?
 
Old 12-24-2004, 07:07 AM   #3
brandnewbie
LQ Newbie
 
Registered: Jan 2004
Location: Virginia
Distribution: Fedora Core 2
Posts: 27

Original Poster
Rep: Reputation: 15
Yeah, and that's what's bizzare. All the SELECT, INSERT, DROP, etc. commands work fine from the command line, so I know that MySQL is writing to the db. Also, I can use the insert commands from phpmyadmin, i.e. I can insert data into the table through pma and select it through the command line.
 
Old 12-24-2004, 01:52 PM   #4
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 79
Sorry, I just spotted that you are still using MySQL 3 - you need to go back to using an old phpMyAdmin "2.2.7-pl1" for it to work correctly.
 
Old 01-08-2005, 05:04 PM   #5
brandnewbie
LQ Newbie
 
Registered: Jan 2004
Location: Virginia
Distribution: Fedora Core 2
Posts: 27

Original Poster
Rep: Reputation: 15
Thanks, I upgraded to mysql 4.1 and everything now works fine.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
error using phpMyAdmin funkyche Linux - Newbie 1 01-12-2005 03:55 PM
PHPMYADMIN does not work photoworks Linux - Networking 10 10-31-2004 04:06 PM
Can't browse or insert with phpMyAdmin causticmtl Linux - Software 1 07-27-2004 02:30 PM
Can't get phpmyadmin to work, php works dfuse Linux - Networking 2 12-05-2003 02:22 AM
ADSL Connection is fine, but can't browse the internet. JustOne Linux - Networking 11 07-12-2003 07:01 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:21 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration