ERROR: An error has occurred while interacting with the database.

nutsnbolts

Joined: 2004-12-15
Posts: 71
Posted: Tue, 2006-07-25 05:30

This is now getting annoying. Second re-installation of Gallery 2.1.1 due to ERRORS in uploading. First error upload occured when using GALLERY REMOTE. I re-installed and started using PICASA2 to use instead. Worked wonderful a couple times and then it just crashed. Now I'm getting this error when I'm trying to access my gallery.

Quote:
Debug Output
file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../config.php) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../plugins/index.modules) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter language.useBrowserPref for core plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/module/core/0/0/0.inc) getParameter default.language for core plugin controller , view Loading plugin core Class not defined, trying to include it. file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/core/module.inc) core plugin successfully instantiated file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/versions.dat) file(/var/www/com/eternalgathering/gallery2/mygallery/g2data/versions.dat, ) getParameter id.anonymousUser for core plugin [1153803672] can't guarantee 5 -- extending! file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/entity/0/0/5.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/core/ShowItem.inc) getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin getParameter id.anonymousUser for core plugin getParameter id.adminGroup for core plugin
--------------------------------------------------------------------------------
(mysql): SET NAMES "utf8"
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 5 AND g2_UserGroupMap.g_groupId = 3 LIMIT 1
--------------------------------------------------------------------------------
getParameter id.rootAlbum for core plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/entity/0/0/7.inc) getParameter default.theme for core plugin Loading plugin eternalgathering Class not defined, trying to include it. file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../config.php) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../plugins/index.themes) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../themes/eternalgathering/theme.inc) eternalgathering plugin successfully instantiated Check the version of the eternalgathering plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the eternalgathering plugin is ok file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/theme/eternalgathering/0/0/0.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/theme/eternalgathering/0/0/7.inc)
--------------------------------------------------------------------------------
(mysql): SELECT g2_Group.g_id, g2_Group.g_groupName FROM g2_UserGroupMap, g2_Group WHERE g2_Group.g_id = g2_UserGroupMap.g_groupId AND g2_UserGroupMap.g_userId = 5 ORDER BY g2_Group.g_groupName LIMIT 18446744073709551615
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT g2_PermissionSetMap.g_module, g2_PermissionSetMap.g_permission, g2_PermissionSetMap.g_description, g2_PermissionSetMap.g_bits, g2_PermissionSetMap.g_flags FROM g2_PermissionSetMap
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT DISTINCT g2_AccessMap.g_accessListId FROM g2_AccessMap WHERE g2_AccessMap.g_userOrGroupId IN (5,4) AND g2_AccessMap.g_permission & 1 = 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT g2_AccessSubscriberMap.g_itemId FROM g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId = 7 AND g2_AccessSubscriberMap.g_accessListId IN (8,9,10,11,12,13,14,20,112,147,178,209,210,211,212,213,215) LIMIT 1
--------------------------------------------------------------------------------
file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/../../../themes/local/eternalgathering) getParameter misc.markup for core plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/search/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/imageblock/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/module/imageblock/0/0/0.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/imageframe/classes/ImageFrameImpl.class) Loading plugin imageframe Class not defined, trying to include it. file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/imageframe/module.inc) imageframe plugin successfully instantiated Check the version of the imageframe plugin The version of the imageframe plugin is ok file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/../../../modules/imageframe/local/frames) is_dir(/var/www/com/eternalgathering/gallery2/mygallery/modules/imageframe/classes/../frames/) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/imageframe/classes/../frames//frame.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/comment/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/exif/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/comment/Preloads.inc) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/icons/classes/IconsImpl.class) getParameter iconpack for icons plugin file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/cache/module/icons/0/0/0.inc) getParameter default.orderBy for core plugin getParameter default.orderDirection for core plugin Array ( [limit] => Array ( [count] => 9 [offset] => 0 ) ) mysql error: [126: Incorrect key file for table './eternalgathering/g2_AccessSubscriberMap.MYI'; try to repair it] in EXECUTE(" SELECT g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight FROM g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g2_ItemAttributesMap WHERE g2_ChildEntity.g_parentId = 7 AND g2_ChildEntity.g_id = g2_Item.g_id AND g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id AND g2_AccessSubscriberMap.g_accessListId IN (8,9,10,11,12,13,14,20,112,147,178,209,210,211,212,213,215) AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id LIMIT 9")
--------------------------------------------------------------------------------
(mysql): SELECT g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight FROM g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g2_ItemAttributesMap WHERE g2_ChildEntity.g_parentId = 7 AND g2_ChildEntity.g_id = g2_Item.g_id AND g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id AND g2_AccessSubscriberMap.g_accessListId IN (8,9,10,11,12,13,14,20,112,147,178,209,210,211,212,213,215) AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id LIMIT 9
--------------------------------------------------------------------------------
126: Incorrect key file for table './eternalgathering/g2_AccessSubscriberMap.MYI'; try to repair it

ADOConnection._Execute(
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
FROM
g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g...) % line 836, file: adodb.inc.php

ADOConnection.Execute(
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
FROM
g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g...,
Array[18]) % line 479, file: adodb-mysql.inc.php
ADODB_mysql.SelectLimit(
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
FROM
g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g..., 9, -1,
Array[18]) % line 465, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap::orderWeight]
FROM
[GalleryChildEntity], [GalleryItem], [Ga..., Array[18],
Array[1]) % line 223, file: Gallery.class
Gallery.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap::orderWeight]
FROM
[GalleryChildEntity], [GalleryItem], [Ga..., Array[18],
Array[1]) % line 334, file: GalleryChildEntityHelper_simple.class
getParameter default.theme for core plugin Loading plugin eternalgathering eternalgathering plugin successfully instantiated Check the version of the eternalgathering plugin The version of the eternalgathering plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/helpers/../../../../modules/core/ErrorPage.inc) getParameter id.adminGroup for core plugin realpath(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/../../../) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/smarty/templates_c/%%881022792) is_dir(/var/www/com/eternalgathering/gallery2/mygallery/g2data/smarty/templates_c/%%881022792) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/smarty/templates_c/%%881022792) is_writeable(/var/www/com/eternalgathering/gallery2/mygallery/g2data/smarty/templates_c/%%881022792) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/g2data/smarty/templates_c/%%881022792/v_9) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/../../themes/eternalgathering/local/theme.css) file_exists(/var/www/com/eternalgathering/gallery2/mygallery/modules/core/classes/../../../themes/eternalgathering/local/theme.css)

Any help please! This is now getting on my nerves! What is going on? I seem to keep having issues on uploads and things breaking.

Thanks in advance!

----
Gallery version 2.1.1
PHP version 5.1.2 apache2handler
Webserver Apache/2.2.2 (FreeBSD) mod_ssl/2.2.2 OpenSSL/0.9.7e-p1 DAV/2 PHP/5.1.2
Database mysql 5.0.22
Toolkits SquareThumb, ImageMagick, NetPBM, Gd
Operating system FreeBSD

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2006-07-26 09:07

> mysql error: [126: Incorrect key file for table './eternalgathering/g2_AccessSubscriberMap.MYI'; try to repair it]

Your MySQL database is broken. There's nothing G2 can do about it. Your server / MySQL is just very unreliable.
Please try the SQL command "REPAIR TABLE g2_AccessSubscriberMap;", maybe it helps.

 
nutsnbolts

Joined: 2004-12-15
Posts: 71
Posted: Wed, 2006-07-26 14:14

Valiant:

Thank you for the response. At least I got one. I made a backup of my g2data/album folder and re-ran the installation wizard again. Works again after tweaking the settings. I guess I just have to keep a backup regularly and reinstall when this specific problem occurs. On the other hand, you stated, /MySQL is very unreliable. What do you mean by that? Could you elaborate this way I can tell the sysadmin what is going on and hopefully he can correct it? I mean this happened twice now in two different occassions.

If it happens the third time, I'm going to try your SQL command.

----
Gallery version 2.1.1
PHP version 5.1.2 apache2handler
Webserver Apache/2.2.2 (FreeBSD) mod_ssl/2.2.2 OpenSSL/0.9.7e-p1 DAV/2 PHP/5.1.2
Database mysql 5.0.22
Toolkits SquareThumb, ImageMagick, NetPBM, Gd
Operating system FreeBSD

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2006-07-26 21:14

> mysql error: [126: Incorrect key file for table './eternalgathering/g2_AccessSubscriberMap.MYI'; try to repair it

"Unreliable" may be the wrong word. Let's say the server / MySQL installation are broken / buggy.
It could be a memory defect, a hard disk issue, a bug in the MySQL version for FreeBSD, ...

The simple fact that you're getting corrupted mysql database files again and again shows that the MySQL installation or the server in general has a serious problem.

 
jadmanx
jadmanx's picture

Joined: 2005-09-06
Posts: 83
Posted: Mon, 2006-09-25 05:00

is there ony one way to fix this ?
restor the backup ???

http://www.blubbs.com is my page

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-09-25 13:42

jadmanx

i don't know your issue since this forum thread is about another user's problem.