1

Re: Version 0.2.4

Hi All,

I have just posted up the new version of Indicia. The download links are under the Featured Downloads section at http://code.google.com/p/indicia/ and include indicia (the Warehouse), client_helpers (the library used to build forms in PHP) and iform (the Drupal integration module).

Here is a list of the main changes:
The Drupal iForm module is released, allowing the library of prebuilt forms to be used as Drupal content. The documentation for using this module will be at http://code.google.com/p/indicia/w/edit/UsingDrupalIForm when it is ready.

Additional forms in the library of prebuilt forms, including forms targetted at citizen science projects, transect walk based recording, and a "my_dot_map" form for presenting posted records on a distribution map.

Some general performance enhancements in accessing the services, including a new option apply_schema in the indicia config file. If set to false, then the system does not apply the default schema to each database connection, which makes performance better. To enable this, run the following SQL, then create or insert the config option in the indicia.php file:
ALTER USER indicia_user SET search_path = indicia, public, pg_catalog;
Config option required:
$config['apply_schema']=true;

Now, there is a survey details report which automatically includes the attributes for the samples and occurrences in a survey. Occurrences can be downloaded and flagged as such, so the next run of the report does not include previuosly downloaded occurrences.

Grids in the Warehouse now include the item IDs, making it much easier to check the IDs for attributes, websites and surveys when building forms.

Revised used interface in the Warehouse for some edit pages (moved to tabs rather than multiple grids on one page).

Support for multiple taxon images. When uploading taxon or occurrence images, the system automatically generates thumbnail and medium sized images.

Client side validation now supported through the jQuery UI Validation plugin. See http://code.google.com/p/indicia/wiki/TutorialEnablingClientSideValidation for more details.

The tabs support has been augmented to allow building of wizard style interfaces on one page. See http://code.google.com/p/indicia/wiki/TutorialTabs for more information.

The data entry helper now has code for automatic output of custom attributes (experimental at this stage).

The upgrade process has been refactored, fixing issues with incorrect version numbers. When upgrading, it is now necessary to click a button on the home page to apply the database changes.

Editing existing attribute values fixed, by specifying the value id in the control name (i.e. smpAttr:2:3 rather than just smpAttr:2, where 2 is the attribute ID, and 3 is the attribute value ID).

A new tree browser control, designed for pictorial browsing of a species or other list.

New checkbox control for boolean data.

Many improvements to the templating control in the data entry helper class.

Plus lots of small bug fixes.

Best Wishes

John

John van Breda
Biodiverse IT

2

Re: Version 0.2.4

That is great news, John.
I plan to upgrade http://testwarehouse.indicia.org.uk tomorrow, Friday 29th January.
Users should expect the service to be unavailable during the upgrade.
I will post here again when the work is complete.

Jim Bacon
Biological Records Centre.

3

Re: Version 0.2.4

Hi John

I've upgraded my Indicia server and been able to log in. However, I find that I cannot run the database upgrade (I just get taken to the "unable to complete request" page).

Any ideas?

Cheers

Alan

Alan Hale
Aberystwyth

4

Re: Version 0.2.4

Here's the error from the log file:

Upgrade Error - Time: Fri, 29 Jan 10 09:47:23 -0500
MESSAGE: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  cannot drop columns from view
CODE: 0
FILE: /................./indicia/system/libraries/drivers/Database/Pgsql.php
LINE: 86

2010-01-29 09:47:23 -05:00 --- error: Error converted to exception. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block at line 86 in file /............/indicia/system/libraries/drivers/Database/Pgsql.php
2010-01-29 09:47:23 -05:00 --- error: Uncaught ErrorException: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block in file system/libraries/drivers/Database/Pgsql.php on line 86
2010-01-29 09:50:43 -05:00 --- error: Error converted to exception. pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  cannot drop columns from view at line 86 in file /............/indicia/system/libraries/drivers/Database/Pgsql.php
2010-01-29 09:50:43 -05:00 --- error:

Regards

Alan

Alan Hale
Aberystwyth

5

Re: Version 0.2.4

Oops. Sorry, I think there was a problem in the upgrade path, as the latest version includes a rewrite of the upgrade functionality. Can you try these steps please:
Think I just spotted the problem in the upgrade path. Can you try the following:
1)    Go to indicia/modules/indicia_setup/db. Check you have still got a folder called upgrade_0_1_to_0_2.
2)    Go to indicia/modules/indicia_setup/db/version_0_2_3. Remove the file in this folder called ____***____ (the only one that starts and ends with underscores). It may not exist, so don’t worry if it doesn’t.
3)    Go to indicia/modules/indicia_setup/models/upgrade.php. Open it in a text editor. Find the line
private function version_0_2_4() {
and change this to
private function version_0_2_3() {

Let me know how you get on,

John van Breda
Biodiverse IT

6

Re: Version 0.2.4

Thanks John

I've just been through the steps you suggested but the problem persists.

(There was still a folder called upgrade_0_1_to_0_2).

Cheers

Alan

Alan Hale
Aberystwyth

7

Re: Version 0.2.4

Hi Alan

Sorry about the hassles. If you download the file at http://code.google.com/p/indicia/ called Indicia-0.2.4c.zip and extract it over your existing files then it should fix the issues with the upgrade process.

The testwarehouse is back up online now and successfully upgraded.

Regards

John van Breda
Biodiverse IT

8

Re: Version 0.2.4

Hi

Following the upgrade of the BRC test warehouse I will be running the upgrade on http://warehouse1.indicia.org.uk on Tuesday 2nd February. The service will be unavailable while this is in progress. I will post a notice here when it is back.

Jim.

9

Re: Version 0.2.4

Hi

BRC Warehouse1 was successfully upgraded on Tuesday using version 0.2.4c. A by-product of the upgrade was that the configuration for sending emails was corrected so that you can now receive help for forgotten passwords. This also applies to the BRC Test Warehouse.

Jim Bacon.