In a fresh installation using postgresql,
the missing sequence is preventing (for example) drupal_next_id to function properly. As a result, files upload isn't working as described here:
http://drupal.org/node/100477

to fix the situation manually:

  CREATE SEQUENCE file_fid_seq
   INCREMENT 1
   MINVALUE 1;

from a psql console in the drupal database.

I'm asking to port this fix (or an equivalent solution) to the core (i don't know where this statement belongs... maybe the install procedure?).

Comments

evui’s picture

evui commented
Version: 4.7.4 » 5.x-dev

I posted the issue against 4.7 but it belongs in 5.x-dev

evui’s picture

evui commented

I believe i've posted a duplicate of this issue:
http://drupal.org/node/100143

if some developer is sure it's a duplicate, can he/she close this issue?

sammys’s picture

sammys commented

Thank you for submitting this bug report. It definitely is a duplicate and a final patch has been supplied over in the other issue (link given above).

We will not be providing an update function for people updating Drupal 5.0 beta 2 to later versions. We are unable to do this because 4.7 had a sequence in it and so the update only applies to Drupal 5.0 beta 1 and beta 2. Please use the instructions given in the other bug posting to update your beta 1/2 files table.

Be careful though because the update neglectfully removes files uploaded rather than updating them properly.

Cheers,

Sammy Spets
Synerger
http://synerger.com

sammys’s picture

sammys commented
Status: Active » Closed (duplicate)

Setting to duplicate.