Error (ERROR_STORAGE_FAILURE)
|
mkruer
Joined: 2003-01-01
Posts: 28 |
Posted: Wed, 2003-03-26 06:17
|
|
Just trying to keep up with the development of G2, and being a clean freak I though it would be fun to wipe everything and start anew. All the setting were setup with the identical settings, however when I ran the setup file, I got this error. <!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Code:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><PRE>Error (ERROR_STORAGE_FAILURE) * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 243 Doing a search on previous posts I found this <!-- BBCode Start --><A HREF="http://gallery.menalto.com/modules.php?op=modload&name=phpBB_14&file=index&action=viewtopic&topic=3842&16371" TARGET="_blank">article</A><!-- BBCode End --> <!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Code:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><PRE>Error (ERROR_STORAGE_FAILURE) * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 243 Did I miss something? I am using the gallery2-2003-03-24.tar files |
|
Posts: 7994
If you put Gallery in debug mode (in config.php) you'll get more debug output when this error occurs and some of that may give us a clue as to what's happening.
Make sure that the database exists and that your database username/password are correct, and that the database username has privileges to access the database you created. That's pretty much all Gallery is doing at the point where it's failing.
Posts: 28
Ok this is what I get when i first load the setup page. Any ID?
<!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Code:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><PRE>
Warning: Undefined property: _storage in /home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/Gallery.class on line 837 </TD></TR></TABLE><!-- BBCode End -->
Posts: 7994
Hmm. My guess is that you have tables lying around from a failed install so try connecting to the database via mysql and dropping any sequence tables (sequence_id, sequence_lock) as well as any Gallery tables (g2_*), then try it again with debug turned on.
Posts: 28
Yeah I just found out that that was the hick up for the first error.
So I removed the sequence_id and sequence_lock tables and reran the log in again and got this with the error debug on.
<!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Code:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><PRE>Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1072
* in modules/core/classes/Gallery.class at line 357
* in modules/core/classes/GalleryModuleParameterMap.class at line 147
* in modules/core/classes/Gallery.class at line 1070
* in modules/core/classes/GalleryModule.class at line 321
* in modules/core/module.inc at line 292
* in init.php at line 162
* in main.php at line 99
* in main.php at line 46
Trying to load core version. If you see an error like table Xxx doesn't
exist here, that's OK.
mysql error: [1146: Table 'vegastrike.g2_GalleryModuleParameterMap' doesn't
exist] in EXECUTE("
SELECT
g2_GalleryModuleParameterMap.g_parameterName,
g2_GalleryModuleParameterMap.g_parameterValue
FROM
g2_GalleryModuleParameterMap
WHERE
g2_GalleryModuleParameterMap.g_moduleName = 'core'
")
(mysql):
SELECT
g2_GalleryModuleParameterMap.g_parameterName,
g2_GalleryModuleParameterMap.g_parameterValue
FROM
g2_GalleryModuleParameterMap
WHERE
g2_GalleryModuleParameterMap.g_moduleName = 'core'
1146: Table 'vegastrike.g2_GalleryModuleParameterMap' doesn't exist
Can't load core version -- assuming that the core needs
installation
opendir(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
(mysql): SHOW TABLES
fopen(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Schema.sql,
r, 0)
(mysql): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--
CREATE TABLE g2_Schema (
g_name
varchar(
128
)
,
g_major
int(11)
,
g_minor
int(11)
) TYPE=MyISAM
(mysql): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Schema',
1,
0
)
(mysql): create table sequence_lock (id int not null)
(mysql): insert into sequence_lock values (0)
(mysql): create table sequence_id (id int not null)
(mysql): insert into sequence_id values (0)
(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema
fopen(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryGroup.sql,
r, 0)
(mysql): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--
CREATE TABLE g2_GalleryGroup (
g_id
int(11)
NOT NULL
,
g_groupType
int(11)
,
g_groupName
varchar(
32
)
,
UNIQUE KEY (g_groupName)
,
INDEX (g_id)
) TYPE=MyISAM
(mysql): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'GalleryGroup',
1,
0
)
fopen(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryItem.sql,
r, 0)
(mysql): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--
CREATE TABLE g2_GalleryItem (
g_id
int(11)
NOT NULL
,
g_canContainChildren
int(1)
,
g_description
text
,
g_keywords
varchar(
255
)
,
g_layout
varchar(
32
)
,
g_orderBy
varchar(
128
)
,
g_orderDirection
varchar(
128
)
,
g_orderWeight
int(11)
,
g_ownerId
int(11)
NOT NULL
,
g_summary
varchar(
255
)
,
g_theme
varchar(
32
)
,
g_title
varchar(
128
)
,
g_viewedSinceTimestamp
int(11)
NOT NULL
,
INDEX (g_id)
,
INDEX (g_keywords)
,
INDEX (g_ownerId)
,
INDEX (g_summary)
,
INDEX (g_title)
) TYPE=MyISAM
(mysql): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'GalleryItem',
1,
0
)
fopen(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryUser.sql,
r, 0)
(mysql): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--
CREATE TABLE g2_GalleryUser (
g_id
int(11)
NOT NULL
,
g_userName
varchar(
32
)
NOT NULL
,
g_fullName
varchar(
128
)
,
g_hashedPassword
varchar(
32
)
,
g_email
varchar(
128
)
,
g_language
varchar(
128
)
,
UNIQUE KEY (g_userName)
,
INDEX (g_id)
) TYPE=MyISAM
(mysql): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'GalleryUser',
1,
0
)
fopen(/home/groups/v/ve/vegastrike/htdocs/users/mkruer/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Lock.sql,
r, 0)
(mysql): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--
CREATE TABLE g2_Lock (
g_lockId
int(11)
,
g_readEntityId
int(11)
,
g_writeEntityId
int(11)
,
g_request
int(11)
,
INDEX (g_lockId)
) TYPE=MyISAM
(mysql): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Lock',
1,
0
)
mysql error: [1146: Table 'vegastrike.g2_GalleryModuleParameterMap' doesn't
exist] in EXECUTE("
SELECT
g2_GalleryModuleParameterMap.g_parameterName,
g2_GalleryModuleParameterMap.g_parameterValue
FROM
g2_GalleryModuleParameterMap
WHERE
g2_GalleryModuleParameterMap.g_moduleName = 'core'
")
(mysql):
SELECT
g2_GalleryModuleParameterMap.g_parameterName,
g2_GalleryModuleParameterMap.g_parameterValue
FROM
g2_GalleryModuleParameterMap
WHERE
g2_GalleryModuleParameterMap.g_moduleName = 'core'
1146: Table 'vegastrike.g2_GalleryModuleParameterMap' doesn't exist </TD></TR></TABLE><!-- BBCode End -->
looking at the database after I ran the setup, it created the following tables before it failed
g2_GalleryGroup
g2_GalleryItem
g2_GalleryUser
g2_Lock
g2_Schema
sequence_id
sequence_lock
It looks like one of the tables (g2_GalleryModuleParameterMap) is not being created properly or at all. I hope this helps
Posts: 7994
That's strange. Perhaps we're running into a limitation with the length of the table?
You're doing this on a sf.net server that I have access to; can I have your permission
to go dink around with your installation and see if I can figure out what's going wrong
directly?
Posts: 28
Sure, Just let me know what you need to gain access to the site.
Posts: 7994
Ok, I've fixed the problem and your Gallery2 install is working now. The problem was that you had given "/path/to/gallery2" as the data directory, but that's actually the path to the gallery code. I fixed it so that it's "/path/to/gallery2_albums" and now things work properly. I'll send you more sensitive info in a private message.