MySQL Problem

In 10 Minuten startet der nächtliche Backupvorgang! Es kann währenddessen (ca. 10 Minuten) zu Einschränkungen bei der Nutzung des Forums kommen
Weitere Infos findet ihr im Thema Backup des Forums
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
  • Guten Tag,
    Folgendes Problem:
    [17:11:53] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
    [17:11:53] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pMarried'
    [17:11:53] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Friedhof'
    [17:11:53] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1

  • Hier:
    cache_get_data(rows,fields);
    if(rows)
    {
    if(passwortstate == 1)
    {
    cache_get_field_content(0,"Passwort",result);
    new tmpp[25];
    strmid(tmpp,(pass), 0, 24, 25);
    if(!strcmp(tmpp,result,true))
    {
    format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0);
    return 1;
    }
    format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid));
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen");
    return 1;
    }
    cache_get_field_content(0,"Tutorial",result);
    Spieler[playerid][pViewTutorial] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Admin",result);
    Spieler[playerid][pAdmin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Verwarnungen",result);
    Spieler[playerid][pWarns] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FLeaderRechte",result);
    Spieler[playerid][pLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Fraktion",result);
    Spieler[playerid][pFraktion] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsRang",result);
    Spieler[playerid][pFraktRang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsURang",result);
    Spieler[playerid][pFraktURang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsSperre",result);
    Spieler[playerid][pFraktionSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsGehalt",result);
    Spieler[playerid][pFraktionsGehalt] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Job",result);
    Spieler[playerid][pJob] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"JobWarns",result);
    Spieler[playerid][JobWarns] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"JobSperre",result);
    Spieler[playerid][pJobSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ArbeitslosenGeld",result);
    Spieler[playerid][pWorkLess] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Geschlecht",result);
    Spieler[playerid][pSex] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"SpielerAlter",result);
    Spieler[playerid][pYearsOld] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Level",result);
    SetPlayerLevel(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Geld",result);
    ACMoney(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"GWD",result);
    Spieler[playerid][pGrundwehrdienst] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Zivinote",result);
    Spieler[playerid][pZiviNote] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FAbteilung",result);
    Spieler[playerid][pFraktABTInvite] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bankguthaben",result);
    Spieler[playerid][pBank] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"BankPin",result);
    Spieler[playerid][pBankPin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WantedSterne",result);
    SetPlayerWantedLevel(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WantedPunkte",result);
    Spieler[playerid][pWantedPoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Suspects",result);
    Spieler[playerid][pSuspectPoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund1",result);
    strmid(pWantedReason1[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund2",result);
    strmid(pWantedReason2[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund3",result);
    strmid(pWantedReason3[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund4",result);
    strmid(pWantedReason4[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund5",result);
    strmid(pWantedReason5[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Crimes",result);
    Spieler[playerid][pLastSuspects] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"STVOcrimes",result);
    Spieler[playerid][pSTVOpoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KampfStyle",result);
    SetPlayerFightingStyle(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handy",result);
    Spieler[playerid][pHandy] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handycoins",result);
    Spieler[playerid][pHandyCoins] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyStatus",result);
    Spieler[playerid][pHandystate] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyAkku",result);
    Spieler[playerid][pHandyakku] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyNummer",result);
    Spieler[playerid][pPhonenumber] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handyflat",result);
    Spieler[playerid][pHandyFlat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handyflatbuyinbiz",result);
    Spieler[playerid][pHandyBuyByBiz] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_X",result);
    Spieler[playerid][LastInGamePos_x] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Y",result);
    Spieler[playerid][LastInGamePos_y] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Z",result);
    Spieler[playerid][LastInGamePos_z] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Interior",result);
    Spieler[playerid][LastInGamePos_int] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_VirtualWorld",result);
    Spieler[playerid][LastInGamePos_world] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pSelectHome",result);
    Spieler[playerid][pSelectHome] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HausMieter",result);
    Spieler[playerid][pRentHome] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Spawn",result);
    Spieler[playerid][pSpawn] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Hotel",result);
    Spieler[playerid][pHotel] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tod",result);
    Spieler[playerid][pDeath] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_X",result);
    Spieler[playerid][tot_x] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Y",result);
    Spieler[playerid][tot_y] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Z",result);
    Spieler[playerid][tot_z] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Interior",result);
    Spieler[playerid][tot_int] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_VirtualWorld",result);
    Spieler[playerid][tot_world] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TotZeit",result);
    Spieler[playerid][pDeathTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Friedhof",result);
    Spieler[playerid][pFriedhof] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FriedhofZeit",result);
    Spieler[playerid][pFriedhofTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ImKnast",result);
    Spieler[playerid][pJailed] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KnastZeit",result);
    Spieler[playerid][pJailTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KnastKaution",result);
    Spieler[playerid][pKaution] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Muted",result);
    Spieler[playerid][pMuted] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"MuteZeit",result);
    Spieler[playerid][pMuteTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ImPrison",result);
    Spieler[playerid][pInPrison] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PrisonCheckPointsAbgelaufen",result);
    Spieler[playerid][pPrisonCPsgelaufen] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PrisonCheckPointsGegeben",result);
    Spieler[playerid][pPrisonCPsgegeben] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Morde",result);
    Spieler[playerid][pMorde] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tode",result);
    Spieler[playerid][pTode] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"SkinID",result);
    Spieler[playerid][pSkin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionSkinID",result);
    Spieler[playerid][pFraktSkin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallKills",result);
    Spieler[playerid][pPBKills] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallTode",result);
    Spieler[playerid][pPBDeaths] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallRang",result);
    Spieler[playerid][pPBRang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallBesuche",result);
    Spieler[playerid][pPBVisits] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"AngenommeneReports",result);
    Spieler[playerid][Reports] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KopfGeld",result);
    Spieler[playerid][pHeadMoney] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pWantedDeaths",result);
    Spieler[playerid][pWantedDeaths] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBuyTickets",result);
    Spieler[playerid][pBuyTickets] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pJailedCount",result);
    Spieler[playerid][pJailedCount] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bankkonto",result);
    Spieler[playerid][pBankkonto] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyPlaneOrder",result);
    Spieler[playerid][pArmyPlaneOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyHeliOrder",result);
    Spieler[playerid][pArmyHeliOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyWaffenOrder",result);
    Spieler[playerid][pArmyWaffenOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"LevelUPKosten",result);
    Spieler[playerid][pLevelKosten] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RespectForLevelUp",result);
    Spieler[playerid][pRespektToLevelUp] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RespectFromPayday",result);
    Spieler[playerid][pRespektFromPayday] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TimeAfterRegister",result);
    Spieler[playerid][pTimeAfterRegister] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Time4Payday",result);
    Spieler[playerid][pMinutesAfterPayday] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TimeoutCrashExeorKick",result);
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RpChat",result);
    Spieler[playerid][RpChat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Autologin",result);
    Spieler[playerid][Autologin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Newschat",result);
    Spieler[playerid][Newschat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Jobchat",result);
    Spieler[playerid][Jobchat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Neulingschat",result);
    Spieler[playerid][Neulingschat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Premiumchat",result);
    Spieler[playerid][Premiumchat] = strval(result);
    strdel(result,0,sizeof(result));
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HabGeworben",result);
    Spieler[playerid][HatGeworben] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pPremium",result);
    Spieler[playerid][pPremium] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"GeworbenerSpieler",result);
    strmid(Spieler[playerid][GeworbenPlaya],result,0,strlen(result),24);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pScheinSperre",result);
    Spieler[playerid][pScheinSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"DigiHud",result);
    Spieler[playerid][DigiHud] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pDHitsound",result);
    Spieler[playerid][pDHitsound] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bonus",result);
    Spieler[playerid][pStartbonus] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Gutschein",result);
    Spieler[playerid][pGutschein] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pCoins",result);
    Spieler[playerid][pCoins] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pFirmaLeader",result);
    Spieler[playerid][pFirmaLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pFirmaMember",result);
    Spieler[playerid][pFirmaMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pOrgLeader",result);
    Spieler[playerid][pOrgLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pOrgMember",result);
    Spieler[playerid][pOrgMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pParteiLeader",result);
    Spieler[playerid][pParteiLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pParteiMember",result);
    Spieler[playerid][pParteiMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pLohn",result);
    Spieler[playerid][pLohn] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WaitPerso",result);
    Spieler[playerid][WaitPerso] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMarried",result);
    strmid(Spieler[playerid][pMarried],result,0,strlen(result),sizeof(result));
    strdel(result,0,sizeof(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBuyClothes",result);
    Spieler[playerid][pBuyClothes] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pTsIdent",result);
    strmid(Spieler[playerid][pTsIdent],result,0,strlen(result),24);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pIll",result);
    Spieler[playerid][pIll] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pConterminatedTime",result);
    Spieler[playerid][pConterminatedTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBitchSkill",result);
    Spieler[playerid][pBitchSkill] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBitchFuckCount",result);
    Spieler[playerid][pBitchFuckCount] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMedicHealplayerSkill",result);
    Spieler[playerid][pMedicHealplayerSkill] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMedicHealCount",result);
    Spieler[playerid][pMedicHealCount] = strval(result);
    strdel(result,0,sizeof(result));
    new stringlogin[256];
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountWeapons","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountFish","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountKoffer","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBlacklists","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountInventar","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountLicenses","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBankSafe","i",playerid);
    for(new slot=0;slot<MAX_PLAYER_VEHS;slot++)
    {
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_vehicle WHERE name = '%s' AND slot = '%d'",SpielerName(playerid),slot);
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountVehicles","ii",playerid,slot);
    }