0 Replies Latest reply: Aug 1, 2009 11:21 PM by Mike_Watt RSS

    Strange file upload/MySQL issue

    Mike_Watt Community Member

      This one is a tough one - for me, at least.

      I have a page that has 12 file upload fields along with 12 text fields (for short descriptions).  I also have, at the top, three drop downs that set the file paths (one of these three is "account_id").  All of these fields are also inserted into a table at the time of upload.

      The upload script (uploader.php) also has a hidden form on it which passes all of the $_POST data to the table for record insertion.

      Here's my issue.

       

      During testing, when I put a description and file to upload in the first 10 of the 12 (and leave off the last 2) everything works as expected.  If I do the opposite, and leave off the first 10 and only use the last 2, also, as expected.  But, when I do all 12, I get "account_id cannot be null" from the DB.  The account ID is set in the form, and works when doing the first 10, or the last 2, and only kicks back this error when trying to do all 12 at once.

      What could be causing this?? Any ideas?