[Mon May 07 22:14:18 2012] [error] [client 2.27.92.5] 
 
PHP Fatal error:  Uncaught exception 'ADODB_Exception' with message 'mysql error: 
 
   [1048: Column 'fsDisplayOrder' cannot be null] in 
      EXECUTE(
         "INSERT INTO FileSetFiles(fsfID,fID,fsID,timestamp,fsDisplayOrder) 
          VALUES (NULL,'348','24',NULL,NULL)"
      )\n' 
 
in /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78\n
 
 
Stack trace:\n
 
#0 /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): 
 
   adodb_throw('mysql', 'EXECUTE', 1048, 'Column 'fsDispl...', 'INSERT INTO Fil...', false, Object(ADODB_mysql))\n
 
This is the error-handling explicit in the _Execute() function for the condition 
that the query failed.
 
 
#1 /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): 
 
   ADOConnection->_Execute('INSERT INTO Fil...')\n
 
This is the call from the function Execute() to the function _Execute() to 
attempt the query.
 
 
#2 /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(747): 
 
   ADOConnection->Execute('INSERT INTO Fil...', Array)\n
 
This is the call from the function Insert() to the function Execute() after the 
INSERT statement is composed.
 
 
#3 /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(711): 
 
   ADODB_Active_Record->Insert()\n
 
This is the call from the Save() function to the Insert() function; call is 
made for the case that the entry is new, i.e., do INSERT, not UPDATE, when 
saving new.
 
 
#4 /var/www/v in /var/www/vhosts/birdandbee.co.uk/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78, referer:http://www.birdandbee.co.uk/index.php/dashboard/files/search/...
 
This is the explicit {throw} from the function adodb_throw() invoked from 
the _Execute() function at #0.
 
 
Hence, the error is introduced by the function Insert() at #2. The function is:
 
[717]      // false on error
[718]      function Insert()
[719]      {
[720]         $db = $this->DB(); if (!$db) return false;
[721]         $cnt = 0;
[722]         $table = $this->TableInfo();
[723]      
[724]         $valarr = array();
[725]         $names = array();
[726]         $valstr = array();
[727]
 
The error results from the steps that begin at [738], where the empty values 
are set to NULL. However, this follows from the fact that the needed value for 
the column {fsDisplayOrder} is empty in the first place. Again, the reported 
error from the {throw} was:
 
   [1048: Column 'fsDisplayOrder' cannot be null] in 
      EXECUTE(
         "INSERT INTO FileSetFiles(fsfID,fID,fsID,timestamp,fsDisplayOrder) 
          VALUES (NULL,'348','24',NULL,NULL)"
      )\n' 
 
The resolution relies on understanding the nature of the datum from which the 
value for the {fsDisplayOrder} column is to be derived. Is there any input 
field in the form on the C5 interface that appears to correspond to this?
 
This is the beginning of the problem block. 
[728]         foreach($table->flds as $name=>$fld) {
[729]            $val = $this->$name;
[730]            if(!is_array($val) || !is_null($val) || !array_key_exists($name, $table->keys)) {
[731]               $valarr[] = $val;
[732]               $names[] = $this->_QName($name,$db);
[733]               $valstr[] = $db->Param($cnt);
[734]               $cnt += 1;
[735]            }
[736]         }
[737]      
[738]         if (empty($names)){
[739]            foreach($table->flds as $name=>$fld) {
[740]               $valarr[] = null;
[741]               $names[] = $name;
[742]               $valstr[] = $db->Param($cnt);
[743]               $cnt += 1;
[744]            }
This is the end of the problem block.
 
[745]         }
[746]         $sql = 'INSERT INTO '.$this->_table."(".implode(',',$names).') VALUES ('.implode(',',$valstr).')';
[747]         $ok = $db->Execute($sql,$valarr);
[748]      
[749]         if ($ok) {
[750]            $this->_saved = true;
[751]            $autoinc = false;
[752]            foreach($table->keys as $k) {
[753]               if (is_null($this->$k)) {
[754]                  $autoinc = true;
[755]                  break;
[756]               }
[757]            }
[758]            if ($autoinc && sizeof($table->keys) == 1) {
[759]               $k = reset($table->keys);
[760]               $this->$k = $this->LastInsertID($db,$k);
[761]            }
[762]         }
[763]      
[764]         $this->_original = $valarr;
[765]         return !empty($ok);
[766]      }