Strange symbols in database

[_Aion_]

Can anyone help me?
a while ago I had a problem with a script, then deactivated the script.
But the "nothing" gave the same error in a current script, made by Darkoahs.
Link of script that are giving erro http://otland.net/f83/grizzly-adams-killing-name-quest-all-tasks-more-real-tibia-159150/
The error consists of, instead of getting numerical values ​​in the database, something is "corrupting" my database, rendering them with symbols.
Look at the picture.



If anyone knows how I can fix, I thank you.
I think it must be something in the sourcer, because the script made ​​by him is without error.
Note: I'm using TFS 0.3.6 PL1

 

[_Aion_]

Well, I think you can just dump the database. It seems to be the only logical way to go about such a problem. Otherwise I'd try to delete the storage keys that are bigger than 65000 from your database completely. I do not have much experience with databases, but I believe that may solve your problem.

I've done it and it did not work when the player will perform the action again, the same values ​​will appear (even if I change 65000 to 12000) will give this problem, however with a different key.
have tested all possible ways (as I know), I used a database "virgin" and nothing works.

- - - Updated - - -

BUMP
anyone know how to solve?

 

[_Aion_]

BUMP
anyone know how to solve?

 

[_Aion_]

BUMP
anyone know how to solve?

 

[_Aion_]

BUMP
anyone know how to solve?

 

[_Aion_]

I'm still having this problem, can not find a solution.

 

[_Aion_]

Bump

 

[bladeatblackd]

Im not sure I will be able to help but try posting the script there may be a problem somewhere else in the script

 

[_Aion_]

Have many scripts that give this error
example, where is place that show "attempt to perform..."
Example: local new = setPlayerStorageValue(cid, 47061) + (newlevel - oldLevel) * 2 ) <<< in one of my scripts, this line shows how error

 

[_Aion_]

Bump

 

[_Aion_]

Bump

 

[Pneumonia]

Have many scripts that give this error
example, where is place that show "attempt to perform..."
Example: local new = setPlayerStorageValue(cid, 47061) + (newlevel - oldLevel) * 2 ) <<< in one of my scripts, this line shows how error

err, where is the rest of this line? you have a close parenthesis at the end but no open parenthesis matching. i'm not even entirely sure what you're attempting to do here and i don't know shit about servers and storage and any of what you are doing but i'll throw out a couple things that might get the ball rolling (or just waste my time because i'm wrong, which is fine, i'm just here to try to help!)

issue 1 that may arise: if you meant "local new = setPlayerStorageValue((cid, 47061) + (newlevel - oldLevel) * 2 )" then you would have a huge number because 47k would be multiplied by 2

issue 2 that may arise: if you meant "local new = setPlayerStorageValue(cid, 47061) + ((newlevel - oldLevel) * 2 )" then you would run into the risk of multiplying 0 by 2 or setting storage that is lower than 47061 if the new level is less than the old level (i.e. if they died and their new level is less than their old level). i don't know anything about servers but i do know that a lot of programs don't like playing with negative numbers and put characters in the place of signed fields or numbers over their threshold

issue 3 that may arise: if what you put is correct, then you may want to try to figure out what you are multiplying by 2 in your statement because it looks mighty weird from my perspective.

 

[_Aion_]

Bump

 

[Gsp]

use a diff version of mysql and phpmyadmin see what happens

 

[_Aion_]

what diff version?
i'm using xammp 1.7.3 :X

 

[Gsp]

try a newer version or you can try uniserver which is 10x better than xamp http://www.uniformserver.com/

 

[_Aion_]

but I think there is problem with mysql but with something in my table

 

[Gsp]

there are many people who use this quest and you are the only one with this problem. i don't think it has anything to do with tables

 

[_Aion_]

I also do not understand this, among several people this forum, I am the only one with this problem ...
and not only is this system of quest

 

[Ninja]

Would you mind posting a script that corrupts the storage value (not grizzly adams)?

- - - Edited - - -

Just tested the script myself and didn't have any issues at all. Would you mind posting the whole console error (attempt to perform arithmetic~)?

 

[_Aion_]

Here, other script that corrupts

function onAdvance(cid, skill, oldlevel, newlevel)

local attribute = (getPlayerStorageValue(cid, 47061) + (newlevel - oldlevel) * 2) -- line that show "attempt to perform..."

if skill == 8 then
  doSendMagicEffect(getThingPos(cid), math.random(28, 30))
  doSendAnimatedText(getThingPos(cid), "LEVEL UP!", math.random(1, 255))
  doCreatureAddHealth(cid, getCreatureMaxHealth(cid))
  doCreatureAddMana(cid, getCreatureMaxMana(cid))
  setPlayerStorageValue(cid, 47061, attribute)
  end
  return true
end