Problem With database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chicote
    New Member
    • Jan 2007
    • 13

    Problem With database

    when i try uploading atachemetts, a zip file with 4mb, but the limit to uploading is 5mb, it appeared an error in popup of the atachementts.

    error 1153

    Code:
    MySQL Error  : Got a packet bigger than 'max_allowed_packet' bytes
    Error Number : 1153
    Date         : Tuesday, March 27th 2007 @ 08:05:12 PM
    Script       : http://www.infodigital.ws/board/newattachment.php?do=manageattach&p=
    Referrer     : http://www.infodigital.ws/board/newattachment.php?f=28&poststarttime=1175022169&posthash=5545364bf4519e8e97d081ac9d28210f
    IP Address   : 82.154.146.169
    Username     : chicote
    Classname    : vB_Database
    I leave a file in anexe with complete error.

    help me please..

    download here
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    MySQL is telling you its limit is lower than what you're trying to upload. You'll either need to set the max_allowed_packet to something higher than it currently is or switch to the file storage method for attachments.

    Comment

    • chicote
      New Member
      • Jan 2007
      • 13

      #3
      I have this in my ini-file

      Code:
       ;;;;;;;;;;;;;;;;
      ; File Uploads ;
      ;;;;;;;;;;;;;;;;
      
      ; Whether to allow HTTP file uploads.
      file_uploads = On
      
      ; Temporary directory for HTTP uploaded files (will use system default if not
      ; specified).
      ;upload_tmp_dir =
      
      ; Maximum allowed size for uploaded files.
      upload_max_filesize = 20M
      not this

      Code:
      max_allowed_packet
      what it is this "20M" ? it will be 20mb ?


      I want that it gives uploads of the 5 mb minimum, what I must modify in this code?


      thank you..

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        That is your php.ini not your my.cnf.

        Comment

        • chicote
          New Member
          • Jan 2007
          • 13

          #5
          where folder of the ftp is this file (my.cnf.)?

          I spoke with host they had said that it had to modify the php5.ini file, and I make download of this file and I found this code.

          I do not know where to find the file my.cnf

          thanks

          Comment

          • Zachery
            Former vBulletin Support
            • Jul 2002
            • 59097

            #6
            You most likely need to have root access to the server, if you do not you're host will have to make this change.

            Comment

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