Bug #7151 Updated: phpMyAdmin causes crash of php.exe

ID: 7151 Updated by: msopacua@idg.nl Reported By: sbergmann@php.net Status: Closed Bug Type: Reproducible Crash Operating System: Windows 2000 PHP Version: 4.0 Latest CVS (12/10/2000) New Comment: > A second problem: If I browse through a table, click an entry, alter > some field contents and then click "OK" to confirm the changes, the > message "This URL can not be found on this server" is displayed; but if > I then re-display the table, the altered data although has changed. > But why the heck then is this message showed???? This problem is not platform specific. It depends on the number of fields in the table - the query string is too long and therefore php reports the file not being found. [Sat Apr 6 15:41:35 2002] [error] PHP Warning: stat failed for ./sql.php?lang=en&server=1&db=mydb&table=mytable&pos=0&sql_query=SELECT+%60id%60%2C%60titel%60%2C%60auteurid%60%2C%60auteur_dn%60%2C%60synopsis%60%2C%60intro%60%2C%60creationtime%60%2C%60lastmod%60%2C%60pubtime%60%2C%60published%60%2C%60updated%60%2C%60react_status%60%2C%60metadata%60%2C%60head%60%2C%60body%60%2C%60resourcepack%60+FROM+%60nieuws%60+WHERE+1+AND+%60id%60+%3D+10049 (errno=63 - File name too long) in /my/dir/phpMyAdmin-2.2.1/tbl_replace.php on line 215 It's actually lame code (line 215 of tbl_replace.php): if (file_exists('./' . $goto)) { where $goto is an url-escaped query string, tucked into a variable. I think that on windows the fstat isn't checked well enough and causes the errors - i.e. passes the file not found, directly to the webserver, which interpretes this as a 404. Previous Comments: ------------------------------------------------------------------------ [2002-04-05 12:35:15] mm@bikeracer.com In reply to http://www.phpwizard.net/phorum/read.php?f=1&i=2266&t=2266 I've got exactly the same problem using PHP3 (3.0.17), phpMyAdmin (2.2.5), Xitami (V2.4d9) and Win2k (Professional) on two Notebooks (Fujitsu C342, HP OmniBook 6100). Every time, I try to execute an SQL command entered in the box provided for this purpose by phpMyAdmin, the php.exe module crashes with an program error popping up. A second problem: If I browse through a table, click an entry, alter some field contents and then click "OK" to confirm the changes, the message "This URL can not be found on this server" is displayed; but if I then re-display the table, the altered data although has changed. But why the heck then is this message showed???? Using phpMyAdmin on a linux system works just fine and perfectly. So this seems all to be about a problem of php.exe on the windows platform(s). Any idea about this? I searched this forum and just found one "sql crashes php3"... ------------------------------------------------------------------------ [2000-10-12 05:46:54] dbeu@php.net unable to reproduce & not enough information ------------------------------------------------------------------------ [2000-10-12 04:24:05] sbergmann@php.net After hitting the "Create" button in phpMyAdmin's "Create new database" form (on the start page of phpMyAdmin) php.exe crashes. The form calls db_create.php3, but I cannot find the cause for the crash therein. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=7151&edit=1