539618 - Run sql from bug 534340 on support-stage.mozilla.org

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Gary]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.16) Gecko/2009121601 Linux Mint/7 (Gloria) Firefox/3.0.16
Build Identifier: 

An error message is returned to the user when he tries to register a new account.





Reproducible: Always

Steps to Reproduce:
1. Proceed to https://support-stage.mozilla.org/tiki-register.php
2. Enter a valid value for each field
3. Click on the "Register" button
4. Observe that an error message is displayed on the next page
Actual Results:  
The SUMO website displays this error message:

"An unexpected error has occurred!"

Expected Results:  
The website should confirm the registration, or return an error message allowing the user to know if he entered invalid data.

-That issue was reproduced at 100% using different e-mail addresses (from different domains).

-The issue could not be reproduced on the casual SUMO site.

-It is not possible to log in using the username/password that was submitted (which is consistent with the registration failure).

-It has been observed that the website could still detect an invalid registration code or mismatching passwords.

Comment 1

[Paul Craciunoiu [:paulc]]

Good catch. Logged in as admin, I get this:
---
Context:
File	tiki-register.php
Url	tiki-register.php
Query:
SELECT login FROM users_users WHERE login = ? OR livechat_id = ?
Values:
0	testuserreg123
1	testuserreg123
Message:
Built query was probably:
SELECT login FROM users_users WHERE login = 'testuserreg123' OR livechat_id = 'testuserreg123'
---

I'm guessing that the livechat_id column doesn't exist. We need IT to run the SQL in attachment 417205 [details] [diff] [review] from bug 534340 on the staging database.

Comment 2

[[:Cww]]

changed the subject to reflect what we're asking IT to do.

Comment 3

[Shyam Mani [:fox2mike]]

mysql> ALTER TABLE users_users ADD livechat_id VARCHAR( 255 ) NULL DEFAULT NULL ,
    -> ADD UNIQUE (livechat_id)
    -> ;
Query OK, 149733 rows affected (7.41 sec)
Records: 149733  Duplicates: 0  Warnings: 0

Done.

Comment 4

[Paul Craciunoiu [:paulc]]

And now I could register an account. Thanks Shyam!