Erorr When Moving Attachment From Database to File System

[datacrux]

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 ?

[Lynne]

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?

[datacrux]

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.;..

[Lynne]

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.

[datacrux]

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

[datacrux]

no way to solve ?

[BirdOPrey5]

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.

[Lynne]

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.

[datacrux]

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...

[datacrux]

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...

[Lynne]

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:

$config['debug'] = false;

To:

$config['debug'] = true;

Then edit the /core/includes/config.php file and change:

// $config['Misc']['debug'] = true;

To:

$config['Misc']['debug'] = true;

[Zachery]

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

[datacrux]

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...

[datacrux]

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

[datacrux]

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