Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Upgrading from 1.8 to 2.2

web-app

I am trying to upgrade my setup which is on a Japanese Windows 2000 Server SP4 with MSDE. I am using the manual database upgrade process, which seems to contain a bug where a field named "projarchived" isn't being added to table "project". I think I have managed to correct this issue, but I am still getting the following error when I open Main.aspx:

Exception information:
    Exception type: SqlException
    Exception message: 構文エラー。varchar 値 'N' から bit データ型に変換できませんでした。
  (Which means Syntax error. Could not convert varchar value 'N' to bit)

Request information:
    Request URL: http://apps.fujisan.co.jp/gemini/Main.aspx
    Request path: /gemini/Main.aspx

Can you tell me which field needs to be converted to bit?
akamiya
· 1 		akamiya
Thursday, February 28, 2008, 11:39:21 PM
Replies (2)
helpful
0
not helpful

Did you run the upgrade scripts in the correct order?

See: http://www.countersoft.com/Downloads/Installing%20Gemini.pdf
Mark Wing
· 9108 		Mark Wing
Friday, February 29, 2008, 9:04:26 AM
helpful
0
not helpful

Yep, I did.

The problem was with how I added the field projarchived. I assumer it would be the same as verarchived in version table (a bit), but looking in the CreateTables.sql it turns out to be a varchar(1). So I replaced the bit field with varchar(1) and it now seems to be working.

The line I added to Upgradev1-9.sql is the following:
alter table projects add projarchived nvarchar(1) not null default('N')
akamiya
· 1 		akamiya
Saturday, March 1, 2008, 1:25:11 AM