The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#11
|
|||
|
|||
The forum loads and I can browse around, but threads can not be read.
This is the message: Database error in vBulletin 3.7.1: Invalid SQL: SELECT a.*, au.*, post.userid, post.postid FROM post AS post INNER JOIN award_user AS au ON (au.userid=post.userid) INNER JOIN award AS a ON (a.award_id=au.award_id) WHERE 1=1 AND post.postid IN (0,864427,864429,864430,864431,864433,864523) GROUP BY au.issue_id ORDER BY a.award_displayorder ASC; MySQL Error : Can't create/write to file '/tmp/#sql_53de_0.MYI' (Errcode: 13) Error Number : 1 Request Date : Tuesday, May 25th 2010 @ 03:53:17 AM Error Date : Tuesday, May 25th 2010 @ 03:53:17 AM Script : http://www.mumsmeeting.com/showthread.php?p=864523 Referrer : http://www.mumsmeeting.com/ IP Address : xxxxxx Username : "my name" Classname : vB_Database_MySQLi MySQL Version : 5.0.90-community |
#12
|
||||
|
||||
Are you using some sort of award hack?
|
#13
|
|||
|
|||
Yeah I am, I installed it ages ago.
--------------- Added [DATE]1274780125[/DATE] at [TIME]1274780125[/TIME] --------------- I just disabled the award hack and now my forum seems to be working again. Thank you. I didn't edit the hack and haven't given anyone an award for ages, do you have any idea why it could be affecting my forum now? |
#14
|
|||
|
|||
The error is:
MySQL Error : Can't create/write to file '/tmp/#sql_53de_0.MYI' (Errcode: 13) This means that MySQL can not create a temporary table for sorting when needed. You should try to either: - reboot the server - Clean up you /tmp directory - Check permissions on the /tmp directory You might need to contact your host about this. Disabling 1 product doesn't ensure that you will not run into the same problem later. |
#15
|
||||
|
||||
Quote:
I would also follow Marco's advice and contact the host with the error and see what is going on with the /tmp directory. |
#16
|
|||
|
|||
I've contacted the host but no reply yet.
The hack is called Yet Another Award System 3.6 The site is working ok but still getting error when clicking on usercp Database error in vBulletin 3.7.1: Invalid SQL: SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored ,icon.iconpath, icon.title AS icontitle FROM pm AS pm INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) LEFT JOIN userlist AS userlist_ignore ON (userlist_ignore.userid = 2 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore') LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid) WHERE pm.userid = 2 AND pm.messageread = 0 ORDER BY pmtext.dateline DESC LIMIT 5; MySQL Error : Can't create/write to file '/tmp/#sql_53de_0.MYI' (Errcode: 13) Error Number : 1 |
#17
|
||||
|
||||
According to this:
http://serverfault.com/questions/848...myi-errcode-13 It looks like your permissions on /tmp are wrong. You will need to contact the host and have them check that out. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|