Taxes are not send

Page 1 of 2 1 2
10/25/2016 16:41 firesqual#1
Hello,

I have a strange problem with Taxes, i don't know why but the SecretRoom winner don't recieve them...

I have a strange error like this :

query:{call MAIL_STR('A1', 26086, '01', '0002523', '0000000', 1039500, 1477398601, 0, ?, ?,0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0,0,0, 0, 0, 0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 0, 0, 0,0, 0, 0, 0, 0,0)}
SQLSTATE:22001 error:[Microsoft][SQL Native Client]String data, right truncation

Here is the function associated :


Maybe you know what's the problem ?

Thanks alot
10/25/2016 17:06 Offspringfan1234#2
Sorry for the question but weren't you able to find something out through the debug mode?
10/25/2016 17:32 firesqual#3
I only debug my Worldserver when it crashes :/
10/26/2016 04:51 NoWay | Phoenix#4
Upload: Resource/Lua/SecreetRoom....
I Check the Source Code later :)
10/26/2016 09:10 raventh1984#5
No need for Resource etc.

Its an truncation did you search google what it ment?

Its simple. The data that is inserted is larger then the field allows.

So it has nothing to do with the procedure.
DbManager.cpp
10/26/2016 10:25 firesqual#6
Thanks, then what should i do ? Just increase every field size ?

Is there a way to know exactly which data is the truncated one ?
10/26/2016 12:47 raventh1984#7
Post your MAIL_STR here and your
Code:
 void CDbManager::MakeQueryAddMail( char* szSql, CMail* pMail, u_long idReceiver )
so i can compare it to what i have to see if there is something out of the order.
10/26/2016 13:04 firesqual#8

STr :

10/26/2016 22:50 raventh1984#9
Seems the same.

Thus this only happen with the taxes? You can send gold for yourself to an other player?
Also over 1B?
10/27/2016 12:20 firesqual#10
Mmh.. I'll try with 1B.

Edit : It worked with 1B, not Perins but 1b. So maybe there is something else ?
And yes it only happen with the taxes
10/27/2016 13:07 raventh1984#11
I think its still the gold.
Increase the table nGold from int to bigint. To see if that helps.
10/27/2016 13:43 firesqual#12
Ok i'll try that thanks

Edit : Its already a bigint :c
10/27/2016 14:08 xTwiLightx#13
It seems that either the Title or the Text is too long for the column.By default, szTitle can take 128 and szText can take up to 255 characters.

Check what length your szText and szTitle columns (in MAIL_TBL) can take and check what your server wants to insert there (maybe with debug output, or some error log output for testing).
10/27/2016 14:57 firesqual#14
I changed the szText and szTitle values to varchar(MAX) already, i though it was that but its not :/
10/27/2016 16:32 xTwiLightx#15
Quote:
Originally Posted by firesqual View Post
I changed the szText and szTitle values to varchar(MAX) already, i though it was that but its not :/
Then it must happen while the quetion marks (?) are being binded to the values.

So check what length pMail->m_szText and pMail->m_szTitle have during runtime.
Page 1 of 2 1 2