mysql error [+4rep]
#1

Hello
I've a problem, look:

Код:

format(string, sizeof(string), "INSERT INTO vehicule (veh_id,veh_model, veh_posx, veh_posy, veh_posz, veh_posa, veh_c1, veh_c2,veh_proprio,veh_essence) VALUES (%d, %d, %f, %f, %f, %f, %d, %d, aucun, %d)",
totalcar,v_info[totalcar][veh_model],v_info[totalcar][veh_pos][0],v_info[totalcar][veh_pos][1],v_info[totalcar][veh_pos][2],v_info[totalcar][veh_pos][3],v_info[totalcar][veh_couleur][0],v_info[totalcar][veh_couleur][1],v_info[totalcar][veh_proprio],v_info[totalcar][veh_essence]);
mysql_function_query(mysql, string, false, "", "");
[16:07:48] Passing query INSERT INTO vehicule (veh_id,veh_model, veh_posx, veh_posy, veh_posz, veh_posa, veh_c1, veh_c2,veh_proprio,veh_essence) VALUES (49, 411, 1.100000, 2.200000, 3.299999, 4.400000, 6, 6, aucun, 0) | 
[16:07:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[16:07:48] OnQueryError() - Called.
The query displays nothing in the error console
Thank
Reply
#2

pawn Код:
format(string, sizeof(string), "INSERT INTO Vehicules (veh_id, veh_model, veh_posx, veh_posy, veh_posz, veh_posa, veh_c1, veh_c2, veh_proprio, veh_essence) VALUES (%d, %d, %f, %f, %f, %f, %d, %d, %s, %d)",
totalcar,v_info[totalcar][veh_model],v_info[totalcar][veh_pos][0],v_info[totalcar][veh_pos][1],v_info[totalcar][veh_pos][2],v_info[totalcar][veh_pos][3],v_info[totalcar][veh_couleur][0],v_info[totalcar][veh_couleur][1],v_info[totalcar][veh_proprio],v_info[totalcar][veh_essence]);
mysql_function_query(mysql, string, false, "", "");
also check your vehicle table's name, are you sure it's vehicule and not vehicle?
Reply
#3

There was an error in the name of the table (I forgot an s) but the error is still present

Knowing that I am French and I wrote with ****** translation so it was "Vehicules"
Reply
#4

There was also another issue, you put "ascun" instead of '%s' for veh_proprio ...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)