Moving attachment database error

[stunod]

I am trying to use the "moving attachment from the database to a directory" feature, but when I click the go button I get the following database error.

Can someone please help me?

Thanks,
Adam


Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408


Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT attachmentid, filename, filedata, filesize, userid, thumbnail
FROM srvb_attachment
WHERE attachmentid >= 1 AND attachmentid < 301
ORDER BY attachmentid ASC;

--------------- Added [DATE]1240357897[/DATE] at [TIME]1240357897[/TIME] ---------------

anyone?

[stunod]

I am still get this error could someone please help me. I am running out of database space.

Thanks,
Adam

[Lynne]

The important part of the database error is the part after what you posted. It gives the mysql error number and other stuff.

Did you create a folder to put them in? And did you chmod it to 777? And is it above your forum root (don't put it in the forum folder or in the public_html folder)? And is the path correct?

[stunod]

Yes, I have created a folder with the chmod of 777. Also, I have my url pointing to a folder called "vbulletin" and all of the forum files are located in there. How would I put the the attachment folder above the forum root folder. The section where I enter the "Attachment File Path" url wont let me put a "http" in the front of it.

Adam

[RLShare]

You do not need to put http in front of it, it should be a full local path on your server.. For example your public_html folder will usually be something like this

'home/USER_NAME/public_html'

[Lynne]

Originally Posted by RLShare

You do not need to put http in front of it, it should be a full local path on your server.. For example your public_html folder will usually be something like this

'home/USER_NAME/public_html'

Yep. And you should put your attachment folder on the same level as the public_html folder. So
'home/USER_NAME/attachments'

[stunod]

Ok, I have gotten that far but when it asks me "Number of attachments to process per cycle" I have it set to 200 and tried 100, 300, 50, but when I hit go I get the database error.

Could there be something wrong with the core.php file?

[RLShare]

Give us the full database error

[Lynne]

As RLShare said, we need to know what the exact database error is. You can either view the page source and you'll see it near the bottom of the page, or if they get emailed to you, copy/paste it from the email (you may xxx out the ip address if you wish).

[stunod]

Yeah sure, here is a copy of the database error i receive in my inbox ever time I try to preform it.

Thanks for the help everyone!

Adam



Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT attachmentid, filename, filedata, filesize, userid, thumbnail
FROM srvb_attachment
WHERE attachmentid >= 1 AND attachmentid < 301
ORDER BY attachmentid ASC;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Thursday, May 7th 2009 @ 08:57:31 PM
Error Date : Thursday, May 7th 2009 @ 08:57:34 PM
Script : http://stunodracing.com/admincp/atta...moveattachment
Referrer : http://stunodracing.com/admincp/atta...o=doswitchtype
IP Address : xx.x.xxx.xx
Username : stunod
Classname : vb_database
MySQL Version :