INSERT IGNORE is a MySQL specific syntax used in user_terms.module line 401. The code preceding it removes and terms before re inserting therefore has no reason to use this style syntax.

Can you please remote the 'IGNORE' part which will make PostgreSQL users much happier.

CommentFileSizeAuthor
#1 1033208.user_terms.remove-insert-ignore.patch675 bytesjoachim
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

joachim’s picture

joachim CreditAttribution: joachim commented
Version: 6.x-1.3 » 6.x-1.x-dev
Status: Active » Fixed
FileSize
1033208.user_terms.remove-insert-ignore.patch675 bytes

Yup, you're right, there's no need for the IGNORE as the old terms are all deleted first. Thanks for reporting this.

Committed this patch.

#1033208 by joachim: Fixed invalid syntax for PostgreSQL.

Status: Fixed » Closed (fixed)

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