I installed the latest CVS version for testing (the Group By aliasing) and got an error when I tried to search for something.
user warning: SQLSTATE[HY000]: General error: 907 OCIStmtExecute: ORA-00907: missing right parenthesis (ext\pdo_oci\oci_statement.c:146) query: SELECT * FROM (SELECT TAB.*, ROWNUM RWN FROM (SELECT SUM(i.score * t.count) AS score FROM "DPSEARCH_INDEX" i INNER JOIN "DPSEARCH_TOTAL" t ON i.word = t.word INNER JOIN "DPNODE" n ON n.nid = i.sid WHERE n.status = 1 AND (i.word = :s0 OR i.word = :s1) AND i.type = :s2 GROUP BY i.type, i.sid HAVING COUNT(*) >= :d3 ORDER BY t.count) DESC) TAB) WHERE RWN BETWEEN :d4 AND :d5 args: Array ( [0] => image [1] => hello [2] => node [3] => 2 [4] => 1 [5] => 1 ) unformatted: SELECT SUM(i.score * t.count) AS score FROM {search_index} i INNER JOIN {search_total} t ON i.word = t.word INNER JOIN {node} n ON n.nid = i.sid WHERE n.status = 1 AND (i.word = '%s' OR i.word = '%s') AND i.type = '%s' GROUP BY i.type, i.sid HAVING COUNT(*) >= %d ORDER BY score DESC in C:\WebServer\docroot\drupal\modules\search\search.module on line 946.

Unrolling the last update fixed the issue.

Comments

aaaristo’s picture

Assigned: Unassigned » aaaristo
Status: Active » Fixed

Ok i fixed it in the new dev snapshot, could you confirm and close? Thanks.

siromega’s picture

Status: Fixed » Closed (fixed)

Yup. Put it into the development environment, it worked, then put it into production and it worked there too. Thanks!