bug save mysql [+4 rep]
#9

Quote:
Originally Posted by DarkZeroX
Посмотреть сообщение
Код:
[OnQueryError] Error ID: 1064
[OnQueryError] Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p_armure = 10, p_cagoule = 0, p_cigarettes = 0, p_tabac = 0, p_feuilles = 0, p_c' at line 1
[OnQueryError] Callback: 
[OnQueryError] Query: p_armure = 10, p_cagoule = 0, p_cigarettes = 0, p_tabac = 0, p_feuilles = 0, p_combat = 0, p_marche = 0, p_compte = 0 WHERE p_id = 1p_faction = 0, p_rang = 0, p_maison = 0, p_commerce = 0, p_crash_x = 0.000000, p_crash_y = 0.000000, p_crash_z = 0.000000
 [OnQueryError] Connection handle: 1
Your query is confusing me. There is something wrong while strcat'ing them. Try to debug those strings through printf().

@Above posters ShivRp and [MWR]Blood:

You don't really need to add those ' ' or ` `, simple query works fine too. Usually scripters make them to look fancy, but it is wastage of time anyway. Although ' ' needs to be used only for strings, it is still needed. Do like this '%s' to every string specifier.

@Macronix: That won't work because the formatted string cannot be that longer, and it will give silly errors. You need to strcat them if they're long. This doesn't applies for the patched compiler by Zeex/xeeZ.
Reply


Messages In This Thread
bug save mysql [+4 rep] - by DarkZeroX - 29.04.2014, 17:13
Re: bug save mysql [+4 rep] - by arakuta - 29.04.2014, 17:15
Re: bug save mysql [+4 rep] - by GeasyW - 29.04.2014, 17:18
Re: bug save mysql [+4 rep] - by DarkZeroX - 29.04.2014, 17:33
Re: bug save mysql [+4 rep] - by iZN - 29.04.2014, 18:04
Re: bug save mysql [+4 rep] - by DarkZeroX - 29.04.2014, 18:12
Re: bug save mysql [+4 rep] - by Guest4390857394857 - 29.04.2014, 18:32
Re: bug save mysql [+4 rep] - by [MWR]Blood - 29.04.2014, 18:33
Re: bug save mysql [+4 rep] - by iZN - 29.04.2014, 18:42
Re: bug save mysql [+4 rep] - by [MWR]Blood - 29.04.2014, 18:43

Forum Jump:


Users browsing this thread: 1 Guest(s)