[jonah] Re: RESOLVED: jonah_channels_seq again (postgresql)

[Stefan Hessenauer]

Jan Schneider <jan <at> horde.org> writes:

> 
> Zitat von Stefan Hessenauer <s.hessenauer <at> ppc-ag.de>:
> 
> > You have to create the sequence "jonah_channels_seq" and "jonah_stories_seq"
> >
> > This isn't in the script which creates the tables for jonah.
> 
> No, they get created by the PEAR DB package on demand.
> 

hm, not really. I get an error till i created these sequences manually.

the error:
Apr 19 15:38:07 HORDE [error] [jonah] DB Error: unknown error: SELECT
NEXTVAL('jonah_channels_seq') [nativecode=ERROR:  relation "jonah_channels_seq"
does not exist
] [on line 94 of "/var/www3/jonah/lib/News/sql.php"]
Apr 19 15:40:52 HORDE [error] [jonah] DB Error: unknown error: SELECT
NEXTVAL('jonah_stories_seq') [nativecode=ERROR:  relation "jonah_stories_seq"
does not exist
] [on line 211 of "/var/www3/jonah/lib/News/sql.php"]


I got same error for horde_datatree_seq. 
"fascinating"