500646 - When searching for some queries on SUMO, the software returns "d - Table 'support_dw.tiki_objects' doesn't exist"

Status: VERIFIED FIXED

(support.mozilla.org :: Knowledge Base Software, task, P1)

Description

[Ricardo Maçãs [:Ricmacas]]

Attachment: the bug

Getting error "d - Table 'support_dw.tiki_objects' doesn't exist" while accessing http://support.mozilla.com/tiki-newsearch.php?where=all&locale=en-US&q=install , on HTTP and HTTPS.
Also happening on https://support.mozilla.com/tiki-newsearch.php?where=all&locale=pt-PT&q=df&sa= .
Can anyone diagnose this?

Comment 1

[Ricardo Maçãs [:Ricmacas]]

I suspect this has something to do with the SUMO 1.2 update.

Comment 2

[Laura Thomson :laura]

Smacks of regression to me.

Comment 3

[Tobias (:Tobbi) Markus]

WFM with 3.5 RC 3 (Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.1) Gecko/20090624 Firefox/3.5 (.NET CLR 3.5.30729))

Comment 4

[Laura Thomson :laura]

This is reproducible on stage.  Did we really not regress test search?   Must
be going mad.  We'll ship a fix as soon as we can get one.

Comment 5

[Ricardo Maçãs [:Ricmacas]]

Shall we confirm this? I have no permissions for that.

Comment 6

[E. Cooper [:ecooper]]

Attachment: v1

The original code by Nelson didn't use the adodb wrapper, but just mysql_query(), making it use the last active connection.

Oddly, I can't repro this locally, but this patch doesn't break anything either. It's also the only places that use mysql_query in newsearch that I'm aware of. We'll need to test of stage to confirm this is the fix.

Comment 7

[E. Cooper [:ecooper]]

r28630 on trunk

Comment 8

[E. Cooper [:ecooper]]

r28633 in prod branch.