MySQL stellt keine verbindung zu mysql_car

- Stofftrank - · 19. Mai 2015

Hallo,
bei mien Script verbindet der server nicht zur mysql_car.
Aber bei allen anderen verbindet er es.

// Connect to the database.
mysql_connect(dbhost, dbuser, dbpw, dbdb, mysql,1);
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_save,1);
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_car,1);
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_load,1);
dummyQuery();

mysql = mysql_init(LOG_ONLY_ERRORS);
mysql_save = mysql_init(LOG_ONLY_ERRORS);
mysql_car = mysql_init(LOG_ALL);
mysql_load = mysql_init(LOG_ONLY_ERRORS);

new MySQL:mysql;
new MySQL:mysql_save;
new MySQL:mysql_car;
new MySQL:mysql_load;

stock dummyQuery()
{
printf("DummyQuery wurde aufgerufen.");
mysql_query("UPDATE user SET id='1' WHERE id='1'");
mysql_query("UPDATE user SET id='1' WHERE id='1'",-1,0,mysql_save);
mysql_query("UPDATE user SET id='1' WHERE id='1'",-1,0,mysql_car);
mysql_query("UPDATE user SET id='1' WHERE id='1'",-1,0,mysql_load);
return 1;
}

stock loadPlayerAutos(playerid)
{
format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%s' AND laden='1'",SpielerName(playerid));
mysql_query(query,777,playerid,mysql_car);
return 1;
}

case 1234:
{
mysql_store_result(mysql_car);
//new spareid=spareid;
new loadvehs=4;
if(SpielerInfo[spareid][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;
}

Danke im vorraus für die hilfe!

Mfg

Jeffry · 19. Mai 2015

Es reicht wenn du mysql_connect ein einziges Mal verwendest. Du nutzt ja nur unterschiedliche Tabellen, keine anderen Datenbanken.
Mach das hier weg:
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_save,1);
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_car,1);
mysql_connect(dbhost,dbuser,dbpw,dbdb,mysql_load,1);

new MySQL:mysql_save;
new MySQL:mysql_car;
new MySQL:mysql_load;

Und alles was dazu gehört.
Das kannst du alles mit "mysql" ersetzen.

- Stofftrank - · 19. Mai 2015

Wie meinst du das jetzt mit ersetzen?
Wenn ich ja die Mysql_connect weg mache, connectet er ja nichtmehr ?

Mfg

Jeffry · 19. Mai 2015

Doch, wenn du 3 der 4 weg machst stellt er ja trotzdem noch eine Verbindung her. Du brauchst aber keine 4 Verbindungen zur gleichen Datenbank, das macht keinen Sinn.
Das wäre in etwa so, wie wenn du eine Microsoft Word Datei 4 mal öffnest, das machst du ja auch nicht.

- Stofftrank - · 19. Mai 2015

Der Server ist nun gecrasht.

Was soll ich jetzt tuhn?

Mfg

#EDIT
:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Anmeldung für Dner111 ist komplett fertig (10ms).
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Für Dner111 werden Autos geladen.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Anmeldung für Dner111 ist komplett fertig (10ms).
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Für Dner111 werden Autos geladen.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Anmeldung für Dner111 ist komplett fertig (7ms).
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Für Dner111 werden Autos geladen.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] Anmeldung für Dner111 ist komplett fertig (6ms).
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_query called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_fetch_field called when not connected to any database.
[18:31:38] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Jeffry · 19. Mai 2015

Füge das Crashdetect Plugin in deinen Server ein und poste dann, was im Server Log steht, wenn der Server abstürzt.
http://forum.sa-mp.com/showthread.php?t=262796

- Stofftrank - · 19. Mai 2015

Serverlog beim EDIT eingefügt.

Mfg

Jeffry · 19. Mai 2015

Hast du jetzt alle 4 mysql_connects entfernt, oder wie?
Eins muss natürlich bleiben, sonst stellst du ja gar keine Verbindung mehr her.

- Stofftrank - · 19. Mai 2015

Ich hab das gemacht was du mir ja gesagt hast die 3 weg und der rest mit mysql überschreiben also mysql_car,mysql_load_mysql_save

Mfg

Jeffry · 19. Mai 2015

Baust du die Verbindung möglicherweise erst nach den ganzen Queries auf?
Poste mal das was im MySQL Log steht, zwecks Verbindung, ganz am Anfang wenn du den Server startest.
Leere den Log und poste ihn dann, nachdem du den Server gestartet hast.

- Stofftrank - · 20. Mai 2015

[Wed May 20 20:46:52 2015] MySQL closed. Logging ended.
[Wed May 20 20:46:52 2015] MySQL closed. Logging ended.
[Wed May 20 20:46:52 2015] MySQL closed. Logging ended.
[Wed May 20 20:46:52 2015] MySQL closed. Logging ended.
[Wed May 20 20:46:52 2015] -------------------------
[Wed May 20 20:46:52 2015] Logging Ended
[Wed May 20 20:46:52 2015] -------------------------
[Wed May 20 20:46:59 2015] -------------------------
[Wed May 20 20:46:59 2015] Logging Started
[Wed May 20 20:46:59 2015] -------------------------
[Wed May 20 20:46:59 2015] Connected (0) to samp5242 @ Localhost via UNIX socket.
[Wed May 20 20:46:59 2015] MySQL Server Version 5.5.41-0+wheezy1.
[Wed May 20 20:46:59 2015] Connected (1) to samp5242 @ Localhost via UNIX socket.
[Wed May 20 20:46:59 2015] MySQL Server Version 5.5.41-0+wheezy1.
[Wed May 20 20:46:59 2015] Connected (2) to samp5242 @ Localhost via UNIX socket.
[Wed May 20 20:46:59 2015] MySQL Server Version 5.5.41-0+wheezy1.
[Wed May 20 20:46:59 2015] Connected (3) to samp5242 @ Localhost via UNIX socket.
[Wed May 20 20:46:59 2015] MySQL Server Version 5.5.41-0+wheezy1.
[Wed May 20 20:46:59 2015] Error (0): Function: mysql_store_result called when no prior successful query executed.
[Wed May 20 20:46:59 2015] Error (0): Function: mysql_num_rows called when no result stored.

Jeffry · 20. Mai 2015

Jetzt stellst du ja erst wieder 4 Verbindungen her. Er darf sich nur einmal verbinden, es bringt nichts, wenn du das vier mal machst.
Die beiden Errors kommen, weil du die Funktionen ohne ein Query ausgeführt zu haben aufrufst.

Bring das soweit hin, dass

Zitat

[Wed May 20 20:46:59 2015] Connected (0) to samp5242 @ Localhost via UNIX socket.
[Wed May 20 20:46:59 2015] MySQL Server Version 5.5.41-0+wheezy1.

nur einmal im Log steht.

- Stofftrank - · 21. Mai 2015

Zitat von Jeffry

Jetzt stellst du ja erst wieder 4 Verbindungen her. Er darf sich nur einmal verbinden, es bringt nichts, wenn du das vier mal machst.
Die beiden Errors kommen, weil du die Funktionen ohne ein Query ausgeführt zu haben aufrufst.

Bring das soweit hin, dass

nur einmal im Log steht.

Wenn ich das machen würde , funktioniert das ganze Script nichtmehr.

Mfg

Jeffry · 21. Mai 2015

Warum denn das? Jedem Server reicht eigentlich eine MySQL Verbindung zur Datenbank. Du musst keine 4-fache Verbindung zur gleichen Datenbank aufbauen. Das bringt nur was, wenn du Daten in verschiedenen Datenbanken hast, was du aber nicht hat, da du vier mal die gleichen Daten zum Login angibst.
Was funktioniert denn dann nicht mehr, wenn du das änderst?

Du kannst ja mal ein Backup von deinem Code machen und es dann testen, dann hast du keinen Aufwand falls es nicht klappt.

- Stofftrank - · 21. Mai 2015

Ich hatte es ja schonmal versucht.
Man kann sich nichtmehr einloggen und es funktioniert dann garnichts mehr.
Würde mich aber auch zur TV verfügung stellen vor 18Uhr.

Oder nach 18 uhr so um 20Uhr ca
mfg

Jeffry · 21. Mai 2015

Geht bei mir nicht, da bin ich noch nicht zu Hause. Ich kann dir frühestens Sonntag anbieten, dass ich es mir da mal anschaue, wenn es bis dahin noch nicht erledigt ist. Ansonsten, und das wäre der bessere Weg, mache das was ich dir gesagt habe mal und poste dann den Log der kommt, wenn du versuchst dich einzuloggen.

Rückgängig kannst du das ja immer noch machen, wenn du ein Backup zuvor machst (nicht vergessen!).

- Stofftrank - · 22. Mai 2015

Zitat von Jeffry

Geht bei mir nicht, da bin ich noch nicht zu Hause. Ich kann dir frühestens Sonntag anbieten, dass ich es mir da mal anschaue, wenn es bis dahin noch nicht erledigt ist. Ansonsten, und das wäre der bessere Weg, mache das was ich dir gesagt habe mal und poste dann den Log der kommt, wenn du versuchst dich einzuloggen.

Rückgängig kannst du das ja immer noch machen, wenn du ein Backup zuvor machst (nicht vergessen!).

Ok, ich warte lieber auf Sonntag bevor ich noch was falsches mache.
Da ich nicht sehr sehr erfahren bin wie du.

mFG

Jeffry · 22. Mai 2015

In Ordnung, dann würde ich dir am Samstag (morgen) Abend nochmal genau Bescheid sagen, wie es von der Zeit her klappt. Ich gehe aber davon aus, dass ich nachmittags Zeit habe, mir das anzuschauen.
Außer es findet sich noch jemand anderes, der dir das machen will, dann sagst halt Bescheid. Aber nicht vergessen ein Backup zu machen, falls es nicht klappt

- Stofftrank - · 23. Mai 2015

Zitat von Jeffry

In Ordnung, dann würde ich dir am Samstag (morgen) Abend nochmal genau Bescheid sagen, wie es von der Zeit her klappt. Ich gehe aber davon aus, dass ich nachmittags Zeit habe, mir das anzuschauen.
Außer es findet sich noch jemand anderes, der dir das machen will, dann sagst halt Bescheid. Aber nicht vergessen ein Backup zu machen, falls es nicht klappt

Ok

Mfg

Jeffry · 24. Mai 2015

Das Problem wurde behoben.
Problem war, dass eine falsche Query ID (777 anstatt 1234) angegeben wurde, beim Laden der Fahrzeuge, zudem hat in der sscanf Funktion ein Wert gefehlt (ganz am Anfang ein Integer).

Funktioniert nun wie gewünscht.

breadfish.de 12. März 2022