Bud, Run "DBupdate.exe columns.lst" from the command line in the Imail directory. It will update all the tables at once. If you have problems with it not adding the 2 new culumns and if you have special columns in the tables that you have added yourself be sure to add them the to columns.lst file. Also make sure the database or tables are not locked when you do this.
-- Sean Kenworthy -- Sr. IMail Software QA Engineer -- Ipswitch, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bud Sent: Wednesday, May 15, 2002 9:12 AM To: [EMAIL PROTECTED] Subject: RE: [IMail Forum] Upgrade 6.06->7.1 - can't login to web client on ODBC based accounts On 5/14/02, Ron Hornbaker penned: >If you are currently using an external user database with an earlier >(pre-v7.0) version of IMail, you must add a new set of required columns to >the database table in which user information is stored. Table? Cripes, there's a table for every domain. I wish they'd have designed the database correctly with a "domains" table and a "users" table related to that. It would sure make adding a couple dozen columns much easier. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
