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
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

Earl Grey - November 4, 2009 - 21:37
Status:active» needs review

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

rolfmeijer - November 5, 2009 - 13:48

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

Earl Grey - November 5, 2009 - 13:50
Status:needs review» fixed

Thanks for testing. I will do some more tests regarding the token module.

#4

System Message - November 19, 2009 - 14:00
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.