Hana Posted November 22, 2013 Report Share Posted November 22, 2013 Hello Until last week we were using Daminion Server 1.0.0.779 with PostgreSQL 9.0. This week we upgraded the server and clients to 2.0.0.911 (still PostgreSQL 9.0) but since then we've been getting several database errors: - Every thumbnail shows this error: PicaJet.Daminion.Common.Error ERROR: 42703: column "dataoffset2" does not exist - When adding a file: ERROR: 42703: column "useruid" of relation "importsession" does not exist It seems there are several columns (and even tables) missing in our database that weren't required in version 779. As a test I added the missing columns in table "thumbnailstack" and that fixed the thumbnail preview issue, but I'd prefer not having to go through all the tables manually do find the differences.. ;) Is there any way we can upgrade our database with all the tables and columns? Is there a specific patch we're missing for this or did something went wrong during the installation of version 911? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Murat Posted November 22, 2013 Report Share Posted November 22, 2013 Thanks for the info. Can you email us your database backup to support/at/daminion/dot/net? Or you can send me a shared dropbox link. You can backup the database via Daminion Server Administrator Panel: File > Backup Database... Quote Link to comment Share on other sites More sharing options...
Hana Posted December 2, 2013 Author Report Share Posted December 2, 2013 Hi Murat Would you happen to have any news for us on how to resolve the issue? :) Quote Link to comment Share on other sites More sharing options...
Murat Posted December 2, 2013 Report Share Posted December 2, 2013 I'll send you a response today. Sorry for the delay. Quote Link to comment Share on other sites More sharing options...
Murat Posted December 2, 2013 Report Share Posted December 2, 2013 We fixed your database issue (not all tables were updated to a new version) and I've sent you the fixed dump with detailed instructions. Please check your email. Quote Link to comment Share on other sites More sharing options...
Hana Posted December 4, 2013 Author Report Share Posted December 4, 2013 Just tried the fix and that did the trick indeed, thanks a lot! :D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.