Announcement

Collapse
No announcement yet.

database error uploading image

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

  • database error uploading image

    I just got this error if anyone can help me understand what the issue is?

    Code:
    Database error in vBulletin 3.8.2:
    
    Invalid SQL:
    INSERT INTO picture
            (caption, userid, extension, width, height, filesize, thumbnail_filesize, thumbnail_width, thumbnail_height, idhash, thumbnail_dateline, state, filedata, thumbnail)
    VALUES
            ('20090503083510(1)', 4877, 'jpg', 2304, 1296, 1775592, 5117, 150, 84, '35cd93ee8bb75be597c37e5a70a0c8a2', 1254926995, 'visible', 'ÿØÿá îExif\0\0II*\0 \0\0\0 \0   \0 \0\0\0’\0\0\0   \0 \0\0\0²\0\0\0   \0 \0\0\0¸\0\0\0   \0 \0\0\0 \0\0\0\Z  \0 \0\0\0Î\0\0\0   \0 \0\0\0Ö\0\0\0(  \0 \0\0\0 \0\0\01  \0 \0\0\0Þ\0\0\02  \0 \0\0\0ô\0\0\0   \0 \0\0\0 \0\0\0i‡ \0 \0\0\0  \0\0À \0\0                               \0SONY\0\0Sony Picture Utility\0\0H\0\0\0 \0\0\0H\0\0\0 \0\0\0Sony Picture Utility\0\02009:05:09 11:02:42\0       \0\0  \0 \0\0\00221   \0 \0\0\0z \0\0   \0 \0\0\0Ž \0\0 ‘ \0 \0\0\0   \0\0  \0 \0\0\00100   \0 \0\0\0 \0\0\0   \0 \0\0\0\0      \0\0   \0 \0\0\0  \0\0   \0 \0\0\0¢ \0\0\0\0\0\02009:05:03 08:35:30\02009:05:09 11:02:42\0 \0 \0 \0 \0\0\0R98\0 \0 \0 \0\0\00100\0\0\0\0 \0   \0 \0\0\0 \0\0\0   \0 \0\0\0 \0\0\0\Z  \0 \0\0\0\Z \0\0   \0 \0\0\0\" \0\0(  \0 \0\0\0 \0\0\0   \0 \0\0\0* \0\0   \0 \0\0\0» \0\0\0\0\0\0H\0\0\0 \0\0\0H\0\0\0 \0\0\0ÿØÿÛ\0„\0              \n \n\n               \n             \Z % \Z #    , #&\')*)  -0-(0%()(    \n \n \n\n (\Z \Z((((((((((((((((((((((((((((((((((((((((((((((((((ÿÀ\0  \0x\0   !\0      ÿÄ ¢\0\0        \0\0\0\0\0\0\0\0          \n  \0           \0\0 }   \0    !1A  Qa \"q 2 ‘¡ #B±Á RÑð$3br‚  \n    \Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùú \0          \0\0\0\0\0\0                \n  \0           \0  w\0      !1  AQ aq \"2   B‘¡±Á     #3Rð brÑ\n $4á%ñ   \Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz‚ƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚâãäåæçèéêòóôõö÷øùúÿÚ\0   \0    \0?\0ùRŠ\0(  Š\0(  Š\0(  Š\0(  Š\0( \rŸøEõñ»þ$z¯ÊÛOú$œ N i‡Ãzè( ‹©åþèû,Ÿ7ÓŠWErË°²xg^  f‰©®N ëI  Jl  Öî  4}JR§\r²ÕÛ ÐàQt ²ìH¾ ñ #:èZ©EûÌ,ä }x§¯„¼Hÿ\0sÃú»},¤?û- AË.Ä\ráíidhÛGÔD‹Ã)µpGáŠH|?¬Î Á¤j  ûÛ-œãë EÐrË°ŸØ\ZÇËÿ\0  Cæû¿èÏÏÓŠ‚M2þ<ù–7IŽ»¡aý(º Yv$M TxVTÓoZ&8W 9R}Ž)ÿ\0ð ë;K dê GSögÀý(º Iv# FÔäBñé×®€í,°1\0út§  W)¼iwå8ù…»ãž ¨º Yv ] X‰ÕeÒµ f  *œ úR  W  éWáÛ ¿g|ŸÒ‹ å—beðμØÛ¢j‡=1i\'?¥BÚ ¬¤†ÒïÁS‚\r»ñúQt ²ì9|=*2 ]#Q(Ü  σúU ìËýÄ}Šë#¨ò›ü)Ü9%ØúžÎê  -¥ûDŒÆC¹*Ñ K ç © €N?J½åù×¾d*°<k³çNQG\'“ëÓÖ±:Þ†f»$1B’ÊÌŽ ªÈÌ[é· =ý©¾ ½µû Š7KƒóF ‚±÷cëÓšLi  \\ÚË›Ki³æ ,D{ ñ×$ M3R¸6 ¯,;ßo\rè}1Ç9úÒ ÇßA5ö“æ[¦g»¸Ûóá@ œpFp2O_ëQ^@º>Ÿ V÷ ˜]Ld?\\± ›Žƒ  ¥; +#Ÿºiîç?gŽå`ŒùjÅxE  åúÖ>  )½Œ >Y³ Øçn 9ÅR&HèÛS»ŠÉ`X–8 äá0ñžàúçŠÏ¼¸‘a`žiŠF2ïo—y?)ãÓ Š ÞÅ==žÚâH¢™† r£ Ÿ§oþµv6ºÈ{XTX¨ÚULÒ`[email protected]Ôž(\'¡S_Ô {¯6M§b Êó¸ç @#Œz⣹ÓåŒÃug4±# y\"CÀ8 ÆNqO`¹Ði—K-²Æ\\€8Ü*Œ çQêÖ¢EŽXžMü`ï8<óŸóøÒê  iæ?°Í ðÀ–Ý»$ sקCùW5}j˜‘ 
    [TRUNCATED]...
    Thank You...Mick Knutson

    BLiNC Magazine Forums: "Everything you ever wanted to know about BASE-Jumping, but didn't know whom to ask."


  • #2
    I am trying to also track down the userId 4877 but can not seem to find a way to search by userId, only username...

    I was hoping that I can ask that user what they are trying to upload as there have been about 5 failures now.
    Thank You...Mick Knutson

    BLiNC Magazine Forums: "Everything you ever wanted to know about BASE-Jumping, but didn't know whom to ask."

    Comment


    • #3
      It's actually pretty simple, the admin cp frame that allows you to edit the user comes up as the following URL:

      http://YOURSITE.COM/forums/admincp/user.php?do=edit&u=1

      you just have to replace the u=1 with the userid you are attempting to edit, so u=xxxx

      Done.
      anders | vbulletin team | check out the new vbulletin facebook app
      Proudly vBulletin'ing since 2001
      Please be my friend!
      http://www.twitter.com/inetskunkworks
      vBulletin Performance Articles:
      Click here to read

      Comment


      • #4
        The first error message shows that the image you're trying to upload is too large for mysql's max_packet_size and you'll either need to have your host adjust max_packet_size or switch to storing files in the file system.

        Comment


        • #5
          What would you recommend as far as the max size?
          Thank You...Mick Knutson

          BLiNC Magazine Forums: "Everything you ever wanted to know about BASE-Jumping, but didn't know whom to ask."

          Comment


          • #6
            My normal servers run 16mb as the default packet size.

            Comment

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