After updating to 6.x-1.4, I noticed the following SQL error in my database log:

db ERROR:  syntax error at or near "LEFT" at character 18
db STATEMENT:  UPDATE webform w LEFT JOIN node n ON w.nid = n.nid SET w.redirect_url = 'cart/checkout' WHERE n.type = 'paidevent';

I think it's something with the table alias. Anyway, I've attached a patch that uses a sub-select instead of a join and does not use table aliases in the update statement.

CommentFileSizeAuthor
uc_event_registration-update_6100_pgsql_error.patch627 bytesChrisLaFrancis

Comments

andyf’s picture

andyf commented
Status: Needs review » Fixed

Thanks so much. I've updated the code and created a new release.

If anyone finds this thread because they've done a db update to v1.4 while using PostgreSQL and got the OP's error, then use the following instructions. Note: It will reset any custom redirects on paidevents (if you've set any since updating to 1.4).

  1. Download v1.5 or greater.
  2. run drush ev 'module_load_install('uc_event_registration'); print_r(uc_event_registration_update_6100());'

Status: Fixed » Closed (fixed)

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