X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffix_refsystem.php;h=44547a191836cc7a9703e243fbeb3b4b1a2913cc;hb=cc6cc0c81d1a270dd2ae94f98e18e3b2bfe51133;hp=31bbf1d420d76955b8ec2768731979be5702bf08;hpb=20741b93fd58620af677a7f1039ffd16ea6ec689;p=mailer.git

diff --git a/inc/fix_refsystem.php b/inc/fix_refsystem.php
index 31bbf1d420..44547a1918 100644
--- a/inc/fix_refsystem.php
+++ b/inc/fix_refsystem.php
@@ -50,7 +50,7 @@ if (!SQL_HASZERONUMS($result)) {
 	SQL_QUERY('UPDATE `{?_MYSQL_PREFIX?}_refsystem` SET `level`=`level`+1', __FILE__, __LINE__);
 
 	// Add it again
-	SQL_ALTER_TABLE('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE `userid_level` (`userid`,`level`)', __FILE__, __LINE__);
+	SQL_ALTER_TABLE('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE INDEX `userid_level` (`userid`,`level`)', __FILE__, __LINE__);
 
 	// Rebuild cache
 	rebuildCache('refsystem', 'refsystem');
@@ -78,7 +78,7 @@ if (!SQL_HASZERONUMS($result_direct)) {
 	while ($content = SQL_FETCHARRAY($result_direct)) {
 		// Update refback table
 		//* DEBUG: */ debugOutput('userid=' . $content['userid']);
-		updateReferalTable($content['userid']);
+		updateReferralTable($content['userid']);
 	} // END - while
 } // END - if