527796 - [sumo mobile]: Search is broken on mobile support

Status: VERIFIED FIXED

(support.mozilla.org :: Mobile, task)

Description

[Vishal Kamdar [:vish_moz]]

Attachment: search broken

STR:
1. go to SUMO mobile site https://mobile.support-stage.mozilla.org/en-US/kb/
2. enter a search term and hit enter.

Actual result:
An unexpected error has occurred!

Comment 1

[Stephen Donner [:stephend] Not actively reading bugmail]

I think we should hold off on tonight's scheduled push (bug 527777) for this.

Comment 2

[James Socol [:jsocol, :james]]

Attachment: sql for se_* tables

Not sure why the tables aren't there. I could reproduce the error locally by doing:

DROP TABLE se_index, se_words, se_letters, se_stopwords, se_weights;

This patch just creates the tables with no data--data should be filled in by the old-style search indexer.

Comment 3

[Michael Morgan [:morgamic]]

Comment on attachment 411552 [details] [diff] [review]
sql for se_* tables

- set default charset to utf8
- remove autoincrement values

Comment 4

[James Socol [:jsocol, :james]]

Attachment: sql for se_* tables, 2

Changes made.

Comment 5

[James Socol [:jsocol, :james]]

Attachment: sql for se_* tables, 3

:%s/USING BTREE//g
6 substitutions on 6 lines

Applied on cm-webdev01-master01, MySQL 5.0.45.

Comment 6

[Michael Morgan [:morgamic]]

Comment on attachment 411563 [details] [diff] [review]
sql for se_* tables, 3

Looks good -- ship it.

Comment 7

[James Socol [:jsocol, :james]]

This is fixed. See bug 527829 for the issues it exposed.

Comment 8

[Vishal Kamdar [:vish_moz]]

Verified, FIXED.