Solved-STORAGE_FAILURES (Using WPG2 - having Managing Use...

Andrew_Low

Joined: 2005-08-30
Posts: 13
Posted: Tue, 2005-08-30 03:35

I did search the forum before hand, but may have missed the posting. I originally posted this on the WPG2 forum but they pointed me here.

I realize this is NOT a gallery2 problem specifically, since it seems to be something wrong with the WPG2 plugin trying to access Gallery -- but pointers to where to look or how to debug why embedding Gallery2 into Wordpress isn't working for the user part would be great.

Installed: Wordpress 1.5.2 / Gallery2 RC2 (Typical + ImageBlock & ImageFrame)

Gallery2 was installed, and appears to be working ok. I was having trouble getting the archive import to work, but that is likely unrelated. I can upload and view pictures no problem.

Using Wordpress 5min install, SQL database - seems to work ok. I can even embed an image/album in my wordpress blog.

What doesn't work:
----------------------

In Wordpress - Site Admin -> Users -> Gallery2 Users

Fatal G2 error:Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1166 (gallerystatus::error)
in modules/core/classes/GalleryStorage.class at line 245 (mysqldatabasestorage::search)
in modules/core/classes/Gallery.class at line 223 (gallerystorage::search)
in modules/core/classes/GalleryEmbed.class at line 808 (gallery::search)
in /var/www/htdocs/protected/wp-content/plugins/wp-gallery2/g2users.php at line 81 (galleryembed::getexternalidmap)
in /var/www/htdocs/protected/wp-admin/admin.php at line 63
in /var/www/htdocs/protected/wp-admin/profile.php at line 2

similarly Gallery2 User Groups and Gallery2 Groups fail in the same way.

Looking on the filesystem - I seem to be getting an error out of mysql:

050828 20:59:54 /usr/local/libexec/mysqld: Can't open file: 'g2_ExternalIdMap.MYI'. (errno: 9

but I'm stumped. The file does exist in my gallery2 mysql database. Clearly this is the reason for the error (mysql not being able to see this particular bit of the database it needs to see) but I'm not certain how to get more debug out of this, or what's actually wrong.

Any hints?

Thanks,
Roo
----

Gallery URL (optional):
Gallery version: Gallery2 RC2
Webserver (with version): Apache 1.3.29 (OpenBSD 3.7)
Datatabase (with version): mysql 4.0.23
PHP version (eg 4.2.1): php4 4.3.10p1
phpinfo URL (optional):
Graphics Toolkit(s): netpbm-9.24p1
Operating system: OpenBSD 3.7
Web browser/version: IE6.x
G1 version (for migration bugs):
Login or register to post comments
ozgreg
ozgreg's picture

Joined: 2003-10-18
Posts: 1378
Posted: Tue, 2005-08-30 05:36

The title is a little misleading.. As you can see he is getting STORAGE_FAILURES
Login or register to post comments
valiant

Joined: 2003-01-04
Posts: 32324
Posted: Tue, 2005-08-30 11:51

i'm quite sure your mysql database table file(s) are corrupted = need to be repaired.
try
repair table g2_ExternalIdMap;
in mysql or click on the corresponding icon in phpmyadmin.

i guess this is another case of:

http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=29876&highlight=truncate

but...the bug was filed for windows and not for openbsd. so, not sure about this.
Login or register to post comments
Andrew_Low

Joined: 2005-08-30
Posts: 13
Posted: Tue, 2005-08-30 16:01

Sorry for original mis-leading subject - I've edited the original post to be better hopefully.

So being a command line type, I was using mysql that way.

#mysql -u <gallery user> -p <gallery database>

I got an interesting list of messages out once I logged into mysql:

Didn't find any fields in table 'g2_ExternalIdMap'
Didn't find any fields in table 'g2_Lock'
Didn't find any fields in table 'g2_MovieItem'
Didn't find any fields in table 'g2_RecoverPasswordMap'
Didn't find any fields in table 'g2_UnknownItem'

So not really knowing what else to do, I issued the repair table.

> repair table g2_ExternalIdMap;

which resulted in:
+---------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+--------+----------+---------------------------------------------------------------+
| gallery2.g2_ExternalIdMap | repair | error | Can't find file: './gallery2/g2_ExternalIdMap.frm' (errno: 9) |
+---------------------------+--------+----------+---------------------------------------------------------------+

which is very odd.. since the file seems to exist

# ls -l gallery2/g2_Ext*
-rw-rw---- 1 _mysql _mysql 0 Aug 16 07:02 gallery2/g2_ExternalIdMap.MYD
-rw-rw---- 1 _mysql _mysql 1024 Aug 16 07:02 gallery2/g2_ExternalIdMap.MYI
-rw-rw---- 1 _mysql _mysql 8646 Aug 16 07:02 gallery2/g2_ExternalIdMap.frm

Thanks for the help so far, but I'm still stumped as you can see.

Roo
Login or register to post comments
Andrew_Low

Joined: 2005-08-30
Posts: 13
Posted: Tue, 2005-08-30 16:07

One random thought. I am running Typical - which doesn't include a lot of plug-ins. Is it possible that my install of Typical (originally RC1) didn't include the right bits to intialize those tables?

Roo
Login or register to post comments
Andrew_Low

Joined: 2005-08-30
Posts: 13
Posted: Tue, 2005-08-30 16:49

Ugh.. red faced, I admit this seems to be solved. :oops:

Something was amiss with sql - since a reboot of my machine has now fixed the problems.
Login or register to post comments