2,147,483,647 Point Limit

I deleted logs in Database base and somehow the problem was solved.

Hey Agent.

Sorry for the long reply. While I am happy the issue is resolved, could you give me some information about the setup you were using so I can try and prevent this from happening?

Did you change the decimal setup at some point or adjusted the database table’s structure?

Hi Gabriel sorry for late reply, just saw this now.

The problem is simple – 2,147,483,647 is the highest possible ‘Int Value’. This is the INT (integer) computing limit.

So when I tried to add a value twice this. I got stuck. I should have had subtracted this value to go to zero but didn’t as I was new.

I solved my problem by deleting the DB Logs completely. I had just started so it was not a problem.

While most users won’t reach this limit unless they are giving away large points say 10,000 for simple tasks to members. I give 1000 points for a post. 200 for Topics. So unless my site grow like crazy in few months, I myself won’t reach the limit.

I guess the limit can be increased by using ‘float’ instead. I have no idea how it works with PHP. Should be same as C, C++ and Java right.

PS: I will join the main Support Forum on your site soon and re post this there. I have few more questions too.