[SOLVED] Odd Errors

accleas

Joined: 2005-04-20
Posts: 25
Posted: Wed, 2005-05-18 14:12

I got the following errors while I was editiing the captions of my photos.
Since then I was unable to get back to the albums and login any more.

I was able to browse the Gallery2 database via phpsqladmin.

Any help or hints will be appreciated.

Thanks 

Database Error 
An error has occurred while interacting with the database. 

Back to the Gallery 

Error Detail -
Error (ERROR_STORAGE_FAILURE) : 
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1164 (gallerystatus::error) 
in modules/core/classes/GalleryStorage.class at line 220 (mysqldatabasestorage::search) 
in modules/core/classes/Gallery.class at line 216 (gallerystorage::search) 
in modules/imageblock/classes/ImageBlockHelper.class at line 406 (gallery::search) 
in modules/imageblock/classes/ImageBlockHelper.class at line 325 (imageblockhelper::_iscached) 
in modules/imageblock/classes/ImageBlockHelper.class at line 193 (imageblockhelper::fetchviewabledata) 
in modules/imageblock/classes/ImageBlockHelper.class at line 86 (imageblockhelper::_addblock) 
in modules/imageblock/module.inc at line 123 (imageblockhelper::loadimageblocks) 
in modules/core/classes/GalleryLayout.class at line 706 (imageblockmodule::loadsystemcontent) 
in layouts/matrix/layout.inc at line 262 (matrixlayout::loadlayouttemplate) 
in layouts/matrix/layout.inc at line 155 (matrixlayout::_loadalbumtemplate) 
in modules/core/ShowItem.inc at line 156 (matrixlayout::loadtemplate) 
in modules/core/classes/GalleryView.class at line 214 (showitemview::loadtemplate) 
in main.php at line 293 (showitemview::doloadtemplate) 
in main.php at line 79
in main.php at line 70
 
accleas

Joined: 2005-04-20
Posts: 25
Posted: Wed, 2005-05-18 14:27

When I try to backup the gallery2 database, I get the following error.
Any help will be appreciated.

mysqldump: Can't get CREATE TABLE for table `g2_ImageBlockCacheMap` (Can't open file: 'g2_ImageBlockCacheMap.MYD'. (errno: 145))
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-05-18 15:33

seems like your database has somehow corrupted a storage file of the database management software (mysql), (g2_ImageBlockCacheMap.MYD).

what you could try...
deactivate AND uninstall the imageblock module (and then install and activate it again).

if you can't browse to the site admin page because of the error, perhaps you can browse to it directly with yourgaller2url/main.php?g2_view=core:SiteAdmin&g2_subView=core:AdminModules

perhaps you can also try to repair the table in phpmyadmin or so...
 
accleas

Joined: 2005-04-20
Posts: 25
Posted: Wed, 2005-05-18 15:54

Thanks Valiant.
You're my man.
Your ways work and it's fixed.
:)