Mysql Error? Was ist das wie ich krieg ich den weg.

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • [20:15:59] Error-ID: 1054 | Error: Unknown column 'Meth_Sucktfaktor' in 'field list' | Callback: | Query: UPDATE `server_user` SET `Meth_Sucktfaktor` = '9' WHERE `id` = '353963'


    Bekomme diesen Error wenn ich Drogen einnehme was ist das für einen Error wie beheb ich den?


  • if(strcmp(cmd, "/usedrugs", true) == 0){
    if(IsACop(playerid) || PlayerInfo[playerid][Team] == 6){
    SendClientMessage(playerid, COLOR_RED, "Nur für Gangs/Mafien und Zivis!");
    return 1;
    }



    new tmp22[128];
    new phonenumb;



    tmp22 = strtok(cmdtext, idx);



    if(!strlen(tmp22)) {
    SendClientMessage(playerid, COLOR_WHITE, "Benutze: /usedrugs [Drogensorte 1,2,3,4,5 oder 6]");
    return 1;
    }
    phonenumb = strval(tmp22);



    for (new i=0; i < MAX_Z_ZONAS; i++)
    {
    if(ZoneInfo[i][war] == 1)
    {
    if(isPlayerInArea19(playerid, ZoneInfo[i][zMinX],ZoneInfo[i][zMinY],ZoneInfo[i][zMaxX],ZoneInfo[i][zMaxY]))
    {
    if(ZoneInfo[i][war] == 1 && ZoneInfo[i][only_zonefight] == 0)
    {
    SendClientMessage(playerid, COLOR_RED, "In einer Kampf Zone wird nicht gehealt!");
    return 1;
    }
    }
    }
    }



    if(PlayerInfo[playerid][healpause] == 1)
    {
    SendClientMessage(playerid, COLOR_RED, "Du hast 1 min. ''Heal-Pause''");
    return 1;
    }



    if(phonenumb == 1){
    if(PlayerInfo[playerid][drogens] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }
    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 10;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Hanf benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s benutzt Hanf", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
    }
    }
    else if(phonenumb == 2){
    if(PlayerInfo[playerid][drogens1] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }
    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 15;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Cannabis benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens1] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s raucht Cannabis", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
    }
    }
    else if(phonenumb == 3){
    if(PlayerInfo[playerid][drogens2] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }



    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 22;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Whitewidow benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens2] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s benutzt Whitewidow", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
    }
    }
    else if(phonenumb == 4){
    if(PlayerInfo[playerid][drogens3] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }
    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 30;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Koks benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens3] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s schnupft 'ne Line Koks", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    if(PlayerInfo[playerid][meth_Suchtfaktor] == 0) PlayerInfo[playerid][meth_Suchtfaktor] = 3;
    PlayerInfo[playerid][meth_Suchtfaktor]+=1;
    UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
    }
    }
    else if(phonenumb == 5){
    if(PlayerInfo[playerid][drogens4] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }
    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 45;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Heroin benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens4] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s spritzt sich Heroin", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    PlayerInfo[playerid][meth_Suchtfaktor]+=2;
    UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
    }
    }
    else if(phonenumb == 6){
    if(PlayerInfo[playerid][drogens5] > 1){
    if(PlayerStoned[playerid] >= 4) {
    PlayerStoned[playerid] += 1;
    GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
    return 1;
    }
    new Float:health;
    GetPlayerHealth(playerid, health);
    new hp = 65;
    PlayerInfo[playerid][healpause] = 1;
    SetPlayerHealthk(playerid, health + hp);
    SendClientMessage(playerid, COLOR_GREY, "2 gramm Meth benutzt");
    SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
    PlayerInfo[playerid][drogens5] -= 2;
    new string348901[128];
    format(string348901, sizeof(string348901), "* %s schnupft 'ne Line Crystal Meth", PlayerName(playerid));
    ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    if(PlayerInfo[playerid][meth_Suchtfaktor] == 0) PlayerInfo[playerid][meth_Suchtfaktor] = 5;
    PlayerInfo[playerid][meth_Suchtfaktor]+=2;
    methuse[playerid]=4;
    UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
    }
    else{
    SendClientMessage(playerid, COLOR_GREY, "Du brauscht schon was, damit das ballert...");
    }
    }



    return 1;
    }

    dROGENSORTE 6 ALSO mETH