Jeroen Reijn wrote:
Hi Slavic,

did you also use the correct workflow configuration? I just noticed there is 
nog workflow template defined for PostgreSQL eventhough I know people are using 
postgress.

See [1] for workflow templates for other databases.
You can also find some details at:

http://www.hippocms.org/display/CMS/Configuring+the+workflow+databases

Regards,
Bart



Regards,

Jeroen Reijn

[1] 
http://svn.hippocms.org/repos/hippo/hippo-cms/branches/Branch-CMS-v6_05_xx/editor/templates/


-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Stevo Slavic
Sent: Wed 4/16/2008 1:59 PM
To: [email protected]
Subject: [HippoCMS-dev] Hippo CMS 6.05.02 on PostgreSQL 8.2.7 issue
When selecting a document in Hippo CMS which is on Postgres 8.2.7, on right hand side following error message gets displayed:

An error occured during loading: com.opensymphony.workflow.StoreException: Error creating new workflow instance: root cause: ERROR: relation "os_wfentryids" does not exist (file:/home/hippo/miles/editor-v6.05.02/cocoon/../sites/h


When inspecting "osworkflow" database in Postgres and comparing it to the same database in MySQL, table "os_wfentryids" is not present in Postgres, but sequence "seq_os_wfentry" is. Similarly, table "os_stepids" is not present in Postgres but there is a sequence "seq_os_currentsteps". osworkflow database schema was initialized with SQL script found in latest Hippo CMS sources. What should I do to resolve the issue? Thanks in advance!

********************************************
Hippocms-dev: Hippo CMS development public mailinglist

********************************************
Hippocms-dev: Hippo CMS development public mailinglist


--
Hippo B.V.  -  Amsterdam
Oosteinde 11, 1017 WT, Amsterdam, +31(0)20-5224466

Hippo USA Inc.  -  San Francisco
101 H Street, Suite Q, Petaluma CA, 94952-3329, +1 (707) 773-4646
-----------------------------------------------------------------
http://www.onehippo.com   -  [EMAIL PROTECTED]
-----------------------------------------------------------------
********************************************
Hippocms-dev: Hippo CMS development public mailinglist

Reply via email to