Hello,

on my site, which is multilingual, I have disabled translation for forum topics.

To display all forum topics in all languages for every user I have set the visibility of content to "current language (if available) or default language or language neutral.

This works for german and english (english is default), but not for french.

When I entered a forum topic in french, I got the following error:

Column 'type' in where clause is ambiguous query: SELECT n.nid, n.title FROM node n LEFT JOIN node i18n ON n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR (n.language = 'en' AND i18n.nid IS NULL)) AND ( n.status=1 AND type='image' )ORDER BY n.sticky DESC, n.title ASC in /www/htdocs/w00694ab/drupal/modules/image/contrib/image_attach/image_attach.module on line 319.

I am a newbie with drupal and webservers, so if some information is missing please give a hint where to find it, and I will supply it.

You can see the site at raumgeometrie.de

Regards,

Andreas Goebel

Comments

michelle’s picture

Project: Drupal core » Image
Version: 6.6 » 6.x-1.x-dev
Component: forum.module » image_attach

If you look at the error message, the error is occuring in image_attach, so moving it to that queue.

Michelle

Andreas Goebel’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

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