Hi,

I used 'user_import-6.x-1.2'.
There were custom profile fields included in the import.
All seemed to go fine.

However, when I try to use any of the imported profile fields in Views2, it throws an error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-name_value FROM node node INNER JOIN users users ON node.uid = users.uid LE' at line 2 query: SELECT DISTINCT(node.nid) AS nid, profile_values_profile-name.value AS profile_values_profile-name_value FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_values_profile-name ON users.uid = profile_values_profile-name.uid AND profile_values_profile-name.fid = '1' in /home/user/public_html/drupal/sites/all/modules/views/includes/view.inc on line 735

I don't get this error when adding profile fields that I created and populated manually.

Could it be related to the following issue: http://drupal.org/node/421370

If it is, how do I fix the 'profile_values' table?

If it isn't, do you have any idea what might be wrong?

Thanks.

Comments

-Anti-’s picture

-Anti- commented
Status: Active » Closed (fixed)

Apologies. It transpires that my profile field was named 'profile-name' rather
than with default profile_ prefix. It was simply the hyphen causing the problem.

The 'profile_values' table seems to be populating just fine on importing users.

Cheers.