Gallery 2.1.3 issues

[PinkElephant]

I've recently upgraded a couple of sites to 1.12.2 and Gallery to 2.1.3.

One site no longer displays any galleries, the other seems to work. In both cases, editing is no longer possible under admin -- clicking on any gallery presents unpopulated fields (title, comment, template, hide parent, etc) and a list of the gallery folders below root.

The logs are showing multiple entries like this:

Code: Select all

PHP Notice:  Undefined index: filepath in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 75, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: filename in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 75, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: defaultfile in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 164, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: defaultfile in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 126, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: title in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 211, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: comment in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 212, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery
PHP Notice:  Undefined index: hideparentlink in /srv/example.com/public/htdocs/modules/Gallery/action.editgallery.php on line 221, referer: https://www.example.com/[admin-dir]/moduleinterface.php?_sx_=8a99a463bbdd5dad&module=Gallery

The problem sites are on the same host with a similar setup, e.g:
----------------------------------------------

Cms Version: 1.12.2

Installed Modules:

CMSMailer: 5.2.14
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.7
MicroTiny: 1.2.9
ModuleManager: 1.5.8
News: 2.15.2
Search: 1.7.13
ThemeManager: 1.1.8
Gallery: 2.1.3
CGExtensions: 1.52.2
CGSmartImage: 1.21
FormBuilder: 0.8.1.3

Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 15000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true

Php Information:

phpversion: 5.6.19-0+deb8u1
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 120
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 10M
upload_max_filesize: 15M
session_save_path: /var/lib/php5/sessions (1733)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)

Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.47
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found

----------------------------------------------

disabled functions:

Code: Select all

pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority

Looking further I'm now seeing it under CMSms 2.1.3. I'll try downgrading Gallery on one of the sites...

[PinkElephant]

Update 1:

Probably not the cleanest method but a straight file copy of Gallery 2.0 files restored full functionality. Overwriting with the more recent 2.1.2 files and all remains well.

I can't see why some sites were affected and others not...

[PinkElephant]

Update 2:

It looks like the affected sites are missing the jsposition field in the cms_module_gallery_templateprops table.

Not sure how/why/when but I'll file a bug report on the forge (hopefully, today).

[Jos]

My guess is that your upgrade did not go the way it was ment to go. I don't have any clue why.

Especially the way you did like you described at update 1 is not the way to go, so no need to file a bugreport for that.

[PinkElephant]

Hi Jos

First up, thanks for the module!

My guess is that your upgrade did not go the way it was ment to go. I don't have any clue why.

Yup, upgrade problem was my first thought but I've not encountered any error messages during upgrade -- always via the Module Manager (except for the file-copy downgrade...)

Especially the way you did like you described at update 1 is not the way to go, so no need to file a bugreport for that.

Understood. The file copy was a quick and dirty experiment to isolate the problem (deliberately avoiding changes to the database) and I only tried it on one of the affected sites.

I can't get into the forge at the moment - credentials rejected and password-reminder causing an error ("We're sorry, but something went wrong. We've been notified"...) - but I'll try and provide more detail when I'm in.

Regards

[Jos]

To complete your quick and dirty fix, you can add the missing column "jsposition" (type INT) manually with e.g. phpmyadmin in table "module_gallery_templateprops"

[PinkElephant]

Hi Jos

I've added the jsposition field, where necessary, and all sites are now on Gallery 2.1.3.

One site showed duplicate galleries and signs of database corruption:

Expected;

Code: Select all

INSERT INTO `cms_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES
(1, 'Gallery/', '', '2010-11-18 23:39:01', -1, 1, 0, 0, 'Gallery', 'Thank you for installing the Gallery module. If you have uploaded some images to the ''uploads/images/Gallery'' folder, you will see them below. You can edit titles, descriptions and thumbnail sizes in the admin section. Check out all the other features this module offers in the Module Help.'),
(2, 'Artisan/', '', '2010-11-19 13:54:22', 0, 1, 0, 1, 'Artisan Image Gallery', 'This is the Artisan collection. Click on any thumbnail to start the image viewer.'),
(3, 'AAP-banner-Artisan.jpg', 'Artisan', '2010-11-19 13:57:56', 0, 1, 0, 2, 'AAP Banner at the School of Artisan Food event', ''),
(4, 'Artisan-bus-bikes-2.jpg', 'Artisan', '2010-11-19 13:57:59', 0, 1, 0, 2, 'School of Artisan Food bus and bikes', ''),
(5, 'MTH-inside-2.jpg', 'Artisan', '2010-11-19 13:58:02', 0, 1, 0, 2, 'Inside the Mobile Training Hub', ''),
(6, 'MTH-outside.jpg', 'Artisan', '2010-11-19 13:58:04', 0, 1, 0, 2, 'Outside the Mobile Training Hub', ''),
(7, 'conference_2010/', '', '2010-11-19 15:03:26', 0, 1, 8, 1, '2010 Conference Image Gallery', 'This gallery contains pictures from the 2010 annual Conference. Click on a thumbnail image to start the viewer.'),
(8, 'IMG_6729.jpg', 'conference_2010', '2010-11-19 15:04:08', 1, 1, 0, 7, 'Opening Address from Chair, Councillor Keith Girling', ''),
(9, 'IMG_6771.jpg', 'conference_2010', '2010-11-19 15:04:11', 2, 1, 0, 7, 'Delegate discussions during breakout session', ''),
(10, 'IMG_6801.jpg', 'conference_2010', '2010-11-19 15:04:14', 3, 1, 0, 7, 'Speaker discussions during breakout session', ''),
(11, 'IMG_6845.jpg', 'conference_2010', '2010-11-19 15:04:18', 4, 1, 0, 7, 'SLIC Training receiving awards from Cllr. Keith Girling', ''),
(12, 'IMG_6849.jpg', 'conference_2010', '2010-11-19 15:04:21', 5, 1, 0, 7, 'Gordon Stokes presenting awards to Dave Skepper, Stagecoach East Midlands', ''),
(13, 'IMG_6853.jpg', 'conference_2010', '2010-11-19 15:04:24', 6, 1, 0, 7, 'Cllr Chris Jackson presenting award to Bob Rowley, Chesterfield & District Community Transport', ''),
(14, 'IMG_6856.jpg', 'conference_2010', '2010-11-19 15:04:26', 7, 1, 0, 7, 'Jayne Ball from Portland College receiving two awards', ''),
(15, 'IMG_6862.jpg', 'conference_2010', '2010-11-19 15:04:29', 8, 1, 0, 7, 'Brenda Smithurst receiving award on behalf of Elmton & Creswell Village Company', ''),
(16, 'IMG_6865.jpg', 'conference_2010', '2010-11-19 15:04:32', 9, 1, 0, 7, 'The Conference team', ''),
(17, 'IMG_6874.jpg', 'conference_2010', '2010-11-19 15:04:34', 10, 1, 0, 7, 'The runner-up medal winners', ''),
(18, 'LO8Y3940.jpg', 'conference_2010', '2010-11-19 15:04:37', 11, 1, 0, 7, 'Keynote address from Gordon Stokes', ''),
(19, 'LO8Y4039.jpg', 'conference_2010', '2010-11-19 15:04:40', 12, 1, 0, 7, 'AAP Retrospective from Norman James, STAR', ''),
(20, 'Projects-Launch-Event/', '', '2010-11-19 16:11:43', 0, 1, 0, 1, 'AAP Projects Launch Event Image Gallery', 'Click on a thumbnail to start the image viewer.'),
(21, 'IMG_5357.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:24', 1, 1, 0, 20, 'Cllr. Simon Spencer, Derbyshire Economic Partnership', ''),
(22, 'IMG_5360.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:27', 2, 0, 0, 20, '', ''),
(23, 'IMG_5363.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:29', 3, 1, 0, 20, 'Tim Malynn, Notts. County Council', ''),
(24, 'IMG_5367.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:32', 4, 1, 0, 20, 'Dave Skepper, Stagecoach, AAP Stagecoach Jobseeker Fares', ''),
(25, 'IMG_5370.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:35', 5, 0, 0, 20, '', ''),
(26, 'IMG_5372.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:37', 6, 1, 0, 20, 'Serving the Community with Transport to Training cheque award', ''),
(27, 'IMG_5374.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:40', 7, 1, 0, 20, 'Alliance Access Bus cheque award', ''),
(28, 'IMG_5375.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:43', 8, 1, 0, 20, 'Rural Rover cheque award', ''),
(29, 'IMG_5377.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:45', 9, 1, 0, 20, 'Steetley Access Projects cheque award', ''),
(30, 'IMG_5380.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:48', 10, 1, 0, 20, 'Portland Skills Bus cheque award', ''),
(31, 'IMG_5382.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:50', 11, 1, 0, 20, 'Junction 29a Transport to Training cheque award', ''),
(32, 'IMG_5384.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:53', 12, 1, 0, 20, 'Stagecoach Jobseeker Fares cheque award', ''),
(33, 'IMG_5393.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:55', 13, 1, 0, 20, 'Rural Rover', ''),
(34, 'IMG_5398.jpg', 'Projects-Launch-Event', '2010-11-19 16:20:58', 14, 1, 0, 20, 'Serving the Community with Transport to Training', ''),
(35, 'IMG_5407.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:00', 15, 1, 0, 20, 'Alliance Access Bus', ''),
(36, 'IMG_5421.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:03', 16, 1, 0, 20, 'Portland Skills Bus', ''),
(37, 'IMG_5428.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:06', 17, 1, 0, 20, 'The AAP team flying the flag', ''),
(38, 'IMG_5447.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:08', 18, 1, 0, 20, 'AAP-funded vehicles at Markham Vale Environment Centre', ''),
(39, 'IMG_5450.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:11', 19, 0, 0, 20, '', ''),
(40, 'IMG_5452.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:13', 20, 1, 0, 20, 'Stagecoach Bus at Project Launch Event', ''),
(41, 'IMG_5456.jpg', 'Projects-Launch-Event', '2010-11-19 16:21:16', 21, 1, 0, 20, 'AAP-funded minibuses', ''),
(42, 'Test/', '', '2010-11-19 17:49:23', 0, 1, 0, 1, 'Test', 'Click on a thumbnail...'),
(43, 'test2/', '', '2010-11-19 17:49:47', 0, 1, 0, 1, 'test2', 'test2'),
(44, 'AAPConference061109-019.jpg', 'test2', '2010-11-19 17:50:43', 0, 1, 0, 43, '', ''),
(45, 'AAPConference061109-021.jpg', 'test2', '2010-11-19 17:50:45', 0, 1, 0, 43, '', ''),
(46, 'IMG_5357.jpg', 'test2', '2010-11-19 17:50:48', 0, 1, 0, 43, '', ''),
(47, 'IMG_5360.jpg', 'test2', '2010-11-19 17:50:50', 0, 1, 0, 43, '', ''),
(48, 'IMG_5363.jpg', 'test2', '2010-11-19 17:50:54', 0, 1, 0, 43, '', ''),
(49, 'IMG_5367.jpg', 'test2', '2010-11-19 17:50:56', 0, 1, 0, 43, '', ''),
(50, 'tilos-set-2020-029.jpg', 'Test', '2010-11-19 17:51:15', 0, 1, 0, 42, 'Tilos view', ''),
(51, 'tilos-set-2020-038.jpg', 'Test', '2010-11-19 17:51:44', 0, 1, 0, 42, '', ''),
(52, 'tilos-set-2020-039.jpg', 'Test', '2010-11-19 17:51:47', 0, 1, 0, 42, '', ''),
(53, 'LO8Y3957.jpg', 'conference_2010', '2010-11-22 09:55:21', 13, 1, 0, 7, 'Presentation from Gareth Kennedy, School of Artisan Food', ''),
(54, 'LO8Y3971.jpg', 'conference_2010', '2010-11-22 09:55:29', 14, 1, 0, 7, 'Presentation from Bob Rowley, Chesterfield & District Community Transport', ''),
(55, 'LO8Y3991.jpg', 'conference_2010', '2010-11-22 09:55:36', 15, 1, 0, 7, 'Presentation from Dave Skepper, Stagecoach East Midlands', ''),
(56, 'LO8Y4000.jpg', 'conference_2010', '2010-11-22 09:55:44', 16, 1, 0, 7, 'Presentation from Ian Benison, SLIC Training Ltd', ''),
(57, 'LO8Y4022.jpg', 'conference_2010', '2010-11-22 09:55:51', 17, 1, 0, 7, 'AAP External Evaluation presentation from Polly Swann, ERS', '');

Actual;

Code: Select all

INSERT INTO `cms_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES
(1, '', '', '2010-11-18 23:39:01', -1, 1, 0, 0, 'Gallery', 'Thank you for installing the Gallery module. If you have uploaded some images to the ''uploads/images/Gallery'' folder, you will see them below. You can edit titles, descriptions and thumbnail sizes in the admin section. Check out all the other features this module offers in the Module Help.'),
(2, 'Artisan/', '', '2010-11-19 13:54:22', 0, 1, 0, 1, 'Artisan Image Gallery', 'This is the Artisan collection. Click on any thumbnail to start the image viewer.'),
(3, 'AAP-banner-Artisan.jpg', 'Artisan////', '2010-11-19 13:57:56', 0, 1, 0, 2, 'AAP Banner at the School of Artisan Food event', ''),
(4, 'Artisan-bus-bikes-2.jpg', 'Artisan////', '2010-11-19 13:57:59', 0, 1, 0, 2, 'School of Artisan Food bus and bikes', ''),
(5, 'MTH-inside-2.jpg', 'Artisan////', '2010-11-19 13:58:02', 0, 1, 0, 2, 'Inside the Mobile Training Hub', ''),
(6, 'MTH-outside.jpg', 'Artisan////', '2010-11-19 13:58:04', 0, 1, 0, 2, 'Outside the Mobile Training Hub', ''),
(7, 'conference_2010/', '', '2010-11-19 15:03:26', 0, 1, 8, 1, '2010 Conference Image Gallery', 'This gallery contains pictures from the 2010 annual Conference. Click on a thumbnail image to start the viewer.'),
(8, 'IMG_6729.jpg', 'conference_2010////', '2010-11-19 15:04:08', 1, 1, 0, 7, 'Opening Address from Chair, Councillor Keith Girling', ''),
(9, 'IMG_6771.jpg', 'conference_2010////', '2010-11-19 15:04:11', 2, 1, 0, 7, 'Delegate discussions during breakout session', ''),
(10, 'IMG_6801.jpg', 'conference_2010////', '2010-11-19 15:04:14', 3, 1, 0, 7, 'Speaker discussions during breakout session', ''),
(11, 'IMG_6845.jpg', 'conference_2010////', '2010-11-19 15:04:18', 4, 1, 0, 7, 'SLIC Training receiving awards from Cllr. Keith Girling', ''),
(12, 'IMG_6849.jpg', 'conference_2010////', '2010-11-19 15:04:21', 5, 1, 0, 7, 'Gordon Stokes presenting awards to Dave Skepper, Stagecoach East Midlands', ''),
(13, 'IMG_6853.jpg', 'conference_2010////', '2010-11-19 15:04:24', 6, 1, 0, 7, 'Cllr Chris Jackson presenting award to Bob Rowley, Chesterfield & District Community Transport', ''),
(14, 'IMG_6856.jpg', 'conference_2010////', '2010-11-19 15:04:26', 7, 1, 0, 7, 'Jayne Ball from Portland College receiving two awards', ''),
(15, 'IMG_6862.jpg', 'conference_2010////', '2010-11-19 15:04:29', 8, 1, 0, 7, 'Brenda Smithurst receiving award on behalf of Elmton & Creswell Village Company', ''),
(16, 'IMG_6865.jpg', 'conference_2010////', '2010-11-19 15:04:32', 9, 1, 0, 7, 'The Conference team', ''),
(17, 'IMG_6874.jpg', 'conference_2010////', '2010-11-19 15:04:34', 10, 1, 0, 7, 'The runner-up medal winners', ''),
(18, 'LO8Y3940.jpg', 'conference_2010////', '2010-11-19 15:04:37', 11, 1, 0, 7, 'Keynote address from Gordon Stokes', ''),
(19, 'LO8Y4039.jpg', 'conference_2010////', '2010-11-19 15:04:40', 12, 1, 0, 7, 'AAP Retrospective from Norman James, STAR', ''),
(20, 'Projects-Launch-Event/', '', '2010-11-19 16:11:43', 0, 1, 0, 1, 'AAP Projects Launch Event Image Gallery', 'Click on a thumbnail to start the image viewer.'),
(21, 'IMG_5357.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:24', 1, 1, 0, 20, 'Cllr. Simon Spencer, Derbyshire Economic Partnership', ''),
(22, 'IMG_5360.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:27', 2, 0, 0, 20, '', ''),
(23, 'IMG_5363.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:29', 3, 1, 0, 20, 'Tim Malynn, Notts. County Council', ''),
(24, 'IMG_5367.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:32', 4, 1, 0, 20, 'Dave Skepper, Stagecoach, AAP Stagecoach Jobseeker Fares', ''),
(25, 'IMG_5370.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:35', 5, 0, 0, 20, '', ''),
(26, 'IMG_5372.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:37', 6, 1, 0, 20, 'Serving the Community with Transport to Training cheque award', ''),
(27, 'IMG_5374.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:40', 7, 1, 0, 20, 'Alliance Access Bus cheque award', ''),
(28, 'IMG_5375.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:43', 8, 1, 0, 20, 'Rural Rover cheque award', ''),
(29, 'IMG_5377.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:45', 9, 1, 0, 20, 'Steetley Access Projects cheque award', ''),
(30, 'IMG_5380.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:48', 10, 1, 0, 20, 'Portland Skills Bus cheque award', ''),
(31, 'IMG_5382.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:50', 11, 1, 0, 20, 'Junction 29a Transport to Training cheque award', ''),
(32, 'IMG_5384.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:53', 12, 1, 0, 20, 'Stagecoach Jobseeker Fares cheque award', ''),
(33, 'IMG_5393.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:55', 13, 1, 0, 20, 'Rural Rover', ''),
(34, 'IMG_5398.jpg', 'Projects-Launch-Event////', '2010-11-19 16:20:58', 14, 1, 0, 20, 'Serving the Community with Transport to Training', ''),
(35, 'IMG_5407.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:00', 15, 1, 0, 20, 'Alliance Access Bus', ''),
(36, 'IMG_5421.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:03', 16, 1, 0, 20, 'Portland Skills Bus', ''),
(37, 'IMG_5428.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:06', 17, 1, 0, 20, 'The AAP team flying the flag', ''),
(38, 'IMG_5447.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:08', 18, 1, 0, 20, 'AAP-funded vehicles at Markham Vale Environment Centre', ''),
(39, 'IMG_5450.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:11', 19, 0, 0, 20, '', ''),
(40, 'IMG_5452.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:13', 20, 1, 0, 20, 'Stagecoach Bus at Project Launch Event', ''),
(41, 'IMG_5456.jpg', 'Projects-Launch-Event////', '2010-11-19 16:21:16', 21, 1, 0, 20, 'AAP-funded minibuses', ''),
(42, 'Test/', '', '2010-11-19 17:49:23', 0, 1, 0, 1, 'Test', 'Click on a thumbnail...'),
(43, 'test2/', '', '2010-11-19 17:49:47', 0, 1, 0, 1, 'test2', 'test2'),
(44, 'AAPConference061109-019.jpg', 'test2////', '2010-11-19 17:50:43', 0, 1, 0, 43, '', ''),
(45, 'AAPConference061109-021.jpg', 'test2////', '2010-11-19 17:50:45', 0, 1, 0, 43, '', ''),
(46, 'IMG_5357.jpg', 'test2////', '2010-11-19 17:50:48', 0, 1, 0, 43, '', ''),
(47, 'IMG_5360.jpg', 'test2////', '2010-11-19 17:50:50', 0, 1, 0, 43, '', ''),
(48, 'IMG_5363.jpg', 'test2////', '2010-11-19 17:50:54', 0, 1, 0, 43, '', ''),
(49, 'IMG_5367.jpg', 'test2////', '2010-11-19 17:50:56', 0, 1, 0, 43, '', ''),
(50, 'tilos-set-2020-029.jpg', 'Test////', '2010-11-19 17:51:15', 0, 1, 0, 42, 'Tilos view', ''),
(51, 'tilos-set-2020-038.jpg', 'Test////', '2010-11-19 17:51:44', 0, 1, 0, 42, '', ''),
(52, 'tilos-set-2020-039.jpg', 'Test////', '2010-11-19 17:51:47', 0, 1, 0, 42, '', ''),
(53, 'LO8Y3957.jpg', 'conference_2010////', '2010-11-22 09:55:21', 13, 1, 0, 7, 'Presentation from Gareth Kennedy, School of Artisan Food', ''),
(54, 'LO8Y3971.jpg', 'conference_2010////', '2010-11-22 09:55:29', 14, 1, 0, 7, 'Presentation from Bob Rowley, Chesterfield & District Community Transport', ''),
(55, 'LO8Y3991.jpg', 'conference_2010////', '2010-11-22 09:55:36', 15, 1, 0, 7, 'Presentation from Dave Skepper, Stagecoach East Midlands', ''),
(56, 'LO8Y4000.jpg', 'conference_2010////', '2010-11-22 09:55:44', 16, 1, 0, 7, 'Presentation from Ian Benison, SLIC Training Ltd', ''),
(57, 'LO8Y4022.jpg', 'conference_2010////', '2010-11-22 09:55:51', 17, 1, 0, 7, 'AAP External Evaluation presentation from Polly Swann, ERS', ''),
(58, 'LO8Y3971.jpg', 'conference_2010/', '2010-11-22 09:55:29', 0, 1, 0, 7, '', ''),
(59, 'LO8Y4000.jpg', 'conference_2010/', '2010-11-22 09:55:44', 0, 1, 0, 7, '', ''),
(60, 'IMG_6771.jpg', 'conference_2010/', '2010-11-19 15:04:11', 0, 1, 0, 7, '', ''),
(61, 'IMG_6874.jpg', 'conference_2010/', '2010-11-19 15:04:34', 0, 1, 0, 7, '', ''),
(62, 'LO8Y3940.jpg', 'conference_2010/', '2010-11-19 15:04:37', 0, 1, 0, 7, '', ''),
(63, 'IMG_6845.jpg', 'conference_2010/', '2010-11-19 15:04:18', 0, 1, 0, 7, '', ''),
(64, 'LO8Y3957.jpg', 'conference_2010/', '2010-11-22 09:55:21', 0, 1, 0, 7, '', ''),
(65, 'LO8Y3991.jpg', 'conference_2010/', '2010-11-22 09:55:36', 0, 1, 0, 7, '', ''),
(66, 'IMG_6801.jpg', 'conference_2010/', '2010-11-19 15:04:14', 0, 1, 0, 7, '', ''),
(67, 'LO8Y4039.jpg', 'conference_2010/', '2010-11-19 15:04:40', 0, 1, 0, 7, '', ''),
(68, 'IMG_6853.jpg', 'conference_2010/', '2010-11-19 15:04:24', 0, 1, 0, 7, '', ''),
(69, 'IMG_6862.jpg', 'conference_2010/', '2010-11-19 15:04:29', 0, 1, 0, 7, '', ''),
(70, 'IMG_6865.jpg', 'conference_2010/', '2010-11-19 15:04:32', 0, 1, 0, 7, '', ''),
(71, 'LO8Y4022.jpg', 'conference_2010/', '2010-11-22 09:55:51', 0, 1, 0, 7, '', ''),
(72, 'IMG_6849.jpg', 'conference_2010/', '2010-11-19 15:04:21', 0, 1, 0, 7, '', ''),
(73, 'IMG_6729.jpg', 'conference_2010/', '2010-11-19 15:04:08', 0, 1, 0, 7, '', ''),
(74, 'IMG_6856.jpg', 'conference_2010/', '2010-11-19 15:04:26', 0, 1, 0, 7, '', ''),
(75, 'IMG_5380.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:48', 0, 1, 0, 20, '', ''),
(76, 'IMG_5384.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:53', 0, 1, 0, 20, '', ''),
(77, 'IMG_5421.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:03', 0, 1, 0, 20, '', ''),
(78, 'IMG_5393.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:55', 0, 1, 0, 20, '', ''),
(79, 'IMG_5357.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:24', 0, 1, 0, 20, '', ''),
(80, 'IMG_5370.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:35', 0, 1, 0, 20, '', ''),
(81, 'IMG_5360.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:27', 0, 1, 0, 20, '', ''),
(82, 'IMG_5452.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:13', 0, 1, 0, 20, '', ''),
(83, 'IMG_5363.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:29', 0, 1, 0, 20, '', ''),
(84, 'IMG_5447.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:08', 0, 1, 0, 20, '', ''),
(85, 'IMG_5407.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:00', 0, 1, 0, 20, '', ''),
(86, 'IMG_5377.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:45', 0, 1, 0, 20, '', ''),
(87, 'IMG_5450.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:11', 0, 1, 0, 20, '', ''),
(88, 'IMG_5382.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:50', 0, 1, 0, 20, '', ''),
(89, 'IMG_5375.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:43', 0, 1, 0, 20, '', ''),
(90, 'IMG_5428.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:06', 0, 1, 0, 20, '', ''),
(91, 'IMG_5372.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:37', 0, 1, 0, 20, '', ''),
(92, 'IMG_5398.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:58', 0, 1, 0, 20, '', ''),
(93, 'IMG_5367.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:32', 0, 1, 0, 20, '', ''),
(94, 'IMG_5374.jpg', 'Projects-Launch-Event/', '2010-11-19 16:20:40', 0, 1, 0, 20, '', ''),
(95, 'IMG_5456.jpg', 'Projects-Launch-Event/', '2010-11-19 16:21:16', 0, 1, 0, 20, '', ''),
(96, 'Artisan-bus-bikes-2.jpg', 'Artisan/', '2010-11-19 13:57:59', 0, 1, 0, 2, '', ''),
(97, 'AAP-banner-Artisan.jpg', 'Artisan/', '2010-11-19 13:57:56', 0, 1, 0, 2, '', ''),
(98, 'MTH-inside-2.jpg', 'Artisan/', '2010-11-19 13:58:02', 0, 1, 0, 2, '', ''),
(99, 'MTH-outside.jpg', 'Artisan/', '2010-11-19 13:58:04', 0, 1, 0, 2, '', ''),
(100, 'conference_2010/', '', '2016-04-18 13:26:27', 0, 1, 0, 0, '', ''),
(101, 'conference_2010/', '', '2016-04-18 13:26:40', 0, 1, 0, 0, '', ''),
(102, 'conference_2010/', '', '2016-04-18 13:26:41', 0, 1, 0, 0, '', ''),
(103, 'Projects-Launch-Event/', '', '2016-04-18 20:52:40', 0, 1, 0, 0, '', ''),
(104, 'Projects-Launch-Event/', '', '2016-04-19 00:01:19', 0, 1, 0, 0, '', ''),
(105, 'Projects-Launch-Event/', '', '2016-04-19 07:41:44', 0, 1, 0, 0, '', ''),
(106, 'conference_2010/', '', '2016-04-20 03:12:10', 0, 1, 0, 0, '', ''),
(107, 'Projects-Launch-Event/', '', '2016-04-20 03:12:10', 0, 1, 0, 0, '', ''),
(108, 'conference_2010/', '', '2016-04-20 09:51:36', 0, 1, 0, 0, '', ''),
(109, 'Projects-Launch-Event/', '', '2016-04-20 09:51:39', 0, 1, 0, 0, '', '');

... but after a manual clean-up it seems to be behaving fine.

[Jos]

I released Gallery version 2.1.4 which hopefully saves others the trouble you went through.

[PinkElephant]

I released Gallery version 2.1.4 which hopefully saves others the trouble you went through.

Hey, absolutely no problem -- the module's a great contribution and much appreciated.

(I suspect the missing jsposition field occurred on upgrade to 2.1.1 which didn't test for previous version 2.0.2).

Cheers,
Martin

[Jos]

I suspect the missing jsposition field occurred on upgrade to 2.1.1 which didn't test for previous version 2.0.2

I hope that was the cause. Otherwise I have to dig deeper

[pengels]

Hi Jos,

thanks for fixing the upload-bug!

regards Peter