Accounting 2.0 - Prompted Message: Error during upgrade to 2-Invalid Data Definition Language Statement and ALTER TABLE dbo.ADVQT…Guid

From AutoCount Resource Center

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]

Alter table advqt1.png

Alter table advqt2.png

Possible Reason:

The registry value failed to upgrade properly when upgrading the database.


1) Search and open SQL Management Studio from window search.

Alter table advqt3.png

2) Click the database name and Execute the below query:

UPDATE REGISTRY SET RegValue = '2.2.23' WHERE RegID = 2

Alter table advqt4.png

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

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations