Upgrade from 1.0 to 1.4 and the Wiki

drumz 2007-06-20 22:55:12 UTC #1

I’m preparing to upgrade a production system from 1.0 to 1.4. I’ve uncovered a few issues which I’ve been able to figure out and get resolved, but I’m having problems with the Wiki. (It should be noted that I’ve duplicated the production system in a test environment so everything I’ve done below has been performed on a test system, NOT the production system.)

After upgrading, all of the recent information is ‘gone.’ By that I mean all I see is a subset of all of the pages the users have created. Digging into the database tables, I see egw_wiki_ and phpgw_wiki_. I looked at the phpgw_wiki_pages table I found all of the ‘missing’ pages. The egw_wiki_pages table contained the older version.

So I deleted all of the data from the egw_wiki_ tables and copied all of the data from the corresponding phpgw_wiki_ tables into them. I’m still left seeing an ‘older’ version of the Wiki.

I followed the upgrade instructions (went to /egroupware/setup) and updated the header.inc.php file, then performed a database upgrade (which erronously reported that it detected a version 1.2 schema when it was really 1.0) and no errors were reported. (I have also tried going from 1.0 to 1.2 and the Wiki showed the same problem.)

So how do I get the Wiki straightened back out after the upgrade? (Even if I search the Wiki for a page it still doesn’t see it even though I can see it in both the egw and phpgw_wiki_pages table.)

Thanks!

Ralf_Becker_6 2007-06-21 07:30:02 UTC #2

Hi,

that a bug in the upgrade procedure. Either use a complete svn checkout
of the 1.4 release (www.egroupware.org/wiki/subversion), or download
http://svn.egroupware.org/egroupware/branches/1.4/phpgwapi/setup/tables_update_1_2.inc.php
or wait for the 1.4.002 coming out the next days.

The first option gives your probably the highest flexibility, as you can
always updated it.

Ralf

drumz schrieb:

I’m preparing to upgrade a production system from 1.0 to 1.4. I’ve uncovered
a few issues which I’ve been able to figure out and get resolved, but I’m
having problems with the Wiki. (It should be noted that I’ve duplicated the
production system in a test environment so everything I’ve done below has
been performed on a test system, NOT the production system.)

After upgrading, all of the recent information is ‘gone.’ By that I mean
all I see is a subset of all of the pages the users have created. Digging
into the database tables, I see egw_wiki_ and
phpgw_wiki_. I looked at the phpgw_wiki_pages table I found all
of the ‘missing’ pages. The egw_wiki_pages table contained the older
version.

So I deleted all of the data from the egw_wiki_ tables and copied
all of the data from the corresponding phpgw_wiki_ tables into
them. I’m still left seeing an ‘older’ version of the Wiki.

I followed the upgrade instructions (went to /egroupware/setup) and updated
the header.inc.php file, then performed a database upgrade (which erronously
reported that it detected a version 1.2 schema when it was really 1.0) and
no errors were reported. (I have also tried going from 1.0 to 1.2 and the
Wiki showed the same problem.)

So how do I get the Wiki straightened back out after the upgrade? (Even if
I search the Wiki for a page it still doesn’t see it even though I can see
it in both the egw and phpgw_wiki_pages table.)

Thanks!

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

drumz 2007-06-22 16:00:09 UTC #3

Hi Ralf:

I recreated everything and using the svn version attempted the upgrade again. The result was the same, the Wiki shows old data. Th e egw_wiki_pages table contains the old data and the phpgw_wiki_pages table contains all of the new pages/data.

Paul

Ralf_Becker_6 2007-06-22 18:50:17 UTC #4

have you droped the database or all tables, before you restored the backup?

Ralf

drumz schrieb:

Hi Ralf:

I recreated everything and using the svn version attempted the upgrade
again. The result was the same, the Wiki shows old data. Th e
egw_wiki_pages table contains the old data and the phpgw_wiki_pages table
contains all of the new pages/data.

Paul

Ralf Becker-3 wrote:

Hi,

that a bug in the upgrade procedure. Either use a complete svn checkout
of the 1.4 release (www.egroupware.org/wiki/subversion), or download
http://svn.egroupware.org/egroupware/branches/1.4/phpgwapi/setup/tables_update_1_2.inc.php
or wait for the 1.4.002 coming out the next days.

The first option gives your probably the highest flexibility, as you can
always updated it.

Ralf

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

drumz 2007-06-22 19:30:26 UTC #5

I completely dropped the database and recreated it, then imported from a backup dump. (I’m running postgres for the backend.)

[quote=“Ralf Becker-3”]
have you droped the database or all tables, before you restored the backup?

Ralf

drumz schrieb:

Hi Ralf:

I recreated everything and using the svn version attempted the upgrade
again. The result was the same, the Wiki shows old data. Th e
egw_wiki_pages table contains the old data and the phpgw_wiki_pages table
contains all of the new pages/data.

Paul

drumz 2007-06-25 13:51:19 UTC #6

Here’s additional information that may help in troubleshooting this problem.

The version of eGroupware I’m attempting to upgrade from based on the text at the bottom of a web page is: 1.0.0.008
Clicking on ‘About WIKI’ shows the Wiki version to be: 1.0.0.001

After logging into the ‘setup’ page to do the configuration for the upgrade it says:
You appear to be running version 1.2.100 of eGroupWare.
We will automatically update your tables/records to 1.5.001…

(If we’re running eGroupware v1.0.0.008, is it stating we’re running version 1.2.100 accurate?)

After clicking on the ‘Upgrade’ button to perform the database upgrade, the following text appears - but no errors are reported:

AlterColumnSQL(‘egw_vfs’,‘vfs_content B’,‘vfs_file_id I AUTOINCREMENT NOTNULL PRIMARY, vfs_owner_id I4 NOTNULL, vfs_createdby_id I4, vfs_modifiedby_id I4, vfs_created T DEFTIMESTAMP NOTNULL, vfs_modified T, vfs_size I4, vfs_mime_type C(64), vfs_deleteable C(1) DEFAULT ‘E’E\\’::character varying’, vfs_comment C(255), vfs_app C(25), vfs_directory C(233), vfs_name C(100) NOTNULL, vfs_link_directory C(255), vfs_link_name C(128), vfs_version C(30) NOTNULL DEFAULT ‘E’E\\’::character varying’, vfs_content B’) sql=

Array
(
[0] => BEGIN
[1] => SELECT * INTO TEMPORARY TABLE egw_vfs_tmp FROM egw_vfs
[2] => DROP TABLE egw_vfs
[3] => CREATE TABLE egw_vfs (
vfs_file_id SERIAL,
vfs_owner_id INT4 NOT NULL,
vfs_createdby_id INT4,
vfs_modifiedby_id INT4,
vfs_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
vfs_modified TIMESTAMP,
vfs_size INT4,
vfs_mime_type VARCHAR(64),
vfs_deleteable VARCHAR(1) DEFAULT ‘E\’,
vfs_comment VARCHAR(255),
vfs_app VARCHAR(25),
vfs_directory VARCHAR(233),
vfs_name VARCHAR(100) NOT NULL,
vfs_link_directory VARCHAR(255),
vfs_link_name VARCHAR(128),
vfs_version VARCHAR(30) DEFAULT ‘E\’ NOT NULL,
vfs_content BYTEA,
PRIMARY KEY (vfs_file_id)
)
[4] => INSERT INTO egw_vfs SELECT CAST(vfs_file_id AS INTEGER), vfs_owner_id, vfs_createdby_id, vfs_modifiedby_id, vfs_created, vfs_modified, vfs_size, vfs_mime_type, vfs_deleteable, vfs_comment, vfs_app, vfs_directory, vfs_name, vfs_link_directory, vfs_link_name, vfs_version, CAST(vfs_content AS BYTEA) FROM egw_vfs_tmp
[5] => SELECT setval(‘egw_vfs_vfs_file_id_seq’,MAX(vfs_file_id)) FROM egw_vfs
[6] => DROP TABLE egw_vfs_tmp
[7] => CREATE INDEX egw_vfs_directory_name_mime_type ON egw_vfs (vfs_directory, vfs_name, vfs_mime_type)
[8] => COMMIT
)

If I then click on ‘Re-Check My Installation’ it appears that the upgrade went OK and all I have to do is fix the ‘Missing or Incomplete Mailserver configuration’, which is fixed by installing the ‘emailadmin’ application and then updating the configuration. (We don’t use any email features in eGroupware, hence the reason it’s not installed.)

Paul