Looking at 'My account' in a Drupal system using a PostgreSQL database and having the locale module enabled with Dutch as a default language (and nl.po imported), gives the following message appears for the account edit page (http://localhost/drupal/user/1/edit):

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "LIMIT" at character 64 in /var/www/drupal-cvs/includes/database.pgsql.inc on line 155.
* user warning: query: UPDATE locales_source SET version = '6.0-dev' WHERE lid = 1349 LIMIT 1 in /var/www/drupal-cvs/modules/locale/locale.module on line 354.

The reason seems to be that PostgreSQL doesn't allow a LIMIT keyword in an UPDATE query. The 'LIMIT 1' option also has no use, because the lid column is a primary key.
The attached patch removes the LIMIT part.

CommentFileSizeAuthor
locale.module_2.patch1.13 KBjpulles
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

JirkaRybka’s picture

JirkaRybka CreditAttribution: JirkaRybka commented
Status: Needs review » Reviewed & tested by the community

OK, the LIMIT is not necessary indeed. (I'm the one who added the query originally, didn't know that it's not cross-database compatible - sorry.)

Let's remove that unnecessary LIMIT now :-)

JirkaRybka’s picture

JirkaRybka CreditAttribution: JirkaRybka commented
Version: 6.0-beta2 » 6.x-dev

Oh, and this should go into 6.x-dev.

jpulles’s picture

jpulles CreditAttribution: jpulles commented

Nice to have such a fast response :-)

Gábor Hojtsy’s picture

Gábor Hojtsy
he/him
Primary language Hungarian
Location Hungary
CreditAttribution: Gábor Hojtsy commented
Status: Reviewed & tested by the community » Fixed

Indeed, sorry for not spotting this before committing that patch. Thanks, committed.

Anonymous’s picture

(not verified) CreditAttribution: commented
Status: Fixed » Closed (fixed)

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