Announcement

Collapse
No announcement yet.

Erorr When Moving Attachment From Database to File System

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

  • Erorr When Moving Attachment From Database to File System

    Hello suypport, i found the erorr when i move attachment from database system to file system. I trying to move 300 attachment first, and found the erorr like this : Attachment Manager
    Attachment : 6
    Attachment : 7
    Attachment : 8
    Attachment : 22
    Attachment : 23
    Attachment : 24
    Attachment : 25
    Attachment : 27
    Attachment : 28
    Attachment : 29
    Attachment : 30
    Attachment : 31
    Attachment : 32
    Attachment : 35
    Attachment : 36
    Attachment : 37
    Attachment : 38
    Attachment : 39
    Attachment : 40
    Attachment : 45
    Attachment : 48
    Attachment : 49
    Attachment : 50
    Attachment : 51
    Attachment : 52
    Attachment : 53
    Attachment : 54
    Attachment : 55
    Attachment : 56
    Attachment : 57
    Attachment : 58
    Attachment : 66
    Attachment : 67
    Attachment : 68
    Attachment : 69
    Attachment : 70
    Attachment : 71
    Attachment : 73
    Attachment : 74
    Attachment : 75
    Attachment : 76
    Attachment : 77
    Attachment : 78
    Attachment : 79
    Attachment : 80
    Attachment : 82
    Attachment : 83
    Attachment : 84
    Attachment : 85
    Attachment : 86
    Attachment : 87
    Attachment : 88
    Attachment : 93
    Attachment : 94
    Attachment : 95
    Attachment : 96
    Attachment : 97
    Attachment : 98
    Attachment : 99
    Attachment : 100
    Attachment : 101
    Attachment : 102
    Attachment : 103
    Attachment : 106
    Attachment : 107
    Attachment : 108
    Attachment : 109
    Attachment : 114
    Attachment : 115
    Attachment : 122
    Attachment : 124
    Attachment : 125
    Attachment : 126
    Attachment : 127
    Attachment : 128
    Attachment : 129
    Attachment : 130
    Attachment : 131
    Attachment : 132
    Attachment : 133
    Attachment : 134
    Attachment : 135
    Attachment : 136
    Attachment : 137
    Attachment : 138
    Attachment : 139
    Attachment : 140
    Attachment : 141
    Attachment : 142
    Attachment : 143
    Attachment : 144
    Attachment : 145
    Attachment : 146
    Attachment : 148
    Attachment : 149
    Attachment : 150
    Attachment : 151
    Attachment : 152
    Attachment : 153
    Attachment : 154
    Attachment : 155
    Attachment : 156
    Attachment : 157
    Attachment : 158
    Attachment : 159
    Attachment : 160
    Attachment : 161
    Attachment : 162
    Attachment : 167
    Attachment : 168
    Attachment : 169
    Attachment : 170
    Attachment : 171
    Attachment : 172
    Attachment : 173
    Attachment : 174
    Attachment : 175
    Attachment : 176
    Attachment : 177
    Attachment : 178
    Attachment : 179
    Attachment : 180
    Attachment : 181
    Attachment : 182
    Attachment : 183
    Attachment : 184
    Attachment : 185
    Attachment : 192
    Attachment : 193
    Attachment : 194
    Attachment : 195
    Attachment : 196
    Attachment : 197
    Attachment : 198
    Attachment : 199
    Attachment : 200
    Attachment : 201
    Attachment : 202
    Attachment : 203
    Attachment : 204
    Attachment : 205
    Attachment : 206
    Attachment : 207
    Attachment : 208
    Attachment : 209
    Attachment : 210
    Attachment : 211
    Attachment : 212
    Attachment : 213
    Attachment : 214
    Attachment : 215
    Attachment : 216
    Attachment : 217
    Attachment : 218
    Attachment : 219
    Attachment : 220
    Attachment : 221
    Attachment : 222
    Attachment : 223
    Attachment : 224
    Attachment : 225
    Attachment : 226
    Attachment : 227
    Attachment : 228
    Attachment : 229
    Attachment : 230
    Attachment : 231
    Attachment : 234
    Attachment : 235
    Attachment : 236
    Attachment : 237
    Attachment : 238
    Attachment : 239
    Attachment : 240
    Attachment : 241
    Attachment : 242
    Attachment : 243
    Attachment : 244
    Attachment : 245
    Attachment : 246
    Attachment : 247
    Attachment : 248
    Attachment : 249
    Attachment : 250
    Attachment : 251
    Attachment : 252
    Attachment : 253
    Attachment : 254
    Attachment : 255
    Attachment : 256
    Attachment : 257
    Attachment : 258
    Attachment : 259
    Attachment : 260
    Attachment : 261
    Attachment : 262
    Attachment : 263
    Attachment : 264
    Attachment : 265
    Attachment : 266
    Attachment : 267
    Attachment : 268
    Attachment : 269
    Attachment : 270
    Attachment : 271
    Attachment : 272
    Attachment : 273
    Attachment : 274
    Attachment : 275
    Attachment : 276
    Attachment : 277
    Attachment : 278
    Attachment : 279
    Attachment : 283
    Attachment : 284
    Attachment : 285
    Attachment : 286
    Attachment : 287
    Attachment : 288
    Attachment : 289
    Attachment : 290 There is a serious error and the page cannot be rendered

    I checked the erorr_log, and not found anything regarding this issue. can you help me to resolve this problem ?

  • #2
    I just tried this on my site and I don't get a list like you are showing at all. It says Filedata ID, Size in Database, Size in Filesystem. Nowhere does it mention Attachment at all (except as the heading in the admincp). So, exactly what version are you using and exactly what steps are you taking to do this?

    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


    • #3
      Hello i`m using 5.0.5 version at my Site..

      here is step i doing,...

      1. turn off the forum
      2. attachments > attachment storage type > Move Items from Database into File System > Go > Attachment File Path ( I fill the path of attachments folder and chmod it to 0777 ) > Go > Number of attachments to process per cycle ( i fill 300 ) > Go

      After that i found the erorr like message above...

      Can you try it at your back end with the reference ticket support : vBulletin Ticket System (Ticketid: 1248318), because i need it to resolve due of memory usage.;..

      Comment


      • #4
        Please make sure you ONLY have vb5 files uploaded to your site. I would redownload the 5.0.5 package and then reupload it. I tried those exact steps and it doesn't give me a list like yours at all when I click Go. Your list looks like the old vB4 list.

        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


        • #5
          Hello Lynne, thanks for your reply.

          After i replace all Vbulletin with fresh download, the problem is still happened. I have upgrade to 5.10 Beta 3. The erorr still same.

          Here is log :

          There is a serious error and the page cannot be rendered

          Fatal error: Uncaught exception 'Exception' with message 'MySQL server has gone away' in /home/metro/public_html/core/vb/db/query/update.php:120
          Stack trace: #0 /home/metro/public_html/core/vb/db/query/update.php(101): vB_dB_Query_Update->doUpdates()
          joe.media: #1 /home/metro/public_html/core/vb/db/assertor.php(282): vB_dB_Query_Update->execSQL()
          #2 /home/metro/public_html/core/vb/db/assertor.php(517): vB_dB_Assertor->assertQuery('session', Array)
          #3 /home/metro/public_html/core/vb/session.php(450): vB_dB_Assertor->update('session', Array, Array)
          joe.media: #4 /home/metro/public_html/core/vb/shutdown.php(84): vB_Session->save()
          #5 /home/metro/public_html/core/vb/vb.php(454): vB_Shutdown->shutdown()
          #6 [internal function]: vB:hutdown()
          #7 {main} thrown in /home/metro/public_html/core/vb/db/query/update.php on line 120

          This caused memory usage in my server and bomb email to my account due erorr SQL

          Comment


          • #6
            no way to solve ?

            Comment


            • #7
              MySQL server has gone away arror is a problem with your MySQL server. Most likely it is getting overloaded from the amount of data being moved.

              Change the Number of attachments to process per cycle from the default of 300 to a lower value, try 100 and lower if from there if you still get the error.

              Comment


              • #8
                Why are you upgrading? You shouldn't use beta software on a live site. I would use the database backup you took before the upgrade and just redownload/upload the 5.0.5 files. And, as Joe suggested, set the number of attachments to process per cycle to something less than 300 and see if that helps.

                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


                • #9
                  Originally posted by Joe D. View Post
                  MySQL server has gone away arror is a problem with your MySQL server. Most likely it is getting overloaded from the amount of data being moved.

                  Change the Number of attachments to process per cycle from the default of 300 to a lower value, try 100 and lower if from there if you still get the error.
                  Joe..thanks for your reply...

                  I have try one attachment for move. But it still shown erorr :
                  Attachment Manager
                  Attachment : 6 There is a serious error and the page cannot be rendered

                  Can you look detail at vBulletin Ticket System (Ticketid: 1248318), please provide time to try ones...

                  Comment


                  • #10
                    Originally posted by Lynne View Post
                    Why are you upgrading? You shouldn't use beta software on a live site. I would use the database backup you took before the upgrade and just redownload/upload the 5.0.5 files. And, as Joe suggested, set the number of attachments to process per cycle to something less than 300 and see if that helps.
                    Hi Lynne, thanks for the reply.

                    I have reupload 5.0.5 and the erorr still look same. So i decide to upgrade to 5.1.0 and hope the problem will be solved. But it still happened. i have try to set the number of attachments to 1 process per cycle. but shown erorr like above...

                    Comment


                    • #11
                      Try going into debug mode and see if the "There is a serious error...." message will change to something that gives more information.

                      To enable debug mode edit the /config.php file and change:

                      Code:
                      $config['debug'] = false;
                      To:
                      Code:
                      $config['debug'] = true;
                      Then edit the /core/includes/config.php file and change:

                      Code:
                      // $config['Misc']['debug'] = true;
                      To:
                      Code:
                      $config['Misc']['debug'] = true;

                      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


                      • #12
                        Reduce the number of attachments, try 50 at a time, instead of 300.

                        Comment


                        • #13
                          Hello Lynne Thanks for reply. I Have activated debug mode as your said.. here is Message :

                          Error :MySQL server has gone away on line 120 in /home/metro/public_html/core/vb/db/query/update.php
                          Step 0: doUpdates() called on line 101 in /home/metro/public_html/core/vb/db/query/update.php
                          Step 1: execSQL() called on line 282 in /home/metro/public_html/core/vb/db/assertor.php
                          Step 2: assertQuery() called on line 517 in /home/metro/public_html/core/vb/db/assertor.php
                          Step 3: update() called on line 724 in /home/metro/public_html/core/vb/library/user.php
                          Step 4: updateEmailFloodTime() called on line 423 in /home/metro/public_html/core/vb/mail.php
                          Step 5: send() called on line 120 in /home/metro/public_html/core/vb/mail.php
                          Step 6: vbmail() called on line 39 in /home/metro/public_html/core/vb/exception/database.php
                          Step 7: __construct() called on line 1201 in /home/metro/public_html/core/vb/database.php
                          Step 8: halt() called on line 439 in /home/metro/public_html/core/vb/database.php
                          Step 9: execute_query() called on line 473 in /home/metro/public_html/core/vb/database.php
                          Step 10: query_read() called on line 122 in /home/metro/public_html/core/vb/db/result.php
                          Step 11: rewind() called on line 59 in /home/metro/public_html/core/vb/db/result.php
                          Step 12: __construct() called on line 118 in /home/metro/public_html/core/vb/db/query/select.php
                          Step 13: doSelect() called on line 96 in /home/metro/public_html/core/vb/db/query/select.php
                          Step 14: execSQL() called on line 282 in /home/metro/public_html/core/vb/db/assertor.php
                          Step 15: assertQuery() called on line 599 in /home/metro/public_html/core/vb/db/assertor.php
                          Step 16: getRow() called on line 459 in /home/metro/public_html/core/admincp/attachment.php
                          Step 17: require_once() called on line 118 in /home/metro/public_html/includes/api/interface/collapsed.php
                          Step 18: relay() called on line 29 in /home/metro/public_html/includes/vb5/frontend/controller/relay.php
                          Step 19: admincp() called
                          Step 20: call_user_func_array() called on line 72 in /home/metro/public_html/index.php

                          at /home/metro/public_html/core/vb/db/query/update.php shown : throw new Exception($error);

                          I have trying with 50 process per cycle as Zachery said...

                          Comment


                          • #14
                            here is my Server configuration after update to Vbulletin 5.1.0
                            Server Type Linux Users to Moderate 0 [View]
                            Web Server Apache Topics to Moderate 0 [View]
                            PHP 5.4.25 Posts to Moderate 1 [View]
                            PHP Max Post Size 1,000.00 MB MySQL Version 5.5.32-cll
                            PHP Maximum Upload Size 1,000.00 MB MySQL Packet Size 1.00 GB
                            PHP Memory Limit 64.00 MB

                            Comment


                            • #15
                              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 Type Attachments are currently being stored in the database
                              Average Attachment File-size 117.4 KB
                              Total Downloads 959,224

                              Comment

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