Upgrading

From Photolibrary

Upgrading

1. Check release notes for specific instructions.
2. Delete all files from:
   • root directory
   • /UI
   • /bin
3. Drop the language table.

   Steps 2 and 3 are to clear out deprecated files and so are optional.

4. Extract new installation.

   For versions less than 1.002 you will need to run the database updates below manually.

5. Load the main page. You should be redirected to /update.php.
6. Go to /settings.php and save your settings to update the settings file.

Database updates

Run all the database updates listed after the last build you installed, up to the build you are installing.

1.000

ALTER TABLE `photolibrary`.`photostocategories` CHANGE COLUMN `hash` `hash` varchar(32) NOT NULL;

1.001

ALTER TABLE `accounts` DROP PRIMARY KEY;
ALTER TABLE `accounts` ADD COLUMN `user_id` int(8) unsigned NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`user_id`);
ALTER TABLE `accounts` ADD COLUMN `admin` tinyint(1) unsigned NOT NULL DEFAULT 0;
UPDATE `accounts` SET `admin` = 1;
ALTER TABLE `photocomments` ADD INDEX `hash` (`hash`(32));
ALTER TABLE `photostocategories`  ADD INDEX `category` (`category`);
ALTER TABLE `categories` ADD INDEX `parent` (`parent`);

1.002

When updating to 1.002 or higher all database updates are done automatically by /update.php.

Release notes

1.001

• First public release.

1.002

• Started user account implementation. Backend finished.
• Fixed slideshow closing bug.
• User styles. Create generated/user.stylesheet.css, generated/user.index.css, generated/user.comments.css if required etc.
• Tree-expanding auto-complete.
• Scriptaculous animations.
• Google Analytics support.
• Auto-update script.
• Database optimisations (lots of extra keys)
• More slideshow features
• Quicker categorisation of photos.
• Better selection of icon for "recent categories"
• "Sort by" on main page (date/views/views per day/resolution/filesize) deprecates "Popular" page (and Stats to some extent)
• Better permalinks.

1.003

• Major bugfix (Calendar view was broken)
• Streamlined stats page (with introduction of "sort by")
• "Move to session" on categories page
• Optimise main page loading time (SQL queries)
• Installation bugfixes

1.004

• '<?' -> '<?PHP' bug fix
• Minor updates to standalone flash browser
• More account front end, still have to created manually.
• AJAX loading marker, doesn't hide content whilst loading.
• Sort by date added
• More localised variables
• Other bugfixes (calendar again).

1.005

• Fill area backgrounds
• Minor bugfixes
• Tweaks to install process

1.006

• Major javascript rewrite, photolisting generated with extensible classes.
• Coloured icons cached.
• Viewing uses on-page javascript popup, instead of new window popup.

1.007

• Import thumbnails
• Russian
• Hover icons, comments icons
• Support for big thumbnails
• Clickable dates in metadata
• Auto-populated unassign drop down box
• Major javascript rewrite of category tree
• Finish accounts front end
• Many minor bugfixes

1.008

• Updated prototype and scriptaculous libraries
• Fix view counter bug
• Fix implementation of disable comments/stats
• Fix metabar layout
• Clickable camera name in metadata
• Javascript graphical checkbox

1.009

• Fix rendering of views for Javascript popup

2.000 (next release)

• Major javascript rewrite
• Documented javascript API