Migration Posts

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

  1. UkPlayer

    UkPlayer Regular Member

    Joined:
    Apr 25, 2002
    Messages:
    1,163
    Likes Received:
    200
    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:
    41,048
    Likes Received:
    2,073
    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:
    2
    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:
    1,163
    Likes Received:
    200
    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:
    607
    Likes Received:
    10
    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