Ralf, all,
After noticing there were no updates to 1.6 lately, I looked for a new version
and found 1.8. (looking back though the list, I see the announcement on 9/5). So
I decided to update. With just a few simple steps I was done and looking at 1.8.
Here are a few notes about the process that may save somebody a second or two
when they do the same:
(1) rename your old install, example:
cd /srv/http/htdocs
mv egroupware egroupware_16
(2) install 1.8 from svn
svn checkout http://svn.egroupware.org/egroupware/branches/1.8/aliases/default .
(3) look for changes in header.inc.php.template. The only differences I noted were:
if (substr($_SERVER['SCRIPT_NAME'],-7) != 'dav.php') // dont do it
for webdav/groupdav, as we can not savely switch it off again
{
ob_start(); // to prevent error messages to be send before
our headers
}
At that point I simply copied my existing header.inc.php from egroupware_16
to egroupware and added the webdav check.
(4) Enter setup:
http://yourserver/egroupware/setup
Update/backup database. (On my first attempt, I had an error due to no
sqlite support):
"An error happened
calendar_timezones::import_sqlite(‘calendar/setup/timezones.sqlite’) required
SQLite support (PHP extension pdo_sqlite) missing!
edit php.ini and fix"
If you get the same error, just edit /etc/php/php.ini and enable:
extension=pdo_sqlite.so
then restart apache (restart may not be necessary a ‘reload’ may work) We may
just want to drop an upgrade note to advise that pdo_sqlite is required. That
way people can check to make sure it is enabled and eliminate the message. (I
know that manually updating header.inc.php and jumping right to /setup isn’t the
normal way to upgrade, but I think it probably is the way a lot of people who
are familiar with egw will do it)
On the next backup attempt everything worked. I have included the table
alteration messages below for completeness:
AlterColumnSQL(‘egw_cal’,‘cal_creator’,Array ( [type] => int [precision] => 4
[comment] => creating user ) ) sql=Array ( [0] => ALTER TABLE egw_cal ADD
cal_creator INTEGER )
Duplicate column name ‘cal_creator’
AlterColumnSQL(‘egw_cal’,‘cal_created’,Array ( [type] => int [precision] => 8
[comment] => creation time of event ) ) sql=Array ( [0] => ALTER TABLE egw_cal
ADD cal_created BIGINT )
Duplicate column name ‘cal_created’
AlterColumnSQL(‘egw_cal’,‘cal_recurrence’,Array ( [type] => int [precision] => 8
[nullable] => [default] => 0 [comment] => cal_start of original recurrence for
exception ) ) sql=Array ( [0] => ALTER TABLE egw_cal ADD cal_recurrence
BIGINT NOT NULL DEFAULT 0 )
Duplicate column name ‘cal_recurrence’
AlterColumnSQL(‘egw_cal_user’,‘cal_role’,Array ( [type] => varchar [precision]
=> 64 [default] => REQ-PARTICIPANT ) ) sql=Array ( [0] => ALTER TABLE
egw_cal_user ADD cal_role VARCHAR(64) DEFAULT ‘REQ-PARTICIPANT’ )
Duplicate column name ‘cal_role’
CreateTableSQL(‘egw_cal_timezones’,‘tz_id I AUTOINCREMENT NOTNULL PRIMARY,
tz_tzid C(128) NOTNULL, tz_alias I4, tz_latitude I4, tz_longitude I4,
tz_component X’) sql=Array ( [0] => CREATE TABLE egw_cal_timezones ( tz_id
INTEGER NOT NULL AUTO_INCREMENT, tz_tzid VARCHAR(128) NOT NULL, tz_alias
INTEGER, tz_latitude INTEGER, tz_longitude INTEGER, tz_component TEXT,
PRIMARY KEY (tz_id) )CHARACTER SET latin1 )
Table ‘egw_cal_timezones’ already exists
CreateIndexSQL(NULL,‘egw_cal_timezones’,‘tz_tzid’,Array ( [0] => UNIQUE ) )
sql=Array ( [0] => ALTER TABLE egw_cal_timezones ADD UNIQUE INDEX
egw_cal_timezones_tz_tzid (tz_tzid) )
Duplicate key name ‘egw_cal_timezones_tz_tzid’
CreateIndexSQL(NULL,‘egw_cal_timezones’,‘tz_alias’,Array ( ) ) sql=Array ( [0]
=> ALTER TABLE egw_cal_timezones ADD INDEX egw_cal_timezones_tz_alias
(tz_alias) )
Duplicate key name ‘egw_cal_timezones_tz_alias’
(5) Recheck installation
All was good so it was back to user login for 1.8! Great job to all who
worked so hard on the new branch. It looks great. I’ll be sure and pass on any
quirks I find in the days ahead. Thanks.
–
David C. Rankin, J.D.,P.E.
Rankin Law Firm, PLLC
510 Ochiltree Street
Nacogdoches, Texas 75961
Telephone: (936) 715-9333
Facsimile: (936) 715-9339
www.rankinlawfirm.com
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
