Announcement

Collapse
No announcement yet.

Attachment problems

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

  • Attachment problems

    Noone can upload pictures to their postings. This is the error message I recieve by Email (error report):

    Invalid SQL:
    INSERT INTO attachment
    (userid, dateline, filename, filesize, visible, filehash, posthash, thumbnail, thumbnail_dateline)
    VALUES
    (1, 1097777595, 'stoppie.jpg', 122548, 1, '12ac8cb6f94a451f37f6fd6aa4309717', 'cc4ac14c8b9ce2c82fda12d336f9c020', 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0>CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), default quality\nÿÛ\0C\0 \n \r \Z\Z $.\' \",#(7),01444\'9=82<.342ÿÛ\0C \r\r2!!22222222222222222222222222222222222222222222222222ÿÀ\0\0T\0È\"\0ÿÄ\0\ 0\0\0\0\0\0\0\0\0\0 \n ÿÄ\0µ\0\0\0}\0!1AQa\"q2'¡#B±ÁRÑð$3br, \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcde........(I HAVE SHORTED THIS DOWN).......SYÿ\0Ym<sÓ*Gûïþñ¨ÿ\0¾§úS\0r)¬\0å^>~§7ú¶ü?~¦ÃѨ¿tF)UÈNAô#åê~fù\nl?v O¥\0\0'~Nh¦zÿ\0½E?ÿÙ', 1097777595)


    mysql error: Duplicate entry '65535' for key 1

    mysql error number: 1062

    Date: Thursday 14th of October 2004 08:13:15 PM
    Script: http://www.sporthoj.com/forum/newattachment.php
    Referer: http://www.sporthoj.com/forum/newattachment.php?f=21&poststarttime=1097777488&posthash=cc4ac14c8b9ce2c82fda12d336f9c020


    I am able to switch out my avatar and profile picture.

    What is wrong?

  • #2
    You've got an old setting in the attachment table. To fix this you need to edit the attachmentid field in the attachment table and change it to type:

    int(10)
    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.. it works now
      Last edited by R1Swedie; Thu 14 Oct '04, 12:07pm.

      Comment

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