Group-Office 4.0 public beta available for download

[Intermesh]

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/

[JoBoCo]

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]

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

[Intermesh]

Yes, you can add this apt source:

deb http://repos.groupoffice.eu/ fourzero main

[Intermesh]

@jocobo

What happens when you run:

/groupoffice/?r=maintenance/upgrade now?

[JoBoCo]

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]

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.

[Intermesh]

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

[mglaredo]

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]

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

[dustundag]

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]

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]

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]

Updated to 4.04 successfully
mail issue was solved from the email account folder setting.

[mglaredo]

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!