Install OpenSuse Build Dated 26 Jun on Centos5 with Yum: Table ctags missing in schema

Hello list,
I just subscribed to ask for a solution to a problem that I managed to
clear myself. I think other people will stumble over it so I'm posting
to preserve the info for others:

SETUP:

Centos 5.3 Base install with Gnome Desktop

Added following repository:

[server_OpenGroupware]
name=OpenGroupware.Org Groupware Server & Collaberation Platform (CentOS_5)
type=rpm-md
baseurl=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/
gpgcheck=1
gpgkey=http://download.opensuse.org/repositories/server:/OpenGroupware/CentOS_5/repodata/repomd.xml.key
enabled=1



INSTALL:

yum install ogo-meta-5.5-8.2 ogo-database-setup-1.1-14.2
Everthing installs nice an the server is up and running.
Browsing http://localhost/OpenGroupware works fine


PROBLEM:

Changing the password leads to a "Check Password" Error which links to
following line in the logs:

name:   PostgreSQL72FatalError  reason: fatal pgsql error
(channel=<0x0x9cb52c4[PostgreSQL72Channel]:
connection=<0x0x9cb54ac[PGConnection]:  connection=0x0x9cb5ce0>>):
ERROR:  relation "ctags" does not exist



SOLUTION:
The Suse Build is from the 26-Jun
I found
http://mail.opengroupware.org/pipermail/developer/2009-June/003812.html
which was already checked in before 26 Jun.

Apparently the schema files

/usr/lib/opengroupware.org-5.5/commands/OGo.model/Resources/pg-build-schema.psql
/usr/share/opengroupware.org-1.1/dbsetup/PostgreSQL/pg-build-schema.psql

were not updated to represent this change and are missing the ctags table.


So just add it:

CREATE TABLE ctags (
  entity VARCHAR NOT NULL,
  ctag  INTEGER NOT NULL DEFAULT 0
);

INSERT INTO ctags (entity) VALUES ('Person');
INSERT INTO ctags (entity) VALUES ('Enterprise');
INSERT INTO ctags (entity) VALUES ('Date');
INSERT INTO ctags (entity) VALUES ('Job');
INSERT INTO ctags (entity) VALUES ('Team');


Hope that my description is clear enough and helps others.
Should I open a bug somewhere or post to developper list?

Have fun Marc



-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users