IMP 2.2.x to 3.0.x DataBase Upgrade
Brian Helman
bhelman@salemstate.edu
Tue, 15 Jan 2002 16:28:33 -0500
Is it possible to upgrade the IMP 2.2 database to 3.0? I've spent the
better part of today trying to find references to the new db structure with
no luck. I am running postrgesql.
I backed up my existing db and installed it on a test server. I verified
that it backed up/restored correctly by pointing my IMP 2.2 to it
temporarily. I then configured my 3.0 installation to point to the
restored db and tried to log in. I received the following error:
A fatal error has occurred:
object(db_error)(7) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-19)
["message"]=>
string(23) "DB Error: no such field"
["userinfo"]=>
string(434) "update imp_pref set pref_value =
'a:1:{i:0;a:9:{s:2:"id";s:16:"Default
Identity";s:8:"fullname";s:0:"";s:9:"from_addr";s:0:"";s:12:"replyto_addr";s:0:"";s:9:"signature";s:0:"";s:9:"sig_first";i:0;s:10:"sig_dashes";i:0;s:14:"save_sent-mail";N;s:16:"sent_mail_folder";s:9:"sent-mail";}}'
where pref_uid = 'bhelman@salemstate.edu' and pref_name = 'identities' and
pref_scope = 'horde' [nativecode=ERROR: Attribute 'pref_uid' not found
]"
["callback"]=>
NULL
}
[/var/www/html/horde/lib/Prefs/sql.php : 273]
thanks,
brian
------------------------------------------------------
__ ____ __ ____ __ __
/\ \ / \_\ / /\ / \ \ / |\ / /\
/ \_\ / /\ |_| / / /| /\ \ \ / ||/ / /
/ /\ | |\ \/ /_/_ / / / \ \/ \ \ / |/ / /
/ \/ |_| \ __ \_\ / / / \ /\ \_\ / /| / /
/ /\ ./_/ \ \ \/_// / / \ \ \/_// / | / /
\ \/ |_| \ \_\ /_/ / \ \_\ /_/ /|_/ /
\__/_/ \/_/ \_\/ \/_/ \_\/ \_\/
Brian M Helman
Director, Networking Services
Salem State College
e-mail: bhelman@salemstate.edu
snail-mail: 352 Lafayette St, MH207A
Salem, MA 01970-5353