10 Mar

MySQL error when uploading a 1.8MB PDF file to 2.3.2

Posted by admin under enart.hubeidaxue.com

  • Any Suggestions? MySQL is 4.0.13-nt.

    Database error in vBulletin 2.3.2:

    Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,vi sible) VALUES (NULL,1,1060791707,'guderletter.pdf','%PDF-1.3
    %âãÏÓ
    1 0 obj
    <<
    /Type /ExtGState
    /SA false
    /OP false
    /HT /Default
    >>
    endobj
    2 0 obj
    <<
    /Type /Halftone
    /HalftoneType 1
    /HalftoneName (Default)
    /Frequency 60
    /Angle 45
    /SpotFunction /Round
    >>
    endobj
    4 0 obj
    <<
    /Type /XObject
    /Subtype /Image
    /Name /Im1
    /Width 1700
    /Height 2200
    /BitsPerComponent 8
    /ColorSpace /DeviceGray
    /Length 458408
    /Filter /DCTDecode
    >>
    stream
    (binary data removed!)
    endstream
    endobj
    17 0 obj
    <<
    /Length 50
    >>
    stream
    /GS1 gs
    q
    612.00 0 0 792.00 0 0 cm
    /Im4 Do
    Q
    endstream
    endobj
    18 0 obj
    <<
    /ProcSet [/PDF /ImageC ]
    /XObject <<
    /Im4 16 0 R
    >>
    /ExtGState <<
    /GS1 1 0 R
    >>
    >>
    endobj
    19 0 obj
    <<
    /Type /Page
    /Parent 3 0 R
    /Resources 18 0 R
    /Contents 17 0 R
    /MediaBox [0 0 612 792]
    >>
    endobj
    3 0 obj
    <<
    /Type /Pages
    /Kids [
    7 0 R
    11 0 R
    15 0 R
    19 0 R
    ]
    /Count 4
    /MediaBox [0 0 595 842]
    >>
    endobj
    20 0 obj
    <<
    /Type /Catalog
    /Pages 3 0 R
    >>
    endobj
    21 0 obj
    <<
    /Author ()
    /Creator ()
    /Producer ()
    /Title ()
    /Subject ()
    /Keywords ()
    /CreationDate (D:20030811112108)
    >>
    endobj
    xref
    0 22
    0000000000 65535 f
    0000000017 00000 n
    0000000096 00000 n
    0001895930 00000 n
    0000000228 00000 n
    0000458834 00000 n
    0000458940 00000 n
    0000459051 00000 n
    0000459164 00000 n
    0001149585 00000 n
    0001149691 00000 n
    0001149803 00000 n
    0001149918 00000 n
    0001764235 00000 n
    0001764342 00000 n
    0001764455 00000 n
    0001764571 00000 n
    0001895594 00000 n
    0001895701 00000 n
    0001895814 00000 n
    0001896047 00000 n
    0001896103 00000 n
    trailer
    <<
    /Size 22
    /Root 20 0 R
    /Info 21 0 R
    >>
    startxref
    1896240
    %%EOF
    ','1')
    mysql error: MySQL server has gone away

    mysql error number: 2006

    Date: Wednesday 13th of August 2003 12:21:47 PM
    Script: http://ptsem.presidentsearch.org/bbs/bbs/newthread.php
    Referer: http://ptsem.presidentsearch.org:81/bbs/newthread.php?action=newthread&forumid=15


  • Well, I basically copyied the file C:mysqlmy-huge.cnf to c:my.cnf, stopped and started the service, and everything is fine now!

    Thanks for the help and prompt service!

    I had the exact same problem today, although, I swear this has only begun happening since upgrading to 2.3.2 (ok, I don't swear that I don't know that I've put attachments up over 1MB before).... ;) ;)

    anyhow, for others that stumble across this thread you can change this setting from the WinMySQLAdmin "application" by opening it, clicking on the "my.ini setup" tab, and adding the following line into the text box:

    set-variable=max_allowed_packet=12345125

    of course, change this # to be the proper # of bytes you'd like it to accept. save the changes then stop/start the service and you're golden.


  • So, I can't figure out how to change the max_allowed_packet.

    It seems I would change the my.cnf file, but there isn't one on my system (w2k).


  • Max Packet size is more likely 1mb which is the default, though you'd have to check.


  • bill.french,

    To get vB support on these forums you first need to register for Priority Forum Support. To do this, please click HERE (http://www.vbulletin.com/members/forums.php) and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page. Thanks.


  • There was a glitch in the system. You're showing up as licensed now. Thanks!


  • bill.french,

    To get vB support on these forums you first need to register for Priority Forum Support. To do this, please click HERE (http://www.vbulletin.com/members/forums.php) and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page. Thanks.

    I did that earlier today.


  • So, I can't figure out how to change the max_allowed_packet.

    It seems I would change the my.cnf file, but there isn't one on my system (w2k).
    do a search on your server and try and find a my.ini or my.cnf it could be i system folder, if not you need to create a my.cnf file at c:my.cnf


  • Go into PhpMyAdmin and type:

    REPAIR TABLE attachment

    Or upload repair.php to your admin directory and run it.


  • Go into PhpMyAdmin and type:

    REPAIR TABLE attachment

    Or upload repair.php to your admin directory and run it.

    Thanks, but no dice.

    SQL-query

    SQL-query : [Edit] [Create PHP Code]
    REPAIR TABLE attachment

    Table Op Msg_type Msg_text
    ptssearch.attachment repair status OK

    I get the same error.


  • What webserver are you running?

    Both the web server and the mysql server are plain vanilla w2k/iis.


  • Well, I basically copyied the file C:mysqlmy-huge.cnf to c:my.cnf, stopped and started the service, and everything is fine now!

    Thanks for the help and prompt service!


  • What webserver are you running?


  • is in fact 10485576 - i was able to find it. However, how do I change it?

    (forgive my total ignorance!) In the mean time I'm searching for the answer. Thanks -- Bill







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about MySQL error when uploading a 1.8MB PDF file to 2.3.2 , Please add it free.
    | |