Welcome to FinHeaven Fans Forums! We're glad to have you here. Please feel free to browse the forum. We'd like to invite you to join our community; doing so will enable you to view additional forums and post with our other members.



VIP Members don't see these ads. Join VIP Now
Results 1 to 5 of 5

Thread: Points not recording...

  1. -1
    Waterlogged

    Status:
    Offline
    WPA:
    Join date:
    May 2002
    Posts:
    17,876
    vCash:
    1000
    Loc:
    In a land far, far away
    Thanks / No Thanks

    Points not recording...

    I've been "stuck" at 32767 points... but have posted several times... is there a cap on the amount you can have?

    I notice that 39 and I both have the exact same amount....

    just wondering...
    Quote Quote  

  2. -2
    FinHeaven Lives

    Status:
    Offline
    WPA:
    Join date:
    Sep 2001
    Posts:
    3,809
    vCash:
    1400
    Loc:
    Atlanta, GA
    Thanks / No Thanks
    Oook, it's been fixed... Here's the reason for the error...

    In the database, I was using smallint for the field "points." Anyone that knows databases, knows that smallint can only go up to 32767. So, I went in and changed it to mediumint, which can go as high as 8,388,607. The only drawback is size, as mediumint is 4 bytes, compared to 3 bytes with smallint.

    Ok, enough tech talk , the problem is fixed. :cool:
    AJ Tatum

    "If carrots got you drunk, rabbits would be messed up."
    - Mitch Hedberg
    Quote Quote  

  3. -3
    Clumpy's Avatar
    is Clumpalicious!!

    Status:
    Offline
    WPA:
    Join date:
    Dec 2001
    Posts:
    9,330
    vCash:
    1000
    Loc:
    Clumptowaga
    Thanks / No Thanks
    Thanks.........clear as mud
    Quote Quote  

  4. -4
    Waterlogged

    Status:
    Offline
    WPA:
    Join date:
    May 2002
    Posts:
    17,876
    vCash:
    1000
    Loc:
    In a land far, far away
    Thanks / No Thanks
    Originally posted by FinHeavenAJ
    Oook, it's been fixed... Here's the reason for the error...

    In the database, I was using smallint for the field "points." Anyone that knows databases, knows that smallint can only go up to 32767. So, I went in and changed it to mediumint, which can go as high as 8,388,607. The only drawback is size, as mediumint is 4 bytes, compared to 3 bytes with smallint.

    Ok, enough tech talk , the problem is fixed. :cool:
    You Da Man AJ!!!
    Quote Quote  

  5. -5
    Waterlogged

    Status:
    Offline
    WPA:
    Join date:
    May 2002
    Posts:
    17,876
    vCash:
    1000
    Loc:
    In a land far, far away
    Thanks / No Thanks
    Originally posted by clumpedplatelet
    Thanks.........clear as mud
    I understood it clumpy!
    Quote Quote  

Similar Threads

  1. Recording DVD from DVR
    By Austin Tatious in forum The Lounge
    Replies: 0
    Last Post: 12-27-2012, 12:21 PM
  2. Recording Music Via PC
    By Muck in forum The Lounge
    Replies: 3
    Last Post: 10-11-2006, 09:55 PM
  3. Santorum Trails Casey By 23 Points - Lynn Swann Down 18 Points
    By Blitz in forum Political | War Forum
    Replies: 6
    Last Post: 06-01-2006, 08:11 AM
  4. Replies: 2
    Last Post: 05-14-2006, 08:37 PM
  5. Recording on DVD
    By Coots82 in forum The Lounge
    Replies: 6
    Last Post: 08-16-2005, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •