Re: [Emerald] Incomplete upgrade..

Dale E. Reed Jr. ( (no email) )
Sat, 12 Dec 1998 23:20:24 -0800

Rick Knospler wrote:
>
> I upgraded a copy of my database to Emerald 2.5 RC3 and these are the error
> messages displayed during the database update... How can I fix this..?

The dropold.sql script drops the RadRoamServers table before the actuall
update begins (so that insttabs.sql can re-create it with the correct
fields). The only thing I could think is that the dropold.sql script
wasn't updated to the latest version that includes the dropping of the
RadRoamServers table.

> Invalid column name 'AuthPort'.
> IF (SELECT COUNT(*) FROM RadRoamServers WHERE RadRoamServerID = -1) = 0
> BEGIN
> SET IDENTITY_INSERT RadRoamServers ON
> INSERT INTO RadRoamServers(RadRoamServerID, IPAddress, Server, Secret,
> Timeout, Retries, TreatAsLocal, StripDomain, AuthPort, AcctPort, AllowRLogin)
> VALUES(-1, 'None', 'None', '', 0, 0, 0, 0, 1645, 1646, 0)
> SET IDENTITY_INSERT RadRoamServers OFF
> END

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html