Topics

1

Deutsch / Aus OpenGoo wird Feng Office

« on: December 18, 2009, 07:01:40 pm »

Hallo,

nachdem das Entwicklungsteam Tatsachen schafft mit der Umstellung der Webseite  und dem Update der Software auf Version 1.6.1 gibt es dazu Meinungen im DE-Bereich?

Würde mich mal so interessieren, so nach einem Jahr mit OpenGoo...

Gruß
Werner Wuerfel

2

Deutsch / Version 1.6 - Upgrade Problem

« on: October 27, 2009, 02:13:14 pm »

Für alle User die vor der Version 1.5 mit OpenGoo arbeiten ein kurzer Hinweis auf ein mögliches Upgrade-Problem bei Version 1.6 (aktuell 1.6 beta). Nachzulesen hier: http://forums.opengoo.org/index.php?topic=3066.0

Mit der Version 1.5 wurde die Verwaltung der Avatar's für Benutzer, Kontakte und Company's geändert.
Bis zur Version 1.4 wurden diese Bilder im Verzeichnis public/files gespeichert. Mit der Version 1.5 wurden diese Daten verschoben in das Verzeichnis upload. Hier liegen auch alle Dateien, die in OpenGoo geladen wurden, wenn als Speicherort Filesystem gewählt wurde.
Offensichtlich hat dieses Verschieben beim Upgrade von 1.4 auf 1.5 bei mir nicht funktioniert.

Die Version 1.6 beta überprüft aber nun die Konsistenz der Daten in der Datenbank und im Upload-Verzeichnis. Nun findet sie einige Avatar's nicht mehr, obwohl es in der Datenbank einen entsprechenden Eintrag gibt.

OpenGoo als Applikation stört das weniger. Bei Aufruf einer Benutzerinformation wird eben das Avatar nicht angezeigt.

Wenn das Problem beim Upgrade bei euch auftritt, müsst ihr als erstes euer Backup und die Version 1.5 wieder installieren. Dann eure gesamte Daten (Benutzer, Kontakte und Company) überprüfen. Die Einträge merken, bei denen kein Avatar angezeigt werden.

Dann kann man mit den nachfolgenden SQL-Queries in der Datenbank alle Einträge raus suchen, bei denen ein Avatar eingetragen ist:

Code: [Select]

SELECT * FROM `og_users` WHERE `avatar_file` != ''

Code: [Select]

SELECT * FROM `og_contacts` WHERE `picture_file` != ''

Code: [Select]

SELECT * FROM `og_companies` WHERE `logo_file` != ''Nun bei allen Einträgen, bei den ein Avatar in der Datenbank hinterlegt ist, aber nicht angezeigt wird, in den entsprechenden Datensätzen den Eintrag für das Avatar löschen, wie von alvarotm01 beschrieben.

Vielleicht hilft es ja jemanden.

Gruß
Werner Wuerfel

3

Older versions / [1.6 beta] Upgrade from 1.5.3 failed

« on: October 26, 2009, 09:10:04 am »

There is a bug by the upgrade from 1.5.3 to 1.6 beta. After no replay from the developer team here: http://forums.opengoo.org/index.php?topic=3044.0 I post the bug here again:

First I installed 1.5.3 and import my database backup. Then I installed 1.6 beta and made the upgrade.

I do the upgrade manually and I got the following message by the upgrade:

Config file found and loaded. File '/config/config.php' exists and is writable Folder '/config' exists and is writable Folder '/cache' exists and is writable Folder '/tmp' exists and is writable Folder '/upload' exists and is writable Extension 'mysql' is loaded Extension 'gd' is loaded Extension 'simplexml' is loaded Upgrade script has connected to the database. Test query has been executed. Its safe to proceed with database migration. Database schema transformations executed (total queries: 30)

exception 'FileNotInRepositoryError' with message 'File '7db4b721fff9bfb26e055b846afb31e0f03f7622.png' can not be found in the repository' in C:\xampp\htdocs\opentest\library\filerepository\backend\FileRepository_Backend_FileSystem.class.php:170
Stack trace:
#0 C:\xampp\htdocs\opentest\library\filerepository\FileRepository.class.php(95): FileRepository_Backend_FileSystem->setFileAttribute('7db4b721fff9bfb...', 'public', true)
#1 C:\xampp\htdocs\opentest\public\upgrade\scripts\ChivitoUpgradeScript.class.php(158): FileRepository::setFileAttribute('7db4b721fff9bfb...', 'public', true)
#2 C:\xampp\htdocs\opentest\public\upgrade\library\classes\ScriptUpgrader.class.php(199): ChivitoUpgradeScript->execute()
#3 C:\xampp\htdocs\opentest\public\upgrade\index.php(25): ScriptUpgrader->upgrade('1.5.3', '1.6-beta')
#4 {main}

The upgrade process is not successful. The file  installed_version is not changed to 1.6-beta.
When you looked in to OpenGoo 1.6 beta you have only the Overview.

4

Feature requests / Using local picture to insert to html documents and presentations

« on: September 27, 2009, 10:22:56 am »

Hi Guy's

actual we can only insert picture from the webserver and this function is without any comfort. You know it...

So we want to use local pictures to insert to html documents and presentations. In both modules (FCKEditor and Slimey) we want to have a browser to get the right picture form our local computer or from the webserver.

In the FCKEditor with is used in OpenGoo, you disabled this browser. See here: http://docs.fckeditor.net/FCKeditor_2.x/Users_Guide/Common_Tasks/Inserting_Images

By this way local pictures should by uploaded to the webserver.

Waiting for a hopeful response...
Werner Wuerfel

5

Feature requests / Group documents and/or fixed tag-system

« on: September 13, 2009, 01:55:24 pm »

Hi Guy's

we need the function to group documents in a workspace - like sub folders or so, without using tags for quickly way to found documents, with belong to one group - so as in active collab...

Example: In a workspace I have 200 documents as pdf-files. 100 pdf-files are general info's, 50 pdf-files are protocols of meetings and the last 50 pdf-files are mixed documents.
Today I only can find all documents of one type by using tags. But every time I must have use the right tags for each document...

Today we have an open tag-system in OpenGoo. Every user can create tags and he can use his one spelling...

So we have a lot off tags - a little invasions off tags - but we are unable to found the right information, documents, etc..  by using tags.

The second feature request is too have a fixed tag-system. One way is to define tags by the administration or another way is too change the user rights and allow only selected user to define tags.

Waiting for a hopeful response...
Werner Wuerfel

6

Older versions / 1.5.3 - Problem with search function in OpenGoo

« on: September 13, 2009, 12:30:56 pm »

Hi Guy's

in the Forum are a lot off topic's to problems with the search function in OpenGoo. You know it...

So we here also that is planed for version 1.6 to change the search function.

You please tell us, what the search function today can find an what not. With fields are using by the search function?

Example: In our OpenGoo instance all user's belong too one company "St. Pauli-Gemeinde" and all have a contact. When I now search after Pauli-Gemeinde so I will found only 10 contacts - not more. But we have a lot more users and contacts.

Another user off the DE-Communtiy has the same problem: http://forums.opengoo.org/index.php?topic=2700.0

Currently we receive search results and do not know whether they are complete or not.

So we can't  use the search feature today in OpenGoo.

Can we disable the Search function in version 1.5.3 as workaround until we have version 1.6 with a new search engine?

Waiting for a hopeful response...
Werner Wuerfel 

7

Older versions / 1.5.3 - Problem with created Zip-Files in OpenGoo

« on: September 13, 2009, 11:53:16 am »

Hi Guy's,

since Version 1.2.1 OpenGoo use the php5 zip-Extension for backup module and to compress/uncompress of documents.

In the OpenGoo DE-Community we have a lot off problems with zip in OpenGoo - on our Web server or local under XAMPP. After a wer server crash one user is unable to restore his data form the backup, because the zip-File is defect. You can see here: http://forums.opengoo.org/index.php?topic=2674.0

So we checked our OpenGoo installations and found this:

In XAMPP Version 1.7.0 with php 5.2.8 the zip-Extension will not work. In OpenGoo created zip-File are unable to uncompress after download, because the zip-File is defect. Here the Version of the zip-Extension:

Zip enabled
Extension Version $Id: php_zip.c,v 1.1.2.46 2008/11/12 17:50:37 felipe Exp $
Zip version 1.8.11
Libzip version 0.9.0

In XAMPP Version 1.7.2 with php 5.3.0 the zip-Extension work's very good. Here the Version of the zip-Extension:

Zip    enabled
Extension Version    $Id: php_zip.c,v 1.1.2.38.2.29 2009/02/24 23:55:14 iliaa Exp $
Zip version    1.9.1
Libzip version    0.9.0

On Karl's web server work's the zip-Extension also very good. Here the Version of the zip-Extension of Karl's web server:

Zip: enabled
Extension Version: $Id: php_zip.c,v 1.1.2.49 2009/02/05 19:53:22 pajoye Exp $
Zip version: 1.8.11
Libzip version: 0.9.0

Please check the zip-Extension of php5.

• What is the right Version for the zip-Extension in php5, that will correctly work in OpenGoo?
• What can I do, when I have the wrong Version off the zip-Extension?
• Is it possibly to turn off the zip-Functions in OpenGoo, include in the Backup-Module?

Without correction, we have no functioning backup module and no zip functionality in OpenGoo. That's not good...

Waiting for a hopeful response...
Werner Wuerfel

8

Deutsch / Mitarbeit in der DE-Community

« on: September 07, 2009, 02:59:36 pm »

OpenGoo lebt sehr stark von seiner Community. Daher der Aufruf an alle DE-User sich einzubringen. Siehe auch hier: http://forums.opengoo.org/index.php?topic=1888.0

Aktuell wäre es gut, wenn wir eine Übersetzung des EN-Wiki in DE angehen könnten. Denn das Wiki wird aus OpenGoo als Hilfe aufgerufen.

Da Karl und ich beruflich sehr eingespannt sind, können wir uns nur die DE-Übersetzung kümmern, die ja meistens sehr aktuell nach einer neuen Version verfügbar ist.

Ferner brauchen wir auch User die Support hier im DE Forum leisten. Ich habe nicht die Zeit immer alle Fragen in der gebotenen Tiefe zu beantworten und auch nicht zu allen Modulen das notwendige Wissen. Die Module Email, Reporting, Zeit nutzen wir aktuell nicht.

Dann wären da noch die Bereiche Provider und php-Programmierung. Da gibt es sicherlich Spezialisten in der DE-Community.

Es wäre schön, wenn sich einige etwas aktiver einbringen könnten und vielleicht sich kurz melden würden, welches Thema sie übernehmen wollen.

Gruß
Werner Wuerfel

9

Older versions / SOLVED: 1.5.1. - No Gui for new Documents and Presentations

« on: August 05, 2009, 10:10:57 am »

There is no Gui for new Documents (FCKEditor) and Presentations (Slimey) in all Browsers (FF3.5; IE8; Chrome 2)

After downgrade to Version 1.5 is there a Gui for new Documents and Presentations

10

Older versions / 1.5.1 - Error (DBQueryError) after Login

« on: August 05, 2009, 08:35:33 am »

After Upgrade from Version 1.4.2  to Version 1.5.1 every User has the following Error after login:

Query failed with message 'Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=''

Error params:

File:    /var/www/web38/html/opentest/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    386
Error number:    1267

Sql:    SELECT DISTINCT `t`.`tag` AS `name`, count(`t`.`tag`) AS `count` FROM `og_tags` `t`, (SELECT 'ProjectMessages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_messages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMessages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMessages' AND `xx_pu`.can_read_messages = true ) ) ) ) UNION SELECT 'ProjectEvents' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_events` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectEvents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectEvents' AND `xx_pu`.can_read_events = true ) ) ) ) UNION SELECT 'ProjectFiles' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_project_files` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectFiles' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectFiles' AND `xx_pu`.can_read_files = true ) ) ) ) UNION SELECT 'ProjectTasks' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_tasks` `co` WHERE `is_template` = false AND `completed_by_id` = 0 AND `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectTasks' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectTasks' AND `xx_pu`.can_read_tasks = true ) ) ) ) UNION SELECT 'ProjectMilestones' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_milestones` `co` WHERE `trashed_by_id` = 0 AND `is_template` = false AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectMilestones' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectMilestones' AND `xx_pu`.can_read_milestones = true ) ) ) ) UNION SELECT 'ProjectWebPages' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_project_webpages` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ProjectWebpages' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'ProjectWebpages' AND `xx_pu`.can_read_weblinks = true ) ) ) ) UNION SELECT 'MailContents' AS `object_manager_value`, `id` AS `oid`, `sent_date` AS `order_value` FROM `og_mail_contents` `co` WHERE `trashed_by_id` = 0 AND `is_deleted` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'MailContents' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( ( ( `created_by_id` = 2) OR ( EXISTS(SELECT * FROM `og_users` `xx_u`, `og_workspace_objects` `xx_wo` WHERE `xx_u`.`id` = 2 AND `xx_u`.`personal_project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' )) OR ( EXISTS ( SELECT * FROM `og_project_users` `xx_pu`, `og_workspace_objects` `xx_wo` WHERE `xx_pu`.`user_id` IN (2,10000004,10000005,10000006,10000007,10000008) AND `xx_pu`.`project_id` = `xx_wo`.`workspace_id` AND `xx_wo`.`object_id` = `co`.id AND `xx_wo`.`object_manager` = 'MailContents' AND `xx_pu`.can_read_mails = true ) ) ) ) UNION SELECT 'Companies' AS `object_manager_value`, `id` as `oid`, `updated_on` AS `order_value` FROM `og_companies` `co` WHERE `trashed_by_id` = 0 AND `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'Companies' AND `workspace_id` IN (SELECT `og_project_users`.`project_id` FROM `og_project_users` WHERE ((`og_project_users`.`user_id` = '2') OR (`og_project_users`.`user_id` IN (SELECT `group_id` FROM `og_group_users` WHERE `og_group_users`.`user_id` = '2'))))) AND ( true) UNION SELECT 'Contacts' AS `object_manager_value`, `id` AS `oid`, `updated_on` AS `order_value` FROM `og_contacts` `co` WHERE `trashed_by_id` = 0 AND ( true)) `o` WHERE `t`.`rel_object_manager` = `o`.`object_manager_value` AND `t`.`rel_object_id` = `o`.`oid` GROUP BY `t`.`tag` ORDER BY `count` DESC, `t`.`tag`

11

Older versions / 1.5 final - unable to set perferences for default user

« on: July 30, 2009, 12:06:24 pm »

I'am unable to set start week on monday in the default user preferences [administration/configuration/default user preferences].

After select Yes an Save the preference will stay on No.

12

Older versions / 1.5 final - Translation tools missing plugin files

« on: July 30, 2009, 12:01:44 pm »

Hi,

the translate tools check lang and translate opengoo support not all necessary files.

Check lang don't check slimey.js, all files in the plugins and  the help directory.

So we are not able to complete the translation with the translation tools.

And there is no translation file for the spreadsheet...

13

1.4 final / Missing lang: mime type:

« on: June 23, 2009, 02:19:14 pm »

Missing lang: mime type:  in the documents properties

I think in all languges...

14

Feature requests / Custom Properties only in selected Workspace

« on: June 18, 2009, 12:57:16 pm »

Is it possibly to create custom properties for an object type which is only show's in the selected workspace(s)?

Today custom properties for an objects typ are shown in all workspaces.

15

How To's / Using Temlates - only some Objects for select

« on: June 18, 2009, 12:29:58 pm »

What's the vision and meaning off templates?

When I created a template I can only select as objects tasks and milestones.

Why not events, notes, documents, web-links....