[Mo123]

Quote:

Originally Posted by azzerking Listen to what I am saying. The columns already exist, and your trying to create them again, but mysql will error and say that they already. You can't create something that already exists. Find the line of where these queries are being called and comment them out. You only ever need to run this queries once, when you start fresh or like you said have moved.

OnQueryError: errorid: 1060, error: Duplicate column name 'LogUnix', callback: , query: ALTER TABLE `players` ADD `LogUnix` INT NOT NULL DEFAULT '0';, connectionHandle: 1


17413 > PlayerInfo[playerid][pLastLogoutUnix] = cache_get_field_content_int(0, "LogUnix");

24441 > mysql_format(sqlGameConnection, query, sizeof(query), "%s`HelperReports` = %d, `SpawnPos` = %d, `LogUnix` = %d",

92191 > mysql_tquery(sqlGameConnection, "ALTER TABLE `players` ADD `LogUnix` INT NOT NULL DEFAULT '0';");

//


OnQueryError: errorid: 1060, error: Duplicate column name 'HelperReports', callback: , query: ALTER TABLE `players` ADD `HelperReports` INT NOT NULL DEFAULT '0';, connectionHandle: 1


24442 > mysql_format(sqlGameConnection, query, sizeof(query), "%s`HelperReports` = %d, `SpawnPos` = %d, `LogUnix` = %d",
query, PlayerInfo[playerid][pHelperReports], PlayerInfo[playerid][pSpawnPos], PlayerInfo[playerid][pLastLogoutUnix]);


33084 > mysql_format(sqlGameConnection, query, sizeof(query), "SELECT `Name`, `LastLogin`, `HelperReports` FROM `players` WHERE `Adjustable`=1 AND `HelperLevel` > 0");

92193 > mysql_tquery(sqlGameConnection, "ALTER TABLE `players` ADD `HelperReports` INT NOT NULL DEFAULT '0';");