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