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
Comment #1
Roberto Gerola commentedThis 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)
Comment #2
Roberto Gerola commentedFixed now.
Download the update from here :
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/localizer/m...
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.