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?

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
	XUser login Username: * Password: * Create new account Request new password
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?

Yet another Beta 1 --> Beta 2 problem

XUser login