Here is the output :

Drupal database update

    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: la relation « ec_receipt_paypal_payer_email_idx » existe déjà in /home/html/manifestation-contre-hadopi/includes/database.pgsql.inc on line 139.
    * user warning: query: CREATE INDEX ec_receipt_paypal_payer_email_idx ON ec_receipt (paypal_payer_email) in /home/html/manifestation-contre-hadopi/includes/database.pgsql.inc on line 828.

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

    * Main page
    * Administration pages

The following queries were executed
ec_paypal module
Update #6401

    * ALTER TABLE {ec_receipt} ADD COLUMN paypal_payer_email varchar(127) NOT NULL default ''
    * Failed: CREATE INDEX {ec_receipt}_paypal_payer_email_idx ON {ec_receipt} (paypal_payer_email)
    * ALTER TABLE {ec_receipt} ADD COLUMN paypal_subscr_id varchar(127) NOT NULL default ''

Update #6402

    * Failed:

Comments

grub3’s picture

grub3 commented

Update 6401 was just a warning. The index already existed (since I was upgrading from dev).
I have no idea why update 6402 failed.

grub3’s picture

grub3 commented

Okay, more information on 6402 (as replaying it):

UPDATE ec_receipt r, ec_receipt_paypal rp 
SET r.extern_id = rp.txn_id, 
r.paypal_payer_email = rp.payer_email 
WHERE r.erid = rp.erid

This update query on a join is not supported by PostgreSQL.

gordon’s picture

gordon commented
Status: Active » Fixed

I have changed the select, can you please give a look and let me know how if it works.

Status: Fixed » Closed (fixed)

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