I am trying to import a set of users (civiCRM contacts who are not users) into our test installation of Drupal 7, but am getting the following error: Core and all modules are up to date. What module should have created this profile.values table?

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'perma_civi.profile_values' doesn't exist: SELECT value FROM {profile_values} WHERE fid = :fid AND uid = :uid LIMIT 0, 1; Array ( [:fid] => 1 [:uid] => 8357 ) in profile_user_import_save_profile() (line 62 of /var/www/xxxxxx/xxxxxxxxxxxxx/civi/sites/all/modules/user_import/supported/profile.inc).

Comments

permaculturegeek’s picture

permaculturegeek CreditAttribution: permaculturegeek commented

It appears that the import will process a single record each time it is run (and generate duplicate errors for all records preceding). I had profile2 installed but disabled. Enabling it has not changed anything (and no database upgrades were required).

mertero’s picture

mertero CreditAttribution: mertero commented

This is old - but it happened to me under D7. It turns out that the profile_values was renamed profile_value. I manually changed all profile_values instances in the code to profile_value and it worked for me...

gisle’s picture

gisle
he/him
Primary language Norwegian Bokmål
Location Norway
CreditAttribution: gisle at Hannemyr Nye Medier AS commented
Status: Active » Closed (duplicate)
Parent issue: » #2392355: profile_values doesn't exist

Duplicate of #2392355: profile_values doesn't exist.