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

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

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.


--Source from AutoCount Wiki --