Conflicts with localizer 5.x-3.13 Drupal 5.14

output this:

* user warning: Column 'pid' in where clause is ambiguous query: SELECT COUNT(DISTINCT(id)) FROM simpleguestbook LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN( SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('ru' AS CHAR(10)) AS language ) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from localizernode loc2 LEFT JOIN ( SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('ru' AS CHAR(10)) AS language ) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( pid=0 AND status=1) in C:\www\linebrew\includes\database.mysql.inc on line 174.

* user warning: Column 'pid' in where clause is ambiguous query: SELECT * FROM simpleguestbook LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN( SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('ru' AS CHAR(10)) AS language ) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from localizernode loc2 LEFT JOIN ( SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('ru' AS CHAR(10)) AS language ) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( pid=0 AND status=1 ) ORDER BY id DESC LIMIT 0, 10 in C:\www\linebrew\includes\database.mysql.inc on line 174.

Works fine when I disable module localizer

Comments

Debugger_01’s picture

Debugger_01 commented

It's trouble in localizer module
when I added code 

if (module_exists('simpleguestbook')) {
  	if (($primary_table == 'n') && preg_match('/simpleguestbook/', $query)) {
      //Don't apply localizer because we are serving a
      //simpleguestbook request
      $applylocalizer = FALSE;
    }
  }

in function localizernode_db_rewrite_sql

after this 

if (module_exists('gsitemap') && !variable_get('localizer_switch_byhostname', FALSE)) {
    if (($primary_table == 'n') && preg_match('/gsitemap/', $query)) {
      //Don't apply localizer because we are serving a
      //gsitemap request on a site with switchbyhostname
      $applylocalizer = FALSE;
    }
  }

it's began work ok

Debugger_01’s picture

Debugger_01 commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

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