The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Moving attachment database error
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? |
#2
|
||||
|
||||
I am still get this error could someone please help me. I am running out of database space.
Thanks, Adam |
#3
|
||||
|
||||
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? |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
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' |
#6
|
||||
|
||||
Quote:
'home/USER_NAME/attachments' |
#7
|
||||
|
||||
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? |
#8
|
|||
|
|||
Give us the full database error
|
#9
|
||||
|
||||
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).
|
#10
|
||||
|
||||
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 : |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|