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.




v3.0.4 to 3.1.2 fail

web-app

in the installation guide, it states on page 10 8.2 step 1, execute "Upgradev3-1.sql".  I did that, and it errored out.

 

"

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Msg 2705, Level 16, State 4, Line 5

Column names in each table must be unique. Column name 'parentcomponentid' in table 'geminicomponents' is specified more than once.

Msg 3726, Level 16, State 1, Line 5

Could not drop object 'geminiprojectlabels' because it is referenced by a FOREIGN KEY constraint.

Msg 2714, Level 16, State 6, Line 2

There is already an object named 'geminiprojectlabels' in the database.

Msg 2705, Level 16, State 4, Line 2

Column names in each table must be unique. Column name 'projectlabelid' in table 'geminiprojects' is specified more than once.

Msg 2705, Level 16, State 4, Line 5

Column names in each table must be unique. Column name 'apikey' in table 'geminiusers' is specified more than once."

This is the first time it was ran.  We were running 3.0.4.  I ran the other two procedures after.

Now, when we access the website"

"

Server Error in '/gemini' Application.

Invalid column name 'apikey'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'apikey'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Suggestions?

englea
· 1
englea
Replies (4)
helpful
0
not helpful

Which scripts did you run?

The 3.1 upgrade is the only one that adds that field.

Is it possible to restore the database?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

First line of my post:  "in the installation guide, it states on page 10 8.2 step 1, execute "Upgrade_v3-1.sql".  I did that, and it errored out."

I think its self-explanatory Saar which script I ran.

Restored the database.  Same error.


englea
· 1
englea
helpful
0
not helpful

Just making sure!

Is it possible to send us a backup of your database?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

nevermind.  helps to have the Web.config pointing to the right database.  I updated the connection string for the user id and server, just not the db.

thanks.


englea
· 1
englea