SteezCram / extDB3

An archive repository of extDB3
Other
63 stars 35 forks source link

Error Unknown Protocol: {407638} when persistent is set to 0 #11

Closed Evaexe117 closed 2 years ago

Evaexe117 commented 2 years ago

Hello. I'm having issus that i don't understand. When persistent is set to 0. The first sql request that i do work fine, an return the good data. But the second ( same request that the first ) return any or scalar, and the log give me an error unknow protocol.

The request is sended by the init.sqf at the connection of the player.

server.cfg

persistent=0

extdb3-conf.ini

[Main]
Version = 1

Randomize Config File = false
;; Randomizes Config File after loading.
;;   Recommend to turn on, if you have enabled filepatching on arma.

Allow Reset = false
;; Allows 9:RESET, usefull for development work

Thread = 0
;; Option to force number of worker threads for extDB3.
;;   Auto = 0, Min = 2, Max = 6

[Log]
Flush = false;
;; Flush logfile after each update.
;;    Option really only usefull if running DEBUG BUILD
`

requete.ini 
`[Default]
Version = 1
;; Used incase there is ever a breaking change, or to inform user in log about a new feature.

;;Strip Chars = ""
Strip Chars = "/\|;{}<>'`[]"
;; List of characters to strip out

Strip Chars Mode = 0
;; 0 = Strip Bad Chars, 1 = Strip + Log Bad Chars, 2 = Return Error & Log Bad Chars
;; Note: Logging on works when sending data to database.

Input SQF Parser = false
;; Experimental
;; If enabled will use SQF Array Parser instead of : seperator for values
;; i.e 0:SQL:UpdatePlayer:["Joe",[1,2,0],0.22333,"PlayerBackpack",-3]
;; Advantage is that you don't need to strip : seperator from user inputted values

Number of Retrys = 5
;; Number of Retrys if Error Encountered
;; Note: If doing multiple SQL i.e SQL1_1 SQL2_1 etc, it will retry everything.

; --------------------------------------------------------------------------------
; SQL Statements
; --------------------------------------------------------------------------------

[getUid]
SQL1_1 = SELECT score FROM players WHERE guid=?
SQL1_INPUTS = 1
OUTPUT = 1-STRING

sqf requete

params ["_uid_joueur", "_clientOwner"];

 _query = format["getUid:%1",_uid_joueur];

 _data = [_query, 2] call DB_fnc_asyncCall;

LOG SQL

[11:30:41:220348 +02:00] [Thread 23092] extDB3: Locked
[11:32:08:325241 +02:00] [Thread 23092] extDB3: Error Unknown Protocol: {407638}  Input String: 2:{407638}:getUid:765611979987*****

LOG ARMA : FIRST CONNECTION TO SERVER

11:46:41 "--- LRX Load Game finish at 1.012" 11:46:42 "--- Server Init stop ---" 11:46:42 Weather was forced to change 11:46:42 "askUnitServer UID LOCAL = 765611979987***** " 11:46:42 "count _data = 1 " `

AFTER DECO/RECO

11:48:07 "--- LRX Load Game finish at 1" 11:48:08 "--- Server Init stop ---" 11:48:08 Weather was forced to change 11:48:08 "askUnitServer UID LOCAL = 765611979987***** " 11:48:08 "count _data = scalar "

SteezCram commented 2 years ago

Hello,

I never use this for SQL in Arma 3, so I cannot help much with your error. You can try by putting your query in your string in the query variable and test.

SteezCram commented 2 years ago

No response