[SOLVED] ERROR_STORAGE_FAILURE after changing permissions

modules_

Joined: 2005-01-12
Posts: 63
Posted: Sun, 2005-01-16 14:42 
 Error (ERROR_STORAGE_FAILURE)

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 720 (gallerystatus::error)
    * in modules/core/classes/GalleryStorage.class at line 220 (mysqldatabasestorage::search)
    * in modules/core/classes/Gallery.class at line 184 (gallerystorage::search)
    * in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 373 (gallery::search)
    * in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 189 (gallerychildentityhelper_simple::_fetchchilditemids)
    * in modules/core/classes/GalleryCoreApi.class at line 2076 (gallerychildentityhelper_simple::fetchchilditemids)
    * in layouts/matrix/layout.inc at line 245 (gallerycoreapi::fetchchilditemids)
    * in layouts/matrix/layout.inc at line 153 (matrixlayout::_loadalbumtemplate)
    * in modules/core/ShowItem.inc at line 124 (matrixlayout::loadtemplate)
    * in modules/core/classes/GalleryView.class at line 244 (showitemview::loadtemplate)
    * in main.php at line 312 (showitemview::doloadtemplate)
    * in main.php at line 47
    * in main.php at line 40

this happend after changing permissions.

can somebody help?

Regards, Tobias.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2005-01-16 14:57

modules_, please fill out this form, it will answer a few questions that we'd have to ask you anyway:
----

Gallery URL (optional):
Gallery version:
Webserver (with version):
Datatabase (with version):
PHP version (eg 4.2.1):
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:
 
modules_

Joined: 2005-01-12
Posts: 63
Posted: Sun, 2005-01-16 15:18

ok, thanks.

Gallery URL (optional):
Gallery version: gallery-2.0-alpha-4.zip
Webserver (with version): Apache/1.3.33
Datatabase (with version): mysql Ver 12.22 Distrib 4.0.23, for pc-linux-gnu (i386)
PHP version (eg 4.2.1): PHP 4.3.9-1
phpinfo URL (optional):
Graphics Toolkit(s): all possible
Operating system: Debian GNU/Linux
Web browser/version: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0
 
modules_

Joined: 2005-01-12
Posts: 63
Posted: Mon, 2005-01-17 12:15

can i help with some more information to solve my problem?

Would already help to know how i can port my data to a new g2 installation.

Regards, modules.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2005-01-17 16:49

modules_, first thing i'd try is:

- go to yourgallery/lib/tools/test/
- click the FlushCache and FlushTemplates, perhaps that helps
- if it helps, upgrade G2 to current cvs version
- else, maybe mindless can help
 
modules_

Joined: 2005-01-12
Posts: 63
Posted: Mon, 2005-01-17 17:07
valiant wrote:
- click the FlushCache and FlushTemplates, perhaps that helps

thx, valiant. Did not know this tools.

But it is not working. same error again.
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Mon, 2005-01-17 17:17

sorry, i tend to ignore topics with offensive titles.
try debug mode.
 
modules_

Joined: 2005-01-12
Posts: 63
Posted: Mon, 2005-01-17 17:27

ok, sorry for beeing harsh. changed the topic

here are the error parts of debug:

mysql error: [1030: Got error 134 from table handler] in EXECUTE("
	SELECT
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
	FROM
	  g2_ChildEntity, g2_Item, g2_PermissionMap, g2_ItemAttributesMap
	WHERE
	  g2_ChildEntity.g_parentId = 6
	  AND
	  g2_ChildEntity.g_id = g2_Item.g_id
	
	     AND
	     (g2_PermissionMap.g_userId = 5
	      OR
	     g2_PermissionMap.g_groupId IN (1, 3, 2))
	     AND
	    g2_PermissionMap.g_permission & 1 = 1
	     AND
	     g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
	    AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id
	GROUP BY
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
	ORDER BY g2_ItemAttributesMap.g_orderWeight LIMIT 4")

1030: Got error 134 from table handler

                     
                 adodb_mysql._execute(
	SELECT
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWe...) % line  818, file: adodb.inc.php
                           
        adodb_mysql.execute(
	SELECT
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWe...,
Array[7]) % line  452, file: adodb-mysql.inc.php
                           
     adodb_mysql.selectlimit(
	SELECT
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWe..., 4, -1,
Array[7]) % line  708, file: DatabaseStorage.class
                           
  mysqldatabasestorage.search(
	SELECT
	  [GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[7],
Array[1]) % line  220, file: GalleryStorage.class
                          
gallerystorage.search(
	SELECT
	  [GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[7],
Array[1]) % line  184, file: Gallery.class

Does this help somehow?
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Mon, 2005-01-17 19:36

this looks like a database problem and maybe not an application problem..
a quick search turns up this.
try the repair table command and see if it helps.
 
modules_

Joined: 2005-01-12
Posts: 63
Posted: Tue, 2005-01-18 12:01

thx mindless. after repairing tables its working again.