Index: trunk/core/kernel/utility/unit_config_reader.php
===================================================================
diff -u -r7635 -r7855
--- trunk/core/kernel/utility/unit_config_reader.php	(.../unit_config_reader.php)	(revision 7635)
+++ trunk/core/kernel/utility/unit_config_reader.php	(.../unit_config_reader.php)	(revision 7855)
@@ -350,40 +350,81 @@
 			$this->Application->ReplacementTemplates = array_merge_recursive2($this->Application->ReplacementTemplates, $config['ReplacementTemplates']);
 		}
 
-		if ( $this->Application->isDebugMode() && constOn('DBG_VALIDATE_CONFIGS') && isset($config['TableName']) )
-		{
-			global $debugger;
-			$tablename = $config['TableName'];
+		if ( $this->Application->isDebugMode(false) && constOn('DBG_VALIDATE_CONFIGS') && isset($config['TableName']) ) {
+			$this->ValidateConfig($prefix);
+		}
+	}
 
-			$conn =& $this->Application->GetADODBConnection();
-			$res = $conn->Query("DESCRIBE $tablename");
-
-			foreach ($res as $field) {
-				$f_name = $field['Field'];
-				if (getArrayValue($config, 'Fields')) {
-					if ( !array_key_exists ($f_name, $config['Fields']) ) {
-						$debugger->appendHTML("<b class='debug_error'>Config Warning: </b>Field $f_name exists in the database, but is not defined in config file for prefix <b>".$config['Prefix']."</b>!");
-						safeDefine('DBG_RAISE_ON_WARNINGS', 1);
-					}
-					else {
-						$options = $config['Fields'][$f_name];
-						if ($field['Null'] == '') {
-							if ( $f_name != $config['IDField'] && !isset($options['not_null']) && !isset($options['required']) ) {
-								$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Field $f_name in config for prefix <b>".$config['Prefix']."</b> is NOT NULL in the database, but is not configured as not_null or required!");
-								safeDefine('DBG_RAISE_ON_WARNINGS', 1);
-							}
-							if ( isset($options['not_null']) && !isset($options['default']) ) {
-								$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Field $f_name in config for prefix <b>".$config['Prefix']."</b> is described as NOT NULL, but does not have DEFAULT value!");
-								safeDefine('DBG_RAISE_ON_WARNINGS', 1);
-							}
+	function ValidateConfig($prefix)
+	{
+		global $debugger;
+		
+		$config =& $this->configData[$prefix];
+		
+		$tablename = $config['TableName'];
+		$float_types = Array ('float', 'double', 'numeric');
+		$conn =& $this->Application->GetADODBConnection();
+		
+		$table_found = $conn->Query('SHOW TABLES LIKE "'.$tablename.'"');
+		if (!$table_found) {
+			// config present, but table missing, strange
+			$debugger->appendHTML("<b class='debug_error'>Config Warning: </b>Table <strong>$tablename</strong> missing, but prefix <b>".$config['Prefix']."</b> requires it!");
+			safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+			return ;
+		}
+		
+		$res = $conn->Query("DESCRIBE $tablename");
+		
+		$config_link = $debugger->getFileLink(FULL_PATH.$this->prefixFiles[$config['Prefix']], 1, $config['Prefix']);
+				
+		foreach ($res as $field) {
+			$f_name = $field['Field'];
+			if (getArrayValue($config, 'Fields')) {
+				if (preg_match('/l[\d]+_[\w]/', $f_name)) {
+					// skip multilingual fields
+					continue;
+				}
+				
+				if (!array_key_exists ($f_name, $config['Fields'])) {
+					$debugger->appendHTML("<b class='debug_error'>Config Warning: </b>Field <strong>$f_name</strong> exists in the database, but is not defined in config file for prefix <b>".$config_link."</b> !");
+					safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+				}
+				else {
+					$options = $config['Fields'][$f_name];
+					if ($field['Null'] != 'YES') {
+						// MySQL5 for null returns "NO", but MySQL4 returns ""
+						if ( $f_name != $config['IDField'] && !isset($options['not_null']) && !isset($options['required']) ) {
+							$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Field <strong>$f_name</strong> in config for prefix <b>".$config_link."</b> is NOT NULL in the database, but is not configured as not_null or required !");
+							safeDefine('DBG_RAISE_ON_WARNINGS', 1);
 						}
-
+						if ( isset($options['not_null']) && !isset($options['default']) ) {
+							$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Field <strong>$f_name</strong> in config for prefix <b>".$config_link."</b> is described as NOT NULL, but does not have DEFAULT value !");
+							safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+						}
+						
+						if (!isset($options['default'])) {
+							$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Default value for field <strong>$f_name</strong> in config for prefix <b>".$config_link."</b> not set !");
+							safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+						}
+						elseif ($f_name == $config['IDField'] && $options['default'] !== 0) {
+							$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Default value for field <span class='debug_error'>IDField</span> <strong>$f_name</strong> (".var_export($options['default'], true).") in config for prefix <b>".$config_link."</b> differs from default value from field in database (".var_export($field['Default'], true).") !");
+							safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+						}
+						else if ($options['default'] != '#NOW#' && $field['Default'] !== (string)$options['default'] && !in_array($options['type'], $float_types)) {
+							$debugger->appendHTML("<b class='debug_error'>Config Error: </b>Default value for field <strong>$f_name</strong> (".var_export($options['default'], true).") in config for prefix <b>".$config_link."</b> differs from default value from field in database (".var_export($field['Default'], true).") !");
+//							$debugger->dumpVars($field['Default'], $options['default'], 'STRICT');
+							safeDefine('DBG_RAISE_ON_WARNINGS', 1);
+						}
+						
+						// check that all idfields have default values & are not_null!!!
 					}
+
 				}
 			}
 		}
+		
 	}
-
+	
 	function ProcessDependencies($prefix)
 	{
 		$config =& $this->configData[$prefix];