vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Server not found (https://vborg.vbsupport.ru/showthread.php?t=243004)

leannet 05-25-2010 07:54 AM

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

Boofo 05-25-2010 08:01 AM

Are you using some sort of award hack?

leannet 05-25-2010 08:33 AM

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?

Marco van Herwaarden 05-25-2010 08:51 AM

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.

Boofo 05-25-2010 09:25 AM

Quote:

Originally Posted by leannet (Post 2043059)
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?

As I have not seen that hack, I have no idea what is going on. I would post about it in the thread and see if anyone else has run into any problems.

I would also follow Marco's advice and contact the host with the error and see what is going on with the /tmp directory.

leannet 05-25-2010 11:43 AM

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

Boofo 05-25-2010 12:37 PM

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.


All times are GMT. The time now is 04:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00993 seconds
  • Memory Usage 1,730KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete