[SOLVED] WPG2 sidebar grid block results in Storage_Failure

swordfish

Joined: 2004-10-01
Posts: 388

Posted: Thu, 2008-08-21 21:57

I recently upgraded from Mysql 4.0.26 to 5.0 (converted db to utf8), G2 from svn (17897), WP 2.6.1, and WPG2 3.07. G2 embedded works fine.
After enabling the sidebar grid block the below is outputted in sidebar.
Any ideas?

Array ( [blocks] => recentAlbum|recentAlbum|recentAlbum|recentAlbum [show] => none [exactSize] => 85 ) 
Recent Album
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 959 (GalleryCoreApi::error) 
in modules/core/classes/GalleryStorage.class at line 507 (GalleryStorageExtras::execute) 
in modules/imageblock/classes/ImageBlockHelper.class at line 742 (GalleryStorage::execute) 
in modules/imageblock/classes/ImageBlockHelper.class at line 520 (ImageBlockHelper::cacheViewableTree) 
in modules/imageblock/classes/ImageBlockHelper.class at line 283 (ImageBlockHelper::fetchViewableData) 
in modules/imageblock/classes/ImageBlockHelper.class at line 93 (ImageBlockHelper::_getBlockData) 
in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2embed.inc at line 1352 (ImageBlockHelper::loadImageBlocks) 
in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2embed.inc at line 1088
in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2widgets.inc at line 51
in ??? at line 0
in /var/www/localhost/htdocs/blog/wp-includes/widgets.php at line 249
in /var/www/localhost/htdocs/blog/wp-content/themes/mandigo/sidebar.php at line 14
in /var/www/localhost/htdocs/blog/wp-content/themes/mandigo/index.php at line 157
in /var/www/localhost/htdocs/blog/wp-includes/template-loader.php at line 27
in /var/www/localhost/htdocs/blog/wp-blog-header.php at line 16
in /var/www/localhost/htdocs/blog/index.php at line 17

Gallery version = 2.3-RC1 core 1.2.36
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.6-pl6-gentoo apache2handler
Webserver = Apache 2.2.9
Database = mysql 5.0.60-log, lock.system=flock
Toolkits = LinkItemToolkit, NetPBM, ArchiveUpload, Gd, Dcraw, ImageMagick, jpegtran, Ffmpeg, Thumbnail, Exif
Acceleration = full/900, full/900
Operating system = Linux digi-archive 2.6.25-gentoo-r7 #1 SMP Sun Jul 27 22:23:26 PDT 2008 i686
Default theme = x_treme
gettext = enabled
Locale = en_US

ozgreg

Joined: 2003-10-18
Posts: 1378

Posted: Thu, 2008-08-28 00:59

I suspect the imageblock is trying to retrieve a photo which has some possible issue in the G2 DB. Can I get you to please look at the G2 FAQ Topic on this??
____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

swordfish

Joined: 2004-10-01
Posts: 388

Posted: Thu, 2008-08-28 04:35

I checked the FAQ and verified I only had one row and tried incrementing id by one but same problem still persists.
All albums and items are viewable within G2. If you have any other ideas let me know.

Thanks!

swordfish

Joined: 2004-10-01
Posts: 388

Posted: Sun, 2008-08-31 03:32

I've narrowed down the problem but not a clue on how to fix.

Here's the Mysql error:

mysql error: [1136: Column count doesn't match value count at row 1] in EXECUTE("
INSERT INTO g2_ImageBlockCacheMap SELECT DISTINCT 4, 1, g2_Entity.g_creationTimestamp,
 g2_Entity.g_id, FLOOR(RAND() * 2147483647) FROM g2_Entity, g2_DataItem,
 g2_AccessSubscriberMap, g2_ChildEntity, g2_Derivative WHERE g2_DataItem.g_id =
 g2_Entity.g_id AND g2_AccessSubscriberMap.g_itemId = g2_Entity.g_id AND
 g2_AccessSubscriberMap.g_accessListId IN (36318,36317,36316,36315,36314) AND
 g2_ChildEntity.g_parentId = g2_Entity.g_id AND g2_Derivative.g_id =
 g2_ChildEntity.g_id AND g2_Derivative.g_derivativeType = 1 ")

Viewing the g2_ImageBlockCacheMap table I see it contains no data.

I'm all ears if you have any ideas on how to fix this mess.

Thanks!

swordfish

Joined: 2004-10-01
Posts: 388

Posted: Sun, 2008-08-31 06:15

Problem solved. Just had to uninstall/re-install ImageBlock plugin.

ozgreg

Joined: 2003-10-18
Posts: 1378

Posted: Tue, 2008-09-02 02:07

Really interesting I not seen that combination of error/resolution before..

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

swordfish

Joined: 2004-10-01
Posts: 388

Posted: Tue, 2008-09-02 03:48

Well, I think it had something to do with db table getting corrupted shortly after upgrading to Mysql 5 and converting to UTF8.
Luckily for me no critical data is in that table. Anyways, happy to be back in business

ozgreg

Joined: 2003-10-18
Posts: 1378

Posted: Tue, 2008-09-02 06:34

ahhhh now that makes sense ;)

____________________________________
Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

swordfish Joined: 2004-10-01 Posts: 388	Posted: Thu, 2008-08-21 21:57
	I recently upgraded from Mysql 4.0.26 to 5.0 (converted db to utf8), G2 from svn (17897), WP 2.6.1, and WPG2 3.07. G2 embedded works fine. After enabling the sidebar grid block the below is outputted in sidebar. Any ideas? Array ( [blocks] => recentAlbum\|recentAlbum\|recentAlbum\|recentAlbum [show] => none [exactSize] => 85 ) Recent Album Error (ERROR_STORAGE_FAILURE) in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 959 (GalleryCoreApi::error) in modules/core/classes/GalleryStorage.class at line 507 (GalleryStorageExtras::execute) in modules/imageblock/classes/ImageBlockHelper.class at line 742 (GalleryStorage::execute) in modules/imageblock/classes/ImageBlockHelper.class at line 520 (ImageBlockHelper::cacheViewableTree) in modules/imageblock/classes/ImageBlockHelper.class at line 283 (ImageBlockHelper::fetchViewableData) in modules/imageblock/classes/ImageBlockHelper.class at line 93 (ImageBlockHelper::_getBlockData) in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2embed.inc at line 1352 (ImageBlockHelper::loadImageBlocks) in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2embed.inc at line 1088 in /var/www/localhost/htdocs/blog/wp-content/plugins/wpg2/wpg2widgets.inc at line 51 in ??? at line 0 in /var/www/localhost/htdocs/blog/wp-includes/widgets.php at line 249 in /var/www/localhost/htdocs/blog/wp-content/themes/mandigo/sidebar.php at line 14 in /var/www/localhost/htdocs/blog/wp-content/themes/mandigo/index.php at line 157 in /var/www/localhost/htdocs/blog/wp-includes/template-loader.php at line 27 in /var/www/localhost/htdocs/blog/wp-blog-header.php at line 16 in /var/www/localhost/htdocs/blog/index.php at line 17 Gallery version = 2.3-RC1 core 1.2.36 API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5 PHP version = 5.2.6-pl6-gentoo apache2handler Webserver = Apache 2.2.9 Database = mysql 5.0.60-log, lock.system=flock Toolkits = LinkItemToolkit, NetPBM, ArchiveUpload, Gd, Dcraw, ImageMagick, jpegtran, Ffmpeg, Thumbnail, Exif Acceleration = full/900, full/900 Operating system = Linux digi-archive 2.6.25-gentoo-r7 #1 SMP Sun Jul 27 22:23:26 PDT 2008 i686 Default theme = x_treme gettext = enabled Locale = en_US
	XUser login Username: * Password: * Create new account Request new password
ozgreg Joined: 2003-10-18 Posts: 1378	Posted: Thu, 2008-08-28 00:59
	I suspect the imageblock is trying to retrieve a photo which has some possible issue in the G2 DB. Can I get you to please look at the G2 FAQ Topic on this?? ____________________________________ Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

swordfish Joined: 2004-10-01 Posts: 388	Posted: Thu, 2008-08-28 04:35
	I checked the FAQ and verified I only had one row and tried incrementing id by one but same problem still persists. All albums and items are viewable within G2. If you have any other ideas let me know. Thanks!

swordfish Joined: 2004-10-01 Posts: 388	Posted: Sun, 2008-08-31 03:32
	I've narrowed down the problem but not a clue on how to fix. Here's the Mysql error: mysql error: [1136: Column count doesn't match value count at row 1] in EXECUTE(" INSERT INTO g2_ImageBlockCacheMap SELECT DISTINCT 4, 1, g2_Entity.g_creationTimestamp, g2_Entity.g_id, FLOOR(RAND() * 2147483647) FROM g2_Entity, g2_DataItem, g2_AccessSubscriberMap, g2_ChildEntity, g2_Derivative WHERE g2_DataItem.g_id = g2_Entity.g_id AND g2_AccessSubscriberMap.g_itemId = g2_Entity.g_id AND g2_AccessSubscriberMap.g_accessListId IN (36318,36317,36316,36315,36314) AND g2_ChildEntity.g_parentId = g2_Entity.g_id AND g2_Derivative.g_id = g2_ChildEntity.g_id AND g2_Derivative.g_derivativeType = 1 ") Viewing the g2_ImageBlockCacheMap table I see it contains no data. I'm all ears if you have any ideas on how to fix this mess. Thanks!

swordfish Joined: 2004-10-01 Posts: 388	Posted: Sun, 2008-08-31 06:15
	Problem solved. Just had to uninstall/re-install ImageBlock plugin.

ozgreg Joined: 2003-10-18 Posts: 1378	Posted: Tue, 2008-09-02 02:07
	Really interesting I not seen that combination of error/resolution before.. ____________________________________ Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

swordfish Joined: 2004-10-01 Posts: 388	Posted: Tue, 2008-09-02 03:48
	Well, I think it had something to do with db table getting corrupted shortly after upgrading to Mysql 5 and converting to UTF8. Luckily for me no critical data is in that table. Anyways, happy to be back in business

ozgreg Joined: 2003-10-18 Posts: 1378	Posted: Tue, 2008-09-02 06:34
	ahhhh now that makes sense ;) ____________________________________ Wordpress / Gallery2 (WPG2) Plugin, , WPG2 Documentation, WPG2 Demo

[SOLVED] WPG2 sidebar grid block results in Storage_Failure

XUser login