Maintenance help

sharps

Joined: 2010-08-12
Posts: 2

Posted: Thu, 2010-08-12 09:08

I am a relative newbie to gallery although have dabbled off and on but now starting to really get into it as my albums grow.

I have had this problem for a while but have ignored it but now would really like to fix it.
Every time I click on maintenance in the admin area I get the following error message.

Error Detail -
Error (ERROR_MISSING_VALUE) : Undefined map: GalleryMaintenanceMap
in modules/core/classes/GalleryStorage.class at line 1257 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 1249 (GalleryStorage::describeMap)
in modules/core/classes/GalleryStorage.class at line 572 (GalleryStorage::describeMap)
in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry)
in modules/core/classes/helpers/MaintenanceHelper_simple.class at line 71 (GalleryCoreApi::getMapEntry)
in modules/core/AdminMaintenance.inc at line 183 (MaintenanceHelper_simple::fetchLastRun)
in modules/core/SiteAdmin.inc at line 209 (AdminMaintenanceView::loadTemplate)
in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate)
in main.php at line 465 (GalleryView::doLoadTemplate)
in main.php at line 104
in main.php at line 88

Any help would be gratefully excepted.

suprsidr

Joined: 2005-04-17
Posts: 8339

Posted: Thu, 2010-08-12 12:13

using phpMyAdmin or similar, execute the following SQL into your G2 database:

INSERT INTO `g2_Schema` VALUES ('MaintenanceMap', 1, 0, 'CREATE TABLE DB_TABLE_PREFIXMaintenanceMap(\n DB_COLUMN_PREFIXrunId int(11) NOT NULL,\n DB_COLUMN_PREFIXtaskId varchar(128) NOT NULL,\n DB_COLUMN_PREFIXtimestamp int(11),\n DB_COLUMN_PREFIXsuccess int(1),\n DB_COLUMN_PREFIXdetails text,\n PRIMARY KEY(DB_COLUMN_PREFIXrunId),\n INDEX DB_TABLE_PREFIXMaintenanceMap_21687(DB_COLUMN_PREFIXtaskId)\n) DB_TABLE_TYPE\n/*!40100 DEFAULT CHARACTER SET utf8 */;\n\nINSERT INTO DB_TABLE_PREFIXSchema (\n DB_COLUMN_PREFIXname,\n DB_COLUMN_PREFIXmajor,\n DB_COLUMN_PREFIXminor\n) VALUES(''MaintenanceMap'', 1, 0);\n\n', 'core', 'map', 'a:1:{s:21:"GalleryMaintenanceMap";a:5:{s:5:"runId";a:3:{s:4:"type";i:1;s:4:"size";i:2;s:7:"notNull";b:1;}s:6:"taskId";a:3:{s:4:"type";i:2;s:4:"size";i:2;s:7:"notNull";b:1;}s:9:"timestamp";a:2:{s:4:"type";i:1;s:4:"size";i:2;}s:7:"success";a:2:{s:4:"type";i:8;s:4:"size";i:2;}s:7:"details";a:2:{s:4:"type";i:4;s:4:"size";i:1;}}}');

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

sharps

Joined: 2010-08-12
Posts: 2

Posted: Thu, 2010-08-12 23:40

Thank you so much for your quick reply that has totally fixed my problem. I had to get some help on accessing the database and querying as I was not sure what I was doing.
Once inside phpMyAdmin it was all pretty straight forward, took a deep breath pushed go and VOILA all fixed.
Thanks so much again

sharps Joined: 2010-08-12 Posts: 2	Posted: Thu, 2010-08-12 09:08
	I am a relative newbie to gallery although have dabbled off and on but now starting to really get into it as my albums grow. I have had this problem for a while but have ignored it but now would really like to fix it. Every time I click on maintenance in the admin area I get the following error message. Error Detail - Error (ERROR_MISSING_VALUE) : Undefined map: GalleryMaintenanceMap in modules/core/classes/GalleryStorage.class at line 1257 (GalleryCoreApi::error) in modules/core/classes/GalleryStorage.class at line 1249 (GalleryStorage::describeMap) in modules/core/classes/GalleryStorage.class at line 572 (GalleryStorage::describeMap) in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry) in modules/core/classes/helpers/MaintenanceHelper_simple.class at line 71 (GalleryCoreApi::getMapEntry) in modules/core/AdminMaintenance.inc at line 183 (MaintenanceHelper_simple::fetchLastRun) in modules/core/SiteAdmin.inc at line 209 (AdminMaintenanceView::loadTemplate) in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate) in main.php at line 465 (GalleryView::doLoadTemplate) in main.php at line 104 in main.php at line 88 Any help would be gratefully excepted.
	XUser login Username: * Password: * Create new account Request new password
suprsidr Joined: 2005-04-17 Posts: 8339	Posted: Thu, 2010-08-12 12:13
	using phpMyAdmin or similar, execute the following SQL into your G2 database: INSERT INTO `g2_Schema` VALUES ('MaintenanceMap', 1, 0, 'CREATE TABLE DB_TABLE_PREFIXMaintenanceMap(\n DB_COLUMN_PREFIXrunId int(11) NOT NULL,\n DB_COLUMN_PREFIXtaskId varchar(128) NOT NULL,\n DB_COLUMN_PREFIXtimestamp int(11),\n DB_COLUMN_PREFIXsuccess int(1),\n DB_COLUMN_PREFIXdetails text,\n PRIMARY KEY(DB_COLUMN_PREFIXrunId),\n INDEX DB_TABLE_PREFIXMaintenanceMap_21687(DB_COLUMN_PREFIXtaskId)\n) DB_TABLE_TYPE\n/!40100 DEFAULT CHARACTER SET utf8 /;\n\nINSERT INTO DB_TABLE_PREFIXSchema (\n DB_COLUMN_PREFIXname,\n DB_COLUMN_PREFIXmajor,\n DB_COLUMN_PREFIXminor\n) VALUES(''MaintenanceMap'', 1, 0);\n\n', 'core', 'map', 'a:1:{s:21:"GalleryMaintenanceMap";a:5:{s:5:"runId";a:3:{s:4:"type";i:1;s:4:"size";i:2;s:7:"notNull";b:1;}s:6:"taskId";a:3:{s:4:"type";i:2;s:4:"size";i:2;s:7:"notNull";b:1;}s:9:"timestamp";a:2:{s:4:"type";i:1;s:4:"size";i:2;}s:7:"success";a:2:{s:4:"type";i:8;s:4:"size";i:2;}s:7:"details";a:2:{s:4:"type";i:4;s:4:"size";i:1;}}}'); -s FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

sharps Joined: 2010-08-12 Posts: 2	Posted: Thu, 2010-08-12 23:40
	Thank you so much for your quick reply that has totally fixed my problem. I had to get some help on accessing the database and querying as I was not sure what I was doing. Once inside phpMyAdmin it was all pretty straight forward, took a deep breath pushed go and VOILA all fixed. Thanks so much again

Maintenance help

XUser login