When I run the Update for the 2.5 Release2 database I get the following
errors:
Attempt to initiate a new SQL Server operation with results pending.
Command has been aborted.
IF (SELECT COUNT(*) FROM ObjectGroups) = 0
BEGIN
INSERT ObjectGroups VALUES ( -1, 'All')
INSERT ObjectGroups VALUES (001, 'General')
INSERT ObjectGroups VALUES (002, 'Accounting')
INSERT ObjectGroups VALUES (003, 'Client')
INSERT ObjectGroups VALUES (004, 'RADIUS')
INSERT ObjectGroups VALUES (005, 'Security')
INSERT ObjectGroups VALUES (006, 'Web')
INSERT ObjectGroups VALUES (101, 'MBR')
INSERT ObjectGroups VALUES (102, 'Services')
INSERT ObjectGroups VALUES (103, 'Incidents')
INSERT ObjectGroups VALUES (104, 'Invoices')
INSERT ObjectGroups VALUES (105, 'Reports')
INSERT ObjectGroups VALUES (106, 'Classes')
INSERT ObjectGroups VALUES (107, 'RADIUS Logs')
END
---------------
Command has been aborted.
IF (SELECT COUNT(*) FROM ChargeTypes) = 0
BEGIN
INSERT ChargeTypes (Description,Amount,TaxID,GroupID) VALUES('PPP Setup',
20.00, NULL, NULL)
INSERT ChargeTypes (Description,Amount,TaxID,GroupID) VALUES('DNS
Registration', 35.00, NULL, NULL)
INSERT ChargeTypes (Description,Amount,TaxID,GroupID) VALUES('Reactivation
Fee', 10.00, NULL, NULL)
END
---------------
Command has been aborted.
IF (SELECT COUNT(*) FROM PayMethods) = 0
BEGIN
INSERT PayMethods VALUES('Invoice', NULL, 1)
INSERT PayMethods VALUES('Renewal', NULL, 2)
INSERT PayMethods VALUES('Purchase Order', NULL, 3)
INSERT PayMethods VALUES('Credit Card', NULL, 4)
INSERT PayMethods VALUES('Bank Transfer', NULL, 5)
INSERT PayMethods VALUES('Custom', NULL, 6)
INSERT PayMethods VALUES('Other', NULL, 7)
END
---------------
Command has been aborted.
IF (SELECT COUNT(*) FROM PaymentTypes) = 0
BEGIN
INSERT PaymentTypes VALUES('Cash', NULL, 1)
INSERT PaymentTypes VALUES('Check', NULL, 2)
INSERT PaymentTypes VALUES('Credit Card', NULL, 3)
INSERT PaymentTypes VALUES('Bank Tranfer', NULL, 4)
INSERT PaymentTypes VALUES('Other', NULL, 5)
END
---------------
Command has been aborted.
IF (SELECT COUNT(*) FROM PayPeriods) = 0
BEGIN
INSERT PayPeriods VALUES('Monthly', 1, 100, 0, NULL, 1)
INSERT PayPeriods VALUES('Quarterly', 3, 80, 0, NULL, 3)
INSERT PayPeriods VALUES('Six Months', 6, 70, 0, NULL, 6)
INSERT PayPeriods VALUES('Yearly', 12, 60, 0, NULL, 12)
END
---------------
Invalid object name 'RadConfigs_Old'.
if exists (select * from sysobjects so where so.name = "RadConfigs_Old")
BEGIN
Update RadConfigs_Old
Set RadVendorID = 0 Where RadVendorID is NULL
Update RadConfigs_Old
Set RadVendorType = 0 Where RadVendorType is NULL
Insert Into RadConfigs(AccountID, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck)
Select AccountID, RadAttributeID, RadVendorID, RadVendorType, Data, Value,
RadCheck