MySQL Errors

Zitat von AirM4X

Zeige mal dein komplettes OnGameModeInit.

public OnGameModeInit()
{
//Allgemeine Funktionen
SetGameModeText("Fort Carson RealLife");
AddPlayerClass(26,zivispawn,89.9314,0,0,0,0,0,0); // Spawn
UsePlayerPedAnims();
ShowPlayerMarkers(0);
EnableStuntBonusForAll(0);
DisableInteriorEnterExits();
//mysql_log(LOG_ALL);
//Timer
cblift_timer = SetTimer("CluckinBellLift", 1000, 1);
SetTimer("iminute", 1000*60,1);
//mySQL Connection
dbhandle = mysql_connect(M_HOST,M_USER,M_DB,M_PASS,3306, true);
MySQL_SetupConnection();
//Laden von Sachen
mysql_tquery(dbhandle,"SELECT * FROM fraktion","OnFraktionLaden","","");
mysql_tquery(dbhandle,"SELECT * FROM firma","LoadBusinesses","");
mysql_tquery(dbhandle,"SELECT * FROM job","LoadJobs","");
//TextDraws
TextDrawShowForAll(FCRL);
FCRL = TextDrawCreate(20.000000, 429.000000, "Fort Carson RealLife [v0.2A BETA]");
TextDrawBackgroundColor(FCRL, 255);
TextDrawFont(FCRL, 1);
TextDrawLetterSize(FCRL, 0.230000, 1.000000);
TextDrawColor(FCRL, -1);
TextDrawSetOutline(FCRL, 1);
TextDrawSetProportional(FCRL, 1);
//Pickups & CreateLabel
fcpdexit=CreatePickup(1559,1,246.7761,62.3305,1003.6406);
fcpdenter=CreatePickup(1559,1,-217.8441,979.1752,19.5041);
baenter=CreatePickup(1559,1,-239.3145,1208.8878,20.7459);
baexit=CreatePickup(1559,1,390.7697,173.8157,1008.3828);
khenter=CreatePickup(1559,1,-320.1557,1048.2341,20.3403);
khexit=CreatePickup(1559,1,1333.7242,-1103.7173,-18.9922);
khpenter=CreatePickup(1559,1,-309.7358,1035.8362,19.7217);
khpexit=CreatePickup(1559,1,1349.3016,-1102.2335,-18.9922);
haenter=CreatePickup(1559,1,-311.2923,1303.5500,53.6643);
haexit=CreatePickup(1559,1,501.9278,-67.5629,998.7578);
cbenter=CreatePickup(1559,1,172.9300,1177.2211,14.7578);
cbexit=CreatePickup(1559,1,364.9439,-11.8099,1001.8516);
bmexit=CreatePickup(1559,1,412.3653,1160.7625,7.90733);
bmenter=CreatePickup(1559,1,412.2461,1159.2449,7.9073);
bankenter=CreatePickup(1559,1,-176.2523,1112.2031,19.7422);
bankexit=CreatePickup(1559,1,2304.6865,-16.1382,26.7422);
gunshopenter=CreatePickup(1559,1,-316.1617,829.8556,14.2422);
gunshopexit=CreatePickup(1559,1,285.4617,-41.8049,1001.5156);
einkaufenter=CreatePickup(1559,1,-187.6383,1210.7150,19.7056);
einkaufexit=CreatePickup(1559,1,-27.4278,-58.2752,1003.5469);
pdtrainingenter=CreatePickup(1559,1,246.4184,88.0081,1003.6406);
pdtrainingexit=CreatePickup(1559,1,-977.8561,1053.0299,1344.9913);

CreatePickup(1240,3,508.2990,-84.8993,998.9609); //HA Heal Pickup
CreatePickup(1240,3,1338.2194,-1110.8687,-18.4061); //Medic Heal Pickup
CreatePickup(1239,1,295.5826,-38.5148,1001.5156); // Gunshop i Punkt
CreatePickup(1239,1,2316.6213,-7.3369,26.7422); // Bank i Punkt
CreatePickup(1239,1,-23.4174,-55.6347,1003.5469); // 24/7 i Punkt

medicduty=CreatePickup(1247,1,1343.0153,-1110.8754,-18.4061); // Medic Duty
fcpdduty=CreatePickup(1247,1,255.3864,77.2978,1003.6406); // FCPD Duty
fcpdskin=CreatePickup(1275,1,257.0866,77.2523,1003.6406); // FCPD Uniform
hellsangelsskin=CreatePickup(1275,1,488.2988,-83.0640,998.7578); //HellsAngels Skin
lcnskin=CreatePickup(1275,1,-687.9815,930.1651,13.6293); //HellsAngels Skin
hotdogstand=CreatePickup(1212,2,-137.0489,1129.9392,19.7500); //Hotdog i
eisstand=CreatePickup(1212,2,-136.9156,1126.1348,19.7500); //Eis i
suppenstand=CreatePickup(1212,2,-136.9389,1121.7427,19.7500); //Suppen i
Buergeramt1=CreatePickup(1239,2,361.8299,173.6330,1008.3828); //Buergeramt i
cbmenu=CreatePickup(1239,2,369.5875,-6.0169,1001.8589); //CluckinBell i
guide=CreatePickup(1239,2,-138.7383,1111.1477,19.7500); // Guide i

Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Krankenhaus",WEISS,-320.1557,1048.2341,20.3403,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Police Department",WEISS,-217.8441,979.1752,19.5041,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Bürgeramt",WEISS,-239.3145,1208.8878,20.7459,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Cluckin Bell",WEISS,172.9300,1177.2211,14.7578,10,0);
Create3DTextLabel("{fff200}Hells Angels\n {FFFFFF}Bar",WEISS,-311.2923,1303.5500,53.6643,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Bank",WEISS,-176.2523,1112.2031,19.7422,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}Waffenladen",WEISS,-316.1617,829.8556,14.2422,10,0);
Create3DTextLabel("{fff200}Fort Carson\n {FFFFFF}24/7",WEISS,-187.6383,1210.7150,19.7056,10,0);

Create3DTextLabel("{fff200}Fort Carson\n Taxistand\n {FFFFFF}Ziel: Cluckin Bell\n {FFFFFF}Bitte auf Taxi warten",GELB,-299.6905,1093.3025,19.4632,20,0);
Create3DTextLabel("{fff200}Fort Carson\n Taxistand\n {FFFFFF}Ziel: Stadtrundfahrt\n {FFFFFF}Bitte auf Taxi warten",GELB,-291.5075,1093.1125,19.4456,20,0);
Create3DTextLabel("{fff200}Fort Carson\n Taxistand\n {FFFFFF}Ziel: Zivi-Spawn\n {FFFFFF}Bitte auf Taxi warten",GELB,156.9902,1172.8162,15.0824,20,0);
Create3DTextLabel("{fff200}Fort Carson\n Rundflüge\n {FFFFFF}Ziel: Diverse Bases\n {FFFFFF}Bitte auf Heli warten",GELB,-351.5297,1157.5310,19.9175,20,0);
//Definierte Objekte
medicgarage=CreateDynamicObject(10184, -339.29998779297, 1051.6999511719, 21.200000762939, 0, 0, 0); //Medic Garage
medictor[0]=CreateDynamicObject(1411, -298.60000610352, 1053.0999755859, 20.299999237061, 0, 0, 0); //medictor
medictor[1]=CreateDynamicObject(1411, -293.099609375, 1053.099609375, 20.299999237061, 0, 0, 0); //medictor
admindoor=CreateDynamicObject(1506, 365.79998779297, 189.89999389648, 1007.4000244141, 0, 0, 0); //Admin Tür SH
cblift=CreateDynamicObject(983, 176.19999694824, 1184.5999755859, 13.800000190735, 0.00439453125, 89.499938964844, 55.747619628906);
pdfenster=CreateDynamicObject(974, 250.5, 68.699996948242, 1002.4000244141, 0, 0, 90);
pdtuer1=CreateDynamicObject(14843, 249.10000610352, 72.400001525879, 1003.9000244141, 0, 0, 0);
pdtuer2=CreateDynamicObject(14843, 259, 88.199996948242, 1002.700012207, 0, 0, 270);
pdtuer3=CreateDynamicObject(14843, 250.69999694824, 58.900001525879, 1003.799987793, 0, 0, 270);
return 1;
}

Zitat von AirM4X

C

mysql_tquery(dbhandle,"SELECT * FROM fraktion","OnFraktionLaden","","");

zu

C

mysql_tquery(dbhandle,"SELECT * FROM fraktion","OnFraktionLaden","");

Was ich aber nicht verstehe. Warum ist da kein "active cache"? Entweder ich sehe vor lauter Code den Fehler einfach nicht, oder der Fehler ist ganz schön versteckt.

immer noch gleich.

ich hab den ganzen Code geschrieben xD wo mit MySQL was gemacht hat

EDIT: hab mal Job auskommentiert und ein Erweiterten MYSQL Log angemacht ab da wo es kein Cache mehr gibt kommt das

[17:48:28] [DEBUG] mysql_query - connection: 1, query: "SELECT Besitzer FROM `firma` WHERE ID = 0", use_cache: true
[17:48:28] [DEBUG] CMySQLQuery::Execute - starting query execution
[17:48:28] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.370 milliseconds
[17:48:28] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[17:48:28] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[17:48:28] [DEBUG] cache_get_row_count - connection: 1
[17:48:28] [DEBUG] cache_get_field_content - row: 0, field_name: "Besitzer", connection: 1, max_len: 200
[17:48:28] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Besitzer", data: "None"
[17:48:28] [DEBUG] cache_delete - cache_id: 1, connection: 1
[17:48:28] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[17:48:28] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[17:48:28] [DEBUG] cache_get_row_count - connection: 1