Database STorage Issue??

SonarStudios

Joined: 2004-05-28
Posts: 9
Posted: Thu, 2004-12-23 16:56

I received this error yesterday...

Error (ERROR_STORAGE_FAILURE):

* in file modules/core/classes/GalleryStorage/DatabaseStorage.class at line 720 (gallerystatus::error)
* in file modules/core/classes/GalleryStorage.class at line 220 (mysqldatabasestorage::search)
* in file modules/core/classes/Gallery.class at line 176 (gallerystorage::search)
* in file modules/core/classes/helpers/GalleryItemHelper_simple.class at line 302 (gallery::search)
* in file modules/core/classes/helpers/GalleryItemHelper_simple.class at line 207 (galleryitemhelper_simple::fetchuncacheddescendentcounts)
* in file modules/core/classes/GalleryCoreApi.class at line 1169 (galleryitemhelper_simple::fetchdescendentcounts)
* in file layouts/matrix/layout.inc at line 277 (gallerycoreapi::fetchdescendentcounts)
* in file layouts/matrix/layout.inc at line 153 (matrixlayout::_loadalbumtemplate)
* in file modules/core/ShowItem.inc at line 121 (matrixlayout::loadtemplate)
* in file modules/core/classes/GalleryView.class at line 245 (showitemview::loadtemplate)
* in file main.php at line 281 (showitemview::doloadtemplate)
* in file main.php at line 47
* in file main.php at line 40

I was adding a few images to an album, the system froze - had to reboot the machine - and now I fear the database is jacked up.

Can anyone decipher this for me? I'd really appreciate it.

Thanks

Matt
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2004-12-23 17:02

you need to turn on buffered debug output in config.php to get the details on what the database error is. look near the bottom of the output to find the error.
 
SonarStudios

Joined: 2004-05-28
Posts: 9
Posted: Fri, 2004-12-24 15:46

I'm hoping this is the code to which you were referring (I still don't understand what the actual issue is??):

1030: Got error 127 from table handler

adodb_mysql._execute(
SELECT
iam0.g_itemId,
COUNT(DISTINC...) % line
810, file: adodb.inc.php

adodb_mysql.execute(
SELECT
iam0.g_itemId,
COUNT(DISTINC..., Array[5]) %
line 712, file: DatabaseStorage.class

mysqldatabasestorage.search(
SELECT
[GalleryItemAttributesMap=1::itemId],
..., Array[5], Array[0]) % line 220,
file: GalleryStorage.class

gallerystorage.search(
SELECT
[GalleryItemAttributesMap=1::itemId],
..., Array[5], Array[0]) % line 176,
file: Gallery.class
gallery.search(
SELECT
[GalleryItemAttributesMap=1::itemId],
..., Array[5]) % line 302, file: GalleryItemHelper_simple.class
 
baldur

Joined: 2004-12-04
Posts: 8
Posted: Fri, 2004-12-24 16:27

The Error 127 means that your record file is crashed, try to REPAIR your table and if this doesn't work, you better have a backup.