Forums / Install & configuration / postgre sql kernel_schema flawed!! workflow_event_pos

postgre sql kernel_schema flawed!! workflow_event_pos

Author Message

christian stampf

Friday 26 September 2003 7:58:27 am

the postgreSQL kernel schema is flawed, as everybody running postgreSQL will notice. the table "ezcontentobject_version" is missing the field "workflow_event_pos". i inserted the line below and things worked for me.

workflow_event_pos integer DEFAULT '0' NOT NULL,

but i wonder if there are any more surprises. anybody has had success with ez32 and postgreSQL? i wonder if there are some sites running already...

-----------------------------
i am getting an error when attempting to create a folder in the content section - which is empty after install:

Error: error executing query: SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos
FROM ezcontentobject_version
WHERE version='1' AND contentobject_id='46'
ORDER BY version ASC ERROR: Attribute 'workflow_event_pos' not found

Kai Duebbert

Saturday 27 September 2003 1:43:35 am

No problems here using Postgresql. I did apply the corporate sql though.

Kai

christian stampf

Saturday 27 September 2003 7:14:56 am

mabye i am running the black monday build? :-)

christian stampf

Saturday 27 September 2003 7:18:30 am

any chance you are running on a shared host account?

i am desperately looking for a good and fast host that will let me run ez 3.2 on postgreSQL with unicode!

cfa cfa

Sunday 28 September 2003 7:40:23 am

i am also getting an error with the kernel_schema s first line:

SET search_path = public, pg_catalog;

.. something like error around public (running postgresql 7.2.x with all the specs correct)

any ideas?