Running update.php from a drupal-4.4.0 to 4.4.1 does not work when using postgresql. Also, database.pgsql was not corrected for 4.4.1.

A patch is included, though I still receive this error message when updating:

Note: this might take a while ...

user error: DB Error: unknown error

query: INSERT INTO users (created, changed, uid, data) VALUES ('1083470152', '1083470152', '17', 'N;') in /usr/share/drupal/includes/database.pear.inc on line 89.

ALTER TABLE {users} RENAME timestamp TO changed

OK

In my case, the maximum uid is 16. This insert line uses a default name of '', which is already being used for uid of 0. Since a unique is made on name, the insertion fails. I don't know where this insert comes from.

CommentFileSizeAuthor
#1 4.4.1_0.patch20.89 KBnereocystis
4.4.1.patch20.68 KBnereocystis
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

nereocystis’s picture

nereocystis CreditAttribution: nereocystis commented
FileSize
4.4.1_0.patch20.89 KB

Oops.

I missed a couple of fields where each row had to set to a non-NULL value before the field is set to require non-NULL. I hope this patch covers everything.

This patch is a complete patch from 4.4.1 as distributed, and not based upon the previous patch.

Dries’s picture

Dries CreditAttribution: Dries commented

This patch is against HEAD. Drupal 4.4.1 was tagged incorrectly. Thanks for the patches. I'll commit them to HEAD shortly.

Dries’s picture

Dries CreditAttribution: Dries commented

I committed your patch to HEAD. Thanks!

Anonymous’s picture

(not verified) CreditAttribution: commented