Yet another Beta 1 --> Beta 2 problem

croxis

Joined: 2005-03-15
Posts: 5
Posted: Tue, 2005-04-19 05:11

The upgrade seems to ok except for the following on the top of step 3: system checks.

Quote:
Notice: Undefined offset: 4 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 4 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 3 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 4 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 3 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 2 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 4 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 3 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 2 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Notice: Undefined offset: 1 in /gallery2/modules/core/classes/GalleryUtilities.class on line 1181

Upgrade goes smooth. However main.php gives the following error:

Quote:
Database Error

An error has occurred while interacting with the database.

Back to the Gallery
Error Detail -
Error (ERROR_STORAGE_FAILURE) :

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1164 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (mysqldatabasestorage::search)
* in modules/core/classes/Gallery.class at line 206 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 412 (gallery::search)
* in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 189 (gallerychildentityhelper_simple::_fetchchilditemids)
* in modules/core/classes/GalleryCoreApi.class at line 2161 (gallerychildentityhelper_simple::fetchchilditemids)
* in layouts/matrix/layout.inc at line 253 (gallerycoreapi::fetchchilditemids)
* in layouts/matrix/layout.inc at line 155 (matrixlayout::_loadalbumtemplate)
* in modules/core/ShowItem.inc at line 152 (matrixlayout::loadtemplate)
* in modules/core/classes/GalleryView.class at line 214 (showitemview::loadtemplate)
* in main.php at line 293 (showitemview::doloadtemplate)
* in main.php at line 79
* in main.php at line 70

Gallery Debug Output

file_exists(/temp/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
fopen(/temp/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc,
rb, 0)
fread(Resource id #28, 4096)
fread(Resource id #28, 4096)
fread(Resource id #28, 4096)
fclose(Resource id #28)
Unimplemented: GalleryUrlGenerator
file_exists(/temp/sessions/e10d4d55bfafe777a9398cf8e5605347)
file_exists(/temp/cache/module/core/0/0/0.inc)
fopen(/temp/cache/module/core/0/0/0.inc, rb, 0)
fread(Resource id #34, 4096)
fclose(Resource id #34)
file_exists(/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
file_exists(/temp//versions.dat)
file(/temp//versions.dat, )
[1113887183] can't guarantee 5 -- extending!
file_exists(/temp/cache/entity/0/0/4.inc)
fopen(/temp/cache/entity/0/0/4.inc, rb, 0)
fread(Resource id #39, 4096)
fclose(Resource id #39)
file_exists(/temp/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
fopen(/temp/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc,
rb, 0)
fread(Resource id #45, 4096)
fread(Resource id #45, 4096)
fread(Resource id #45, 4096)
fclose(Resource id #45)
file_exists(/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/temp/cache/entity/0/0/6.inc)
fopen(/temp/cache/entity/0/0/6.inc, rb, 0)
fread(Resource id #52, 4096)
fclose(Resource id #52)

(mysql):
SELECT
g2_Group.g_id,
g2_Group.g_groupName
FROM
g2_UserGroupMap, g2_Group
WHERE
g2_Group.g_id = g2_UserGroupMap.g_groupId
AND
g2_UserGroupMap.g_userId = 4
ORDER BY
g2_Group.g_groupName
LIMIT 18446744073709551615

(mysql):
SELECT
g2_PermissionSetMap.g_module,
g2_PermissionSetMap.g_permission,
g2_PermissionSetMap.g_description,
g2_PermissionSetMap.g_bits,
g2_PermissionSetMap.g_flags
FROM
g2_PermissionSetMap

(mysql):
SELECT DISTINCT
g2_AccessMap.g_accessListId
FROM
g2_AccessMap
WHERE
(g2_AccessMap.g_userId = 4
OR
g2_AccessMap.g_groupId IN (3))
AND
g2_AccessMap.g_permission & 1 = 1

(mysql):
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap
WHERE
g2_AccessSubscriberMap.g_itemId = 6
AND
g2_AccessSubscriberMap.g_accessListId IN (803, 804, 805)
LIMIT 1

file_exists(/gallery2/modules/core/classes/helpers/../../../../layouts/matrix/layout.inc)
file_exists(/temp/cache/layout/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
fopen(/temp/cache/layout/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc,
rb, 0)
fread(Resource id #74, 4096)
fclose(Resource id #74)
file_exists(/temp/cache/layout/matrix/0/0/0.inc)
fopen(/temp/cache/layout/matrix/0/0/0.inc, rb, 0)
fread(Resource id #75, 4096)
fclose(Resource id #75)
file_exists(/temp/cache/layout/matrix/0/0/6.inc)
fopen(/temp/cache/layout/matrix/0/0/6.inc, rb, 0)
fread(Resource id #76, 4096)
fclose(Resource id #76)
Array
(
[limit] => Array
(
[count] => 9
[offset] => 0
)

)

mysql error: [1146: Table 'gallery2.g2_PermissionMap' doesn't exist] 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 = 4
OR
g2_PermissionMap.g_groupId IN (3))
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 9")

(mysql):
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 = 4
OR
g2_PermissionMap.g_groupId IN (3))
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 9

1146: Table 'gallery2.g2_PermissionMap' doesn't exist

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[5]) % line 452, file: adodb-mysql.inc.php

adodb_mysql.selectlimit(
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWe..., 9, -1,
Array[5]) % line 1152, file: DatabaseStorage.class

mysqldatabasestorage.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[5],
Array[1]) % line 220, file: GalleryStorage.class

gallerystorage.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[5],
Array[1]) % line 206, file: Gallery.class

(mysql):
SELECT
g2_UserGroupMap.g_userId
FROM
g2_UserGroupMap
WHERE
g2_UserGroupMap.g_userId = 4
AND
g2_UserGroupMap.g_groupId = '2'
LIMIT 1

realpath(/gallery2/modules/core/classes/../../../)

This page is valid XHTML 1.0 Gallery 2.0-beta-2 Gallery 2 - Beta 2: Holy Hand Grenade
Gallery Debug Output

file_exists(/temp/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
fopen(/temp/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc,
rb, 0)
fread(Resource id #28, 4096)
fread(Resource id #28, 4096)
fread(Resource id #28, 4096)
fclose(Resource id #28)
Unimplemented: GalleryUrlGenerator
file_exists(/temp/sessions/e10d4d55bfafe777a9398cf8e5605347)
file_exists(/temp/cache/module/core/0/0/0.inc)
fopen(/temp/cache/module/core/0/0/0.inc, rb, 0)
fread(Resource id #34, 4096)
fclose(Resource id #34)
file_exists(/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
file_exists(/temp//versions.dat)
file(/temp//versions.dat, )
[1113887183] can't guarantee 5 -- extending!
file_exists(/temp/cache/entity/0/0/4.inc)
fopen(/temp/cache/entity/0/0/4.inc, rb, 0)
fread(Resource id #39, 4096)
fclose(Resource id #39)
file_exists(/temp/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
fopen(/temp/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc,
rb, 0)
fread(Resource id #45, 4096)
fread(Resource id #45, 4096)
fread(Resource id #45, 4096)
fclose(Resource id #45)
file_exists(/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/temp/cache/entity/0/0/6.inc)
fopen(/temp/cache/entity/0/0/6.inc, rb, 0)
fread(Resource id #52, 4096)
fclose(Resource id #52)

(mysql):
SELECT
g2_Group.g_id,
g2_Group.g_groupName
FROM
g2_UserGroupMap, g2_Group
WHERE
g2_Group.g_id = g2_UserGroupMap.g_groupId
AND
g2_UserGroupMap.g_userId = 4
ORDER BY
g2_Group.g_groupName
LIMIT 18446744073709551615

(mysql):
SELECT
g2_PermissionSetMap.g_module,
g2_PermissionSetMap.g_permission,
g2_PermissionSetMap.g_description,
g2_PermissionSetMap.g_bits,
g2_PermissionSetMap.g_flags
FROM
g2_PermissionSetMap

(mysql):
SELECT DISTINCT
g2_AccessMap.g_accessListId
FROM
g2_AccessMap
WHERE
(g2_AccessMap.g_userId = 4
OR
g2_AccessMap.g_groupId IN (3))
AND
g2_AccessMap.g_permission & 1 = 1

(mysql):
SELECT
g2_AccessSubscriberMap.g_itemId
FROM
g2_AccessSubscriberMap
WHERE
g2_AccessSubscriberMap.g_itemId = 6
AND
g2_AccessSubscriberMap.g_accessListId IN (803, 804, 805)
LIMIT 1

file_exists(/gallery2/modules/core/classes/helpers/../../../../layouts/matrix/layout.inc)
file_exists(/temp/cache/layout/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
fopen(/temp/cache/layout/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc,
rb, 0)
fread(Resource id #74, 4096)
fclose(Resource id #74)
file_exists(/temp/cache/layout/matrix/0/0/0.inc)
fopen(/temp/cache/layout/matrix/0/0/0.inc, rb, 0)
fread(Resource id #75, 4096)
fclose(Resource id #75)
file_exists(/temp/cache/layout/matrix/0/0/6.inc)
fopen(/temp/cache/layout/matrix/0/0/6.inc, rb, 0)
fread(Resource id #76, 4096)
fclose(Resource id #76)
Array
(
[limit] => Array
(
[count] => 9
[offset] => 0
)

)

mysql error: [1146: Table 'gallery2.g2_PermissionMap' doesn't exist] 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 = 4
OR
g2_PermissionMap.g_groupId IN (3))
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 9")

(mysql):
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 = 4
OR
g2_PermissionMap.g_groupId IN (3))
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 9

1146: Table 'gallery2.g2_PermissionMap' doesn't exist

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[5]) % line 452, file: adodb-mysql.inc.php

adodb_mysql.selectlimit(
SELECT
g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWe..., 9, -1,
Array[5]) % line 1152, file: DatabaseStorage.class

mysqldatabasestorage.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[5],
Array[1]) % line 220, file: GalleryStorage.class

gallerystorage.search(
SELECT
[GalleryChildEntity::id] , [GalleryItemAttributesMap..., Array[5],
Array[1]) % line 206, file: Gallery.class

(mysql):
SELECT
g2_UserGroupMap.g_userId
FROM
g2_UserGroupMap
WHERE
g2_UserGroupMap.g_userId = 4
AND
g2_UserGroupMap.g_groupId = '2'
LIMIT 1

realpath(/gallery2/modules/core/classes/../../../)

Thanks for you time
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-04-19 05:42

- any errors on the systemcheck step should be taken very seriously. if there are errors there, there will be most certainly errors in the rest of the installer or in G2 on your setup
- g2_PermissionMap, why does it not exist?!

did you have a beta 1 release or was it a nightly snapshot/cvs version, and from what date?
 
croxis

Joined: 2005-03-15
Posts: 5
Posted: Tue, 2005-04-19 06:42

1) I do not know
2) I *attempted* to clear out the table if it was the mimetypemap error, I must have broke something else in my ignorance. I know just enough to get myself into trouble, but not enough to know that I did!
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-04-19 07:05

do you have a backup of your beta 1 g2data folder and database?