Chaos

Gallery 2.1 upgrade to 2.3svn failings

Posted by: Samiuela LV Taufa on January 11, 2008 2:56:59 PM

The regular problems taking for ever and a day to resolve happened again when I tried upgrading (due to security warnings) to a more current version of Gallery2.

Unfortunately, the upgrade coincided with Tonfon deciding to give me a hard time with Internet connections.

Clear problems from the upgrade.

FailedLoginsMap

Login fails due to a missing table row, unfortunately the error message isn't too intuitive unless you've been bashing Gallery2 code. The error is apparently caused by a failure in the following query:

select g_info from nomoa_gallery.g2_Schema where g_name='FailedLoginsMap';

If you install Gallery2 and have a login failure with an error message referencing FailedLoginsMap, then try the above query on your database. If you get an empty result, then you probably need the solution I found (from someone else's backup which was indexed through google.

INSERT INTO `g2_Schema` (`g_name`, `g_major`, `g_minor`, `g_createSql`, `g_pluginId`, `g_type`, `g_info`) VALUES
('FailedLoginsMap', 1, 0, 'CREATE TABLE DB_TABLE_PREFIXFailedLoginsMap(n DB_COLUMN_PREFIXuserName varchar(32) NOT NULL,n DB_COLUMN_PREFIXcount int(11) NOT NULL,n DB_COLUMN_PREFIXlastAttempt int(11) NOT NULL,n PRIMARY KEY(DB_COLUMN_PREFIXuserName)n) DB_TABLE_TYPEn/*!40100 DEFAULT CHARACTER SET utf8 */;nnINSERT INTO DB_TABLE_PREFIXSchema (n DB_COLUMN_PREFIXname,n DB_COLUMN_PREFIXmajor,n DB_COLUMN_PREFIXminorn) VALUES(''FailedLoginsMap'', 1, 0);nn', 'core', 'map', 'a:1:{s:15:"FailedLoginsMap";a:3:{s:8:"userName";a:3:{s:4:"type";i:2;s:4:"size";i:1;s:7:"notNull";b:1;}s:5:"count";a:3:{s:4:"type";i:1;s:4:"size";i:2;s:7:"notNull";b:1;}s:11:"lastAttempt";a:3:{s:4:"type";i:1;s:4:"size";i:2;s:7:"notNull";b:1;}}}');

Image Block.

Got upgraded during the install as well, so you have to specifically 'upgrade' the plugin as administrator.

Image Thumbnails

For some reason, new thumbnails weren't getting created correctly. And I obviously just had to rebuild all the thumbnails to verify (i.e. now the whole gallery had no thumbnails.)

I checked my Graphics Toolkits and they all had the correct references (i.e. toolkits point to the right files on disk) and all tests from the forms worked out ok.

I think I resolved this by just reallocating things around, but that shouldn't(?) have been a solution?

It seems that if you enable the logging facilities, for tracing problems with the installation, then you better make sure you eventually turn it off.

Four days after the installation seemed to be working fine, the website wasn't responding anymore. After a lot of soul searching whether I should just give up on computers, I deleted the old log files to see if I can find something in the new logs that might indicate the problem.

POooof, problem disappears as soon as the old log file is killed. Quickly, turning off the logging for Gallery2.