MSSQL - APPLICATION ERROR #401

poconnor · Post by **poconnor** » 21 Apr 2005, 16:51

Looks like I got MSSQL setup and connecting but the Admin / Upgrade process gives an error. See below:

APPLICATION ERROR #401
Database query failed. Error received from database was #170: Line 1: Incorrect syntax near 'mantis_upgrade_table'. for the query: CREATE TABLE IF NOT EXISTS mantis_upgrade_table
(upgrade_id char(20) NOT NULL,
description char(255) NOT NULL,
PRIMARY KEY (upgrade_id))

Any help is appreciated...

poconnor · Post by **poconnor** » 21 Apr 2005, 16:58

Looks like the file sql/mssql.sql is very old and is missing the last several upgrades. I added a few of the missing fields to the user table and can view the data without any problems.

I would rather run the normal upgrade process to make sure I create everything correctly. See earlier post...