CounterSoft Community Server

Hi.

We updated our gemini application from 3.0.3 to 3.0.4.
Is there any sql script which we should run to update the database?

Best regards
Adam

Yes, you will need to run create_views.sql and create_procs.sql

Oh, yes. Thanks for all.

any trouble?

I did not have any trouble running the scripts, however I am currently experiencing an error with Gemini whenever it attemps to load most any of the pages.  In the error log, I get:

Invalid column name 'viewtype'. Invalid column name 'viewtype'.

SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Bool

Aside from running the database scrips, I archived my previous web files and have the updated package in as the current app, as directed in the documentation.

This error should only come up if you did not upgrade your database from 3.0.0.

Run the 3.0.1 upgrade script.

That did the trick.  I did not read in the upgrade instructions that I needed to patch from 3.0.0 to 3.0.1 before upgrading to 3.0.4.  To help keep this happening to someone else, could the 3.0.1 patch just be included in the database script for views in 3.0.4?

Unfortunately no as database upgrades are not comulative. So we can't add the field twice.

I've upgraded sucessfully from Gemini 3.0.3 (Build 1998) to Gemini 3.0.4 (Build 2026)

1. backed up Gemini web application files
2. backed up Gemini database
3. copied over all web application files
4. ran Create_Views.sql and Create_Procs.sql
5. changed the connection string settings in the web.config