php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #36014 PDO_MYSQL missing mysql_query
Submitted: 2006-01-14 21:54 UTC Modified: 2006-01-22 01:00 UTC
Votes:12
Avg. Score:4.4 ± 0.9
Reproduced:12 of 12 (100.0%)
Same Version:2 (16.7%)
Same OS:1 (8.3%)
From: FranciscSimon at yahoo dot de Assigned:
Status: No Feedback Package: PDO related
PHP Version: 5.1.2 OS: Mandriva 2006
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: FranciscSimon at yahoo dot de
New email:
PHP Version: OS:

 

 [2006-01-14 21:54 UTC] FranciscSimon at yahoo dot de
Description:
------------
Hi,

i installed first PDO with pecl install PDO. After i tried first pecl install PDO_MYSQL and it doesn't work. After that i decide to compile it manualy. during ./configure it shows me this configure: error

=>
....
configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?

compiling command was 

phpize && ./configure && make && make install

THX 

:-) 

Frank



Reproduce code:
---------------
configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-01-14 22:53 UTC] tony2001@php.net
Put your config.log somewhere and paste the URL here.
 [2006-01-16 15:13 UTC] dstloukal at post dot cz
Hello,

I had the same problem. So I tried to use

./configure --with-pdo-mysql=/path/to/your/mysql/installation
(E.G.: /usr/local/mysql)

and it is all right now.
 [2006-01-22 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2009-04-02 09:50 UTC] cocowool at gmail dot com
i also had this problem
my system is fc10 and php is 5.2.6
when i used "pecl install pdo_mysql"
the error listed below:

downloading PDO_MYSQL-1.0.2.tgz ...
Starting to download PDO_MYSQL-1.0.2.tgz (14,778 bytes)
.....done: 14,778 bytes
7 source files, building
running: phpize
Configuring for:
PHP Api Version:         20041225
Zend Module Api No:      20060613
Zend Extension Api No:   220060519
config.m4:104: warning: AC_CACHE_VAL(pdo_inc_path, ...): suspicious cache-id, must contain _cv_ to be cached
../../lib/autoconf/general.m4:1974: AC_CACHE_VAL is expanded from...
../../lib/autoconf/general.m4:1994: AC_CACHE_CHECK is expanded from...
aclocal.m4:2729: PHP_CHECK_PDO_INCLUDES is expanded from...
config.m4:104: the top level
config.m4:104: warning: AC_CACHE_VAL(pdo_inc_path, ...): suspicious cache-id, must contain _cv_ to be cached
../../lib/autoconf/general.m4:1974: AC_CACHE_VAL is expanded from...
../../lib/autoconf/general.m4:1994: AC_CACHE_CHECK is expanded from...
aclocal.m4:2729: PHP_CHECK_PDO_INCLUDES is expanded from...
config.m4:104: the top level
building in /var/tmp/pear-build-root/PDO_MYSQL-1.0.2
running: /var/tmp/PDO_MYSQL/configure
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for a sed that does not truncate output... /bin/sed
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking whether gcc and cc understand -c and -o together... yes
checking for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for PHP prefix... /usr
checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib
checking for PHP extension directory... /usr/lib/php/modules
checking for PHP installed headers prefix... /usr/include/php
checking for re2c... no
configure: WARNING: You will need re2c 0.12.0 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?
ERROR: `/var/tmp/PDO_MYSQL/configure' failed

anyone can help

thanks
 [2010-10-02 19:59 UTC] casualbabies at yahoo dot co dot jp
Hi.

I had this problem that error messeges
"ERROR: `/var/tmp/PDO_MYSQL/configure' failed" when installing pdo_mysql.

But i resolved this problem

that reason why this masseges appear is you don't install php-mysql.

if you install php-mysql by "yum -y install php-mysql", you will already have 
install pdo and pdo-mysql

you don't need to use "pecl install pdo_mysql".

then you should insert to php.ini
"extension=pdo.so"
"extension=pdo-mysql.so"

you can work pdo.

Have a fun!!
 [2011-01-21 22:45 UTC] aleksey000 at hotmail dot com
Had the same problem, which also caused "Couldn't locate driver named mysql" when 
running doctrine:insert-sql in symfony. yum -y install php-mysql as per prev post 
resolved the issue. Thank you!

Fedora 14
PHP 5.3.4
 [2019-06-06 08:44 UTC] 1120238065 at qq dot com
Hi,

i have the same problem 

anyone can help me
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Fri May 09 21:01:27 2025 UTC