User Tag List

Results 1 to 5 of 5

Thread: Migration Posts

  1. #1
    Regular Member
    Join Date
    Apr 2002
    Location
    UK
    Posts
    964
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Migration Posts

    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. #2
    Administrator kwun's Avatar
    Join Date
    Apr 2002
    Location
    Santa Clara, California, United States
    Posts
    36,130
    Mentioned
    55 Post(s)
    Tagged
    2 Thread(s)

    Default

    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. #3
    Regular Member
    Join Date
    Apr 2002
    Location
    Vancouver, Canada
    Posts
    2,373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    Regular Member
    Join Date
    Apr 2002
    Location
    UK
    Posts
    964
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    Regular Member
    Join Date
    Apr 2002
    Location
    Richmond, BC
    Posts
    5,209
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Similar Threads

  1. Migration from a Junior rank player to Senior Level.
    By gemini12 in forum Professional Players
    Replies: 6
    : 06-21-2008, 03:41 PM
  2. 400,000 posts!!!
    By kwun in forum Forum Feedback
    Replies: 22
    : 10-16-2006, 08:08 PM
  3. 100,000 posts !
    By kwun in forum General Forum
    Replies: 41
    : 12-25-2004, 07:23 PM
  4. Migration successful!!
    By kwun in forum General Forum
    Replies: 7
    : 05-01-2002, 11:13 PM

Bookmarks

Posting Permissions

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