problem with kernel_schema.sql, ezPublish 3.7.2

problem with kernel_schema.sql, ezPublish 3.7.2

Tuesday 27 December 2005 8:32:26 pm - 4 replies

Author Message

Dmitry Lakhtyuk

Wednesday 04 January 2006 2:05:51 am

hi.
1. What version of postgresql do you use?
2. Why do you think 'kernel_schema.sql' has wrong format(where/what errors do you have)?
3. You can't use files for 3.4 in 3.7 since they don't have necessary data.

Serg Tsay

Thursday 05 January 2006 12:44:36 am

Thank's for reply.

ezpublish-3.7.2
php-4.4.1
postgresql-v7.4.9

File kernel_schema.sql in folder kernel/sql/postgresql and in kernel/sql/mysql are the same.

Some first string from kernel/sql/postgresql/kernel_schema.sql :

CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL default '0',
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
);

CREATE TABLE ezbasket (
id int(11) NOT NULL auto_increment,
order_id int(11) NOT NULL default '0',
productcollection_id int(11) NOT NULL default '0',
session_id varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY ezbasket_session_id (session_id)
);

From kernel/sql/mysql/kernel_schema.sql :

CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL default '0',
id int(11) NOT NULL auto_increment,
workflow_process_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
);

CREATE TABLE ezbasket (
id int(11) NOT NULL auto_increment,
order_id int(11) NOT NULL default '0',
productcollection_id int(11) NOT NULL default '0',
session_id varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY ezbasket_session_id (session_id)
);

Serg Tsay

Wednesday 11 January 2006 11:23:38 pm

Dmitry where are you? Anybody help, please.

This bug in distributed ezPublish 3.7.2 file.
I download ezPublish 3.7.0 file kernel_schema.sql for postgres are normal.
May be i can use them in 3.7.2 ?

Dmitry Lakhtyuk

Thursday 12 January 2006 1:05:08 am

Looks like something wrong happened during building subrelease.
You can use kernel_schema.sql from 3.7.0. In addition you should apply
'update/database/postgresql/3.7/dbupdate-3.7.1-to-3.7.2.sql'.
Btw, new subrelease 3.7.3 should be out next week

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.