X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fdb%2Flib-mysqli.php;h=56f104cf367dd75fc9a8d851434667339434a92c;hb=e59756ab2e96bba0f3a0cbd2fac98d30d9224071;hp=29c49158e4ad982588a13c36f94a54cc8d63b183;hpb=1c97695e49963bda92fcb368fab7241c16137bd1;p=mailer.git

diff --git a/inc/db/lib-mysqli.php b/inc/db/lib-mysqli.php
index 29c49158e4..56f104cf36 100644
--- a/inc/db/lib-mysqli.php
+++ b/inc/db/lib-mysqli.php
@@ -69,7 +69,9 @@ function sqlQuery ($sqlString, $file, $line, $enableCodes = TRUE) {
 		$sqlStringModified = str_replace(array(chr(9), PHP_EOL, chr(13)), array(' ', ' ', ' '), $sqlStringModified);
 
 		// Compile config entries out
+		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'sqlStringModified=' . $sqlStringModified . ',enableCodes=' . intval($enableCodes));
 		$sqlStringModified = sqlPrepareQueryString($sqlStringModified, $enableCodes);
+		//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'sqlStringModified=' . $sqlStringModified . ',enableCodes=' . intval($enableCodes));
 
 		// Cache it and remember as last SQL query
 		$GLOBALS[__FUNCTION__][$sqlString] = $sqlStringModified;
@@ -216,6 +218,9 @@ function sqlConnectToDatabase ($host, $login, $password, $file, $line) {
 	`character_set_connection`='utf8',
 	`character_set_database`='utf8',
 	`character_set_server`='utf8'", $file . ':' . __FUNCTION__, $line . ':' . __LINE__);
+
+		// Disallow subtraction for unsigned columns
+		sqlQuery("SET `sql_mode`='NO_UNSIGNED_SUBTRACTION'", $file . ':' . __FUNCTION__, $line . ':' . __LINE__);
 	} // END - if
 
 	// Any errors encountered?