Question: When upgrade database from 1.9 to version 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Column already has a DEFAULT bound to it”. After click OK, another message prompted “ALTER TABLE [dbo].[ADVQT] ADD DEFAULT (newid()) FOR [Guid]
The registry value failed to upgrade properly when upgrading the database.
1) Search and open SQL Management Studio from window search.
2) Click the database name and Execute the below query:
UPDATE REGISTRY SET RegValue = '2.2.23' WHERE RegID = 2
Now, you may login to AutoCount Accounting 2.0 again and proceed with the database upgrade.
Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.
By: Jodie 220715, Lay Swan 220727, P220728
|AutoCount Accounting 2.0 & 2.1
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations