Announcement

Collapse
No announcement yet.

Database error with attachments

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error with attachments

    I changed it to INT like other posts said to do and also 10. However I am still getting these errors.. sometimes it works.. sometimes it doesnt.

    Database error in vBulletin 3.0.0:

    Invalid SQL:
    INSERT INTO attachment
    (userid, dateline, filename, filedata, filesize, visible, filehash,
    posthash, thumbnail)
    VALUES
    (31213, 1084533731, 'Helmet2.jpg',
    'ÿØÿà\0JFIF\0,,\0\0ÿÛ\0C\0

    mysql error: Duplicate entry '65535' for key 1

    mysql error number: 1062

    Date: Friday 14th of May 2004 06:22:11 AM
    Script: http://www.sportbikes.net/forums/newattachment.php
    Referer:
    http://www.sportbikes.net/forums/newattachment.php?f=3&poststarttime=1084533405&
    posthash=04389005da8888fa515e649682aabae9
    Username: Gixxer_Six2003
    IP Address: 12.168.127.179

  • #2
    Run Repair/Optimize in the Admin CP:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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


    • #3
      Thanks Steve. I will give that a try right now. Appreciate your time

      Comment


      • #4
        Originally posted by Steve Machol
        Run Repair/Optimize in the Admin CP:

        Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
        Is there a way to do this via mysql shell or something? I am getting time outs when I try to do this via control panel. I got a 3.5 gig database

        Comment


        • #5
          nevermind Steve. It made it through. Couple things said it wasnt closed. I will let you know how it turns out. thanks again!

          Comment

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