CounterSoft Community Server

Hello,

I have installed Gemini web version 2.1.1 and I would like to upgrade my Gemini to the latest 3.0.3 version.

I download the file "CounterSoft_Gemini_v3_0_3.zip", and follow the procedures in "Gemini_Installation_Guide.pdf", section 8.5 "v2.1.x" insctructions. My status:

1. Execute “UPGRADE_v2-2.sql” in Gemini Issues Database - Success

2. Execute “CREATE_VIEWS.sql” in Gemini Issues Database - Failed

3. Execute “CREATE_PROCS.sql” in Gemini Issues Database - Success

Can you suggest what was I doing wrong? Thanks

 

Run all the upgrade scripts first.

It is very confusing as I 'suddently' found another document 'Gemini_Migration_Guide.pdf' and it mention that I should upgrade my database to 2.2 first.

Can you please confirm that is what I need to do prior to 3.0.3?

 

Thanks

You need to upgrade the database in stages.

From 2.1.1 to 2.2 to 3.0 etc... Run only the upgrade scripts (except when upgrading to 3.0 you will need to run the create tables.script).

At the end run create_procs and views.

Hey, I have updated to 3.0.3, but i have a difficulty to login to my system (web interface), it seems like a infinite loop on the browser. I have set the database setting in web.config correctly, any other hints?

Please check that the Gemini sql user has permissions on the Gemini tables and stored procedures.

I have verified the access. No luck on that, any other idea will be much appreciated. Thanks.

Are you running on vista?

Can you please check the gemini error log table and windows event log?

Can you see if the table gemini_projects has a field called "fieldvisibilityschemeid"

if it does not please run this SQL - it fixed my looping issue

ALTER TABLE gemini_projects ADD fieldvisibilityschemeid NUMERIC(10,0) NOT NULL CONSTRAINT gemini_projects_fieldvisibilityschemeid_def DEFAULT (0)

Thanks