Serendipity Forums

Hi

I tried to install seredipity 1.1 to CentOS 4.3 using postgresql-8.1.3 as database and i'm getting error messages shown below. After install i cant login with my admin account. any suggestions how to fix this? (sorry about the spelling english is not my native language)

Checking to see if the database and tables already exists... they do not
Creating default database setup... Done
Creating primary author 'username'...
Warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "serendipity_authors_authorid_seq" is not yet defined in this session in /home/html/serendipity/include/db/postgres.inc.php on line 161

Warning: pg_num_rows(): supplied argument is not a valid PostgreSQL result resource in /home/html/serendipity/include/db/postgres.inc.php on line 162

Warning: pg_last_oid(): supplied argument is not a valid PostgreSQL result resource in /home/html/serendipity/include/db/postgres.inc.php on line 166
Done
Setting default template... Done
Installing default plugins... Error: serendipity_event_browsercompatibility:8d40effdea60c6466773d9aaacd649fe ()
Done
Attempting to write .htaccess file...... Done

Hi!

I'm not so familar with PGSQL, but did you enable its use of automatic sequences? There must be a trigger for pgsql to do that.

HTH,
Garvin

garvinhicking wrote:Hi!

I'm not so familar with PGSQL, but did you enable its use of automatic sequences? There must be a trigger for pgsql to do that.

HTH,
Garvin

I'm not sure what automatic sequences are? How one enables those?

When new table is created and has a column and it's type is serial the database creates the sequnce automatically.

Hi!

Sadly I don't know myself I just know that PGSQL has an option for those "oid" parameters. Maybe you can ask in a PGSQL specific forum?

Somehow pgsql supports autoincrement keys (aka sequences), and usually pgsql has this option enabled...?!

HTH,
Garvin