ID: 12029 Comment by: nick at nickjoyce dot com Reported By: root at byone dot com Status: Bogus Bug Type: MySQL related Operating System: Linux PHP Version: 4.0.6 and 4.1.0RC3 New Comment:
I had the same problem but found that mysql did not have enough disk space to alter its files. Altering the quota fixed the problem. Previous Comments: ------------------------------------------------------------------------ [2002-07-09 10:24:03] levi at tamisoft dot com I found the same problem with: mysql 3.23.51 php 4.1.2 later 4.2.1 roxen I found a possible way to resolv it. Use like this: $query="INSERT INTO test.test SET str=\"a test\""; @mysql_query($query); if (mysql_error()) {echo "Some error occured!";exit();} And this way you won't get the warning. The only thing is that you cannot use the returned value itself directly, you have to use mysql_error() to see if everything went ok. PLZ let me know if it's not ok. It is working for me fine. ------------------------------------------------------------------------ [2002-01-23 10:48:20] [EMAIL PROTECTED] Apache is installed with mod_log_mysql and mod_auth-mysql, and php is installed with the built-in clients. http://www.php.net/manual/en/faq.databases.php#AEN73271 Please reopen with a url to a phpinfo() call if problem persists. ------------------------------------------------------------------------ [2002-01-23 09:29:40] [EMAIL PROTECTED] [EMAIL PROTECTED], can you post a page with phpinfo() on it somewhere so I can have a look please. I've never had any problems with mysql and pgsql co-existing with php. ------------------------------------------------------------------------ [2002-01-23 04:48:46] rami at eduix dot com I'm pretty sure these unable to save result set are due to pgsql and mysql co-existence in self-compiled php. Our service worked well without problems for 8 months with only mysql compiled in, but php started complaining this immediately when we compiled the pgsql in also. So this looks like a true bug allright. ------------------------------------------------------------------------ [2001-11-27 02:23:32] [EMAIL PROTECTED] Suspended at user request. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/12029 -- Edit this bug report at http://bugs.php.net/?id=12029&edit=1