Jump to content
  • 0

Problema baza de date.


NuamNume

Question

Salut, am pe server un sistem de creare de label-uri printr-o comanda, adica merge totul pefect, doar ca atunci cand imi apare dialog si scriu text-ul si dau enter, imi dispare si imi apare in server log asta: 

[19:39:39] Error ID: 1064, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '', '13.578', '1151633605', '0', '')' at line 1
[19:39:39] Callback: FJ37DH3JG_MYSQL_INTERNAL
[19:39:39] gQuery: INSERT INTO `server_labels` (`X`, `Y`, `Z`, `VirtualWorld`, `Interior`, `Text`) VALUES ('1316.274, '-1387.361', '13.578', '1151633605', '0', '')

Stie cineva ce are? Nu stiu daca ma credeti, dar ma chinui de 2 ore si 13 minute si nu ii dau de cap, am scris si am re-scris, degeaba. nimic

Sa va arat si linia cu problema: 

 gQuery[0] = (EOS);
 mysql_format(SQL, gQuery, 256, "INSERT INTO `server_pickups` (Model, X, Y, Z, WorldID, Interior) VALUES ('%d', '%f', '%f', '%f', '%d', '%d')", model, PickupInfo[id][pickupX], PickupInfo[id][pickupY], PickupInfo[id][pickupZ], worldid, interior);

Poate sa ma ajute cineva? Daca da, chiar as fii recunoscator. Si eu vreau sa va ajut, dar nu prea stiu.. sunt destul de incepator in scripting, adica pot sa rezolv anumite erori, sa fac anumite comenzi, dar la asta chiar nu stiu. Multumesc tuturor si o zi/seara buna.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.