[KoreanPeople]

i can playerLv[client] = DBResultSet.FetchInt(0) // but not correct data. It's not what I want.
but cant playerEXP[client] = DBResultSet.FetchInt(1); // Error

what a problem ?

my dedicated console

L 06/30/2019 - 20:24:52: [SM] Exception reported: Error fetching data from field 2
L 06/30/2019 - 20:24:52: [SM] Blaming: test.smx
L 06/30/2019 - 20:24:52: [SM] Call stack trace:
L 06/30/2019 - 20:24:52: [SM] [0] DBResultSet.FetchInt
L 06/30/2019 - 20:24:52: [SM] [1] Line 44, C:\Program Files (x86)\Steam\steamapps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\scripting\ test.sp::playerloadData

field = not sql column ??

my db table column
name(varchar), steamid(varchar), lv(int), gold(int), exp(int)

FetchInt(0) = not lv ?

How do I get the correct data?
perhaps db problem ?
i get stress...

pls solve problem please...

[CrazyHackGUT]

We can't help you because you don't show fully your code.
Also try dump formatted SQL query and execute manually with phpMyAdmin/HeidiSQL/any another sql client.

name - 0.
steamid - 1.
lv - 2.
gold - 3.
exp - 4.

[I am inevitable]

Something went wrong when you tried to fetch the data from that specific field (column).

By: "FetchInt(0) = not lv ?", I suppose you expected that fetching the 0 column (first column, counting starts at 0), would give you the value of the second column (actually third, but hey).

As that was your expectation, you used FetchInt, trying to get an int value, while you were actually getting varchar.

A bit as CrazyHackGUT said.

[KoreanPeople]

Originally Posted by CrazyHackGUT We can't help you because you don't show fully your code. Also try dump formatted SQL query and execute manually with phpMyAdmin/HeidiSQL/any another sql client. name - 0. steamid - 1. lv - 2. gold - 3. exp - 4.

Thx. i solved. really thx

[KoreanPeople]

Originally Posted by I am inevitable Something went wrong when you tried to fetch the data from that specific field (column). By: "FetchInt(0) = not lv ?", I suppose you expected that fetching the 0 column (first column, counting starts at 0), would give you the value of the second column (actually third, but hey). As that was your expectation, you used FetchInt, trying to get an int value, while you were actually getting varchar. A bit as CrazyHackGUT said.

thx too. i solved.
Problem: DBResultSet.FetchInt(0) = datatype varchar
but, i want to int. so dumbass...
really Thx.