Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2009, 04:38 AM
stunod's Avatar
stunod stunod is offline
 
Join Date: Mar 2009
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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?
Reply With Quote
  #2  
Old 05-05-2009, 11:33 PM
stunod's Avatar
stunod stunod is offline
 
Join Date: Mar 2009
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thanks,
Adam
Reply With Quote
  #3  
Old 05-06-2009, 03:17 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #4  
Old 05-07-2009, 04:43 AM
stunod's Avatar
stunod stunod is offline
 
Join Date: Mar 2009
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #5  
Old 05-07-2009, 06:20 AM
RLShare RLShare is offline
 
Join Date: Jun 2008
Posts: 499
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'
Reply With Quote
  #6  
Old 05-07-2009, 02:28 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RLShare View Post
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'
Reply With Quote
  #7  
Old 05-07-2009, 11:59 PM
stunod's Avatar
stunod stunod is offline
 
Join Date: Mar 2009
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #8  
Old 05-08-2009, 12:15 AM
RLShare RLShare is offline
 
Join Date: Jun 2008
Posts: 499
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Give us the full database error
Reply With Quote
  #9  
Old 05-08-2009, 04:47 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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).
Reply With Quote
  #10  
Old 05-08-2009, 05:19 AM
stunod's Avatar
stunod stunod is offline
 
Join Date: Mar 2009
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 :
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:17 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05199 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete