Announcement

Collapse
No announcement yet.

Erorr When Moving Attachment From Database to File System

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

  • #16
    Looking at the top of your Admin CP when you first sign in (under any News articles) what are the values reported for MySQL Version and MySQL Packet Size?

    Comment


    • #17
      This is your error:
      MySQL server has gone away

      "MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment


      • #18
        Hello joe..

        MySQL Packet Size 1.00 GB

        Comment


        • #19
          MySQL Version 5.5.32-cll

          Comment


          • #20
            Originally posted by Lynne
            This is your error:
            MySQL server has gone away

            "MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.
            I have my own dedicated server. I have read that doc. Still not have idea for solve the issue. I have increase mysql data packet to 1 GB...

            Comment


            • #21
              All your values seem well above minimum except PHP Memory Limit- I would suggest you up it from 64 M to 128 M and try again.

              Comment


              • #22
                Originally posted by Joe D. View Post
                All your values seem well above minimum except PHP Memory Limit- I would suggest you up it from 64 M to 128 M and try again.
                i have increased, the erorr still happened. There is a serious error and the page cannot be rendered

                Argh...i don`t have any idea to solve this problem T_T

                Comment


                • #23
                  i`m willing to pay if Vbulletin Support can help me to solve this problem...

                  Comment


                  • #24
                    still no solution ?

                    Comment


                    • #25
                      Do you have an email address setup in your /core/includes/config.php file to get copies of database errors? If not can you check your MySQL error log to see if its a database error and if so- post the text of the error.

                      Comment


                      • #26
                        Originally posted by Joe D. View Post
                        Do you have an email address setup in your /core/includes/config.php file to get copies of database errors? If not can you check your MySQL error log to see if its a database error and if so- post the text of the error.
                        Database error in vBulletin 5.1.0 Beta 3:

                        Invalid SQL:
                        SELECT * FROM filedata
                        WHERE `filedataid` >= 56;

                        MySQL Error : MySQL client ran out of memory
                        Error Number : 2008
                        Request Date : Sunday, March 2nd 2014 @ 04:37:55 PM
                        Error Date : Sunday, March 2nd 2014 @ 04:38:43 PM
                        Script : http:///admincp/attachment.php?do=domoveattachment
                        Referrer : http://www.xxxxx.us/admincp/attachme...o=doswitchtype
                        IP Address : xxx.136.xxx.179
                        Username : admin
                        Classname : vB_Database_MySQL
                        MySQL Version :

                        Comment


                        • #27
                          OK, well that is pretty clear on the problem then. A Google search found this- http://forums.mysql.com/read.php?37,94800,94800 - One option that has helped some people is to disable result caching one of the replies talks about how to do that.

                          How many total attachments do you have?

                          Comment


                          • #28
                            Hi joe thank for your reply. I will try this one and update you.. here is attachment statistics Unique / Total Attachments 63,946 / 63,176 Attachment File-size Sum 7.16 GB Disk Space Used 6.99 GB Storage TypeAttachments are currently being stored in the database.

                            Comment


                            • #29
                              Please let me know if you have any success. Looking at the query there may be a bug here as well I don't see why the query isn't limited by the number to process per cycle. I've raised a bug report here - http://tracker.vbulletin.com/browse/VBV-12268 - I am not sure if it will be accepted or come back as designed.

                              Comment


                              • #30
                                Hi Joe...thanks for solved this issue at 5.1.1.alpha 9 version.

                                i have trying to up0grade and move to attachment from database system to file system. all working smooth and not found any problems.

                                but the problem now is, my attachment can`t shown if i opened it at site. especially image attachment.. i have update the the jira

                                thank you.

                                Comment

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