Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    Read this thread - Forum database issues
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,209
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    Read this thread - Forum database issues
    Keep checking here for updates.

    Earlier today the was a database corruption which lost thousands of posts. The forum was restored to an earlier point in the day - which effectively lost all the posts between the time of the last backup and the time of the restore - roughly 12 hours.

    At this time - there is still a problem - "Replies" in existing threads are not registering and the time stamp for new posts created in existing threads are not being updated.

    Which means, until this issue is taken care of - you'll not see a recognition of new posts in this thread either...

    So, keep checking in here for any news.

  2. #2
    Read this thread - Forum database issues
    dtravis7's Avatar
    Member Since
    Jan 04, 2005
    Location
    Modesto, Ca.
    Posts
    28,481
    Specs:
    iMac late 2007 10.11.b4, iMac 2008 10.10.5, Macbook2007 10.7.5, Mac Mini 10.7.5, iPhone 3GS Note 8!!
    Thank You Tom for posting this.

  3. #3
    Read this thread - Forum database issues
    pigoo3's Avatar
    Member Since
    May 20, 2008
    Location
    U.S.
    Posts
    31,502
    Specs:
    2011 13" MBP 2.3ghz, 8gig ram, OS 10.7.5
    Thanks Tom.

    - Nick
    - Too many "beachballs", read this: Beachballs
    - Computer seems slower than it used to? Read this for some slow computer tips: Speedup
    - Almost full hard drive? Some solutions. Out of Space
    - Apple Battery Info. Battery

  4. #4
    Read this thread - Forum database issues
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,291
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Thanks Tom. Let's hope they get it straightened out before long.
    Last edited by eebean2; 03-15-2014 at 10:03 AM. Reason: Re-wording

  5. #5
    Read this thread - Forum database issues
    XJ-linux's Avatar
    Member Since
    Jul 02, 2007
    Location
    Going Galt...
    Posts
    3,418
    Specs:
    MacBookAir5,2:10.9.5-MacMini3,1:10.9.5-iPhone6,1:8.3
    Restoring databases is always a fun rabbit hole to go down. Best wishes to those working out the kinks. Not sure what your restore method is, but I'm sure it will work out eventually.
    Never judge a man, untill you have walked a mile in his shoes...
    That way you'll be a mile away from him, and you'll have his shoes.

  6. #6
    Read this thread - Forum database issues
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,209
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    Sent another email off.

    My 2 previous posts this morning did indeed update the Replies & Last Post inside the forum and updated the 'Today's Posts' link - but I still see no updating for anyone else's posts.

    They also returned a database error, but the replies posted twice.

    Also, seeing a random issue of only being able to access the 1st page of a multi-page thread.

    If you're seeing other issues, let me know so I can pass it along.

    Appreciate everyone's continued patience.



    ...
    We'll see if this one updates...

    edit: it did not update and posted twice.

    iNet: Here is the database error:

    Code:
    Database error in vBulletin 3.8.7:
    
    Invalid SQL:
    
    				INSERT INTO postlog
    				(postid, useragent, ip, dateline)
    				VALUES
    				(1572434, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.74.9 (KHTML, like Gecko) Version/7.0.2 Safari/537.74.9', 1182457143, 1394972169);
    
    MySQL Error   : Duplicate entry '1572434' for key 'PRIMARY'
    Error Number  : 1062
    Request Date  : Sunday, March 16th 2014 @ 08:16:09 AM
    Error Date    : Sunday, March 16th 2014 @ 08:16:09 AM
    Script        : http://www.mac-forums.com/forums/new...reply&t=309498
    Referrer      : http://www.mac-forums.com/forums/new...se-issues.html
    IP Address    : xx.xxx.xx.x
    Username      : bobtomay
    Classname     : vB_Database
    MySQL Version : 5.5.35-33.0-log
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  7. #7
    Read this thread - Forum database issues
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,209
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    Well, it did update - several minutes later.

    And no error on this reply and only a single post.
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  8. #8
    Read this thread - Forum database issues
    TattooedMac's Avatar
    Member Since
    May 19, 2009
    Location
    Waiting for a mate . . .
    Posts
    8,379
    Specs:
    21" iMac 2.9Ghz 16GB RAM & 13"MBP 2.9Ghz i7 8GB RAM 10.10.3, iPhone5 & iPad Air 2 iOS 8.3, ATV3
    Thanks Tom, I felt something amiss, as it felt empty today in here, with no updates, or in my CP.

    Will keep a eye on your updates. Bookmarked incase its not working properly
    Dont forget to use the Reputation System if someone has helped you out !!!
    Arguing with a zealot is only slightly easier than tunneling through a mountain with your forehead!!!!!
    MoTM ☆☆☆

  9. #9
    Read this thread - Forum database issues
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,209
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    TM, are you seeing your posts update?

    I'm seeing my posts update the 'Todays Posts' link - but yours are not.

    edit:
    Apparently, it's just taking a few minutes - now I can see your post has updated, but mine is not showing.
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  10. #10
    Read this thread - Forum database issues
    dtravis7's Avatar
    Member Since
    Jan 04, 2005
    Location
    Modesto, Ca.
    Posts
    28,481
    Specs:
    iMac late 2007 10.11.b4, iMac 2008 10.10.5, Macbook2007 10.7.5, Mac Mini 10.7.5, iPhone 3GS Note 8!!
    Tom, thanks for following through on this. This is the first time since the DB issue I got posts in New Posts!

  11. #11
    Read this thread - Forum database issues
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,209
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    Yeah, I haven't seen either yours or Bryan's posts update here.
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  12. #12
    Read this thread - Forum database issues
    vansmith's Avatar
    Member Since
    Oct 19, 2008
    Location
    Toronto
    Posts
    19,398
    Specs:
    2012 13" MBP (2.5 i5, 8GB)
    Now for the technical (as best I can): each post is stored in a row in a database (think of a row in an Excel or Numbers document). Each row has multiple columns that need to be filled in with values. In the post by bobtomay, this includes a post id, a user agent string, an ip, and a date (this goes for all people but I'll use his post with the error as an example). One of these columns has to have a value that no other row has which, according to the error, is the post id column. This makes sense - people can have the same IP, user agent and can post at exactly the same time but each post is unique so each row will have a unique post id. This is why the post id is a 'primary key.'

    The error is quite simple: it's effectively saying that the post id for bobtomay's post is the same as another in the database. In other words, his post id is the same as someone else's. This throws an error since his post id has to be unique (otherwise, his post would overwrite someone else's).

    Think of it this way - people in a country can share a birthday, a name, an address, etc. but no two people can share something like a passport number. In this error, bobtomay's post is sent to the database with the same "passport number" as someone else which throws an error.

    In case anyone wanted to know.
    Important Links: Community Guidelines : Use the reputation system if you've been helped.
    M-F Blog :: Write for the blog
    Writing a Quality Post

  13. #13
    Read this thread - Forum database issues
    RavingMac's Avatar
    Member Since
    Jan 07, 2008
    Location
    In Denial
    Posts
    7,765
    Specs:
    4GB Mac Mini 2012, 13" MBA, 15" MacBook Pro OSX 10.7, 32 GB iPhone 3GS, iPad2 64gb 3G
    I am seeing new posts now
    I've always wanted to be smart, handsome and modest. But, I guess I'll have to be satisfied with two out of three . . .

  14. #14
    Read this thread - Forum database issues
    RavingMac's Avatar
    Member Since
    Jan 07, 2008
    Location
    In Denial
    Posts
    7,765
    Specs:
    4GB Mac Mini 2012, 13" MBA, 15" MacBook Pro OSX 10.7, 32 GB iPhone 3GS, iPad2 64gb 3G
    This posted . . . though I immediately got the 'Database Error' page. So, obviously still having problems.
    I've always wanted to be smart, handsome and modest. But, I guess I'll have to be satisfied with two out of three . . .

  15. #15
    Read this thread - Forum database issues
    XJ-linux's Avatar
    Member Since
    Jul 02, 2007
    Location
    Going Galt...
    Posts
    3,418
    Specs:
    MacBookAir5,2:10.9.5-MacMini3,1:10.9.5-iPhone6,1:8.3
    Oddly enough, when I go to "Control Panel" > "List Subscriptions" link, I only see two subscriptions for threads that were started on the 14th. I should normally have about 800+ subscribed threads. Just an FYI in case it is systemic and not just me.
    Never judge a man, untill you have walked a mile in his shoes...
    That way you'll be a mile away from him, and you'll have his shoes.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database auto-read folder items
    By WideScreenWiz in forum OS X - Apps and Games
    Replies: 1
    Last Post: 04-27-2010, 11:33 AM
  2. Replies: 2
    Last Post: 05-12-2008, 12:28 PM
  3. Database forum
    By dmonk in forum Community Suggestions and Feedback
    Replies: 1
    Last Post: 08-24-2003, 04:54 PM

Posting Permissions

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