Announcement

Collapse
No announcement yet.

5.0.5 Error when uploading files to topics

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

  • 5.0.5 Error when uploading files to topics

    I am receiving the following error when attempting to upload attachments.

    exception_trace file name.zip

    I would like to be able to upload 50 or 100mb attachments since we have unlimited storage space.

    Let me know what we need to do for this.

  • #2
    Here is the error i am receiving via email

    Database error in vBulletin 5.0.5:


    [Showing truncated query, original length: 18296507]
    [First 500 chars]
    Invalid SQL:
    INSERT INTO vB_filedata (`userid`,`dateline`,`filesize`,`filehash`,`extension`,`refcount`,`filedata`)
    VALUES('1',1388010549,17822974,'d8faeeae1b5251827350e2f5bf2d4fc4','zip',0,'PK\n\0\0\0\0\ 0±q¿4\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\089-90_240sx/PK\n\0\0\0\0\0Ïq¿4\0\0\0\0\0\0\0\0\0\0\0\0\0\0\089-90_240sx/files/PK\0\0\0\0é¡™0?†„›Z\0©‚\0\0\0\089-90_240sx/files/24l_four.pdfÌyuX”]×/ˆ€€<t‰â€tMRÒÝ%Í\0CÃ(‚´4HƒH‡´Hƒ„\"J7’’rÐçyÞ÷ýÎùÎùþ:s]k~kï{íµö¾¯ë^7“ª¤4˜›—i~¡ˆ \0
    [Last 500 chars]
    g\0ÿÜ\0\0\0\0\0\0\0\0\0\0 \0\0\0œô89-90_240sx/files/wheel_al.pdfPK\0\0\0\0\0ª£™0û˜ƒ2=i\0bî\0\0\0\0\0\0\0\0\0\0 \0\0\0ê[89-90_240sx/files/wiper_wa.pdfPK\0\0\0\0\0°£™0}žS~=º\0³Â\0\0\0\0\0\0\0\0\0\0 \0\0\0cÅ89-90_240sx/files/wiring_2.pdfPK\0\0\0\0\0´£™0˜ˆ²r³R\0)E\0\0\0\0\0\0\0\0\0\0 \0\0\0Ü89-90_240sx/files/wiring_d.pdfPK\0\0\0\0\0\nt¿4½Àõ6\0\0c \0\0\Z\0\0\0\0\0\0\0\0\0 \0\0\0ËÒ89-90_240sx/fsm_index.htmlPK\0\0\0\0W\0W\0¯\0\09Û\0\0')
    /**filedata**/;

    MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
    Error Number : 1153
    Request Date : Wednesday, December 25th 2013 @ 05:29:09 PM
    Error Date : Wednesday, December 25th 2013 @ 05:29:10 PM
    Script : http:///forum/uploader/upload
    Referrer : http://www.super-wow.com/forum/new-content/36
    IP Address : 12.111.84.66
    Username : superwowadmin
    Classname : vB_Database_MySQLi
    MySQL Version : 5.1.72-cll

    Comment


    • #3
      the 'max_allowed_packet' is smaller than the file you are trying to upload.

      You should consider moving attachments to your file system so you don't need to deal with this limitation, info on how to do that is in the manual, here-
      https://www.vbulletin.com/docs/html/...hments_storage

      There is also a php file size limit set by your host, make sure that value is larger than the largest file you want to upload.

      Comment


      • #4
        Thanks for the info! I could not find the instructions on how to do that permanently. I found something that looks like it shows you how to move them out of the database and into the file system but it does not sound permanent. If you could like me directly to the instructions for that i may give it a shot.

        Thanks!

        Comment


        • #5
          If you move attachments into the file system, it is a one time move, and all of the old attachments are moved, and new attachments go into there by default.

          Comment


          • #6
            What path would you recommend creating to store the attachments?

            Comment


            • #7
              One that is not available via the web, so at the same level of public_html

              Comment


              • #8
                I have made the change. Now i am receiving this error message.
                "There has been a database error, and the current page cannot be displayed. Site staff have been notified."

                I receive an email stating the following.
                Database error in vBulletin 5.0.5:

                Invalid SQL:
                INSERT INTO vB_closure (parent, child, depth, publishdate)
                SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
                FROM vB_node AS node
                INNER JOIN vB_closure AS parent ON parent.child = node.parentid
                WHERE node.nodeid = 183
                /**addClosure**/;

                MySQL Error : Duplicate entry '2-183' for key 'closure_uniq'
                Error Number : 1062
                Request Date : Monday, December 30th 2013 @ 09:13:19 PM
                Error Date : Monday, December 30th 2013 @ 09:13:19 PM
                Script : http:///forum/create-content/text/
                Referrer : http://www.super-wow.com/forum/new-content/36
                IP Address : 12.111.84.66
                Username : superwow
                Classname : vB_Database_MySQLi
                MySQL Version : 5.1.72-cll

                Hopefully we can get this squared away, thanks for the help.

                Comment


                • #9
                  Also tried this from a different user account and got the following message.

                  Database error in vBulletin 5.0.5:

                  Invalid SQL:
                  INSERT INTO vB_closure (parent, child, depth, publishdate)
                  SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
                  FROM vB_node AS node
                  INNER JOIN vB_closure AS parent ON parent.child = node.parentid
                  WHERE node.nodeid = 184
                  /**addClosure**/;

                  MySQL Error : Duplicate entry '2-184' for key 'closure_uniq'
                  Error Number : 1062
                  Request Date : Wednesday, January 1st 2014 @ 03:29:01 AM
                  Error Date : Wednesday, January 1st 2014 @ 03:29:01 AM
                  Script : http:///forum/create-content/text/
                  Referrer : http://www.super-wow.com/forum/new-content/36
                  IP Address : 108.67.152.74
                  Username : superwowadmin
                  Classname : vB_Database_MySQLi
                  MySQL Version : 5.1.72-cll

                  Comment


                  • #10

                    Originally posted by superwow View Post

                    I would like to be able to upload 50 or 100mb attachments since we have unlimited storage space.

                    Let me know what we need to do for this.
                    Don't take your host's word seriously about that "unlimited storage space".
                    Videos could be easily that large, causing a warning not to upload them.


                    vB5 is unequivocally the best forum software, but not yet...

                    Comment


                    • #11
                      Originally posted by superwow View Post
                      Also tried this from a different user account and got the following message.

                      Database error in vBulletin 5.0.5:

                      Invalid SQL:
                      INSERT INTO vB_closure (parent, child, depth, publishdate)
                      SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
                      FROM vB_node AS node
                      INNER JOIN vB_closure AS parent ON parent.child = node.parentid
                      WHERE node.nodeid = 184
                      /**addClosure**/;

                      MySQL Error : Duplicate entry '2-184' for key 'closure_uniq'
                      Error Number : 1062
                      Request Date : Wednesday, January 1st 2014 @ 03:29:01 AM
                      Error Date : Wednesday, January 1st 2014 @ 03:29:01 AM
                      Script : http:///forum/create-content/text/
                      Referrer : http://www.super-wow.com/forum/new-content/36
                      IP Address : 108.67.152.74
                      Username : superwowadmin
                      Classname : vB_Database_MySQLi
                      MySQL Version : 5.1.72-cll

                      In Admin CP -> Maintenance -> Repair / Optimize Tables, at the bottom is an option to fix unique indexes, try running that.

                      Comment


                      • #12
                        Tried that as well.

                        Database error in vBulletin 5.0.5:

                        Invalid SQL:
                        INSERT INTO vB_closure (parent, child, depth, publishdate)
                        SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
                        FROM vB_node AS node
                        INNER JOIN vB_closure AS parent ON parent.child = node.parentid
                        WHERE node.nodeid = 180
                        /**addClosure**/;

                        MySQL Error : Duplicate entry '36-180' for key 'closure_uniq'
                        Error Number : 1062
                        Request Date : Wednesday, January 1st 2014 @ 10:09:40 PM
                        Error Date : Wednesday, January 1st 2014 @ 10:09:40 PM
                        Script : http:///forum/create-content/text/
                        Referrer : http://www.super-wow.com/forum/new-content/36
                        IP Address : 108.67.152.74
                        Username : superwowadmin
                        Classname : vB_Database_MySQLi
                        MySQL Version : 5.1.72-cll

                        Comment


                        • #13
                          Any ideas on this?

                          Comment


                          • #14
                            Fix Unique indexes won't do anything to fix this. All it does is check old vBulletin 4 tables to see if they have an auto-increment index. If they don't it adds them. It will do nothing with the 5.X tables.

                            closure_uniq is an index on the parent and child fields. These are derived from the nodeid. I suggest increasing the nodeid autoincrement to be higher than your max child value in that table. Not sure how your transactions would have gotten out of sync though unless you tried to delete content directly from the database for some reason.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud demonstration site.
                            vBulletin 5 API - Full / Mobile
                            Vote for your favorite feature requests and the bugs you want to see fixed.

                            Comment


                            • #15
                              I definitely have not done anything like that. This is a pretty much brand new installation with hardly any modifications done. The latest thing i did was change the setting to store attachments in the file system instead of the DB. I could not attach large files because of that and now i cannot attach large files because of this.

                              Where do we change this nodeid autoincrement and how do i find out what the max child value is in that table? Everything is default settings, the last thing i want to do is start poking around the DB haha.

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X