"Insert Error” when upgrading from AccessServer version 1.1.x
Number
319
Date
16 March 2011
Product
AccessServer
Question
Why can't I upgrade from AccessServer version 1.1.x?
Answer
When trying to upgrade AccessServer (AS) from relatively old previous versions (1.1.x, versions prior to January, 2010), a problem occurs during the database model update, producing an error similar to this:
"Insert Error: Column name or number of supplied values does not match table definition."
This stops the AccessServer setup process from finishing correctly.
The problem will occur if the "rids" table in the AccessServer database does not have a column named "signature", or if a record with id='dbmodelversion' and val=100 does not exist.
Workaround
You can prevent the problem from occurring by running the following SQL script in the AccessServer database:
ALTER TABLE rids ADD signature varchar(65) DEFAULT '0';
INSERT INTO rids (id, val) VALUES( 'dbmodelversion', 100 );
Version which has solved the problem
1.2.9.1364
