May be Unix acces permissions on /root/tmp (Errcode: 13) = EACCES Permission denied
Like you are using an ORDER BY, mysql needs some temporary space to do the order. Marc. -----Message d'origine----- De : Søren Neigaard [mailto:[EMAIL PROTECTED] Envoyé : jeudi 18 mars 2004 13:29 À : [EMAIL PROTECTED] Objet : What causes this error, and how do i fix it? The following SQL (bugzilla): SELECT products.product,description,disallownew,votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON products.product=bugs.product GROUP BY products.product ORDER BY products.product; Causes this error: ERROR 1: Can't create/write to file '/root/tmp/#sql_1e8_0.MYI' (Errcode: 13) But why and what can I do? Med venlig hilsen/Best regards Søren Neigaard System Architect ................................ Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk ................................ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
