Topics

1

Older versions / [1.5b3] Drag&Drop - direct selection misleading (sometimes)

« on: July 13, 2009, 02:25:42 pm »

Warning: OpenGoo 1.5 BETA 3 is not suitable for production environments. Download.
[...]
What has been improved:

• Drag and drop now doesn’t require that you select rows before dragging, and an icon was added to make it easier to know where to drag a row.

Holds true only if you drag an unselected row using the second column (small dotted area).
Otherwise you get a "Success: 0 Object(s) moved successfully"

Another scenario:
You selected a row earlier, but now choose to drag&drop another one. The row that gets moved/copied is the selected one (might even be scrolled out of view ) and not the one that has actually been dragged.

But that's only finetuning. You are doing a great job!

Looking forward to the official release!
Thorsten

2

Installation problems / [1.5b2] DB-Upgrade fails: "specified key was too long..."

« on: July 09, 2009, 04:25:09 pm »

Hi,

was about to upgrade my old test installation to the current beta.
Seems I'm lucky enough to encounter DB upgrade Problems every time

Recent error:

# Database schema transformations executed (total queries: 5)
# OpenGoo has been upgraded. You are now running OpenGoo 1.4.2 Enjoy!
# Upgrade script has connected to the database.
# Test query has been executed. Its safe to proceed with database migration.
#
# Failed to execute DB schema transformations. MySQL said: Specified key was too long; max key length is 1000 bytes
# Error upgrading to version 1.5-beta2

I looked through the "figazza" script but didn't find anything suspicious.

Greetings,
Thorsten

3

Installation problems / [1.4] db upgrade fails

« on: May 19, 2009, 05:24:41 pm »

Running the upgrade script (1.3.1 -> 1.4) after uploading the new files produces the following error message:
    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/public/files' 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.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    *
    * Failed to execute DB schema transformations. MySQL said: Duplicate column name 'type'
    * Error upgrading to version 1.4

Trying to access opengoo without a successful upgrade results in another error:

(DBQueryError)
Query failed with message 'Unknown column 'can_manage_reports' in 'field list''
Error params:
File:    ...//opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    386
Sql:    SELECT `id`, `company_id`, `username`, `email`, `token`, `salt`, `twister`, `display_name`, `title`, `avatar_file`, `timezone`, `created_on`, `created_by_id`, `updated_on`, `last_login`, `last_visit`, `last_activity`, `can_edit_company_data`, `can_manage_workspaces`, `can_manage_security`, `can_manage_configuration`, `auto_assign`, `personal_project_id`, `can_manage_contacts`, `can_manage_templates`, `can_manage_reports`, `default_billing_id` FROM `og_users` WHERE `id` = '1'
Error number:    1054
Error message:    Unknown column 'can_manage_reports' in 'field list'
Backtrace: [...]

Seems I am locked out from my installation so far. (new security feature? )

My assumption: This 1.3.1 installation was once a "wrong 1.3.1" (see http://forums.opengoo.org/index.php?topic=1219.msg5912#msg5912 for details) and might already have added some columns that are now added again (without testing for existing cols before altering).

Am I heading into the right direction or is there another reason for preventing the upgrade?

Greetings,
Thorsten

4

1.4 beta / [Reporting] Conditions on or selecting of custom properties (1.4RC)

« on: May 09, 2009, 06:24:15 pm »

The administration area allows to set up custom properties for contacts etc.

However, it is not possible to use these additional entries to create custom reports.

Admin-created ("global") custom properties should show up in the "Conditions" and "Columns & Order" section.
At least, that is what I was expecting.

If the current behaviour is intended, please feel free to move this topic to the feature request section.

Greetings,
Thorsten

5

1.4 beta / [Workspace] "custom properties" section lacks form content

« on: April 26, 2009, 11:02:05 am »

see attached image

6

1.4 beta / [Company] duplicate "custom properties" link

« on: April 26, 2009, 11:00:34 am »

see attached image

7

1.4 beta / [Calendar] month/day view reset to week on next/previous/goto

« on: April 26, 2009, 10:58:16 am »

I am able to change the calendar view to show a month or a day.
However, this choice is reset to week view whenever I navigate away from the current view with calendar's "Previous", "Next" or "Go To" button.

8

Feature requests / Detailed change tracking in company / contact history

« on: April 25, 2009, 12:49:44 pm »

Currently, OpenGoo offers information about when and by whom a company or contact entry has been edited.

In my opinion this does not add much value to the company/contact data as long as you are not able to actually get an idea about what changes have been made.

I attached two screenshots that show different ways of implementing this detailed history.

The first one (from the tine 2.0 project) is rather compact. Instead of displaying OpenGoo's " Company X updated" a list of all changed fields is shown.

The second way (epesi) displays every changed field in its own row including the old and new value.
I woudn't care much about the first and last section ("Current Record" and "Original Record") as it is completely redundant but I like the middle part ("Changes History") very much.
This is exactly what I would love seeing in OpenGoo's Company and Contacts history respectively.

Would be great to read your thoughts on this

Thorsten