mysql lädt autos nicht oder schmiert ab

Lalelu_du · 17. März 2013

SQL

[Sun Mar 17 19:28:05 2013]      Logging Started
[Sun Mar 17 19:28:05 2013] -------------------------
[Sun Mar 17 19:28:05 2013] Function: mysql_init executed with result: "2".
[Sun Mar 17 19:28:05 2013] Connected (0) to root @ localhost via TCP/IP.
[Sun Mar 17 19:28:05 2013] MySQL Server Version 5.5.27.
[Sun Mar 17 19:28:05 2013] Connected (1) to root @ localhost via TCP/IP.
[Sun Mar 17 19:28:05 2013] MySQL Server Version 5.5.27.
[Sun Mar 17 19:28:05 2013] Connected (2) to root @ localhost via TCP/IP.
[Sun Mar 17 19:28:05 2013] MySQL Server Version 5.5.27.
[Sun Mar 17 19:28:05 2013] Connected (3) to root @ localhost via TCP/IP.
[Sun Mar 17 19:28:05 2013] MySQL Server Version 5.5.27.
[Sun Mar 17 19:28:05 2013] Function: mysql_query executed: "UPDATE user SET id='1' WHERE id='1'" with result: "0".
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Function: mysql_query (threaded) executed: "SELECT * FROM autos WHERE besitzer='lalelu22' AND laden='1'" with result: "0".
[Sun Mar 17 19:28:34 2013] Function: mysql_query executed: "SELECT * FROM autos WHERE besitzer='lalelu22' AND laden='1'" with result: "0".
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Error (0): Function: mysql_fetch_field failed, no field data.
[Sun Mar 17 19:28:34 2013] Function: mysql_store_result executed with result: "1"
[Sun Mar 17 19:28:34 2013] Function: mysql_free_result executed.
[Sun Mar 17 19:28:34 2013] Callback: OnMysqlQuery(1234, 0, 2) called.

Alles anzeigen

und mein pwn code dazu

case 1234:
{
mysql_store_result(mysql_car);
new playerid=spareid;
new loadvehs=4;
if(SpielerInfo[playerid][pRank]>0){loadvehs=6;}
new x=0;
while(mysql_fetch_row(data,"|",mysql_car))
{
if(x==loadvehs){mysql_free_result(mysql_car);return 1;}
new id=getFreePlayerAuto();
sscanf(data, "p<|>is[40]iffffiiiffffs[64]iiis[10]iiiiiiiiiiiiiiiiiiiiiifiiiis[64]s[64]s[64]s[64]s[64]iiiffff",PlayerAuto[id][d_id],PlayerAuto[id][vkey],PlayerAuto[id][vmodel],PlayerAuto[id][v_xc],PlayerAuto[id][v_yc],PlayerAuto[id][v_zc],PlayerAuto[id][v_ac],PlayerAuto[id][vfarbe1],PlayerAuto[id][vfarbe2],PlayerAuto[id][preis],
PlayerAuto[id][a_x],PlayerAuto[id][a_y],PlayerAuto[id][a_z],PlayerAuto[id][a_a],PlayerAuto[id][car_grund],PlayerAuto[id][benzin],PlayerAuto[id][kaputt],PlayerAuto[id][angemeldet],PlayerAuto[id][kennzeichen],PlayerAuto[id][vmod0],PlayerAuto[id][vmod1],PlayerAuto[id][vmod2],PlayerAuto[id][vmod3],PlayerAuto[id][vmod4],
PlayerAuto[id][vmod5],PlayerAuto[id][vmod6],PlayerAuto[id][vmod7],PlayerAuto[id][vmod8],PlayerAuto[id][vmod9],PlayerAuto[id][vmod10],PlayerAuto[id][vmod11],PlayerAuto[id][vmod12],PlayerAuto[id][vmod13],PlayerAuto[id][paintjob],PlayerAuto[id][car_mats],PlayerAuto[id][car_hanf],PlayerAuto[id][car_lsd],PlayerAuto[id][car_lunch],PlayerAuto[id][car_c4],PlayerAuto[id][car_koks],
PlayerAuto[id][neon],PlayerAuto[id][car_distance],PlayerAuto[id][car_pizza0],PlayerAuto[id][car_pizza1],PlayerAuto[id][car_laden],PlayerAuto[id][lastwechsel],PlayerAuto[id][key1],PlayerAuto[id][key2],PlayerAuto[id][key3],PlayerAuto[id][key4],PlayerAuto[id][key5],PlayerAuto[id][car_abtime],PlayerAuto[id][calarm],PlayerAuto[id][finder],PlayerAuto[id][lastx],PlayerAuto[id][lasty],PlayerAuto[id][lastz],PlayerAuto[id][lastr]);
PlayerAuto[id][id_x] = CreateVehicleEx(PlayerAuto[id][vmodel],PlayerAuto[id][v_xc],PlayerAuto[id][v_yc],PlayerAuto[id][v_zc],PlayerAuto[id][v_ac],PlayerAuto[id][vfarbe1],PlayerAuto[id][vfarbe2],-1);
RespawnVehicle(499,PlayerAuto[id][id_x]);
//Kofferraum
carLSD[PlayerAuto[id][id_x]]=PlayerAuto[id][car_lsd];
carKoks[PlayerAuto[id][id_x]]=PlayerAuto[id][car_koks];
carHanf[PlayerAuto[id][id_x]]=PlayerAuto[id][car_hanf];
carMats[PlayerAuto[id][id_x]]=PlayerAuto[id][car_mats];
carC4[PlayerAuto[id][id_x]]=PlayerAuto[id][car_c4];
carLunch[PlayerAuto[id][id_x]]=PlayerAuto[id][car_lunch];
carPizza[0][PlayerAuto[id][id_x]]=PlayerAuto[id][car_pizza0];
carPizza[1][PlayerAuto[id][id_x]]=PlayerAuto[id][car_pizza1];
istkaputt[PlayerAuto[id][id_x]]=PlayerAuto[id][kaputt];
distanz[PlayerAuto[id][id_x]]=PlayerAuto[id][car_distance];
FahrzeugTunen(PlayerAuto[id][id_x]);
lockVehicle(PlayerAuto[id][id_x]);
format(string,sizeof(string),"%s-%d",PlayerAuto[id][kennzeichen],PlayerAuto[id][id_x]);
if(PlayerAuto[id][angemeldet]==1)
{
SetVehicleNumberPlateEx(PlayerAuto[id][id_x],string);
}
else
{
SetVehicleNumberPlateEx(PlayerAuto[id][id_x],"{FF0000}-NA-");
}
tank[PlayerAuto[id][id_x]]=PlayerAuto[id][benzin];
printf("Fahrzeug : %d (ID:%d) geladen und gefunden. [BESITZER : %s]",id,PlayerAuto[id][id_x],PlayerAuto[id][vkey]);
//zähler erhöhen
x++;
}
mysql_free_result(mysql_car);
return 1;

woran kann es Liegen ?

Nbdchemnitz · 17. März 2013

das gleiche problem habe ich auch

Akino Kiritani · 17. März 2013

Zitat

mysql_fetch_field failed, no field data.

Fällt was auf?

Lalelu_du · 17. März 2013

das die datai nich da ist richtig ?

Akino Kiritani · 17. März 2013

Datei?

Nein in deinem "Feld" das du auslesen willst, steht nichts

**Maximilian** · 17. März 2013

Normalerweise sollten die Daten des Autos drinnen stehen

Akino Kiritani · 17. März 2013

Ja scheinbar tun sie es nicht, sonst würde es da nicht stehen

Lalelu_du · 17. März 2013

ja und was kann ich da jetzt machen ?

weil wenn ich das auto kaufe und ein relog mache ist das auto weg
aber in der mysql datenbank ist es aber da. (laden steht auf 0)
wenn ich das umändere auf 1 dass, das auto auch läd kackt der server ab...

Akino Kiritani · 17. März 2013

Zitat von Lalelu_du

ja und was kann ich da jetzt machen ?

Die mit Daten füllen?

Jedesfeld das du ausließt MUSS gefüllt sein und wenn das nur 0 drin steht, irgendwas muss da stehen.
Vielleicht solltet ihr die Tabelleneinstllungen mal ändern

Lalelu_du · 17. März 2013

jetzt schmiert er ab aber schreibt was rein hier meine mysql log

SQL

[Sun Mar 17 21:01:07 2013] Function: mysql_store_result executed with result: "1"
[Sun Mar 17 21:01:07 2013] Function: mysql_fetch_row executed with result: "199738|0|lalelu22|422|1715.92|-1581.55|13.5322|184.8|-1|-1|27999|0|0|0|0||98|0|1|La|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|0|0|0|0|0|0|0|0.797059|0|0|1|0|Niemand|Niemand|Niemand|Niemand|Niemand|0|0|0|1715.92|-1581.55|13.5322|184.8|0".

warum schmiert er ab was ist falsch

Akino Kiritani · 17. März 2013

crashdetect plugin

Lalelu_du · 17. März 2013

SQL

[21:13:38]  German Reallife
[21:13:38] ----------------------------------


[21:13:38] Number of vehicle models: 148
[21:13:38] [debug] Server crashed due to an unknown error
[21:13:38] [debug] System backtrace:
[21:13:38] [debug] #0 10001eab in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #1 10002960 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #2 1000277f in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #3 1000216c in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #4 10001f6f in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #5 1000595e in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\plugins\mysql.DLL
[21:13:38] [debug] #6 00468d66 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #7 0048886d in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #8 00494e91 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #9 00494ea1 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #10 ffc30000 in ?? ()
[21:13:38] [debug] #11 e8042474 in ?? ()
[21:13:38] [debug] #12 ffffffbf in ?? ()
[21:13:38] [debug] #13 c01bd8f7 in ?? ()
[21:13:38] [debug] #14 4859d8f7 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #15 247c83c3 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #16 06740008 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #17 412d01c6 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #18 8b56d8f7 in ?? ()
[21:13:38] [debug] #19 f7d233f1 in ?? ()
[21:13:38] [debug] #20 83082474 in ?? ()
[21:13:38] [debug] #21 057609fa in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #22 eb57c280 in ?? ()
[21:13:38] [debug] #23 30c28003 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #24 85411188 in ?? ()
[21:13:38] [debug] #25 c6e677c0 in ?? ()
[21:13:38] [debug] #26 8a490001 in ?? ()
[21:13:38] [debug] #27 88018a16 in ?? ()
[21:13:38] [debug] #28 06884911 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #29 72f13b46 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #30 55c35ef2 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #31 7d83ec8b in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #32 458b0a10 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #33 850a7508 in ?? ()
[21:13:38] [debug] #34 6a067dc0 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #35 eb0a6a01 in ?? ()
[21:13:38] [debug] #36 ff006a05 in ?? ()
[21:13:38] [debug] #37 4d8b1075 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #38 ff9fe80c in ?? ()
[21:13:38] [debug] #39 458bffff in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #40 5d59590c in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #41 244c8bc3 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #42 24448b08 in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #43 ff006a04 in ?? ()
[21:13:38] [debug] #44 e8102474 in ?? ()
[21:13:38] [debug] #45 ffffff85 in ?? ()
[21:13:38] [debug] #46 1024448b in ?? () from C:\Users\Daves\Desktop\nemesus\Dave\samp-server.exe
[21:13:38] [debug] #47 e8c35959 in ?? ()

Alles anzeigen

ich kann daraus jetzt aber nigx lesen

breadfish.de 11. März 2022