Erorr When Moving Attachment From Database to File System

[BirdOPrey5]

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?

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

[datacrux]

Hello joe..

MySQL Packet Size 1.00 GB

[datacrux]

MySQL Version 5.5.32-cll

[datacrux]

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

[BirdOPrey5]

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.

[datacrux]

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

[datacrux]

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

[datacrux]

still no solution ?

[BirdOPrey5]

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.

[datacrux]

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 :

[BirdOPrey5]

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?

[datacrux]

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.

[BirdOPrey5]

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.

[datacrux]

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.