From: Roland Häder <roland@mxchange.org>
Date: Thu, 15 Sep 2011 15:44:42 +0000 (+0000)
Subject: userid shall be NULL by default everywhere possible
X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=4fb2297b159dc4ccbd63139e9e03a67a743aec38

userid shall be NULL by default everywhere possible
---

diff --git a/inc/db/lib-mysql3.php b/inc/db/lib-mysql3.php
index c336929905..1f4fb3cdbd 100644
--- a/inc/db/lib-mysql3.php
+++ b/inc/db/lib-mysql3.php
@@ -90,8 +90,7 @@ function SQL_QUERY ($sqlString, $F, $L, $enableCodes = true) {
 	// Run SQL command
 	//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'F=' . basename($F) . ',L=' . $L . ',sql=' . $GLOBALS['last_sql']);
 	$result = mysql_query($GLOBALS['last_sql'], SQL_GET_LINK())
-		or debug_report_bug($F, $L, 'file='. basename($F) . ',line=' . $L . ':mysql_error()=' . mysql_error() . "\n".
-'Query string:' . $GLOBALS['last_sql']);
+		or debug_report_bug($F, $L, 'file='. basename($F) . ',line=' . $L . ':mysql_error()=' . mysql_error() . ',last_query=' . $GLOBALS['last_sql']);
 	//* DEBUG: */ logDebugMessage($F, $L, 'sql=' . $GLOBALS['last_sql'] . ',affected=' . SQL_AFFECTEDROWS() . ',numRows='.(is_resource($result) ? SQL_NUMROWS($result) : gettype($result)));
 
 	// Calculate query time
diff --git a/install/tables.sql b/install/tables.sql
index 9a177b93d3..ee3a53a11e 100644
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -175,7 +175,7 @@ DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_task_system`;
 CREATE TABLE `{?_MYSQL_PREFIX?}_task_system` (
   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
   `assigned_admin` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-  `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+  `userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
   `status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW',
   `task_type` VARCHAR(255)  NOT NULL DEFAULT 'FIRST_USER',
   `subject` VARCHAR(255) NOT NULL DEFAULT '',