Unknown column 'n.language'
rolfmeijer - November 4, 2009 - 21:08
| Project: | CCK Blocks |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
When adding a CCK Block with a back reference I get this error when visiting the refering node:
user warning: Unknown column 'n.language' in 'where clause' query: SELECT title FROM blocks WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( delta = 'field_backref_6782407fda57f16974' ) in /domains/delft-esteli.nl/drupal-6.14/sites/all/modules/cck_blocks/cck_blocks.module on line 92.It is probably something with i18n, there are modules that suffered from the same error: http://drupal.org/search/apachesolr_search/Unknown%20column%20%27n.langu...
The block seems to display fine, btw.

#1
Error detected and corrected. Please try next -dev tomorrow.
Will be added to rc1, if it works. Can you also try, if tokens can still be used in the block title? As you ran into that issue, you must have token module installed.
#2
The error has been fixed indeed. Thanks a lot, great work!
About the use of tokens I’m not so sure. When trying [author-name] I got the proper name. But when use [date] I got “3” which is of course not the creation date. I must say I don’t have a lot of experience with tokens, so I might have missed a point somehwere…
#3
Thanks for testing. I will do some more tests regarding the token module.
#4
Automatically closed -- issue fixed for 2 weeks with no activity.