Every now and then I am getting a pair of errors in my site log. The first error is such:

Can't create/write to file 'C:\WINNT\TEMP\#sql_c68_0.MYI' (Errcode: 13) query: SELECT DISTINCT(n.nid), n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 61 in D:\webroot\intranet\includes\database.mysql.inc on line 120.

Now I realise this is a MYSql error, however this error only occurs during the execution of a particular query made by og_vocab, as shown by the second error:

Invalid argument supplied for foreach() in D:\webroot\intranet\modules\og_vocab\og_vocab.module on line 54.

These two errors are always paired together. I have not yet seen them separately.

Comments

moshe weitzman’s picture

moshe weitzman commented

i really don't think this is caused by php code. it says that mysql can't write a file. check file permissions or disk space or something like that.

cooperaj’s picture

cooperaj commented
Status: Active » Closed (fixed)

I've narrowed it down to the virus checker on the machine locking the tmp files mysql produces. So thats the fix. The only reason that I posted it here was that this error only ever occured right before a og_vocab call. Wierd.

Thanks
Adam