2,147,483,647 Point Limit

  • Resolved Agent Deepak

    (@agentdeepak)


    11 years, 1 month ago

    I didn’t know 2,147,483,647 was the highest int number and tried to Adjust point balance with a big number for a particular account and now the total of that particular account always say 2,147,483,647.

    How do I remove this? or change to a specific amount?

    Even SQL/DB help is welcomed.

    PS: If you didn’t know, then now that you know you should informed myCRED users about this Point Limit.

    https://wordpress.org/plugins/mycred/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Agent Deepak

    (@agentdeepak)

    11 years, 1 month ago

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

    Plugin Author myCred

    (@designbymerovingi)

    11 years ago

    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?

    Thread Starter Agent Deepak

    (@agentdeepak)

    10 years, 11 months ago

    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.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘2,147,483,647 Point Limit’ is closed to new replies.