Accounting 2.0 - 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]

Possible Reason:

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

Solution:

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

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note AutoCount Accounting 2.2 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations