unable to reproduce & not enough information

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"...

> 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.