288883 - SQL crash when granting/denying a request

Status: RESOLVED FIXED

(Bugzilla :: Attachments & Requests, defect)

Description

[Frédéric Buclin]

When granting or denying a bug or attachment request, I get the following error:

DBD::mysql::db selectrow_array failed: Table 'email_setting' was not locked with
LOCK TABLES [for Statement "SELECT * 
                              FROM email_setting
                              WHERE user_id = 10195
                              AND relationship = 100 
                              AND event IN (101) 
                              LIMIT 1"] at Bugzilla/User.pm line 1026
	Bugzilla::User::wants_mail('Bugzilla::User=HASH(0x93e7e18)','ARRAY(0x93dc860)')
called at Bugzilla/Flag.pm line 594
	Bugzilla::Flag::modify('HASH(0x8e07208)','\'2005-04-03 14:02:22\'') called at
Bugzilla/Flag.pm line 391
	Bugzilla::Flag::process('HASH(0x93e7e30)','2005-04-03
14:02:22','HASH(0x8e07208)') called at /var/www/html/bugzilla-tip/attachment.cgi
line 1168
	main::update() called at /var/www/html/bugzilla-tip/attachment.cgi line 163

Comment 1

[Frédéric Buclin]

Flags are unusable!

Comment 2

[Colin Ogilvie [:cso]]

Hmm, weird.

Comment 3

[Frédéric Buclin]

Attachment: missing 'email_setting READ', v1

add missing 'email_setting READ' in attachment.cgi and process_bug.cgi.

Comment 4

[Joel Peshkin]

Comment on attachment 179518 [details] [diff] [review]
missing 'email_setting READ', v1

r=joel by inspection.  LpSolit tested it.

Comment 5

[Frédéric Buclin]

Checking in attachment.cgi;
/cvsroot/mozilla/webtools/bugzilla/attachment.cgi,v  <--  attachment.cgi
new revision: 1.78; previous revision: 1.77
done
Checking in process_bug.cgi;
/cvsroot/mozilla/webtools/bugzilla/process_bug.cgi,v  <--  process_bug.cgi
new revision: 1.244; previous revision: 1.243
done