LogicalDoc CE 6.5 to 6.6 Upgrade

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

car031
Posts: 154
Joined: Tue Apr 17, 2012 8:27 am

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Mon Jan 07, 2013 7:58 am

The database changed, as usual between major releases. In addition also contex settings changed so changing putting an old context into your upgraded installation si not safe.

The automated upgrade procedure is available for the commercial editions of LogicalDOC.
car031
Posts: 154
Joined: Tue Apr 17, 2012 8:27 am

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Thu Jan 10, 2013 6:31 pm

You can export as zip the folders you have in your 6.5. Don't do the zip from the root because this may lead to timeout.
Than you can install the 6.6 and import here your zip (choose add document icon and check the zip flag).

In this way you can 'migrate' the folders and documents but you will lose the metadata and the security policies.
agaspa
Posts: 709
Joined: Tue Apr 20, 2010 8:24 am

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Wed Jan 16, 2013 12:19 pm

Dear sthamel,
if your are not in hurry, my advice is to be patient.
Probably towards the end of this month an upgrade script (for the database) will be released.
dcentrio
Posts: 6
Joined: Wed Aug 24, 2011 2:49 pm

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Wed Feb 13, 2013 4:22 pm

I did an upgrade from 6.2 to 6.6.1 today and to be honest, it wasn't that of an issue. The MySQL-diff was quite large, though, I had to "reconstruct" a couple of things from earlier sources and rebuild the folder permissions afterwards but aside from that it should be even more simple to go from 6.5 to 6.6.1!

Maybe this here might be of any help to you. You will still need to modify a couple of things in the resulting SQL statements (pretty simple, too) but it should get you going.

What really made me sad was that the preview feature got "somewhat" locked with that nasty little "this is only available in the commercial editions" but I got that one also "repaired" :P

However, the only thing I've been noticing on the negative side is that 6.2 is quite a bit faster during runtime!
admin
Site Admin
Posts: 29
Joined: Mon Apr 19, 2010 2:20 pm

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Wed Feb 27, 2013 3:13 pm

Dear sthamel,

the upgrade scripts have been published on SourceForge,
here is the link: http://sourceforge.net/projects/logical ... p/download
The sql update scripts allows to upgrade a LogicalDOC CE 6.5.2 to 6.6.2.

Best regards
Alex
sthamel
Posts: 1
Joined: Tue Mar 05, 2013 11:00 pm

Re: LogicalDoc CE 6.5 to 6.6 Upgrade

Tue Mar 05, 2013 11:10 pm

Thank you for the update scripts..... I have updated the script to apply against an instance of HSQLDB. I also put some comments in on how to apply the script. I tried to attach, but the forum doesn't seem to like the file-extensions.

Is there someone I can contact to inquire about a single-user license?





/*

2013-03-01 -- SWT: Modified script to apply against HSQLDB and added how-to make SQL connection.

To apply database changes, make sure your sqltool.rc file is inside your home directory. Create a connection definition to the logicaldoc database.

Then:

cd [Application Server]/webapps/logicaldoc/WEB-INF/lib
java -jar sqltool-2.2.8.jar logicaldoc

*/

/* Modified Update Script from MySQL to HSQLDB */

/* Begin Updates to 6.6 */
alter table ld_generic alter column ld_integer1 bigint;
alter table ld_generic alter column ld_integer2 bigint;
alter table ld_generic alter column ld_integer1 set null;
alter table ld_generic alter column ld_integer2 set null;

drop index AK_GENERIC;
alter table ld_generic add column ld_qualifier bigint null;
alter table ld_generic alter column ld_qualifier set null;
alter table ld_generic add column ld_integer3 bigint null;
alter table ld_generic alter column ld_integer3 set null;
alter table ld_generic add column ld_string3 varchar(4000) null;
alter table ld_generic alter column ld_string3 set null;
create unique index AK_GENERIC on ld_generic (ld_type, ld_subtype, ld_qualifier);

create index LD_HIST_NOT on ld_history (ld_notified);
create index LD_FHIST_NOT on ld_folder_history (ld_notified);

insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-50, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-1', 1, 0, 1, 0, 0);

insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-51, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-3', 1, 0, 3, 0, 1);

insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-52, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-6', 1, 0, 6, 1, 0);
/* End updates 6.6 */

/* Begin Updates 6.6.1 */
alter table ld_folder add column ld_templocked int default 0 not null;
alter table ld_user add column ld_passwordexpired int default 0 not null;
/* End updates 6.6.1 */

/* Begin Updates 6.6.2 */
/* NO DB updates for 6.6.2 */
/* End Updates 6.6.2 */

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 1 guest