Bug #49958 How Solve this Error - Errcode: 13

• Submitted: 28 Dec 2009 13:48
• Modified: 11 Feb 2018 11:09
• Reporter: Raju Balasundar
• Status: Can't repeat
• Category: MySQL Server: DML
• Severity: S1 (Critical)
• OS: Any
• CPU Architecture: Any

[28 Dec 2009 13:48] Raju Balasundar

Description:
Hi How to solve following Query problem. This error coming only select statement with join query.Please Help me.

Error in Selection Query
select c.classif_id,w.member_photo,w.user_name,c1.classifieds_name,c2.class_subcat,c4.State_name,c3.Country_name, c.class_title,c.class_ads,c.class_image,c.class_file,c.class_post_date,c.classif_status,c.cover from tbl_classified_details as c left join tbl_members as w on w.mem_id=c.class_user_id left join tbl_classifieds as c1 on c1.class_id=c.classifieds_name left join tbl_subclassifieds as c2 on (c2.Classfield_Category_Id=c.class_subcat or c.class_subcat='0' or c2.Classfield_Category_Id is null) left join tbl_country as c3 on c.class_country=c3.Ident left join tbl_state as c4 on (c4.Ident=c.class_state or c4.Ident='0' or c4.Ident is null) where c.classif_id is not null and c.classif_status='1' group by c.classif_id order by c.class_post_date desc LIMIT 0, 5
Can't create/write to file '/root/setup/#sql_205c_0.MYI' (Errcode: 13)

How to repeat:
Error in Selection Query
select c.classif_id,w.member_photo,w.user_name,c1.classifieds_name,c2.class_subcat,c4.State_name,c3.Country_name, c.class_title,c.class_ads,c.class_image,c.class_file,c.class_post_date,c.classif_status,c.cover from tbl_classified_details as c left join tbl_members as w on w.mem_id=c.class_user_id left join tbl_classifieds as c1 on c1.class_id=c.classifieds_name left join tbl_subclassifieds as c2 on (c2.Classfield_Category_Id=c.class_subcat or c.class_subcat='0' or c2.Classfield_Category_Id is null) left join tbl_country as c3 on c.class_country=c3.Ident left join tbl_state as c4 on (c4.Ident=c.class_state or c4.Ident='0' or c4.Ident is null) where c.classif_id is not null and c.classif_status='1' group by c.classif_id order by c.class_post_date desc LIMIT 0, 5
Can't create/write to file '/root/setup/#sql_205c_0.MYI' (Errcode: 13)

[28 Dec 2009 14:35] Valeriy Kravchuk

Please, try to set TMPDIR environment variable to some commonly writable location, like this:

export TMPDIR=/tmp

and then, from the same shell, start mysql command line client and execute your query again. Inform about the results.

[29 Jan 2010 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[11 Feb 2018 11:09] Roy Lyseng

Posted by developer:
 
Closing since it has been suspended for 8 years.