Index: branches/5.1.x/core/units/helpers/language_import_helper.php
===================================================================
diff -u -N -r12657 -r13086
--- branches/5.1.x/core/units/helpers/language_import_helper.php	(.../language_import_helper.php)	(revision 12657)
+++ branches/5.1.x/core/units/helpers/language_import_helper.php	(.../language_import_helper.php)	(revision 13086)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: language_import_helper.php 12591 2009-09-22 20:58:35Z alex $
+* @version	$Id: language_import_helper.php 13086 2010-01-12 19:47:40Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -9,7 +9,7 @@
 * the GNU General Public License, and as distributed it includes
 * or is derivative of works licensed under the GNU General Public License
 * or other free or open source software licenses.
-* See http://www.in-portal.net/license/ for copyright notices and details.
+* See http://www.in-portal.org/license for copyright notices and details.
 */
 
 	defined('FULL_PATH') or die('restricted access!');
@@ -207,9 +207,13 @@
 				}
 
 				// email events
-				if( in_array('In-Portal',$module_ids) ) unset( $module_ids[array_search('',$module_ids)] ); // for old language packs
-				$module_sql = preg_replace('/(.*) OR $/', '\\1', preg_replace('/(.*),/U', 'INSTR(Module,\'\\1\') OR ', implode(',', $module_ids).',' ) );
+				if ( in_array('In-Portal',$module_ids) ) {
+					unset( $module_ids[array_search('',$module_ids)] ); // for old language packs
+				}
 
+				$module_sql = preg_replace('/(.*),/U', 'INSTR(Module,\'\\1\') OR ', implode(',', $module_ids).',');
+				$module_sql = substr($module_sql, 0, -4);
+
 				$sql = 'SELECT EventId FROM '.$mainevents_table.' WHERE '.$module_sql;
 				$event_ids = $this->Conn->GetCol($sql);
 
@@ -384,7 +388,7 @@
 				$sql = 'CREATE TABLE %s SELECT * FROM %s WHERE 0';
 				$this->Conn->Query( sprintf($sql, $temp_table, $table) );
 
-				$sql = 'ALTER TABLE %1$s CHANGE %2$s %2$s INT(11) NOT NULL';
+				$sql = 'ALTER TABLE %1$s CHANGE %2$s %2$s INT(11) NOT NULL DEFAULT "0"';
 				$this->Conn->Query( sprintf($sql, $temp_table, $idfield) );
 			}