Introduction

General instructions how to perform update.

Details

• Updating takes two steps updating database changes.
• Updating gallery core files.

Updating database

Database changes can be found at:

doc/database/*.sql

You should run selected files using phpMyAdmin or SQL console tools.

Updating files

Before updating you should make your files backups just in case something wont work. The easiest way to update files is just override. These folders

1. cache/
2. design/
3. doc/
4. ezcomponents/
5. lib/
6. modules/
7. pos/
8. translations/
9. Zend/
10. var/

You should also rewrite root directory files.

1. cron.php
2. index.php
3. robots.txt
4. runtest.php

While updating I recommend turn off all caching stuff. That's all.

Updating to r585

In r585 was presented new feature, last 24 hours top images. It requires to run database update doc/database/update_14.sql

Updating to r579

In r579 was presented new feature, last rated images. It requires to run database update doc/database/update_13.sql

You should also update your sphinx configuration. There are new attribute

sql_attr_uint   = rtime

Everything else is as usual.

Updating to r560

Make sure that you settings.ini.php file contains new options

'imagemagic_enabled' => false,
'delay_image_hit_log' => false,
      'delay_image_hit_log_settings' => array (      
        'host' => false,                               //It can be false or array, ex. array('example.com','www.example.com')
        'log_path' => '' // Absolute path to log, ex. /var/log/lighttpd/access.log.1     
      ), 

No database changes were made.

Updating to r473

You should run doc/database/update_8.sql

Also there are few new policys regarding photo approvement process:

1. auto_approve - Function grants auto approvement for all uploaded photos
2. auto_approve_self_photos - Function grants auto approvement for user self uploaded photos. User uploaded photos to his own albums will be automaticaly approved.
3. can_approve_self_photos - Function grants permision to approve self uploaded photos. Photos have to be uploaded to user album.
4. can_approve_all_photos - Function grants permission to approve all users uploaded photos.

In order to allow automaticaly users uploaded photo be aproved you should grant anonymous users role first policy.

Updating to r462

Since r462 new table was added. You should run doc/database/update_7.sql

Updating to r453

Since r453 there are new configuration variable. It defines available resolutions for filtering.

'resolutions' => array('640x480' =>   array('width' => 640, 'height' => 480),
                             '800x600' =>   array('width' => 800, 'height' => 600),
                             '1024x768' =>  array('width' => 1024,'height' => 768),
                             '1152x864' =>  array('width' => 1152,'height' => 864),
                             '1280x768' =>  array('width' => 1280,'height' => 768),
                             '1280x800' =>  array('width' => 1280,'height' => 800),
                             '1280x960' =>  array('width' => 1280,'height' => 960),
                             '1280x1024' => array('width' => 1280,'height' => 1024),
                             '1366x768' =>  array('width' => 1366,'height' => 768),
                             '1360x768' =>  array('width' => 1360,'height' => 768),
                             '1440x900' =>  array('width' => 1440,'height' => 900),
                             '1600x1200' => array('width' => 1600,'height' => 1200),
                             '1600x900' =>  array('width' => 1600,'height' => 900),
                             '1680x1050' => array('width' => 1680,'height' => 1050),
                             '1920x1200' => array('width' => 1920,'height' => 1200),
                             '1920x1080' => array('width' => 1920,'height' => 1080),
      ),

Updating database. There are data update file located in doc/database/update_6.sql

Updating sphinx.

1. You should drop "sphinxseearch" and create it with following command:

CREATE VIEW `sphinxseearch` AS SELECT `lh_gallery_images`.`pid` AS `id`,`lh_gallery_images`.`pid` AS `pid`,`lh_gallery_images`.`hits` AS `hits`,`lh_gallery_images`.`title` AS `title`,`lh_gallery_images`.`mtime` AS `mtime`,`lh_gallery_images`.`keywords` AS `keywords`,`lh_gallery_images`.`caption` AS `caption`,`lh_gallery_images`.`comtime` AS `comtime`,`lh_gallery_images`.`pic_rating` AS `pic_rating`,`lh_gallery_images`.`votes` AS `votes`,replace(replace(`lh_gallery_images`.`filepath`,'/',' '),'-',' ') AS `file_path`,replace(replace(`lh_gallery_images`.`filename`,'-',' '),'_',' ') AS `filename`,`lh_gallery_albums`.`title` AS `album_title`,`lh_gallery_albums`.`keyword` AS `album_keyword`,`lh_gallery_albums`.`description` AS `album_description`,`lh_gallery_categorys`.`name` AS `category_name`,`lh_gallery_categorys`.`description` AS `category_description`,`lh_gallery_images`.`pwidth`,`lh_gallery_images`.`pheight`,concat(`lh_gallery_images`.`pwidth`,'x',`lh_gallery_images`.`pheight`) AS `pdimension` from ((`lh_gallery_images` left join `lh_gallery_albums` on((`lh_gallery_images`.`aid` = `lh_gallery_albums`.`aid`))) left join `lh_gallery_categorys` on((`lh_gallery_categorys`.`cid` = `lh_gallery_albums`.`category`))) where (`lh_gallery_images`.`approved` = 1);

2. You should also update sphinx configuration to fallowing example settings. There are two new attributes pwidth and pheight

source anifofsrc
{
	type					= mysql
	sql_host				= <host>
	sql_user				= <username>
	sql_pass				= <password>
	sql_db					= <database>
	sql_port				= 3306	# optional, default is 3306

	sql_query				= \
		SELECT * FROM sphinxseearch

	sql_query_info			= SELECT * FROM lh_gallery_images WHERE id=$id
	sql_attr_uint   = pid
	sql_attr_uint   = hits
	sql_attr_uint   = mtime
	sql_attr_uint   = comtime
	sql_attr_uint   = pic_rating
	sql_attr_uint   = votes
	sql_attr_uint   = pwidth
	sql_attr_uint   = pheight
}

That's all. Other update instructions is default.

Updating to r402

Since r402 there are new configuration variable. It allows custom modules integrated, rewriting default gallery actions. How to make custom modules or overwrite gallery functions will be written soon. Also there have to be new folder in gallery root directory named extension.

'extensions' => array (            
),

Updating to r402

Since r402 there are new configuration variable. It allows custom modules integrated, rewriting default gallery actions. How to make custom modules or overwrite gallery functions will be written soon. Also there have to be new folder in gallery root directory named extension.

'extensions' => array (            
),

Updating to r399

Since r399 there are new configuration variable

'modulecompile' => false,