Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Installation Error - Failed to alter rating column in Links table

Quote Reply
Installation Error - Failed to alter rating column in Links table
I got the following error when updating from Links SQL 2.0.5 to 2.2.1:


Performing Links SQL 2.2.0 -> 2.2.1 upgrades...
Updating Rating column in Links table...
Could not alter column Rating: Failed to execute query: 'ALTER TABLE links_Links ALTER COLUMN Rating DECIMAL(4, 2) DEFAULT '0' NOT NULL': [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DEFAULT'. (SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)
Updating payments_term column in Payments table...
Okay!
Checking fk_tables...
Okay!
Links SQL 2.2.0 -> 2.2.1 upgrades performed.




Currently the Rating column in the links_Links table is set to a size of 8, DEFAULT = 0, and Null is unchecked. Do I have to worry about this error?
Everything seems to be working fine in the program. I am just trying to make sure that I am covered.
This was the only section of the upgrade process that had an error.

Thanks in advance.