Gallery2:Test Matrix - Gallery Codex
Personal tools

Gallery2:Test Matrix

From Gallery Codex

G2 is currently supported in the following environments:

  • Operating systems: Unix, Windows
  • VM: PHP 4.1+ (4.3+ in current svn)
  • Database: Postgres 7.x/8.x, MySQL 3.x/4.x/5.x, Oracle 9i/10g, DB2 V8.2 & 9, MS SQL Server 2005 Express Edition


Unit Tests

In order to fill this test matrix, please create an empty G2 installation and activate every module & every theme. We have ffmpeg, imagemagick and netpbm binaries for almost every platform and can help you achieve this goal. Then run all the unit tests and record your findings here along with the date. Unit tests are part of an svn distribution. They are special tests that execute every part of the gallery code on your system to help root out coding errors. To run the tests, navigate to http://yourhost/gallery2/lib/tools/phpunit/ You'll need to login and verify the config password before they will run. Additionally you may need to make changes to your php.ini file. The unit test page has a link back to this page and a almost properly formatted entry you can use to add your test result to the matrix. We will use this to keep track of quality issues as we approach our release milestones. If there's already a line for your configuration with a different owner you can update the line with your data and add yourself to the owner column.

Current

Web Server PHP Version Database Platform Locking Language Owner # Tests # Failed Date Notes
Apache/2.2.10 PHP 5.2.6 DB2 9.5 Windows XP database en_US Larry_Menard 3006 1 2008-11-23 no url_rewrite, multi_root, or jpegtran. Non-svn, so lots of testCodeAudit failures. Only real failure was testFsockopenBadHost
Apache/2.2.4 PHP 5.2.6 Oracle Express Edition Release 10.2.0.1.0 Windows database de_DE valiant 3287 0 2008-10-16 -getid3
Apache/2.2.9 PHP 5.2.6-5 SQLite 3.5.9 Debian/Linux database de_DE valiant 3323 0 2008-10-13
Apache/2.2.3 (CentOS) PHP 5.2.6 pdo_sqlite sqlite 3.3.6 Linux flock en_US fryfrog 3323 1 2008-10-14 [2]
Apache/2.2.3 PHP 4.4.4-8 DB2 Linux flock de_DE valiant 3336 1 2008-10-12
Apache/2.2.4 PHP 5.2.4 MSSQL 2008 Windows XP database de_DE valiant 3300 2 2008-10-12 [3]
Apache/2.2.9 PHP 5.2.6-3 PostgreSQL 8.3.3 Debian/Linux database de_DE valiant 3336 0 2008-10-12
Apache/2.2.9 PHP 5.2.6-3 MySQLi 5.0.30 Debian/Linux flock en_US valiant 3336 0 2008-10-12
Apache/2.2.9 PHP 5.2.6-3 PostgreSQL 7.4.14 Debian/Linux flock en_US valiant 3319 0 2008-09-18
Apache/2.2.9 (Fedora) PHP 5.2.6 mysqli 5.0.51a Linux flock en_US trbailey 3311 0 2008-09-04 [2]
Apache/2.2.8 (Fedora) PHP 5.2.6 mysqli 5.0.51a Linux flock en_US trbailey 3311 0 2008-09-03 [2]
Apache 2.2.6 PHP-CGI 5.2.3 MySQL 5.0.45-5 (trans) Debian lenny/sid Database en_GB mindless 3319 1 2008-09-23 r18056 [1]
Apache 2.2.6 PHP-CGI 5.1.5 MySQL 5.0.45-5 (mysqli) Debian lenny/sid flock zh_TW mindless 3319 1 2008-08-23 r18058 [1]
Apache 2.2.6 PHP-CGI 4.3.0 MySQL 5.0.45-5 (non-trans) Debian lenny/sid flock tr mindless 3319 1 2008-09-23 r18058 [1]
Apache PHP 4.3.10 mysqlt 3.23.58-log FreeBSD flock en_US bharat 3320 0 2008-09-23
Apache/2.2.9 PHP 5.2.6-3 mysqli 5.0.51a-12 Debian/lenny flock en_US trbailey 3319 1 2008-09-24 [2]
Apache 2.2.9 PHP 5.2.7RC1 mysqli 5.0.51a-15-log Linux database en_US bharat 3336 0 2008-10-12
IIS 7 on port 8000 PHP 5.2.4 FastCGI mysqli 5.1.26 Windows 2008 x64 flock en_US virshu 3255 4 2008-10-12 [4][5]
IIS 7 on port 8000 PHP 5.2.4 FastCGI SQL Server 2008 Windows 2008 x64 flock en_US virshu 2882 55 2008-10-14 [5][6][7]
Apache 2.2.9 on port 8000 PHP 5.2.6 mysqli 5.0.67 Linux flock en_US virshu 51 4 2008-10-14 [5]
Apache PHP 5.3.0alpha3-dev mysqlt 5.0.51a-15-log Linux database en_US bharat 3336 0 2008-10-13
lighttpd/1.4.19 PHP 5.2.6-2ubuntu3 mysqli 5.0.67-0ubuntu6 Linux flock en_US trbailey 3065 0 2008-10-14 -nokiaupload -rewrite

[1]: One watermark test fails because I have existing watermarks (test passes if none exist)
[2]: FsockOpenBadHost gives an ambiguous result with DNS global "A" record. Adding "www.BOGUSBOGUSBOGUSBOGUS.com" to hosts and removing any local dns search domain corrects the issue.
[3]: Expected failures because MSSQL doesn't support UTF-8 (but UCS2): migrate.ConfirmImportControllerTest.testImportKOI_8, core.StorageTest.testTruncateString
[4]: watermark doesn't create directory g2data\plugins_data\modules\watermark; if the directory exists - the tests pass.
[5]: 4 httpauth tests are failing on non-default port
[6]: StorageTest.testTruncateString [7]: core.WebTest fail due to non-standard port and/or disabled URL rewrite

Old

Web Server PHP Version Database Platform Locking Language Owner # Tests # Failed Date Notes
Apache/2.0.59 PHP 5.0.4 mysqlt 5.0.45 Windows XP Database de valiant 2964 0 2007-08-31 -getid3
Apache/1.3.33 PHP 4.3.10 mysqlt 3.23.58-log FreeBSD flock en_US bharat 3000 0 2007-08-31 r17011
Apache/2.0.55 PHP-CGI 5.2.3 MySQL 5.1.14 (non-trans) Windows XP Database de valiant 2756 0 2007-06-19 G2.2.2 -getid3
Apache/2.2.4 PHP 5.2.4 mysqlt 5.0.45 Windows XP database de valiant 2964 0 2007-08-31 -getid3
Apache/2.2.3 PHP 4.4.4-8 IBM DB2 v9 Linux flock en_US valiant 2794 0 2007-06-16 G2.2.2
Apache/2.0.55 PHP 5.1.6 Oracle 10.2.0.1 Gentoo flock de valiant 2780 0 2007-06-16 G2.2.2
Apache/2.0.55 PHP 4.4.4 MS SQL Server 2005 Windows XP Database de valiant 2746 3 2007-06-16 G2.2.2 -getid3 -multilang (no gettext) [10]
Apache/2.0.55 PHP 5.2.1 PostgreSQL 8.1.4 Windows XP database de valiant 2752 0 2007-06-10 G2.2.2 -getid3 (no code audit tests)
Apache/2.0.55 PHP 5.2.1 MS SQL Server 2005 Windows XP Database de valiant 2742 3 2007-03-10 -getid3 [10]
Apache/2.2.3 PHP 5.2.0 MS SQL Server 2005 Windows XP flock en birdman 2731 18 2007-03-06 [1][21][22][23][24][25][26][27][28]
Apache/2.0.54 PHP 5.2.1 MySQL 5.0.32 Debian Linux flock de valiant 2770 0 2007-02-24
Apache 2.2.3 PHP 5.2.0-7 MySQL 5.0.27 (trans) Debian Sarge flock en_US h0bbel 2637 4 2006-12-19 -digibug [14]
Apache/2.0.55 PHP 5.2.1 MySQL 5.1.14 Windows XP Database de valiant 2735 0 2007-02-28 -getid3
Apache/2.0.55 PHP 4.4.4 MySQL 5.0.18 (non-trans) Windows XP database de valiant 2591 0 2006-12-18 -getid3 -multilang (no gettext)
Apache 2.0.55 PHP 5.1.6 Oracle 10.2.0.1 Gentoo Linux Database fr valiant 2778 0 2007-03-11 r15988
Apache/2.0.55 PHP 5.2.1 PostgreSQL 8.1.4 Windows XP database de valiant 2736 0 2007-02-24 -getid3
IIS 5.1 PHP 5.2.0 (ISAPI) MySQL 4.1.12a-nt (trans) Windows XP Database de valiant 2744 0 2007-03-13 -getid3
Apache PHP 4.3.10 mysqlt 3.23.58-log FreeBSD flock en_US bharat 2780 0 2007-03-12
Apache 2.0.55 PHP 4.4.4/4.4.2 MySQL 5.0.18 (trans) Windows XP Database de valiant 2451 0 2006-11-05 -getid3 no mbstring
Apache 2.2.3 PHP 5.2.0 IBM DB2 V8.2.2 Windows XP Database en birdman 2575 7 2006-12-18 -getid3 -WebDAV [2][3][4][5][6][7][8]
Apache 2.2.3 PHP 5.2.0 IBM DB2 9 Express C Windows XP Database en birdman 2575 1 2006-12-15 -getid3 -WebDAV [2]
Apache 2.2.3 PHP 5.2.0 IBM DB2 9 Express C SuSE Linux x86-64 Database en birdman 2696 7 2007-02-01 -digibug [20][21][22]
Apache 2.2.3 PHP 5.2.0 RC6 MS SQL Server 2005 Express Edition Windows XP Database en birdman 2558 3 2006-12-02 [1] [12] [16]
Apache 2.2.3 PHP 4.4.4-9 MySQL 5.0.32 (trans) Debian sarge File tr mindless 2968 1 2007-07-13 r16758 +notification +cmmigrate [29]
Apache 2.2.3 PHP-CGI 5.1.5 PostgreSQL 7.4.16 Debian etch File fr mindless 3000 0 2007-08-31 r17012
Apache 2.2.3 PHP 4.4.4-8 IBM DB2 9 Express C Debian Testing flock en_US bharat 2770 0 2007-02-25 r15874
Apache 2.2.3 PHP 4.4.4-8 PostgreSQL 7.4.14 Debian Testing flock en_US bharat 2770 0 2007-02-25 r15874

[1]: testimportkoi_8 failed (should be fixed in r15011), still fails on MS SQL Server if wrong DB collation selected (known issue, ok). see [10]

[2]: DataCacheTest.testCleanPageDataCache: "db2_fetch_array() [function.db2-fetch-array]: Cannot Determine LOB Size". Runs clean by itself.

[3]: migrate.ConfirmImportControllerTest.testImportno_NO: SQL0433N Value "Western European (ISO) Hello World Norwegian Norsk Hallo" is too long. SQLSTATE=22001 SQLCODE=-433

[4]: migrate.ConfirmImportControllerTest.testImportfr_FR: SQL0433N Value "CHARSET=8859-1, fr-Fr, Hello World, french, français, Bon" is too long. SQLSTATE=22001 SQLCODE=-433

[5]: migrate.ConfirmImportControllerTest.testImportKOI_8: SQL0433N Value "???? ?????? ????" is too long. SQLSTATE=22001 SQLCODE=-433

[6]: migrate.ConfirmImportControllerTest.testConvertHtmlToBbcode: There are unreleased locks! (Runs clean by itself, only fails if run with KOI_8.)

[7]: core.StorageTest.testEncodeDecodeBlob: blob data was altered in encode -> insert -> select -> decode

[8]: core.StorageTest.testTruncateString: SQL0433N Value "???????????????" is too long. SQLSTATE=22001 SQLCODE=-433

[9]: core.LocalizationAuditTest fails with a seg fault due to a PCRE call

[10]: Known issue: MS SQL Server does not have full unicode support. It cannot store cyrillic and western umlauts at the same time. You need to select the correct collation for your application / usage.

[12]: StorageTest.testTruncateString fails with SQL0433N Value "???????????????" is too long.

[14]: Missing german locale accounted for 4 failed tests

[16]: WebdavTest.testLockUnlock fails with DB locking (passes with flock file based locking)

[20]: 3 webdav test failures (timestamps coming back as integer instead of string). testLockUnlock, testLockRefresh, testLockConfict

[21]: 3 webdav test failures (Mismatch At: [ 3] <D:href>/gallery2/w/albumtest1602459243/test-630_dat</D:href> !== <D:href>/gallery2/main.php/w/albumtest1602459243/test-630_dat</D:href>) testPropfind, testProppatch, testLockConflict

[22]: 2 webdav test failures (Error (ERROR_BAD_PARAMETER)) testMove, testIllegalDestination

[23]: httpauth.HttpAuthHelperTest.testCheckConfiguration unexpected error code Mismatch At: [] 0 !== -2147483646 0 type:integer -2147483646 type:integer

[24]: httpauth.HttpAuthHelperTest.testCheckConfigurationHttpAuthWorksIgnoresCauses httpauth.HttpAuthHelperTest.testCheckHttpAuth unexpected fwrite: GET /Gallery2/main.php?g2_view=httpauth.HttpAuthWorks HTTP/1.0 Host: cpe0013102da23b-cm0f0079804905.cpe.net.cable.rogers.com Authorization: Basic VVNFUk5BTUU6UEFTU1dPUkQ=

[25]: httpauth.HttpAuthModuleTest.testGetRewriteRules Mismatch At: [] extra keys in array 2: 0

array ( ) type:array

array (

 0 => 'authorization',

) type:array

[26]: randomhighlight.RandomHighlightOptionTest.testHighlightPermission Error (ERROR_COLLISION) : D:\g2data\albums\albumtest9849 already exists

[27]: core.StorageTest.testTruncateString inserted string Mismatch At: [ 0]

[28]: *.*.testCodeAudit Test skipped: .svn/entries not found core.CodeAuditTest.testCodeAudit core.LocalizationAuditTest.testCodeAudit core.Php43CompatibilityTest.testCodeAudit core.PhpDocAuditTest.testCodeAudit core.SvnAuditTest.testCodeAudit core.TemplateAuditTest.testCodeAudit

Very Old

Web Server PHP Version Database Platform Locking Language Owner # Tests # Failed Date Notes
Apache 2.0.55 PHP 5.1.6 PostgreSQL 8.0.1 Windows XP Database de valiant 2439 0 10/28/2006 -getid3
Apache 2.0.54 PHP 5.1.6 MySQL 5.0.14a (trans) Debian sarge File en valiant 2398 1 9/29/2006 [1]
Apache 2.2.2 PHP 5.1.4 MySQL 5.0.21 (trans) FreeBSD 6.1-STABLE File en Edgeman 2250 1 5/11/2006 [1]
Apache 2.0.55 PHP 5.1.4 IBM DB2 9 Express C Windows XP Database en birdman 2279 11 7/29/2006 -getid3[3][4][5][6][7]
Apache 1.3.33 PHP 4.3.10 MySQL 3.23.58 FreeBSD 4.8 File en mindless 2392 0 9/20/2006
Apache 2.2.2 PHP 5.1.4 (with patches) MySQL 5.0.22 OpenSuse 10.2 factory (x86_64) Flock de Jens Tkotz 1908 2 8/08/2006
Apache 2.2.2 PHP 5.1.4 (with patches) IBM DB2/LINUXX8664 9.1.0 OpenSuse 10.2 factory (x86_64) Flock de Jens Tkotz 2218 5 8/08/2006
Apache 2.0.54 PHP 5.0.5 MySQL 4.1.14-nt Windows XP Database en bharat 2366 1 10/5/2006 [1]
Apache 2.0.55 PHP 5.1.4 Oracle 10g Windows XP Database en birdman 2299 27 08/04/2006 [10]
Apache 2.2.0 PHP 5.1.2 DB2 V8 FP10 SuSE SLES9 Database en birdman 1190 10 08/03/2006 [6] [9]

[1]: # testimportkoi_8 (this failure just shows that UTF 8 databases can store more characters than non-utf8 databases. don't adjust the unit test, rather keep it as a reminder that bug 1382037 should be fixed)

         * custom field values 
           Mismatch At: [ 464747 Description] Если звезды зажигают ночью - значит это кому-нибудь надо. Если кто-то выстасвляет фотографии - это ведь неспроста! Может, в этом великая и сер !== Если звезды зажигают ночью - значит это кому-нибудь надо. Если кто-то выстасвляет фотографии - это ведь неспроста! Может, в этом великая и сермяжная правда жизни.
array (
 464747 => 
 array (
   'Description' => 'Если звезды зажигают ночью - значит это кому-нибудь надо. Если кто-то выстасвляет фотографии - это ведь неспроста! Может, в этом великая и сер',
 ),
)
              type:array
array (
 464747 => 
 array (
   'Description' => 'Если звезды зажигают ночью - значит это кому-нибудь надо. Если кто-то выстасвляет фотографии - это ведь неспроста! Может, в этом великая и сермяжная правда жизни.',
 ),
)
              type:array

[3]: In addition to KOI_8, I have the same multi-byte problem with no_NO and fr_FR. testConvertHtmlToBbcode also fails if run with KOI_8, but runs clean in isolation. (Accounts for 4 failures.)

[4]: *.testCodeAudit fail (skipped, actually), these should only be run in SVN builds. (Accounts for 5 failures that are not really failures.)

[5]: StorageTest.testSqlInjectionWithNullCharacter, MSSQL complains: SQL Syntax Error.

[6]: IndexDotPhpTest.testHttpRedirect (known problem)

[7]: StorageTest.testEncodeDecodeBlob, "blob data was altered in encode -> insert -> select -> decode"

[9]: On my Linux env I have not installed anything but the core and search modules. I suspect that the majority of these failures are a result of some modules not being installed:

       * testHttpRedirect (see note [8])
       * testRecreateResizesForSmallPhoto
       * testAddSmallPhotoToAlbum
       * testSessionCookieHeaderAndPersistence
       * testIsPersistentSessionAllowedForRequest

[10]: First time I've ever run unit tests on Oracle. Results:

http://cpe0013102da23b-cm0f0079804905.cpe.net.cable.rogers.com/misc/gallery2/Dynamic%20Albums%20Verification/Windows%20-%20Oracle/Tests%200001%20-%200508.html

http://cpe0013102da23b-cm0f0079804905.cpe.net.cable.rogers.com/misc/gallery2/Dynamic%20Albums%20Verification/Windows%20-%20Oracle/Tests%200509%20-%202299.html

Browser Compatibility Testing

Browser rendering tests. In each box put name+[browser-version]+svnrev+comments.

Feature Firefox IE6 IE7 Opera Safari
AdminPlugins mindless r14884 OK
dmolavi FF2 r14907 OK
dmolavi r14907: silk iconpack has grey backgrounds (transparency not working) bharat r15090: everything looks fine. silk icons have transparency. bharat 9.02 r15298: Actions work, but tooltip screenshots are the full width of the screen. mindless r14887: works, but status msgs show at top of document, not top of visible area
ItemEditPhotoThumbnail bharat FF1 r15316 OK bharat r15316 OK mindless r15334 OK bharat 9.02 r15298: Works, but semi-transparency inside the selection box is missing mindless r14887 OK
Autocomplete

(installer,siteadmin)

dmolavi FF2 r14897 OK
mindless FF2 r15459 OK
dmolavi r14897 OK
bharat r15316 OK
mindless r15459 OK, though don't see green dotted-line until results shown
mindless r15459 OK bharat 9.02 r15298 OK
mindless 9.02 r15459 OK
mindless 2.0.4 r15555 OK
Installer/upgrader, button rounded corners

(refactored in r15456)

mindless FF2 r15456 OK mindless r15456 OK mindless r15456 OK mindless 9.02 r15456 OK mindless 2.0.4 r15555 OK
Popup thumbnails

(itemmove, itemdelete, showallcomments)

bharat FF1 r15316 OK bharat r15316 OK mindless r15450: works in itemmove/delete but in ShowAllComments only shows for first thumbnail
bharat r15547: OK (ShowAllComments fixed in r15547)
bharat 9.02 r15298: Popup thumbnails file in ShowAllComments but takes up full width of the screen in ItemMove and ItemDelete
mindless 9.02 r15715: full width behavior described above occurs in all 3 locations
mindless 2.0.4 r15555 OK
Markup bar/color chooser bharat FF1 r15316 OK bharat r15316: Everything works, but color chooser popup appears behind date/time dropdowns on Edit Album page. IE6 bug mindless r15450 OK bharat 9.02 r15298 OK mindless 2.0.4 r15555: Works, but cursor appears before newly added text instead of after
Watermark

(siteadmin, useradmin, itemadd, itemedit)

bharat FF1 r15316 OK bharat r15316 OK bharat r15447 OK Can't drag the watermark to the leftmost column or topmost row bharat 9.02 r15298 OK mindless 2.0.4 r15555: Works, though add-item has leaves artifacts if switching between watermarks changes the window scrolling (like big watermark changing to small one)
Ratings bharat FF1 r15316 OK bharat r15316 OK bharat r15447 OK bharat 9.02 r15298 OK mindless 2.0.4 r15555 OK
FlashVideo Ankabout RC1 OK mindless 2.0.4 r15639 OK
MP3Audio mindless 2.0.4 r15639 OK
MovVideo (quicktime) floridave FF2 Nov3 activeX issue quicktime fix mindless 2.0.4 r15639 OK
Matrix theme dmolavi FF2 r14627
bharat FF1 r15316 OK
dmolavi r14627
bharat r15316 OK
bharat r15447 OK bharat 9.02 r15298 OK mindless 2.0.4 r15555 OK
Classic theme Ankabout RC1: In main gallery page, sub-albums have a linebreak before. mindless 2.0.4 r15555 OK
Floatrix theme Ankabout RC1: Sidebar scrolls horizontally if random highlight is landscape. mindless 9.02 r14981 OK mindless 2.0.4 r15555 OK
Siriux theme Ankabout RC1: Tabs in Theme Settings overlap. mindless 2.0.4 r15697: incorrect placement of prev/next arrows, no rounded corners
Carbon theme mindless FF2 r14981 OK Ankabout RC1 OK mindless 9.02 r14981 OK mindless 2.0.4 r15697 OK
Hybrid theme mindless r15450 OK mindless r15450: some item titles extend beyond right edge of shaded background mindless 9.02 r14973: Item links popup intermittently too wide; conflict of keyboard commands with opera actions (both are performed) mindless 2.0.4 r15780: using arrow keys for navigation results in double events
Slider theme mindless r15450 OK mindless r15450 OK
Ajaxian theme mindless FF2 r15450 OK mindless r15967: thumbnail images shift on mouseover mindless 9.02 r14981: Click photo(shrink+show link) is ok, but click again to restore size and it disappears mindless 2.0.4 r15697: some rendering/resizing problems
Right-to-Left display
(ar, fa, or he locale)
bharat r15447 OK mindless 2.0.4 r15555 OK

YUI functionality testing

YUI performs consistently across all A-Grade browsers. Just specify which browser version you used. Language is important. It is very possible to miss localization of JavaScript strings. Therefore, if possible, please test in non-English language.

Current

Gallery 2.3 includes YUI 2.3.1

Module Description YUI component Browser Language Owner Date Notes
Comments Show Comments Animation Firefox 2 en_US virshu 2008-04-27
Comments Delete Comments Connection
Core Admin Event Log Viewer Connection, Dom
Core Admin Language Manager Dom
Core Admin Plugins Tooltip, Event
Core Admin Repository Connection, Dialog, Animation
Core Item Delete Tooltip, Dialog
Core Item Edit Captions Tooltip
Core Item Move Tooltip, Dialog, Treeview
Core AutoComplete Autocomplete
Core Item Edit Photo Thumbnail Tooltip, DragDrop, Dom
Core Markup Bar slider
Exif Exif Connection
Link Item Add Link Item Treeview
Rating Rate Item Connection
Replica Add Replica Treeview
Slideshow Slideshow Event
Watermark Add Watermark DragDrop, Dom

Upgrades

The upgrade path is usually tested from the last public release to the new release. Keep old tested upgrade paths in the list and add upgrades to newer versions at the top of the list. From time to time, upgrade paths from older versions (alpha 4 = core version 0.8.4 or newer) to the current release should also be performed.


Current Upgrades

New Core Version New Release Name New G2 Package Old Core Version Old Release Name Web Server PHP Version Database Platform Owner Date Notes
1.3.0 2.3 typical-en.tar.gz 1.2.0.6 2.2.4 Apache 2.0.61 PHP 5.2.6-fcgi MySQL 5.0.67 (mysqlt) Unix valiant 2008-10-17 [OK]
1.3.0 2.3 typical.zip 1.0.0 2.0 Apache 2.0.61 PHP 5.2.6-fcgi MySQL 5.0.67 (mysql) Unix valiant 2008-10-17 [OK]
1.3.0 2.3 full-en.tar.gz 1.1.0.2 2.1.2 Apache 2.2.9 PHP 5.2.6 PostgreSQL 8.3.4 Debian/Linux valiant 2008-10-17 [OK]
1.3.0 2.3 full-en.tar.gz 1.2.0.7 2.2.6 ? ? ? FreeBSD 6.2 nivekiam 2008-10-17 [OK]
1.3.0 2.3 developer.zip 1.2.0.7 2.2.6 Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 typical.zip 1.1.0.2 2.1.2 Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 full-en.tar.gz 1.2.0.8 2.2.6 Apache 2.2.9 PHP 5.2.6 5.0.51a Debian Lenny/5.0 bharat 2008-10-17 [OK]
1.3.0 2.3 full-en.zip 1.2.0.8 2.2.6 Apache 2.2.9 PHP 5.2.6 5.0.51a Windows XP talmdal 2008-10-17 [OK]
1.3.0 2.3 typical.zip Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 full.zip Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 minimal.zip Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 typical-en.zip Apache 2.2.3 PHP 5.2.6 cgi-fcgi MySQL 5.0.67 (mysqli) CentOS fryfrog 2008-10-17 [OK]
1.3.0 2.3 developer.zip 1.2.0.4 2.2.3 Apache 2.2.9 PHP 5.2.6 MySQL 5.0.30 Debian/Linux valiant 2008-10-17 [OK]
1.3.0 2.3 typical.zip 1.1.0.1 2.1.1 Apache/2.2.4 PHP 5.2.6 MySQL 5.0.45 Windows XP valiant 2008-10-17 [OK]
1.3.0 2.3 full.tar.gz 1.2.0.3 2.2.2 Apache/2.2.4 PHP 5.2.6 SQL Server 2008 Windows XP valiant 2008-10-18 [OK]

Upgrades to 2.2

New Core Version New Release Name Old Core Version Old Release Name Web Server PHP Version Database Platform Owner Date Notes
1.2.0.5 2.2.3 1.1.2 2.1.2 Apache 2.2.3 PHP 5.2.3 MySQL 5.1.14 Windows XP valiant 2007-08-29 [OK]
1.2.0.5 2.2.3 1.2.0 2.2 Apache 2.2.3 PHP 5.2.3 MySQL 5.1.14 Windows XP valiant 2007-08-29 [OK]
1.2.0.4 2.2.2 1.2.0.1 2.2.1 Apache 2.0.55 PHP-CGI 5.2.3 MySQL 5.1.14 Windows XP valiant 2007-06-19 [OK]
1.2.0.4 2.2.2 1.1.0.2 2.1.2 Apache 2.0.55 PHP 5.1.6 Oracle 10.2.0.1 Gentoo valiant 2007-06-16 [OK]
1.2.0.4 2.2.2 1.2.0.1 2.2.1 Apache 2.0.55 PHP 4.4.4 MSSQL 2005 Windows XP valiant 2007-06-15 [OK]
1.2.0.4 2.2.2 1.1.26 2.2-RC1 Apache 2.2.3 PHP 4.4.4 DB2 9 Debian valiant 2007-06-15 [OK]
1.2.0.4 2.2.2 1.2.0.1 2.2.1 Typical Apache 2.0.55 PHP 5.2.3 MySQL 5.1.14 Windows XP valiant 2007-06-15 [OK]
1.2.0.3 2.2.2 (pre) 1.1.0.2 2.1.2 Minimal Apache 2.0.55 PHP 5.2.1 MySQL 5.1.14 Windows XP valiant 2007-06-10 [OK]
1.1.30 2.2 SVN (r5990) 1.1.0.2 2.1.2 Minimal Apache 2.0.55 PHP 5.2.1 MySQL 5.1.14 Windows XP valiant 2007-03-12 [OK]
1.1.30 2.2 SVN (r15887) 1.0.0.4 2.0.4 Full Apache 2.2.3 PHP 5.2.0 MySQL 5.0.27 Windows XP talmdal 2007-03-13 [OK]
1.1.21 2.2-SVN (r15222) 1.1.0.2 2.1.2 Typical Apache 1.3.37 PHP 5.1.4 MySQL 4.1.21 RHEL ES rel. 3 virshu 2006-11-18 [OK]
1.1.21 2.2-SVN (r15224) 1.1.0.2 2.1.2 Full Apache 2.2.2 PHP 5.1.6 MySQL 5.0.22 FC 5 virshu 2006-11-19 [OK]
1.1.23 2.2-SVN (r15265) 1.1.0.2 2.1.2 Full IIS 5 PHP 5.2.0 MySQL 5.0.22 on a different FC6 server Windows XP Professional virshu 2006-11-23 [OK]
1.1.23 2.2-SVN (r15265) 1.1.0.2 2.1.2 Full IIS 5 PHP 5.2.0 MySQL 5.0.22 on a different FC6 server Windows XP Professional virshu 2006-11-23 [OK]
1.1.25 2.2-SVN (r15586) 1.1.0.2 2.1.2 Full Apache 1.3 PHP 4.3.10 MySQL 3.23.58-log FreeBSD 4.8 bharat 2006-12-28 [OK]
1.1.25 2.2-SVN (r15586) 1.0.0 2.0 Full Apache 1.3 PHP 4.3.10 MySQL 3.23.58-log FreeBSD 4.8 bharat 2006-12-28 [OK] [1]
1.1.25 2.2-rc-1-dev 1.0.2 2.0.2 Full Apache 2.0 PHP 5.1.16 Oracle 10g Gentoo valiant 2006-12-28 [OK]
1.1.26 2.2-rc-1-dev 0.8.4 2.0-alpha-4 Apache 2.0.55 PHP 5.1.5-cgi MySQL 5.0.22 Debian sarge mindless 2006-12-31 [2] [3] [4] [5] [6]

[1]: My initial 2.0 url was http://example.com/gallery2/v/ and when I refreshed the page it sent me to http://example.com/gallery2/v/upgrade/index.php/upgrade/index.php/upgrade/index.php/... (repeated a long time). I edited the url to go to the upgrader and it worked fine after that.

[2]: After putting new files in place, main.php just showed blank page. perhaps some incompatibility in GalleryDataCache cache files.. direct URL to upgrader was ok.

[3]: Core upgrade got:

Error (ERROR_PLATFORM_FAILURE) : /.../g2data/locks/1
   * in modules/core/classes/FlockLockSystem.class at line 72 (GalleryCoreApi::error)
   * in modules/core/classes/GalleryLockSystem.class at line 147 (FlockLockSystem::_acquireLock)
   * in modules/core/classes/helpers/GalleryLockHelper_simple.class at line 176 (GalleryLockSystem::acquireWriteLock)
   * in modules/core/classes/GalleryCoreApi.class at line 2183 (GalleryLockHelper_simple::acquireWriteLock)
   * in modules/core/CoreModuleExtras.inc at line 799 (GalleryCoreApi::acquireWriteLock)
   * in modules/core/module.inc at line 433 (CoreModuleExtras::upgrade)
   * in modules/core/classes/GalleryModule.class at line 155 (CoreModule::upgrade)
   * in upgrade/steps/UpgradeCoreModuleStep.class at line 83 (GalleryModule::installOrUpgrade)
   * in upgrade/index.php at line 185 (UpgradeCoreModuleStep::processRequest)

I copied the 1.1.8->1.1.9 (remove lock subdirs) code to run earlier in upgrade process, and then core upgrade worked.. fixed in r15613.

[4]: Upgrade plugins step said "Unable to query veloria theme". This old style theme had a MANIFEST so systems check didn't tell me to remove it. Had to remove it before able to upgrade any plugins.

[5]: Netpbm and Gd upgrades failed with: Error (ERROR_COLLISION) : CRC mismatch: 340908721 != 3155881288, or Mime type mismatch: != Had to uninstall all toolkit modules and manually clear tables in db, then reinstall toolkit modules.

[6]: After upgrade, tried to login.. after login, still not logged in. Old domain cookie not being overwritten by new host cookie.. removing old cookie resolve this.

Old Upgrades

New Core Version New Release Name Old Core Version Old Release Name Web Server PHP Version Database Platform Owner Date Notes
1.1.0.1 2.1.1 1.0.0.4 2.0.4 Apache 1.3.33 PHP 4.3.10 Postgres 7.x FreeBSD 4.8 bharat 4/6/2006 Had to upgrade the imagemagick module by hand (probably because I have a vulnerable binary). Otherwise, smooth sailing.
1.1.0.1 2.1.1 1.0.0.4 2.0.4 Apache 2.0.55 PHP 5.1.2 Postgres 8.1.3 Windows XP Larry Menard 13/04/2006 Couldn't configure URL Rewrite in 2.0.4. (Apache conf. prob at my end?), works fine in 2.1.1
1.1.0.1 2.1.1 1.0.0.4 2.0.4 Apache 2.0.54 PHP 5.0.4 MySQL 4.1.13-nt Windows XP bharat 4/14/2006 Worked fine.
1.1.0.1 2.1.1 1.0.0.3 2.0.3 Apache 2.0.5 PHP 4.4.2-1 MySQL 5.0.18 Debian mindless 13-Apr-2006 Upgrade modules request stopped; tried again and finished OK
1.1.0.1 2.1.1 1.0.0.4 2.0.4 Apache 2.0.55 PHP 5.1.2 Oracle 10g XE Windows XP Larry Menard 04/06/2006 1) Frequent NLS probs (req. server restart), 2) Couldn't configure URL Rewrite in 2.0.4. (Apache conf. prob at my end?), works fine in 2.1.1
1.0.34 2.1-rc-2a+ 1.0.0.1 2.0.1 Apache/1.3.33 (Unix) PHP/4.3.10 mysql 3.23.58-log Debian Linux bharat 03/20/2006 [OK]
1.0.34 2.1-rc-2a+ 0.9.35 2.0-rc-1+ Apache/1.3.31 (Unix) PHP/4.3.7 mysql 4.1.9-standard Slackware Linux volksport 03/20/2006 [OK]
1.0.34 2.1-RC-2a+ 0.8.4 2.0 Alpha-4 Apache 1.3.34 PHP 4.4.2 MySQL 4.1.16 FreeBSD 4.11 mindless 3/20/2006 [Good enough] had to go to upgrade url directly (session errors from main.php), and hit known CRC mismatch in toolkit upgrades from alpha-4 to beta-1 days
1.0.34 2.1-RC-2a+ 1.0.0 2.0.0 Apache 2.0.54 PHP 5.1.2 Postgres 8 Windows XP valiant 03/17/2006 [OK] (required generate-sql changes)

Very Old

New Core Version New Release Name Old Core Version Old Release Name Web Server PHP Version Database Platform Owner Date Notes
1.0.28 2.1 RC1a+ 1.0.0.2 2.0.2 Apache 2.0.55 PHP 4.4.0 MySQL 4.1.14 Gentoo fryfrog 02/15/2006 [OK]
1.0.27 2.1 RC1 0.9.10 G 2 Beta-2 Apache 2.0.52 PHP-CGI 4.4.1 MySQL 4.1.10 Gentoo valiant 02/10/2006 [OK]
1.0.25 2.1-soon 0.9.10 G 2 Beta-2 Apache 2.0.52 PHP 4.4.0 PostgreSQL 8.0.1 Gentoo valiant 02/09/2006 rewrite upgrade failed
1.0.16 2.1.0- 1.0.0 G 2.0 Apache 2.0.52 PHP 4.4.0 PostgreSQL 8.0.1 Gentoo valiant 01/10/2006 [OK]
1.0.18 2.1.0- 1.0.3 2.0.1+ Apache 2.0.54 PHP-CGI 4.4.0 MySQL 4.1.12a Windows XP valiant 01/13/2006 [OK]