Drupal Views: custom fields on address do not work

[Matthias de MAUROY - CYIM]

Hello everyone !

I'm working with drupal views and I have problem displaying address custom fields, in fact it doesn't even show itself...

link with civicrm_address is working fine displaying each column but when linked to my custom data, select is empty

Code: [Select]

SELECT civicrm_contact.id AS id, civicrm_address.state_province_id AS civicrm_address_state_province_id, civicrm_value_r_gion_18.r_gion_42 AS civicrm_value_r_gion_18_r_gion_42
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_uf_match} civicrm_uf_match ON civicrm_contact.id = civicrm_uf_match.contact_id
LEFT JOIN {civicrm_address} civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
LEFT JOIN {civicrm_value_r_gion_18} civicrm_value_r_gion_18 ON civicrm_address.id = civicrm_value_r_gion_18.entity_id
WHERE (( (civicrm_uf_match.uf_id = '1' ) ))
When running this request (and removing those ugly brackets) it show the result that should be displayed.

I know there was an issue like that one on CiviCRM 4.3 but was solved in 4.4 => http://issues.civicrm.org/jira/browse/CRM-12110

I'm trying to figure out why 

Any help would be a pleasure 

Thanks !

[Matthias de MAUROY - CYIM]

Sorry 

I was the one making a mistake... The fact was that some tables were missing in my settings.php, that's all 

See you !