Update instructions

Between release 0.1.5 and 0.1.6-dev the database structure has changed in some parts. The table “photos” got a new column called “id” now. Plus the “UPSERT”-functions are now bound to a schema. Therefor the recommended way to update is like following:

• Run the latest installr.pl with the latest contrib/pixlr.sql
• Log into your PostgreSQL database
• Remove the photos table:

DROP TABLE <yourschema>.photos;

• Run the SQL script that has been created by installr:

\i contrib/pixlr.sql

That's it. Now your tables should be up-to-date. Finally run pixlrback.pl to re-insert your photos from you flickr account. Another change from 0.1.5 to 0.1.6-dev is the possibity to decide wether you want the description to be HTML escaped or not. Therefor a new variable has been added:

• [% DESCRIPTION %] - This variable prints the description as HTML escaped version
• [% DESC_NONESC %] - This variable prints a non-escaped description, which makes it possible to use HTML-Tags in the text

Please adjust your template accordingly. The standard template will use escaped HTML by default.

There nothing to update so far. Simply copy the files of the new version into your Pixlr directory. All you need to adjust is the conf/pixlr.conf. This can be easily done be running installr.pl. The newly created conf/pixlr.conf.installr holds all variables that are needed. Simply compare your current pixlr.conf and the one created by installr.pl.