warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: "unknown" && character varying LINE 1: ...d, '-panel-', '-region-') WHERE module = 'panels' && sid LIK... ^ HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. in .../includes/database.pgsql.inc on line 139.

Here is the patch too. Other versions may affected.
diff --git a/skinr.install b/skinr.install
index 2cc9471..96d12fb 100644
--- a/skinr.install
+++ b/skinr.install
@@ -281,7 +281,7 @@ function skinr_update_6003() {
*/
function skinr_update_6004() {
$ret = array();
- $ret[] = update_sql("UPDATE {skinr} SET sid = REPLACE(sid, '-panel-', '-region-') WHERE module = 'panels' && sid LIKE '%-panel-%'");
+ $ret[] = update_sql("UPDATE {skinr} SET sid = REPLACE(sid, '-panel-', '-region-') WHERE module = 'panels' AND sid LIKE '%-panel-%'");

return $ret;
}

Comments

moonray’s picture

Attaching patch from above.

  • Commit 985aa68 on 6.x-2.x by moonray:
    Issue #1221336 by n3ko: Fixed error with pg database when upgrading from...

Status: Needs review » Needs work
moonray’s picture

Status: Needs work » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.