| Bug #45968 | select * fails when select column name returns a result. | ||
|---|---|---|---|
| Submitted: | 6 Jul 2009 12:05 | Modified: | 3 Aug 2009 6:56 |
| Reporter: | Sucheta Moorty | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
| Version: | MySQL client version: 5.1.30 | OS: | Windows (XP) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | innodb, PDO, SELECT | ||
[6 Jul 2009 12:06]
Sucheta Moorty
help needed
[6 Jul 2009 12:13]
Sveta Smirnova
Thank you for the report. Please connect to MySQL server using command line client, then execute `select * from tablename` and inform us if you get error this time as well.
[7 Jul 2009 4:02]
Sucheta Moorty
Hello, I ran mysql from command line and the select * went through. BTW, I get the error in php when I use a PDO (PHP Data Objets)extension. Thanks Sucheta
[7 Jul 2009 5:49]
Sveta Smirnova
Thank you for the feedback. > I ran mysql from command line and the select * went through. > > BTW, I get the error in php when I use a PDO (PHP Data > Objets)extension. This means problem is not at MySQL side. Can be in your code or PDO/Xampp bug as well.
[3 Aug 2009 6:56]
Sucheta Moorty
Hello everybody, Similar to #46289 on PECL(php.net) PDO execute causes apache.exe to crash On PECl. Please look up this bug report for further details. Check out: Magento-forum: http://www.magentocommerce.com/boards/viewthread/31789/ The solution is simple: - Download: http://windows.php.net/downloads/snaps/php-5.2-win32-VC6-x86-latest.zip - Unzip & copy libmysql.dll into xampp\apache\bin & xampp\php. - Restart apache. I did as suggested above and my problem is solved. Thanks Sucheta
Description: hello Everybody, I am running MySQL client version: 5.1.30 which has been bundled with Xampp version 1.7. This is the web server etc details under Xampp installation * Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 * MySQL client version: 5.1.30 * PHP extension: mysql The tables are of type InnoDB. I have a query "select * from tablename" which runs fine under phpmyadmin . It fails in my php code. The error says "Appache needs to close, send error report". In reality Apache doesn't close . Also the same query "select Username from tablename" goes through as expected. Here Username is a column name. I doubt it is an xampp problem. Thank you Sucheta How to repeat: Install Xampp 1.7. 1. Create an Innodb table with some columns. 2. In PHP file, connect to database . 2. Fire "select * from tablename".