finding the g2_SequenceId table after ERROR_STORAGE_FAILURE

boxster5
boxster5's picture

Joined: 2007-03-14
Posts: 11
Posted: Sat, 2008-10-25 09:32

I've read the FAQ, but don't know how to 'find the g2_SequenceId table' - I am so clueless! I was trying to import the g1 users when I encountered errors. [specifically, this error: Error (ERROR_STORAGE_FAILURE)] No idea what to do next. G1 has quit working completely and I really, REALLY need to get this migration done so everyone can stop screaming for my blood. But I'm a technical moron and need LOTS of patient help. Pleeeeease. (Gosh, could I possibly be more pathetic?)

Y

System Information
Gallery version 2.2.5
PHP version 4.4.7 cgi
Webserver Apache
Database mysqlt 5.0.45-log
Toolkits ImageMagick, Thumbnail, NetPBM
Operating system Linux boscgi1504.eigbox.net 2.6.24.7 #1 SMP Wed May 7
12:55:23 EDT 2008 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3)
Gecko/2008092417 Firefox/3.0.3

-----


G2 URL (optional): theboxartden.com/Gallery
G2 version: 2.2.5
G1 URL (optional): theboxartden.com/g1
G1 version: 1.5-RC2
G1 character set: ?????
PHP memory limit: ?????
--
PHP version (e.g. 5.1.6): 4.4.7
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):
Database (e.g. MySql 5.0.32): mysqlt 5.0.45-log
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Firefox 3.0.3

"I am not expendable, I'm not stupid and I'm not going." -- Kerr Avon
 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Sat, 2008-10-25 18:23

...which FAQ asks you to look for the g2_SequenceId table?
 
boxster5
boxster5's picture

Joined: 2007-03-14
Posts: 11
Posted: Sun, 2008-10-26 12:02

The Gallery2 FAQ which has this topic:

# 4.40 I get ERROR_STORAGE_FAILURE when adding new photos or creating albums, what should I do?

and the answer starts with:

In a mysql database this could be a problem with the g2_SequenceId table. To fix this in phpMyAdmin, find the g2_SequenceId table and click "Browse" to see the rows.

I have no idea what/where a g2_SequenceId table is or, for that matter, how to access a phpMyAdmin ... I meant it when I said I'm clueless.
 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Sun, 2008-10-26 12:30

It's difficult to know what to suggest then!

ERROR_STORAGE_FAILURE is a very general message; when it shows up on your screen you should have a more detailed error stack underneath which gives the line numbers being executed that would be useful information to post.

To be honest it's quite unlikely (not impossible) that it's a problem with the g2_SequenceId. For reference, phpMyAdmin is a utility for accessing your database directly - it's usually provided as part of a web-based control panel by your hosting provider. But if you're that uncertain about stuff you have a fair amount of learning to do before you'd know what to do with it. And poking around in the Gallery db with phpMyAdmin can totally wreck an installation unless you know what you're up to.
 
boxster5
boxster5's picture

Joined: 2007-03-14
Posts: 11
Posted: Sun, 2008-10-26 12:53

Heh, I hear ya, re phpMyAdmin - would be my luck to destroy something ...

Well, here is the first error I got in it's entirety:

---------------------------------------------------
Error Detail -
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage.class at line 480
(gallerycoreapi::error)
* in modules/core/classes/Gallery.class at line 202
(mysqlstorage::search)
* in modules/core/classes/helpers/GalleryUserHelper_medium.class at
line 137 (gallery::search)
* in modules/core/classes/GalleryCoreApi.class at line 533
(galleryuserhelper_medium::fetchuserbyusername)
* in modules/migrate/ChooseObjects.inc at line 179
(gallerycoreapi::fetchuserbyusername)
* in modules/core/SiteAdmin.inc at line 201
(chooseobjectsview::loadtemplate)
* in modules/core/classes/GalleryView.class at line 300
(siteadminview::loadtemplate)
* in main.php at line 445 (siteadminview::doloadtemplate)
* in main.php at line 94
* in main.php at line 83

System Information
Gallery version 2.2.5
PHP version 4.4.7 cgi
Webserver Apache
Database mysqlt 5.0.45-log
Toolkits ImageMagick, Thumbnail, NetPBM
Operating system Linux boscgi1504.eigbox.net 2.6.24.7 #1 SMP Wed May 7
12:55:23 EDT 2008 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3)
Gecko/2008092417 Firefox/3.0.3
---------------------------------------------------

When I set it to debug mode I got a HUUUUUUUUGE readout that I am loath to paste here unless you think you might be able to make something of it ...

Y
 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Sun, 2008-10-26 13:11

That's a start.

The bit of the "HUUUUUUUGE" debug out put that would be useful is the bit where there's (probably) a SQL error code embedded in it. You can post the whole thing as an attachment to your next post.
 
boxster5
boxster5's picture

Joined: 2007-03-14
Posts: 11
Posted: Sun, 2008-10-26 13:34

Hmmmm, attachment - okay, I'll give it a try ......
 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Sun, 2008-10-26 14:50

Well, here's the problem:

Quote:
mysqlt error: [2013: Lost connection to MySQL server during query] in EXECUTE(" SELECT g2_User.g_id FROM g2_User WHERE g2_User.g_userName = 'admin' ") (mysqlt): SELECT g2_User.g_id FROM g2_User WHERE g2_User.g_userName = 'admin' 2013: Lost connection to MySQL server during query

But that doesn't give any clue about what underlies it - "Lost connection to MySQL server during query" - I'll have to open it up to anyone else to suggest where to go next.
 
boxster5
boxster5's picture

Joined: 2007-03-14
Posts: 11
Posted: Sun, 2008-10-26 16:08

THANKS!!!!! Hmmm, I will ask my server host if anything on their end may cause that.

Thanks again!!

Y