Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
2.4 SQLite upgrade to 2.5 SQL CE failed
Options
Previous Topic Next Topic
am
#1 Posted : Friday, 17 June 2011 6:59:04 PM(UTC)
Rank: Member

Joined: 14/05/2009(UTC)
Posts: 7
Location: Iceland
I was running version 2.4 , already upgraded the gallery to .NET 4.0 , no problems there. But when running the upgrade wizard it failed with this error:


[SqlCeException (0x80004005): A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK__aspnet_Roles_aspnet_Applications ]]
System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) +66
System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) +631
System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +490
System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() +44
GalleryServerPro.Data.SqlCe.DataUtility.InsertRoles(DataSet ds, SqlCeConnection cn, SqlCeTransaction tran) +1052
GalleryServerPro.Data.SqlCe.DataUtility.ImportData(String galleryData, Boolean importMembershipData, Boolean importGalleryData) +1006
GalleryServerPro.Web.Pages.upgrade.MigrateDataToSqlCe() +246
GalleryServerPro.Web.Pages.upgrade.ShowNextPanel() +207
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3691
Back to top
Roger Martin
#2 Posted : Friday, 17 June 2011 8:42:50 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Can you send me galleryserverpro_data.sqlite from your App_Data directory? I'd like to see if there are some data integrity issues. Send it to roger*at*techinfosystems*dot*com.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
senapsys
#3 Posted : Friday, 30 September 2011 6:36:15 AM(UTC)
Rank: Newbie

Joined: 21/12/2010(UTC)
Posts: 1
Location: senapsys
I've experienced the same problem upgrading from 2.4.6 SQLite to 2.5 SQL CE.

I've tried applying the latest patch as well.

When I go to my gallery and try and log in, my admin credentials aren't recognised (or any other accounts either).

Any thoughts on whether there is an easy fix before I roll things back to my latest backup and try again?
Back to top
WWW
Roger Martin
#4 Posted : Friday, 30 September 2011 7:06:53 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Did you get the exact same error as originally reported? If so, then send me the sqlite data file so I can look for data integrity issues.

If you got a different error, give me the full details, including at what point in the upgrade it occurred.

If the data was successfully migrated to the SQL CE database, the fix could be as simple as tweaking the web.config file to point to the new data provider. The Admin Guide describes tools you can use to look inside the .sdf database.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET