After an import of 148 users error messages for 7 users are shown with following message:

warning: pg_query() [function.pg-query]: Query failed: ERROR: multiple assignments to same column "data" in ../includes/database.pgsql.inc on line 139.

The statement that failed (name and mail address changed):
UPDATE users SET
uid = '209', name = 'AnnaXxx', mail = 'annaXxx@gmail.com',
mode = '0', sort = '0', threshold = '0', theme = '',
signature = '', signature_format = '0', created = '1295200334',
access = '1295200334', login = '1295200334', status = '1', timezone = '-18000',
language = '', picture = '', init = 'annaXxx@gmail.com',
data = 'a:4:{s:18:"profile_first_name";s:4:"Anna";s:15:"profile_country";s:6:"Russia";s:17:"profile_last_name";s:9:"Xxx";s:13:"profile_lang1";s:2:"ru";}',
timezone_name = '',
data = 'a:8:{s:18:"profile_first_name";s:4:"Anna";s:15:"profile_country";s:6:"Russia";s:17:"profile_last_name";s:9:"Xxx";s:13:"profile_lang1";s:2:"ru";s:18:"profile_othernames";s:0:"";s:13:"profile_lang2";s:0:"";s:13:"profile_lang3";s:0:"";s:9:"nodewords";a:0:{}}'
WHERE uid = 209

Data is assigned 2 times therefore SQL must fail. It seems to me that this UPDATE statement does not change anything; the data that I expected was already inserted before.

Comments

ldpm’s picture

ldpm commented

I am getting a similar issue; I reinstalled 6x-2.3, and the issue appears there as well:

warning: pg_query() [function.pg-query]: Query failed: ERROR: multiple assignments to same column "data" in /websites/registrars.afilias.info/0.x/includes/database.pgsql.inc on line 139.

UPDATE users SET uid = '2344', name = '5001-7N', mail = 'support@007names.com', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', signature_format = '0', created = '1299082656', access = '1299082656', login = '1299082656', status = '1', timezone = '-18000', language = '', picture = '', init = 'support@007names.com', data = 'a:0:{}', timezone_name = '', data = 'a:11:{s:22:"profile_registrar_name";s:0:"";s:19:"profile_external_id";s:0:"";s:24:"profile_epp_registrar_id";s:0:"";s:15:"profile_iana_id";s:0:"";s:11:"profile_url";s:0:"";s:14:"profile_region";s:0:"";s:16:"profile_usertype";s:0:"";s:19:"profile_number_pass";s:10:"7358563104";s:19:"profile_cc_con_name";s:9:"Joyce Lin";s:26:"profile_credit_card_status";s:6:"ACTIVE";s:15:"profile_country";s:13:"United States";}' WHERE uid = 2344

robert castelo’s picture

robert castelo commented
Status: Active » Postponed (maintainer needs more info)

Please try the latest dev version and let me know if this error still occurs.

robert castelo’s picture

robert castelo commented
Status: Postponed (maintainer needs more info) » Fixed

Try User Import 6.x-4.1

I've removed some LIMIT clauses from SQL which are incompatible with Postgres.

Feel welcome to re-open the case if this hasn't fixed the issue.

Status: Fixed » Closed (fixed)

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