Thanks for visiting us!

Badminton Central is a free community for fans of badminton! If you find anything useful here please consider registering to see more content and get involved with our great community users, it takes less than 15 seconds! Everybody is welcome here.

Click here for a FREE account!

Migration Posts

Discussion in 'Forum Feedback' started by UkPlayer, May 1, 2002.

  1. UkPlayer

    UkPlayer Regular Member

    Joined:
    Apr 25, 2002
    Messages:
    970
    Likes Received:
    0
    Occupation:
    Academic
    Location:
    UK
    Minor glitch now that the number of posts per day is incorrect & irrelevant.
    For instance cooler has over 300 posts per day now!!
    Thought I'd report this.
     
  2. kwun

    kwun Administrator

    Joined:
    Apr 24, 2002
    Messages:
    39,280
    Likes Received:
    549
    Occupation:
    BC Janitor
    Location:
    Santa Clara, CA, USA
    thanks. yes.

    that'd be one of the less fixable bugs. not impossible, but it will require writing a program to go plow through the db and look for say, when cooler first posted, and make that his registration date. but... ugh. that would take a bit of hacking... :( :(
     
  3. Winex West Can

    Winex West Can Regular Member

    Joined:
    Apr 25, 2002
    Messages:
    2,397
    Likes Received:
    0
    Occupation:
    Hi Tech
    Location:
    Vancouver, Canada
    Hey Kwun,
    You should able to do something like:

    UPDATE members
    SET registration_date = (SELECT MIN(posting_date)
    FROM posts
    WHERE posts.member_id = member_id)

    or something similar. Not sure of mySQL syntax as my background is in Oracle DB.
     
  4. UkPlayer

    UkPlayer Regular Member

    Joined:
    Apr 25, 2002
    Messages:
    970
    Likes Received:
    0
    Occupation:
    Academic
    Location:
    UK
    If Winex West Can's suggestion doesn't work the what about just removing it? If it's meaningless it doesn't need to be there.
     
  5. Matt

    Matt Regular Member

    Joined:
    Apr 25, 2002
    Messages:
    3,514
    Likes Received:
    3
    Occupation:
    IT Developer
    Location:
    Richmond, BC
    I don't think it's a major problem since you are not just going to look at every user's profile. Every user is affected so we may have to live with it.
     

Share This Page