I received this error after updating my localhost machine:
user warning: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_61c_0.MYD' (Errcode: 13) query: SELECT n.title, n.nid, r.body, r.teaser, r.format FROM node n LEFT JOIN node_revisions r ON n.nid = r.nid AND r.vid = n.vid INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type='faq' AND n.status = 1 AND tn.tid = '25' ORDER BY n.sticky DESC, n.created DESC in C:\www\drupal\includes\database.mysql.inc on line 172.

It appears to be an issue with writing to my "temp" directory, but it also says something about the mysql so before updating my live site I just wanted to make sure this isn't something I need to worry about. I wish I understood more, but would appreciate if you let me know. Everything looks fine on the site, so I'm sure I'm being a worry wort, but don't want to update if there is an issue with something I have.

Thanks!
Shari

Comments

stella’s picture

Project: Frequently Asked Questions » Drupal core
Version: 5.x-1.2-1 » 5.1
Component: Code » database system

I don't believe this is a problem with the faq module. It uses the drupal api db_query() to execute all sql queries. It is more than likely a problem with mysql or the server. See #70464 and the comments following #20397#comment-167902.

Cheers,
Stella

uNeedStuff’s picture

Status: Active » Fixed

Thanks! I'm sure that is the issue. I did search, but wasn't "listening" good enough.

Shari

Anonymous’s picture

Status: Fixed » Closed (fixed)