389410 - An error is displayed when a new account is created - Error when trying to lock test_plan_permissions_regexp table

Status: RESOLVED DUPLICATE of bug 378633

(Testopia :: Environments, defect)

Description

[paul jurco]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5
Build Identifier: Testopia Version 1.2

I have installed successfully testopia on linux (httpd-2.0.52, mysql-4.1.20, perl5.8.5).
Everything worked as expected until a new user has been added.
After I submitted the email address and the name of the person the following message is shown:

Software error:

DBD::mysql::st execute failed: Table 'test_plan_permissions_regexp' was not locked with LOCK TABLES [for Statement "SELECT 

test_plan_permissions_regexp.plan_id, 
                                 user_regexp, test_plan_permissions_regexp.permissions, 
                                 test_plan_permissions.plan_id
                          FROM test_plan_permissions_regexp
                     LEFT JOIN test_plan_permissions 
                            ON test_plan_permissions_regexp.plan_id = test_plan_permissions.plan_id
                           AND test_plan_permissions.userid = ?
                           AND test_plan_permissions.grant_type = ?" with ParamValues: 1=2, 0='2078'] at Bugzilla/User.pm line 707
	Bugzilla::User::derive_regexp_groups('Bugzilla::User=HASH(0x9950990)') called at Bugzilla/User.pm line 1417
	Bugzilla::User::insert_new_user('[e-mail]', 'test test') called at /usr/local/bugzilla/createaccount.cgi line 89



Reproducible: Always

Steps to Reproduce:
1. install testopia on an existing bugzilla
2. everything acts normal
3. add a new bugzilla account
Actual Results:  
An error appears on the screen.

Expected Results:  
The account is created, successful message is displayed...

The account is created and works as expected.