This may not be a mysql issue, but mysql is the manefestation of the problem:
Sometimes POST operation seems to loose variable contents, and the apache log
shows "302" result. Blank row is inserted into DB.
My script has a form:
<form method="post" action= "<?echo "$PHP_SELF";?>?action=<? if ($action=="mod") echo
"moded&log_id=$log_id\""; else echo "add\""; ?>>
when the post occurs, the script checks $action. If $action=="add", it does
a db insert:
if ($action == "add") {
$query = "INSERT INTO log SET
log_id = NULL, name = \"$name\", category = \"$category\", duration =
\"$duration:00\",
date = \"$date\", notes = \"$notes\", timestamp = NULL, client = \"$client\",
billable = \"$billable:00\"";
$queryResult= mysql_db_query($database, $query, $connection) or die ("Could not
execute query: $query. " . mysql_error());
SOMETIMES it works fine. SOMETIMES, a blank record (all fields are empty) gets
inserted into the
record, and the apache log shows that the POST operation returned code 302:
some.domain.com - - [08/May/2001:23:54:13 -0400] "POST /log/index.php?action=add
HTTP/1.0" 302 0
"http://www.mydomain.com/log/index.php?Example_Session=70d9b5e963be24003dcc780329b12a7b";
"Mozilla/4.76 [en] (X11; U; Linux 2.4.1-0.1.9 i686)"
After moving from a slow server to a fast server, the error occurs with increased
frequency.
Usually hitting [back] on the browser and posting again, the INSERT works correctly...
but not always.
I'm stumped.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
