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...
Search found 2 matches
- 21 Apr 2005, 16:58
- Forum: Help
- Topic: MSSQL - APPLICATION ERROR #401
- Replies: 1
- Views: 5513
- 21 Apr 2005, 16:51
- Forum: Help
- Topic: MSSQL - APPLICATION ERROR #401
- Replies: 1
- Views: 5513
MSSQL - APPLICATION ERROR #401
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 ...
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 ...