PDA

View Full Version : DB Issue


Deadly Assassin
01-06-2008, 02:33 PM
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.

Lynne
01-06-2008, 03:04 PM
Have you tried a repair/optimize on the tables?

Deadly Assassin
01-06-2008, 03:19 PM
Yeah, it's made no difference. :confused:

Marco van Herwaarden
01-06-2008, 03:47 PM
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.

Deadly Assassin
01-06-2008, 04:02 PM
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.

nexialys
01-06-2008, 08:15 PM
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.