Forums / Install & configuration / postgre sql kernel_schema flawed!! workflow_event_pos
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
Saturday 27 September 2003 7:14:56 am
mabye i am running the black monday build? :-)
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?