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.


Solution:

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