Bug #12048 select doesnt work at all!!!!!!!!!1
Submitted: 20 Jul 2005 8:30 Modified: 20 Jul 2005 11:00
Reporter: Waseem ahmed Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:4.0.23-standard-log OS:HP/UX (HP Ux)
Assigned to: CPU Architecture:Any

[20 Jul 2005 8:30] Waseem ahmed
Description:
Hi ,

I tried to execute the query below mentioned query from php page which took a long time. So i went on to the server and tried to retreive the data manually then i dont know what happened but after pressing enter it went to the next line and it stood there although there are no more than 13000 records even after 5 mins it didnt show the values. so i hit  ctrl+c to exit now i try to retreive data from different mysql db where it is the same case. Do you know why this happened?

$conn=@mysql_connect( "localhost", "$qaft_db" ,"$qaft_pass" ) or die ("Err:Conn");
$rs= @mysql_select_db ("$qaft_db", $conn) or die ("Err:Db");
$sql_mod="select * from  Qaft_Feedback_Mstr where Qaft_Wfm_Login_Name = '$Uid' and Qaft_flag ='Y'";
$rs_modified=mysql_query( $sql_mod, $conn ) or die ("Could not fetch the list from The master table");

select * from  Qaft_Feedback_Mstr where Qaft_Wfm_Login_Name = '$Uid' and Qaft_flag ='Y' 

Thanks for your help.

Regards,
Waseem

How to repeat:
I am not sure but you could try the same method which i have mentioned above
[20 Jul 2005 11:00] Jon Stephens
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

This appears to have nothing to do with MySQL Query Browser, it seems more a request for free application debugging services.

User should seek help through http://forums.mysql.com/ or one of the mailing lists.

A good first step would be to remove the @ error suppression operators from the PHP API calls, which would make it possible to observe error messages.
[20 Jul 2005 11:42] Waseem ahmed
No it is not usage issue. i have already used this installation many times untill this morning. but it failed now