Help! Power outage and database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SloppyGoat
    Senior Member
    • Feb 2002
    • 674

    Help! Power outage and database error

    What do I do? How do I fix this? I'm currently restoring last night's backup of MySQL folder. Hopefully, that will fix this, but if not, how would I go about fixing this?

    Database error in vBulletin 3.6.5:
    Invalid SQL:
    INSERT INTO ewt_statistics
    (uid, sectionid, thisscript, ipaddy, useragent)
    VALUES
    (1, 0, 'index', '192.168.10.8', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648)');
    MySQL Error : Duplicate entry '1916549' for key 1
    Error Number : 1062
    Date : Friday, November 7th 2008 @ 02:18:04 PM
    Script : http://tga.sytes.net/index.php
    Referrer :
    IP Address : 192.168.10.8
    Username : MyUsername
    Classname : vB_Database
    The Grey Area - Tweaking Obsession
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    That's not a vBulletin table. I has not idea how to fix that. You should contact the author of that add-on for help.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • SloppyGoat
      Senior Member
      • Feb 2002
      • 674

      #3
      Any idea what it is? I have no idea.
      The Grey Area - Tweaking Obsession

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Not really. Sorry.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • SloppyGoat
          Senior Member
          • Feb 2002
          • 674

          #5
          Well, it has something to do with ewt stats, whatever the hell that is. Luckily, my backup worked and I'm back up and running. Yeah, I know. I need to update to 3.7.4. I plan to very soon, but severe back pain is keeping me from doing much of anything at the moment.

          Thanks anyway, Steve. If anyone knows what this error was about, I'd still like to know. Feel free to chime in, if you know something about what this could've happened here.

          My god! I did a google search for ewt statistics and this thread has already been indexed! Damn, that was fast! (0_o)
          Last edited by SloppyGoat; Fri 7 Nov '08, 12:21pm.
          The Grey Area - Tweaking Obsession

          Comment

          • SloppyGoat
            Senior Member
            • Feb 2002
            • 674

            #6
            It appears it's just a minor add on.

            What it does:
            Adds a "total page views", "total members", "total posts", ect. to the "What's Going On" box at the bottom of forumhome.
            The Grey Area - Tweaking Obsession

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...