TYPO3 Core

Without the DBAL the error is gone
so it seems to be an error with the DBAL

Are you using MySQL5?
Maybe the SQL Query fails because of the sql-mode selected for the server. MySQL5 sets very high standars especially for insert querys. You can try to add the line sql-mode=MYSQL4 in your my.ini and try again.

no i use MySQL 4.1.12

This happens because media TSconfig have NULL string values in /var/www/html/TYPO3core/typo3/sysext/dbal/class.ux_t3lib_db.php on line 742

The error comes from
function INSERTquery.

Here a null is written for 'B' blob fields which have the database constraint NOT NULL.
....
if($this->sql_field_metatype($table,$k) == 'B') {
$nArr[$this->quoteFieldNames($k)] = 'null';
$blobfields[$this->quoteFieldNames($k)] = $v;
}
---------
Array (3) media
String (4) type blob
String (1) metaType B
Integer notnull 0

Array (3) TSconfig
String (4) type blob
String (1) metaType B
Integer notnull 0

The blob handling was flawed in the sense that it should be skipped for the "native" handler, bit did that only halfway.

In fact it seems as if for "native" the real data never was written for any blob field, which is of course bad. :)

I fixed that and will committ to CVS as soon as it is up again and the RC3 changes have been merged back by Mr. Stucki.

Should be fixed according to Karsten / didn't check.