Setup a image content type with a single file field "image". Next I have the Page content type with a "images" node reference. Setup the media browser as the display type and click add content.

Boom!

* user warning: Unknown column 'n.language' in 'where clause' query: SELECT COUNT(*) FROM node WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( type in ('media','image') ) in /srv/clients/tektronix/tekdesign/drupal/sites/all/modules/contrib/nrembrowser/nrembrowser.module on line 1099.
* user warning: Unknown column 'n.language' in 'where clause' query: SELECT DISTINCT nid, title FROM node WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( type in ('media','image') )ORDER BY created DESC LIMIT 0, 12 in /srv/clients/tektronix/tekdesign/drupal/sites/all/modules/contrib/nrembrowser/nrembrowser.module on line 1099.

Comments

emptyvoid’s picture

StatusFileSize
new81.81 KB

Hmm the screen shot didn't display

emptyvoid’s picture

Follow up, this error appears to occur only when using the WYSIWYG editor insert dialog and when I have multiple content types selected.

bwinett’s picture

Status: Active » Needs review
StatusFileSize
new685 bytes

The query is using a table alias in the WHERE clause, but the alias is not defined in the FROM clause. This patch works for me.