X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_refback.php;h=fc21e4e775de87a26784d1208690ddea1e1b0c5f;hp=7d0a6b7d7b9178a891d7f3538241ddd144a09d11;hb=bd439a79803904c8f255b9b89c876825790f1bfa;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e diff --git a/inc/gen_refback.php b/inc/gen_refback.php index 7d0a6b7d7b..fc21e4e775 100644 --- a/inc/gen_refback.php +++ b/inc/gen_refback.php @@ -1,7 +1,7 @@ 0) { // Remove index temporaly SQL_ALTER_TABLE("ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` DROP INDEX `userid_level`", __FILE__, __LINE__); // Upgrade refsystem, ref-level 0 is silly here - SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_refsystem` SET level=level+1", __FILE__, __LINE__); + 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__);