Uhh need help with msql r34.. Got querty.. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Uhh need help with msql r34.. Got querty.. (/showthread.php?tid=470675)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Uhh need help with msql r34.. Got querty.. (/showthread.php?tid=470675)
Uhh need help with msql r34.. Got querty.. - Scrillex - 19.10.2013
Hello dear samp members again I post the error what I have..
Maybe someone could help me..
pawn Код:
error 035: argument type mismatch (argument 1)
pawn Код:
format(var,100,"UPDATE `vehicles` SET `CarID`='%d' WHERE `CarID`='%d'",vInfo[vehicleid][vCariD],vInfo[vehicleid][vCariD]);
mysql_query(var);//this line.
With best regards Scrillex.
Re: Uhh need help with msql r34.. Got querty.. - iZN - 19.10.2013
The format thing is wrong.
https://sampwiki.blast.hk/wiki/Format
Re: Uhh need help with msql r34.. Got querty.. - Scrillex - 19.10.2013
I don't understand what is wrong with it... %d is correct.. isn't it?
and I got
pawn Код:
(output[], len, const format[], {Float,_}:...)
format(var,100,"UPDATE `vehicles` SET `CarID`='%d' WHERE `CarID`='%d'",vInfo[vehicleid][vCariD],vInfo[vehicleid][vCariD]);
var = output
100 = len
UPDATE = format
and all the rest
Re: Uhh need help with msql r34.. Got querty.. - iZN - 19.10.2013
Ah, I got it.
The correct native for mysql_query is:
pawn Код:
native mysql_query(conhandle, query[]);
pawn Код:
new var[100];
format(var, sizeof(var), "UPDATE `vehicles` SET `CarID`='%d' WHERE `CarID`='%d'", vInfo[vehicleid][vCariD], vInfo[vehicleid][vCariD]);
mysql_query(dbHandle, var); // Your connection handle variable will come here.
Re: Uhh need help with msql r34.. Got querty.. - Scrillex - 19.10.2013
Okay downgraded it to r5 and it worked.. but now I have anther problem
pawn Код:
[12:37:54] [debug] AMX backtrace:
[12:37:54] [debug] #0 native mysql_fetch_field_row () [012165e0] from mysql.DLL
[12:37:54] [debug] #1 00281740 in ?? () from IMGRP.amx
[12:37:54] [debug] #2 000c0090 in public Audio_OnGameModeInit () from IMGRP.amx
[12:37:54] [debug] #3 native CallLocalFunction () [00471ef0] from samp-server.exe
[12:37:54] [debug] #4 000135c8 in ?? () from IMGRP.amx
[12:37:54] [debug] #5 0000d770 in public ab_OnGameModeInit () from IMGRP.amx
[12:37:54] [debug] #6 native CallLocalFunction () [00471ef0] from samp-server.exe
[12:37:54] [debug] #7 0000c1cc in public OnGameModeInit () from IMGRP.amx
[12:37:54] [debug] System backtrace:
[12:37:55] [debug] #0 012190b4 in ?? () from plugins\mysql.DLL
[12:37:55] [debug] #1 012166b3 in ?? () from plugins\mysql.DLL
[12:37:55] [debug] #2 004010b6 in ?? () from samp-server.exe
[12:37:55] [debug] #3 705539e2 in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #4 70555e26 in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #5 7054bf3f in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #6 70553a0e in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #7 004721fe in ?? () from samp-server.exe
[12:37:55] [debug] #8 004010b6 in ?? () from samp-server.exe
[12:37:55] [debug] #9 705539e2 in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #10 70555e26 in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #11 7054bf3f in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #12 70553a0e in ?? () from plugins\crashdetect.DLL
[12:37:55] [debug] #13 004721fe in ?? () from samp-server.exe
[12:37:55] [debug] #14 004010b6 in ?? () from samp-server.exe
[12:37:55] [debug] #15 705539e2 in ?? () from \plugins\crashdetect.DLL
[12:37:55] [debug] #16 70555e26 in ?? () from \plugins\crashdetect.DLL
[12:37:55] [debug] #17 7054bf3f in ?? () from \plugins\crashdetect.DLL
[12:37:55] [debug] #18 70553a0e in ?? () from \plugins\crashdetect.DLL
[12:37:55] [debug] #19 0046e1f4 in ?? () from \samp-server.exe
[12:37:55] [debug] #20 65646f6d in ?? () from \samp-server.exe
[12:37:55] [debug] #21 6d692f73 in ?? () from \samp-server.exe
[12:37:55] [debug] #22 2e707267 in ?? () from samp-server.exe
[12:37:55] [debug] #23 00786d61 in ?? ()
Re: Uhh need help with msql r34.. Got querty.. - Misiur - 19.10.2013
Downgrading is not a good thing. Compile with -d3 flag to get line which causes the crash
Re: Uhh need help with msql r34.. Got querty.. - Patrick - 19.10.2013
Quote:
|
Originally Posted by Misiur
 Downgrading is not a good thing. Compile with -d3 flag to get line which causes the crash
|
pawn Код:
1st - Open your pawno folder.
2nd - Open Notepad++ or notepad, and save the file as pawn.cfg
3rd - Open that file and add -d3
4th - Save it and compile, then test your gamemode and show us the error
Re: Uhh need help with msql r34.. Got querty.. - Scrillex - 19.10.2013
Yeah but still I got the same errors.. and Can't get rid of mysql_query error..
I'm new in mysql and it is something new.. for me..
Done that.. thank you for guide.
Re: Uhh need help with msql r34.. Got querty.. - iZN - 19.10.2013
Use R6 which is the last version for un-threaded queries. And is your crashdetect plugin is up-to-date? The last version is 4.12.
Re: Uhh need help with msql r34.. Got querty.. - Scrillex - 19.10.2013
Got it. ... And okay I will update to r6.