Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
DB Issue Details »»
DB Issue
Version: , by Deadly Assassin Deadly Assassin is offline
Developer Last Online: Nov 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-06-2008 Last Update: Never Installs: 0
 
No support by the author.

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT attachmentid, filename, filesize, dateline, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, counter, attachment.thumbnail, LENGTH(attachment.thumbnail) AS thumbnailsize, newwindow, visible
FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON (attachment.extension = attachmenttype.extension)
WHERE postid IN(1203)
AND visible = 1
GROUP BY attachment.postid
ORDER BY attachmentid;

MySQL Error : Can't create/write to file '/tmp/#sql_2a5b_0.MYI' (Errcode: 13)
Error Number : 1
Date : Sunday, January 6th 2008 @ 11:30:14 AM
Script : http://betterwithage.net/forums/
Referrer : http://betterwithage.net/
IP Address :
Username :
Classname : vb_database

Can someone please tell me why ihave suddenly got this message?

Thanks.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-06-2008, 03:04 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried a repair/optimize on the tables?
Reply With Quote
  #3  
Old 01-06-2008, 03:19 PM
Deadly Assassin's Avatar
Deadly Assassin Deadly Assassin is offline
 
Join Date: Aug 2006
Location: VbAnswers.com
Posts: 222
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, it's made no difference.
Reply With Quote
  #4  
Old 01-06-2008, 03:47 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OS Error Code 13: Permission denied
You do not have permission to write to a directory. Most commonly the temporary files directory. Create a directory in your User Home directory on the server and chmod it 777. If this does not resolve the issue then you must contact your host and have them fix your permissions.
Reply With Quote
  #5  
Old 01-06-2008, 04:02 PM
Deadly Assassin's Avatar
Deadly Assassin Deadly Assassin is offline
 
Join Date: Aug 2006
Location: VbAnswers.com
Posts: 222
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I now have no previous posts, the threads are showing but when you click one of them, nothing shows.

I have posted a reply and it shows as my first post.

Pleaee dont tell me that my DB has reset?

And when i click the link to my portal (advancedCMP)S, it just brings up the error above.
Reply With Quote
  #6  
Old 01-06-2008, 08:15 PM
nexialys
Guest
 
Posts: n/a
Default

actually you have to contact your host support, not vbulletin.. the error is related to your host, so why ask here first?!

this error is common when you are overwriting a file in the database server, or when you are over your limit.. no more access to write your content. it may be another kind of error, but it is surely related to your database management. contact your host support.
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 12:55 AM.


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.07254 seconds
  • Memory Usage 2,243KB
  • Queries Executed 21 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (6)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete