Every time I do, I get to about 9,000 attachments converted and I consistently get the same SQL error:
It doesn't appear SQL actually "goes away" as the site runs just fine throughout the process and just after the error as well. I wrote my host and he replied with:
I tried the conversion again and it dies in the exact same spot every single time.
Anyone have any ideas on what I need to do to get this script to work, and what this error is really meaning?
Thanks!! -Jim
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT filedataid, filedata, filesize, userid, thumbnail
FROM filedata
WHERE filedataid >= 9002 AND filedataid < 9302
ORDER BY filedataid ASC;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Friday, September 7th 2018 @ 09:22:47 AM
Error Date : Friday, September 7th 2018 @ 09:22:49 AM
Script : http://www.***.com/admincp/attachmen...cherrorcount=0
Referrer : http://www.***.com/admincp/attachmen...cherrorcount=0
IP Address : 24.189.81.51
Username : jimnyc
Classname : vB_Database_MySQLi
MySQL Version :
Server : 198.252.109.104
User Agent :
Invalid SQL:
SELECT filedataid, filedata, filesize, userid, thumbnail
FROM filedata
WHERE filedataid >= 9002 AND filedataid < 9302
ORDER BY filedataid ASC;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Friday, September 7th 2018 @ 09:22:47 AM
Error Date : Friday, September 7th 2018 @ 09:22:49 AM
Script : http://www.***.com/admincp/attachmen...cherrorcount=0
Referrer : http://www.***.com/admincp/attachmen...cherrorcount=0
IP Address : 24.189.81.51
Username : jimnyc
Classname : vB_Database_MySQLi
MySQL Version :
Server : 198.252.109.104
User Agent :
I have increased the memory_limit, post_max_size, upload_max_filesize to 1024M, 128M, 64M respectively. Please try again from your end and let us know if you are having any issues.
Anyone have any ideas on what I need to do to get this script to work, and what this error is really meaning?
Thanks!! -Jim
Comment