Those are some weird errors. Wow.
I'm fresh out of solutions. Let me do a bit of poking around...
In the meantime, look at and prepare yourself for a possible file-size limit :o
[Resolved] Images/Pictures Stored in MySQL Database Getting Cut Off
Alright, by the way, thanks a lot for all your help... you're totally awesome.
I'm interested to see the raw query we're submitting to the SQL server.
Do this for me... on that same script we edited earlier, circa line
36 (after a call to mysql_query(); ) ADD the following code:
$fp = fopen('c:/mytest.txt', 'wb');
fwrite($fp, $query);
fclose($fp);Then, attach 'c:\mytest.txt' to your post.
(edited)
Can you paste the source of the code we've been editing? The function isn't doing it's job!
Yes, of course. Here is the source. 
<?php
include "C:\Program Files\Apache Group\Apache\conf\Connect.php";
set_time_limit(1000);
if($Name1==Null || $EmailAddress==Null || $Name2==Null || $City==Null)
{
header('Location: http://mydomain.com/KSBY/index.php?Error=Yes');
}
if($_FILES['File']['size']<1)
{
header('Location: http://mydomain.com/KSBY/index.php?Error=Yes');
}
else
{
$FileName=$_FILES['File']['name'];
$TempName=$_FILES['File']['tmp_name'];
$FileSize=$_FILES['File']['size'];
$FileType=$_FILES['File']['type'];
$ftp=fopen($TempName, 'r');
$Content=fread($ftp, filesize($TempName));
$Content=mysql_real_escape_string($Content);
fclose($ftp);
if(!get_magic_quotes_gpc())
{
$FileName=addslashes($FileName);
}
mysql_select_db("ksbytv");
$Query="INSERT INTO halloweenpictures (Number, Name1, EmailAddress, Name2, City, PronunciationGuide, Comments, FileName, Type, Size, Content, Status1, Status2, Option1, Option2, Option3, Option4, Option5) VALUES (NULL, '$Name1', '$EmailAddress', '$Name2', '$City', '$PronunciationGuide', '$Comments', '$FileName', '$FileType', '$FileSize', '$Content', 'New', 'New', NULL, NULL, NULL, NULL, NULL)";
mysql_query($Query);
$fp=fopen('c:/mytest.txt', 'wb');
fwrite($fp, $Query);
fclose($fp);
$Header="From: [email]halloweenpics@ksby.com[/email]\r\n";
mail($EmailAddress, "Submission Confirmation", "$Name1,\nThank you for submitting your Halloween picture to KSBY, the Central Coast's local news leader. Watch Action News, weekdays from 6-7 p.m. starting October 20th, for Halloween pictures from your community.\n\nTo purchase a VHS or DVD copy of your child's Halloween picture on-air, please call (805) 541-6666 extension 601.", $Header);
move_uploaded_file ("$TempName", "C:\Program Files\Apache Group\Apache\htdocs\KSBY\Upload\$FileName");
header("Location: [url]http://mydomain.com/KSBY/Confirmation.php?EmailAddress=[/url]$EmailAddress");}
?>
Do you have magic_quotes_gpc enabled?
If so, change:
$Content=mysql_real_escape_string($Content); to:
$Content=stripslashes($Content);
$Content=mysql_real_escape_string($Content); Yes, I have that on. I tried adding that one line of code. But it didn't quite do it. The record still doesn't show up in the database.
You're turning out to be quite a hard case.
Another thing that's got me curious: chunking.
You said smaller files uploaded just fine?
First, let's try this. Change this:
$ftp=fopen($TempName, 'r');to this:
$ftp=fopen($TempName, 'rb');Sorry. I wish it were an easy fix too. I added the "b" and the record still does not show up in the database.
:glare: @ your SQL server.
Alrighty then, let's try a different approach.
Change:
$ftp=fopen($TempName, 'rb');
$Content=fread($ftp, filesize($TempName));
$Content=addslashes($Content);
fclose($ftp);to this:
$Content = addslashes(fread(fopen($TempName, "r"), filesize($TempName)));EDIT: After you make that change and test it, if it still fails, add the binary 'b' flag to the fopen() and test again.
ALSO: After you make this change and if it still doesn't work, try uploading a smaller file (one that has worked before) and make sure it still works!
I tried it with the change.... and it didn't go into the database.
I tried it with the change and the b for binary, and it didn't go into the database. Both of the above were with the large 1,500 kb file.
I tried it with the <1000kb file, and it worked.
OK, so it's not 100% broken yet. That's good.
I'm going to try that other approach I didn't like previously:
Change:
$Content = addslashes(fread(fopen($TempName, "r"), filesize($TempName)));to this:
$Content = base64_encode(fread(fopen($TempName, 'r'), $FileSize));and give her a go.
I tried it... $Content = base64_encode(fread(fopen($TempName, 'r'), $FileSize));
However, the record does not appear in the database.
Here's the last couple lines of the MySQL error doc....
#define ER_TOO_MUCH_AUTO_TIMESTAMP_COLS 1293
"Incorrect table definition; There can only be one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"
#define ER_INVALID_ON_UPDATE 1294
"Invalid ON UPDATE clause for '%-.64s' field",
#define ER_UNSUPPORTED_PS 1295
"This command is not supported in the prepared statement protocol yet",
Remember that code I had you add so that it print's $query to a file?
Can you re-add that code again now, using the new method, and give me a link to the file?
(edited)
It's getting late here. I'm tired. You must be too. So I'm going to go to bed. Thanks for all your help again.
Yeah, I'm a bit tired. Should be doing my homework, teehee.
I'm gonna post another solution. Try it whenever you have time and get back to me on it.
sigh I know it said it would make it a bit larger when encoded.. but DANG.
Ok, so I've exhausted all possibilities.... except one. Chunking. Splitting up a file larger than 1000kb and sending it to MySQL in chunks of.. 500kb to be safe. Let's try that.
NOTE: Before making the following change, I ASSUMED that the "Number" field was type AUTO_INCREMENT. If this is INCORRECT, do NOT attempt the following change, and notify me.
Change:
$Content = base64_encode(fread(fopen($TempName, 'r'), $FileSize)); to:
$ftp=fopen($TempName, 'r');
$content = stripslashes(fread($ftp, 1024*500));
$Query="INSERT INTO halloweenpictures (Number, Name1, EmailAddress, Name2, City, PronunciationGuide, Comments, FileName, Type, Size, Content, Status1, Status2, Option1, Option2, Option3, Option4, Option5) VALUES (NULL, '$Name1', '$EmailAddress', '$Name2', '$City', '$PronunciationGuide', '$Comments', '$FileName', '$FileType', '$FileSize', '" . mysql_real_escape_string($Content) . "', 'New', 'New', NULL, NULL, NULL, NULL, NULL)";
mysql_query($Query);
while(!feof($ftp)) {
$content = stripslashes(fread($ftp, 1024*500));
$query = "UPDATE halloweenpictures SET Content = CONCAT(Content, '" . mysql_real_escape_string($Content) . "') WHERE Number=last_insert_id() AND Name1='$Name1' AND EmailAddress='$EmailAddress' LIMIT 1";
mysql_query($Query);
}
fclose($ftp);EDIT: Once again, if this does not work, try adding the binary 'b' flag.
EDIT2: Wewt! Post #200, right here baby 
Well.... the new code made the file upload into different chunks as seperate database entries (rows). I'm a little confused about how I'm supposed to bring the information back together though. My pictures are all broken links now.