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.




Error Migrating to v3.0+

web-app

I am getting the following error when running the Upgradev3-0-Step1.sql script.

(0 row(s) affected)
Msg 547, Level 16, State 0, Line 375
The INSERT statement conflicted with the FOREIGN KEY constraint "gemini
customfielddatacustomfieldidfk". The conflict occurred in database "Geminiv3", table "dbo.geminicustomfielddefinitions", column 'customfieldid'.
The statement has been terminated.

Any pointers antbody?

Thanks

joseg
· 1
joseg
Replies (1)
helpful
0
not helpful

Seems like you have values for non-existing custom fields.

Try and remove from customfielddata where the custom field id is not in the definition table.


Mark Wing
· 9108
Mark Wing