ID: 12029 Comment by: sietzepost at streetwisedd dot nl 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:
Please read Bug #16906, wich is a follow up. The problem is not PHP-related, but a MySQL table/key corruption. Running myisamchk should resolve it. Previous Comments: ------------------------------------------------------------------------ [2003-10-03 04:27:38] sietzepost at streetwisedd dot nl I have the same problem. The strange thing is, I have PHP Version 4.3.3, compiled by gentoo portage. It worked fone for a couple of days, and now, out of the blue, is generates these same errors. I have plenty of dispace however, and have had plenty all the time. Does anyone have another solution? ------------------------------------------------------------------------ [2003-04-01 03:24:30] nick at nickjoyce dot com 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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