I've installed localizer 5.5-3.0-alpha-preview and can successfully browse my site. However, if I invoke
http://www.myhost.tld/node
I'm getting the following error messages in my status log:

query: SELECT n.nid, n.sticky, n.created FROM node n LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN(select -100 weight, 'de' language union select 1 weight, 'en' language union select 3 weight, 'fr' language union select 4 weight, 'es' language) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) minweight from localizernode loc2 inner join (select -100 weight, 'de' language union select 1 weight, 'en' language union select 3 weight, 'fr' language union select 4 weight, 'es' language) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( n.promote = 1 AND n.status = 1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 10 OFFSET 0 in D:\Websites\Stiegele\includes\database.pgsql.inc in Zeile 144.

pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "weight" LINE 1: ...ernode loc ON loc.nid=n.nid LEFT JOIN(select -100 weight, 'd... ^ in D:\Websites\Stiegele\includes\database.pgsql.inc in Zeile 125.

query: SELECT COUNT(*) FROM node n LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN(select -100 weight, 'de' language union select 1 weight, 'en' language union select 3 weight, 'fr' language union select 4 weight, 'es' language) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) minweight from localizernode loc2 inner join (select -100 weight, 'de' language union select 1 weight, 'en' language union select 3 weight, 'fr' language union select 4 weight, 'es' language) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( n.promote = 1 AND n.status = 1 ) in D:\Websites\Stiegele\includes\database.pgsql.inc in Zeile 144.

pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "weight" LINE 1: ...ernode loc ON loc.nid=n.nid LEFT JOIN(select -100 weight, 'd... ^ in D:\Websites\Stiegele\includes\database.pgsql.inc in Zeile 125.

I'm using PostgreSQL as database backend.
Please note this applies to localizer 5.5-3.0-alpha-preview (which does not yet exist in the dropdown list that is presented while submitting your issue)

Comments

Roberto Gerola’s picture

Version: 5.x-2.x-dev » 5.x-3.x-dev

This error is due to the new fallback language support.
I need to test it with PostgreSQL indeed.

Thanks for your feedback

(You can use now 5.x-3.x-dev as version)

Roberto Gerola’s picture

Assigned: Unassigned » Roberto Gerola
Status: Active » Fixed
Anonymous’s picture

Status: Fixed » Closed (fixed)

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