274599 - error if I try to add a product

Status: RESOLVED INVALID

(Bugzilla :: Query/Bug List, defect)

Description

[kalfi712]

When I try to add a product I get the following error:

DBD::mysql::st execute failed: Can't create/write to 
file '/tmp/#sql_be3_0.MYI' (Errcode: 13) [for Statement "SELECT 
products.name,description,disallownew,
                    votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id)
             FROM products LEFT JOIN bugs ON products.id = bugs.product_id
             GROUP BY products.name
             ORDER BY products.name"] at Bugzilla/DB.pm line 62
	Bugzilla::DB::SendSQL('SELECT products.name,description,disallownew,^J

Comment 1

[Vlad Dascalu]

It's a MySQL configuration issue. It seems the mysql user is unable to write to
the /tmp folder. Not Bugzilla's problem.

You might want to check that the CREATE TEMPORARILY TABLE permission is turned
on for the Bugzilla SQL user, as specified in the docs -
http://www.bugzilla.org/docs/tip/html/configuration.html , section 2.2.2.4.