Group-Office 4.0 public beta available for download

Read important announcements about Group-Office here

Moderator: Developers

mschering
Site Admin
Site Admin
Posts: 8154
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Group-Office 4.0 public beta available for download

Postby mschering » Wed Apr 11, 2012 9:42 am

This is a beta release for the upcoming 4.0 version. It is not intended for production use. Please just use it for testing and provide us feedback in the forum.
We completely rewrote the PHP framework using the MVC approach. On the interface it may seem like there are not so many changes but under the hood there's a shiny new engine! This get's us ready for the future. It will enable us to create a mobile interface for example. It's also a much more organized and more secure framework. Extensive security testing has been performed by Cigitel.
There's also a new module for document management. You can search through files and add workflow to documents. It will be available as an add on paid module.

Changelog:

11-04-2012 4.0.1 (beta)
- Complete new MVC PHP framework
- Extensive security audit by Cigitel.
- Users are stored in the addressbook too.
- Ticket groups for better permission management.
- plupload used for file uploads
- gnupg support dropped. smime still supported.
- Filesearch module for deep searching files content.
- Document workflow module.
- SabreDAV upgraded to 1.5.6
- Swift Mailer upgraded to 4.1.5
- Project tasks have a relation now and have a percentage complete field
- Photo support in sync.
- Sync multiple calendars
- Billing module can create MS word and open-office invoices, quotes and orders.
- Billing module can handle purchase orders and stock.

Addressbook
- Batch edit in addressbook.
- Merge companies and contacts
- Easier and more secure advanced search.

E-mail
- Embed pasted images from firefox into mime mail for better memory management
- Links in messages become relative links when cut & pasted. We make them absolute again on when the message is sent.
- Automatic linking of e-mail replies when sent from a projects, contact, company etc.

IMPORTANT:
- Projects: batch report queries will not work anymore. They need to be reconfigured.
- Billing: Custom fields in templates used to be %Name of customfield% This should be replaced by {col_1}
- SyncML: If you use SyncML clients like funambol you must reconfigure them. When you use the debian repository you must connect to /sync instead of /sync.php. If you don't use Debian packages you can connect to /modules/syncml/index.php. Also make sure the syncml module is installed.

You can download a beta version of 4.0 here:

https://sourceforge.net/projects/group- ... files/4.0/
Best regards,

Merijn Schering
Intermesh
JoBoCo
Posts: 16
Joined: Tue Sep 28, 2010 3:43 pm

Re: Group-Office 4.0 public beta available for download

Postby JoBoCo » Mon Apr 16, 2012 12:37 am

Very happy to see GO4 finally here!

I just installed GO4.0.1 Beta side-by-side with my GO3.7.48 Pro, taking care of duplicating my database, changing the DB name, editing config.php, etc.

Unfortunately the database upgrade script halts on this error:

Older version of Group-Office detected. Preparing database for 4.0 upgrade
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'mute_reminder_sound'
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'show_smilies'
Done.
Updating Group-Office database
Excuting query: UPDATE go_modules SET version=0

... [I truncated the log here, to save some trees!]...

Excuting query: ALTER TABLE `cal_events` CHANGE `category_id` `category_id` INT( 11 ) NULL;
Excuting query: ALTER TABLE `cal_categories` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT;
Running /var/www/groupoffice4/modules/calendar/install/updatescripts/1_convert_categories.php
Converting existing categories from user to calendar
Category Enseignement
{"success":false,"feedback":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'path' in 'field list'"}


Hope this report can be helpful for you; kindly advise me if you need any other detail or if you want bu reports somewhere else in this forum.

Keep up with the good work!
simonalsa
Posts: 22
Joined: Mon Oct 03, 2011 11:11 am

Re: Group-Office 4.0 public beta available for download

Postby simonalsa » Mon Apr 16, 2012 8:18 am

Hi, morning,

it is nice to see the new version,

are there anyway to upgrade GO to 4 from lastest 3 release using an online debian repository?

Kind regards
Simon
mschering
Site Admin
Site Admin
Posts: 8154
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Group-Office 4.0 public beta available for download

Postby mschering » Mon Apr 16, 2012 9:19 am

Yes, you can add this apt source:

deb http://repos.groupoffice.eu/ fourzero main
Best regards,



Merijn Schering

Intermesh
mschering
Site Admin
Site Admin
Posts: 8154
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Group-Office 4.0 public beta available for download

Postby mschering » Mon Apr 16, 2012 9:21 am

@jocobo

What happens when you run:

/groupoffice/?r=maintenance/upgrade now?
Best regards,



Merijn Schering

Intermesh
JoBoCo
Posts: 16
Joined: Tue Sep 28, 2010 3:43 pm

Re: Group-Office 4.0 public beta available for download

Postby JoBoCo » Mon Apr 16, 2012 11:15 am

Hi,

I tried the suggested URL and get a white page.

The Apache error log complains:
[Mon Apr 16 07:12:19 2012] [error] [client XXX.XXX.XXX.XXX] PHP Fatal error: Class 'GO_Maintenance_Controller_Upgrade' not found in /var/www/groupoffice-com-4.0.1/go/base/Router.php on line 109


Thanks for the support!
JoBoCo
Posts: 16
Joined: Tue Sep 28, 2010 3:43 pm

Re: Group-Office 4.0 public beta available for download

Postby JoBoCo » Tue Apr 17, 2012 5:35 am

Hello,


I tried on a development machine to install GOV4.0.3 using apt-get and changing the config.php in /etc/groupoffice to point to a copy of my old G03.7.48 database.
Everything runs fine, but the upgrade script freezes with this error message:

Older version of Group-Office detected. Preparing database for 4.0 upgrade
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'mute_reminder_sound'
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'show_smilies'
Done.

Warning: touch(): Unable to create file /home/groupoffice/log/upgrade/20120417_124.log because Permission denied in /usr/share/groupoffice/controller/MaintenanceController.php on line 255
Fatal error: Could not write to log file


I fixed this by issuing

Code: Select all

sudo chown -R www-data:www-data /home/groupoffice/
and now I get this error message:

Older version of Group-Office detected. Preparing database for 4.0 upgrade
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'mute_reminder_sound'
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'show_smilies'
Done.
Updating Group-Office database
{"success":false,"feedback":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.enabled' in 'field list'"}


Just letting you know, in case that could be helpful.
mschering
Site Admin
Site Admin
Posts: 8154
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Group-Office 4.0 public beta available for download

Postby mschering » Tue Apr 17, 2012 7:54 am

Can you manually add that enabled column as a boolean field to go_modules?
Best regards,



Merijn Schering

Intermesh
mglaredo
Posts: 13
Joined: Tue Apr 17, 2012 11:13 am

Re: Group-Office 4.0 public beta available for download

Postby mglaredo » Tue Apr 17, 2012 12:00 pm

Good afternoon.

We'd like to test Go 4.0.1, but we have two production version: 2.18 and 3.7 over PHP 5.2 on CENTOS 5

Someone has tested PHP 5.2->5.3 upgrading for this Go version with success? Which the general recommendation from Intermesh in these cases?

Thanks in advance!
Miguel
tlarrain
Posts: 66
Joined: Tue Apr 11, 2006 8:33 pm

Re: Group-Office 4.0 public beta available for download

Postby tlarrain » Tue Apr 17, 2012 12:55 pm

Hi Merijn,

Same error:

Fatal error: Class 'GO_Core_Controller_Maintenance' not found in /home/llarrai/public_html/intranet/install/upgrade.php on line 13
Last edited by tlarrain on Thu Apr 19, 2012 2:13 pm, edited 1 time in total.
dustundag
Posts: 5
Joined: Tue Apr 17, 2012 2:24 pm

Delete Email Issue for External Email

Postby dustundag » Tue Apr 17, 2012 2:28 pm

I do not think that this may be due to a space issue


Error while deleting the data:



Moving the e-mail to the trash folder failed. This might be because you are out of disk space. You can only free up space by disabling the trash folder at Administration -> Accounts -> Double click your account -> Folders
dustundag
Posts: 5
Joined: Tue Apr 17, 2012 2:24 pm

Could not open IMAP mailbox Sent

Postby dustundag » Tue Apr 17, 2012 2:30 pm

It probably send the email, but I receive the folowing error when I try to send the email



Could not open IMAP mailbox Sent
JoBoCo
Posts: 16
Joined: Tue Sep 28, 2010 3:43 pm

Re: Group-Office 4.0 public beta available for download

Postby JoBoCo » Wed Apr 18, 2012 12:24 am

Hello,

I did follow your advice and issued the SQL command

Code: Select all

ALTER TABLE `go_modules` ADD `enabled` BOOLEAN NOT NULL


I reloaded GOV4.0.3 and got stuck with this message:
Older version of Group-Office detected. Preparing database for 4.0 upgrade
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'mute_reminder_sound'
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'show_smilies'
Done.
Updating Group-Office database
Excuting query: UPDATE go_modules SET version=0
Excuting query: ALTER TABLE `fs_folders` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT
Excuting query: ALTER TABLE `fs_files` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT

[...again removing some lines to save trees....]

Excuting query: CREATE TABLE IF NOT EXISTS `fs_folder_pref` (
`folder_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`thumbs` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`folder_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Excuting query: ALTER TABLE `cal_events` CHANGE `category_id` `category_id` INT( 11 ) NULL;
Excuting query: ALTER TABLE `cal_categories` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT;
Running /usr/share/groupoffice/modules/calendar/install/updatescripts/1_convert_categories.php
Converting existing categories from user to calendar
Category Enseignement
{"success":false,"feedback":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.status_id' in 'field list'"}


This looks very much like the message I had 3 days ago...

Obviously I have a keen interest in been able to migrate from GO3.7 to GO4.0 and am ready for more tests if this is useful for you...
dustundag
Posts: 5
Joined: Tue Apr 17, 2012 2:24 pm

Re: Group-Office 4.0 public beta available for download

Postby dustundag » Sat Apr 21, 2012 6:28 pm

Updated to 4.04 successfully :lol:
mail issue was solved from the email account folder setting.
mglaredo
Posts: 13
Joined: Tue Apr 17, 2012 11:13 am

Re: Group-Office 4.0 public beta available for download

Postby mglaredo » Tue Apr 24, 2012 12:12 pm

I need to test Go Pro 4.0 in a development environment, but I obtain:

PHP Fatal error: <br>The encoded file <b>...GoCev401/modules/professional/check.php</b> requires a license file.<br>The license file <b>/var/www/html/GoCev401/groupoffice-pro-4.0-license.txt</b> is not valid for this server. in Unknown on line 0

Any advice?

Thanks in advance!

Return to “Announcements”

Who is online

Users browsing this forum: No registered users and 2 guests

cron