profile_values doesn't exist [#2392355]

when running an import, i got this error

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

If i am not mistaking, the correct table name is profile_value (without the S in the end).
After changing the table name, i then got this error

PHP Fatal error: Call to undefined method UpdateQuery::limit() in /var/www/*******/sites/all/modules/user_import/supported/profile.inc on line 129, referer: http://********/admin/people/user_import/add/7/6

i removed the ->limit(1) which is on line 129, and the import ran ok.
Of course, I am not sure whether i broke anything else....

Comment	File	Size	Author
#1	user_import-profile_values-150820.patch	2.18 KB	Louis Delacretaz

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

Louis Delacretaz CreditAttribution: Louis Delacretaz commented 20 August 2015 at 09:24

File	Size
user_import-profile_values-150820.patch	2.18 KB

I was gettting the error "PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '...profile_values' doesn't exist: SELECT value FROM {profile_values} WHERE fid = :fid AND uid = :uid LIMIT 0, 1
and noting that in DP6 the profile tables were profile_fields / profile_values where in dp7 they are profile_field / profile_value respectively I have attached a patch to that names the table properly. The table profile_field was already correct.
I was then able to import users with out the PDOException occuring.

Patch is against ver 2.3