Hello,
When i try to upload photo's i get the understanding errors.
Error (ERROR_TOOLKIT_FAILURE)
• in c:\inetpub\wwwroot\gallery2\modules\imagemagick\classes\ImageMagickToolkit.class at line 229 (gallerystatus::error)
• in c:\inetpub\wwwroot\gallery2\modules\imagemagick\classes\ImageMagickToolkit.class at line 103 (imagemagicktoolkit::_transformimage)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivative.class at line 472 (imagemagicktoolkit::performoperation)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivativeImage.class at line 169 (galleryderivative::rebuildcache)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivativeHelper.class at line 463 (galleryderivativeimage::rebuildcache)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivativeHelper.class at line 399 (galleryderivativehelper::rebuildcache)
• in c:\inetpub\wwwroot\gallery2\modules\core\ItemAdmin.inc at line 81 (galleryderivativehelper::rebuildcacheifnotcurrent)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryView.class at line 237 (itemadminview::renderbody)
• in c:\inetpub\wwwroot\gallery2\main.php at line 211 (itemadminview::renderheadandbody)
• in c:\inetpub\wwwroot\gallery2\main.php at line 24
----
Give us your Gallery/webserver information to get a faster answer.
Get this information from the PHP diagnostic (in the configuration wizard).
Gallery URL (optional but very useful):
Gallery version: snapshot 07-06-03 (dd-mm-yy)
IIS version: 6.0
PHP version (don't just say PHP 4, please): 4.3.2
Operating system: Windows 2003 Server std
Web browser/version (if applicable): IE 6.0.3790.0
Posts: 100
Hello,
After changing security rights i get this errors:
Error (ERROR_LOCK_TIMEOUT)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 911 (gallerystatus::error)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\Gallery.class at line 666 (mysqldatabasestorage::acquirewritelock)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivativeHelper.class at line 453 (gallery::acquirewritelock)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryDerivativeHelper.class at line 399 (galleryderivativehelper::rebuildcache)
• in c:\inetpub\wwwroot\gallery2\layouts\classic\layout.inc at line 183 (galleryderivativehelper::rebuildcacheifnotcurrent)
• in c:\inetpub\wwwroot\gallery2\layouts\classic\layout.inc at line 52 (classiclayout::_renderalbum)
• in c:\inetpub\wwwroot\gallery2\modules\core\ShowItem.inc at line 124 (classiclayout::render)
• in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryView.class at line 237 (showitemview::renderbody)
• in c:\inetpub\wwwroot\gallery2\main.php at line 211 (showitemview::renderheadandbody)
• in c:\inetpub\wwwroot\gallery2\main.php at line 24
When you look at some older post then you see that there was the same problem that is still there.
http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=3982
Greetings from,
André van den Berg
Give us your Gallery/webserver information to get a faster answer.
Get this information from the PHP diagnostic (in the configuration wizard).
Gallery URL (optional but very useful):
Gallery version: snapshot 07-06-03 (dd-mm-yy)
IIS version: 6.0
PHP version (don't just say PHP 4, please): 4.3.2
Operating system: Windows 2003 Server std
Web browser/version (if applicable): IE 6.0.3790.0
Grafix/version: ImageMagick-5.5.7-Q16-windows-dll
Posts: 100
Hello,
Hier is the logfile maybe this helps.
2003-06-08 19:57:08 [<no session id>] <hr />
(mysqlt): SET AUTOCOMMIT=0 & <code></code>
<hr />
<hr />
(mysqlt): BEGIN & <code></code>
<hr />
2003-06-08 19:57:08 [<no session id>] Trying to load core version. If you see an error like <b>table Xxx doesn't exist</b> here, that's OK.
2003-06-08 19:57:08 [<no session id>] <hr />
(mysqlt):
SELECT
g2_ModuleParameterMap.g_parameterName,
g2_ModuleParameterMap.g_parameterValue
FROM
g2_ModuleParameterMap
WHERE
g2_ModuleParameterMap.g_moduleName = 'core'
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_Session.g_key,
g2_Session.g_value
FROM
g2_Session
WHERE
g2_Session.g_sessionId = '352a4be5ef70a9e7f19b0c1d26dbb370'
AND
g2_Session.g_key IN ('core.session.creationTime', 'core.session.lifetime', 'core.session.lastModified')
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_Session.g_key,
g2_Session.g_value
FROM
g2_Session
WHERE
g2_Session.g_sessionId = '352a4be5ef70a9e7f19b0c1d26dbb370'
AND
g2_Session.g_key IN ('core.id.activeUser')
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] [1055095028] can't guarantee 5 -- extending!
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (3) & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryUser.class)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_User.g_userName, g2_User.g_fullName, g2_User.g_hashedPassword, g2_User.g_email, g2_User.g_language FROM g2_Entity, g2_User WHERE g2_Entity.g_id IN (3) AND g2_User.g_id=g2_Entity.g_id & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ModuleMap.g_moduleName,
g2_ModuleMap.g_active
FROM
g2_ModuleMap
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] opendir(c:\inetpub\wwwroot\gallery2/modules\)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\comment)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\comment/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\core)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\debug)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\debug/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\imagemagick)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\imagemagick/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\netpbm)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\netpbm/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:\inetpub\wwwroot\gallery2/modules\search)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\search/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\comment/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\comment/templates/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\search/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\search/templates/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\imagemagick/module.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/ShowItem.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/ShowItem.inc)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/templates/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN ('5') & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryAlbumItem.class)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_ChildEntity.g_parentId, g2_FileSystemEntity.g_pathComponent, g2_Item.g_canContainChildren, g2_Item.g_description, g2_Item.g_keywords, g2_Item.g_layout, g2_Item.g_orderBy, g2_Item.g_orderDirection, g2_Item.g_orderWeight, g2_Item.g_ownerId, g2_Item.g_summary, g2_Item.g_theme, g2_Item.g_title, g2_Item.g_viewedSinceTimestamp FROM g2_Entity, g2_ChildEntity, g2_FileSystemEntity, g2_Item WHERE g2_Entity.g_id IN (5) AND g2_ChildEntity.g_id=g2_Entity.g_id AND g2_FileSystemEntity.g_id=g2_Entity.g_id AND g2_Item.g_id=g2_Entity.g_id & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/themes\classic/templates/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_PermissionSetMap.g_module,
g2_PermissionSetMap.g_permission,
g2_PermissionSetMap.g_description,
g2_PermissionSetMap.g_bits,
g2_PermissionSetMap.g_flags
FROM
g2_PermissionSetMap
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
COUNT(g2_PermissionMap.g_itemId)
FROM
g2_PermissionMap, g2_UserGroupMap
WHERE
g2_PermissionMap.g_itemId = 5
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 = 1
GROUP BY
g2_PermissionMap.g_itemId
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ViewCountMap.g_viewCount
FROM
g2_ViewCountMap
WHERE
g2_ViewCountMap.g_itemId = 5
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): UPDATE g2_ViewCountMap SET g_viewCount=23 WHERE g_itemId=5 & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2/layouts\classic/templates/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_parentId, COUNT(DISTINCT(g2_ChildEntity.g_id))
FROM
g2_ChildEntity, g2_UserGroupMap, g2_PermissionMap
WHERE
( g2_ChildEntity.g_parentId = 5 )
AND
g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 & 0
GROUP BY
g2_ChildEntity.g_parentId
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] Array
(
[limit] => Array
(
[count] => 9
[offset] => 0
)
)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_id
FROM
g2_ChildEntity, g2_UserGroupMap, g2_PermissionMap
WHERE
g2_ChildEntity.g_parentId = 5
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 & 0
AND
g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
GROUP BY
g2_ChildEntity.g_id
LIMIT 9 & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (6) & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_ChildEntity.g_parentId, g2_FileSystemEntity.g_pathComponent, g2_Item.g_canContainChildren, g2_Item.g_description, g2_Item.g_keywords, g2_Item.g_layout, g2_Item.g_orderBy, g2_Item.g_orderDirection, g2_Item.g_orderWeight, g2_Item.g_ownerId, g2_Item.g_summary, g2_Item.g_theme, g2_Item.g_title, g2_Item.g_viewedSinceTimestamp FROM g2_Entity, g2_ChildEntity, g2_FileSystemEntity, g2_Item WHERE g2_Entity.g_id IN (6) AND g2_ChildEntity.g_id=g2_Entity.g_id AND g2_FileSystemEntity.g_id=g2_Entity.g_id AND g2_Item.g_id=g2_Entity.g_id & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_PermissionMap.g_itemId,
BIT_OR(g2_PermissionMap.g_permission)
FROM
g2_PermissionMap, g2_UserGroupMap
WHERE
g2_PermissionMap.g_itemId IN (5, 6)
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
GROUP BY
g2_PermissionMap.g_itemId
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_parentId,
COUNT(g2_Comment.g_id)
FROM
g2_Comment, g2_ChildEntity
WHERE
g2_ChildEntity.g_parentId IN (6)
AND
g2_ChildEntity.g_id = g2_Comment.g_id
GROUP BY
g2_ChildEntity.g_parentId
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_parentId, COUNT(DISTINCT(g2_ChildEntity.g_id))
FROM
g2_ChildEntity, g2_UserGroupMap, g2_PermissionMap
WHERE
( g2_ChildEntity.g_parentId = 6 )
AND
g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 & 0
GROUP BY
g2_ChildEntity.g_parentId
& <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt):
SELECT
g2_Derivative.g_id, g2_ChildEntity.g_parentId
FROM
g2_Derivative, g2_ChildEntity
WHERE
g2_Derivative.g_id = g2_ChildEntity.g_id
AND
g2_ChildEntity.g_parentId IN (6)
AND
g2_Derivative.g_derivativeType IN (1)
ORDER BY g2_Derivative.g_id ASC & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN ('10') & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryDerivativeImage.class)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_ChildEntity.g_parentId, g2_Derivative.g_derivativeSourceId, g2_Derivative.g_derivativeOperations, g2_Derivative.g_derivativeOrder, g2_Derivative.g_derivativeSize, g2_Derivative.g_derivativeType, g2_Derivative.g_derivativeMimeType, g2_DerivativeImage.g_width, g2_DerivativeImage.g_height FROM g2_Entity, g2_ChildEntity, g2_Derivative, g2_DerivativeImage WHERE g2_Entity.g_id IN (10) AND g2_ChildEntity.g_id=g2_Entity.g_id AND g2_Derivative.g_id=g2_Entity.g_id AND g2_DerivativeImage.g_id=g2_Entity.g_id & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] Begin: Rebuilding cache
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:/apps/web/gallerydata\cache\1/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] is_dir(c:/apps/web/gallerydata\cache\1/)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:/apps/web/gallerydata\cache\1/10)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (8) & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryPhotoItem.class)
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_ChildEntity.g_parentId, g2_FileSystemEntity.g_pathComponent, g2_Item.g_canContainChildren, g2_Item.g_description, g2_Item.g_keywords, g2_Item.g_layout, g2_Item.g_orderBy, g2_Item.g_orderDirection, g2_Item.g_orderWeight, g2_Item.g_ownerId, g2_Item.g_summary, g2_Item.g_theme, g2_Item.g_title, g2_Item.g_viewedSinceTimestamp, g2_DataItem.g_mimeType, g2_DataItem.g_size, g2_PhotoItem.g_width, g2_PhotoItem.g_height FROM g2_Entity, g2_ChildEntity, g2_FileSystemEntity, g2_Item, g2_DataItem, g2_PhotoItem WHERE g2_Entity.g_id IN (8) AND g2_ChildEntity.g_id=g2_Entity.g_id AND g2_FileSystemEntity.g_id=g2_Entity.g_id AND g2_Item.g_id=g2_Entity.g_id AND g2_DataItem.g_id=g2_Entity.g_id AND g2_PhotoItem.g_id=g2_Entity.g_id & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): update sequence_lock set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Lock(g_lockId, g_request) VALUES (36, 1) & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId ASC LIMIT 1 & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (10) OR g_writeEntityId IN (10) & <code></code>
<hr />
2003-06-08 19:57:08 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): DELETE FROM g2_Lock WHERE g_lockId IN (36) & <code></code>
<hr />
2003-06-08 19:57:09 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): update sequence_lock set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-08 19:57:09 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Lock(g_lockId, g_request) VALUES (37, 1) & <code></code>
<hr />
2003-06-08 19:57:09 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId ASC LIMIT 1 & <code></code>
<hr />
2003-06-08 19:57:09 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (10) OR g_writeEntityId IN (10) & <code></code>
<hr />
2003-06-08 19:57:09 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): DELETE FROM g2_Lock WHERE g_lockId IN (37) & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): update sequence_lock set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Lock(g_lockId, g_request) VALUES (38, 1) & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId ASC LIMIT 1 & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (10) OR g_writeEntityId IN (10) & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): DELETE FROM g2_Lock WHERE g_lockId IN (38) & <code></code>
<hr />
2003-06-08 19:57:10 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('352a4be5ef70a9e7f19b0c1d26dbb370', 'core.session.creationTime', 1055095028) & <code></code>
<hr />
2003-06-08 19:57:11 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('352a4be5ef70a9e7f19b0c1d26dbb370', 'core.session.lastModified', 1055095030) & <code></code>
<hr />
2003-06-08 19:57:11 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('352a4be5ef70a9e7f19b0c1d26dbb370', 'core.id.activeUser', '3') & <code></code>
<hr />
2003-06-08 19:57:11 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): COMMIT & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />
2003-06-08 19:57:11 [352a4be5ef70a9e7f19b0c1d26dbb370] <hr />
(mysqlt): ROLLBACK & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />
Posts: 7994
I made some changes yesterday, so start by getting the latest code, then rebuilding everything.
The lock failure comes from having a lock lying around in the g2_Lock table. You can go into that table and delete all rows at any time if you see that happening (we'll improve on this later).
This time when you rebuild, turn on debug mode at the beginning so that if you get the toolkit failure you can paste the debug messages that show up on the same page. That will help us to figure out what's going wrong (since we didn't have the debug output from the first error it's hard to see what might have caused it, and all subsequent debug output was about the lock timeout for which we know the quick fix).
Posts: 100
Hello,
Downloaded the version of 21-06-2003 dumped the db delete all the files, so it's a clean install and then i get the following errors.
Sorry that it take some time but did move to a other city and it did take some time to get ADSL in the new house.
Understanding is what i am getting when debug is on.
Before debug:
Notice: Use of undefined constant Enable - assumed 'Enable' in c:\inetpub\wwwroot\gallery2\config.php on line 110
Notice: Undefined variable: country in c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryTranslator.class on line 208
Warning: Cannot modify header information - headers already sent by (output started at c:\inetpub\wwwroot\gallery2\config.php:110) in c:\inetpub\wwwroot\gallery2\modules\core\classes\GallerySession.class on line 218
Debug:
Profiling
Function Combined Internal External
Calls Total <Total> Max Average Total Max Average
GalleryProfiler Error: Stack mismatch! (Gallery::search != GalleryInitSecondPass)
and this is in de log file that's running from the start.
Logfile:
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\)
2003-06-21 17:44:54 [<no session id>] is_dir(c:/apps/web/gallerydata\)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\)
2003-06-21 17:44:54 [<no session id>] fopen(c:/apps/web/gallerydata\/setup4083, w, 0)
2003-06-21 17:44:54 [<no session id>] unlink(c:/apps/web/gallerydata\/setup4083)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\albums\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\albums\)
2003-06-21 17:44:54 [<no session id>] mkdir(c:/apps/web/gallerydata\albums\, 755)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\albums\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\cache\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\cache\)
2003-06-21 17:44:54 [<no session id>] mkdir(c:/apps/web/gallerydata\cache\, 755)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\cache\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\tmp\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\tmp\)
2003-06-21 17:44:54 [<no session id>] mkdir(c:/apps/web/gallerydata\tmp\, 755)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\tmp\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\smarty\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\smarty\)
2003-06-21 17:44:54 [<no session id>] mkdir(c:/apps/web/gallerydata\smarty\, 755)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\smarty\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\smarty\templates_c\)
2003-06-21 17:44:54 [<no session id>] file_exists(c:/apps/web/gallerydata\smarty\templates_c\)
2003-06-21 17:44:54 [<no session id>] mkdir(c:/apps/web/gallerydata\smarty\templates_c\, 755)
2003-06-21 17:44:54 [<no session id>] is_writeable(c:/apps/web/gallerydata\smarty\templates_c\)
2003-06-21 17:44:54 [<no session id>] <hr />
(mysqlt): ROLLBACK & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): SET AUTOCOMMIT=0 & <code></code>
<hr />
<hr />
(mysqlt): BEGIN & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] Trying to load core version. If you see an error like <b>table Xxx doesn't exist</b> here, that's OK.
2003-06-21 17:44:57 [<no session id>] mysqlt error: [1146: Table 'gallery2.g2_moduleparametermap' doesn't exist] in EXECUTE("
SELECT
g2_ModuleParameterMap.g_parameterName,
g2_ModuleParameterMap.g_parameterValue
FROM
g2_ModuleParameterMap
WHERE
g2_ModuleParameterMap.g_moduleName = 'core'
")
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt):
SELECT
g2_ModuleParameterMap.g_parameterName,
g2_ModuleParameterMap.g_parameterValue
FROM
g2_ModuleParameterMap
WHERE
g2_ModuleParameterMap.g_moduleName = 'core'
& <code></code>
<hr />
1146: Table 'gallery2.g2_moduleparametermap' doesn't exist<br>
2003-06-21 17:44:57 [<no session id>] Can't load core version -- <b>assuming that the core needs installation</b>
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): ROLLBACK & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): SET AUTOCOMMIT=0 & <code></code>
<hr />
<hr />
(mysqlt): BEGIN & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] opendir(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): SHOW TABLES & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Schema.sql, r, 0)
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): -- 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=InnoDB & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Schema',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): create table sequence_lock (id int not null) & <code></code>
<hr />
<hr />
(mysqlt): insert into sequence_lock values (0) & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): create table sequence_id (id int not null) & <code></code>
<hr />
<hr />
(mysqlt): insert into sequence_id values (0) & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): SELECT g_name, g_major, g_minor FROM g2_Schema & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryAlbumItem.sql, r, 0)
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): -- 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_AlbumItem (
g_id
int(11)
NOT NULL
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'AlbumItem',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:57 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryChildEntity.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_ChildEntity (
g_id
int(11)
NOT NULL
,
g_parentId
int(11)
,
INDEX (g_id)
,
INDEX (g_parentId)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ChildEntity',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryDataItem.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_DataItem (
g_id
int(11)
NOT NULL
,
g_mimeType
varchar(
128
)
,
g_size
int(11)
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'DataItem',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryDerivative.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_Derivative (
g_id
int(11)
NOT NULL
,
g_derivativeSourceId
int(11)
NOT NULL
,
g_derivativeOperations
varchar(
255
)
,
g_derivativeOrder
int(11)
,
g_derivativeSize
int(11)
,
g_derivativeType
int(11)
,
g_derivativeMimeType
varchar(
128
)
,
INDEX (g_id)
,
INDEX (g_derivativeSourceId)
,
INDEX (g_derivativeOrder)
,
INDEX (g_derivativeType)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Derivative',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryDerivativeImage.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_DerivativeImage (
g_id
int(11)
NOT NULL
,
g_width
int(11)
,
g_height
int(11)
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'DerivativeImage',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryDerivativePreferencesMap.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_DerivativePreferencesMap (
g_itemId
int(11)
,
g_order
int(11)
,
g_derivativeType
int(11)
,
g_derivativeOperations
varchar(
255
)
,
INDEX (g_itemId)
,
INDEX (g_order)
,
INDEX (g_derivativeType)
,
INDEX (g_derivativeOperations)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'DerivativePreferencesMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryEntity.sql, r, 0)
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): -- 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_Entity (
g_id
int(11)
NOT NULL
,
g_creationTimestamp
int(11)
NOT NULL
,
g_modificationTimestamp
int(11)
NOT NULL
,
g_serialNumber
int(11)
NOT NULL
,
g_entityType
varchar(
32
)
NOT NULL
,
INDEX (g_id)
,
INDEX (g_creationTimestamp)
,
INDEX (g_modificationTimestamp)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Entity',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:58 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryFileSystemEntity.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_FileSystemEntity (
g_id
int(11)
NOT NULL
,
g_pathComponent
varchar(
128
)
,
INDEX (g_id)
,
INDEX (g_pathComponent)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'FileSystemEntity',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryGroup.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_Group (
g_id
int(11)
NOT NULL
,
g_groupType
int(11)
,
g_groupName
varchar(
32
)
,
UNIQUE KEY (g_groupName)
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Group',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryItem.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_Item (
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=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Item',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryItemPropertiesMap.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_ItemPropertiesMap (
g_itemId
int(11)
,
g_key
varchar(
128
)
,
g_value
text
,
UNIQUE KEY (g_itemId
,
g_key)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ItemPropertiesMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryModuleMap.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_ModuleMap (
g_moduleName
varchar(
128
)
,
g_active
int(1)
,
UNIQUE KEY (g_moduleName)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ModuleMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryModuleParameterMap.sql, r, 0)
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): -- 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_ModuleParameterMap (
g_moduleName
varchar(
128
)
,
g_parameterName
varchar(
128
)
,
g_parameterValue
varchar(
255
)
,
UNIQUE KEY (g_moduleName
,
g_parameterName)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ModuleParameterMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:44:59 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryMovieItem.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_MovieItem (
g_id
int(11)
NOT NULL
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'MovieItem',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPermissionMap.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_PermissionMap (
g_itemId
int(11)
,
g_userId
int(11)
,
g_groupId
int(11)
,
g_permission
int(11)
,
INDEX (g_itemId)
,
INDEX (g_userId)
,
INDEX (g_groupId)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'PermissionMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPermissionSetMap.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_PermissionSetMap (
g_module
varchar(
128
)
,
g_permission
varchar(
128
)
,
g_description
varchar(
255
)
,
g_bits
int(11)
,
g_flags
int(11)
,
UNIQUE KEY (g_permission)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'PermissionSetMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPhotoItem.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_PhotoItem (
g_id
int(11)
NOT NULL
,
g_width
int(11)
,
g_height
int(11)
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'PhotoItem',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GallerySession.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_Session (
g_sessionId
varchar(
128
)
,
g_key
varchar(
32
)
,
g_value
text
,
INDEX (g_sessionId)
,
INDEX (g_key)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Session',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryToolkitOperationMap.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_ToolkitOperationMap (
g_name
varchar(
128
)
,
g_parametersCrc
varchar(
32
)
,
g_outputMimeType
varchar(
128
)
,
g_description
varchar(
255
)
,
UNIQUE KEY (g_name
,
g_parametersCrc)
,
UNIQUE KEY (g_name)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ToolkitOperationMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryToolkitOperationMimeTypeMap.sql, r, 0)
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): -- 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_ToolkitOperationMimeTypeMap (
g_operationName
varchar(
128
)
,
g_toolkitId
varchar(
128
)
,
g_mimeType
varchar(
128
)
,
INDEX (g_operationName)
,
INDEX (g_mimeType)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ToolkitOperationMimeTypeMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:00 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryToolkitOperationParameterMap.sql, r, 0)
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): -- 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_ToolkitOperationParameterMap (
g_operationName
varchar(
128
)
,
g_position
int(11)
,
g_type
varchar(
128
)
,
g_description
varchar(
255
)
,
INDEX (g_operationName)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ToolkitOperationParameterMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryToolkitPropertyMap.sql, r, 0)
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): -- 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_ToolkitPropertyMap (
g_name
varchar(
128
)
,
g_type
varchar(
128
)
,
g_description
varchar(
128
)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ToolkitPropertyMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryToolkitPropertyMimeTypeMap.sql, r, 0)
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): -- 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_ToolkitPropertyMimeTypeMap (
g_propertyName
varchar(
128
)
,
g_toolkitId
varchar(
128
)
,
g_mimeType
varchar(
128
)
,
INDEX (g_propertyName)
,
INDEX (g_mimeType)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ToolkitPropertyMimeTypeMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryUnknownItem.sql, r, 0)
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): -- 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_UnknownItem (
g_id
int(11)
NOT NULL
,
INDEX (g_id)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'UnknownItem',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryUser.sql, r, 0)
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): -- 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_User (
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=InnoDB & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'User',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:01 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryUserGroupMap.sql, r, 0)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): -- 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_UserGroupMap (
g_userId
int(11)
,
g_groupId
int(11)
,
INDEX (g_userId)
,
INDEX (g_groupId)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'UserGroupMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryViewCountMap.sql, r, 0)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): -- 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_ViewCountMap (
g_itemId
int(11)
,
g_viewCount
int(11)
,
UNIQUE KEY (g_itemId)
) TYPE=InnoDB & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ViewCountMap',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] fopen(c:\inetpub\wwwroot\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Lock.sql, r, 0)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): -- 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=InnoDB & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Lock',
1,
0
) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_ModuleParameterMap.g_parameterName,
g2_ModuleParameterMap.g_parameterValue
FROM
g2_ModuleParameterMap
WHERE
g2_ModuleParameterMap.g_moduleName = 'core'
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'permissions.directory', '0755') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'permissions.file', '0644') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'exec.expectedStatus', '0') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'default.orderBy', 'id') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'default.orderDirection', '1') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'default.layout', 'classic') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'default.theme', 'classic') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'default.language', 'en_US') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'session.idParameter', 'GALLERYSID') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'session.lifetime', 788400000) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'session.inactivityTimeout', 1209600) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_PermissionSetMap.g_module,
g2_PermissionSetMap.g_permission,
g2_PermissionSetMap.g_description,
g2_PermissionSetMap.g_bits,
g2_PermissionSetMap.g_flags
FROM
g2_PermissionSetMap
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.all', 'All access', 2147483647, 3) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.view', '[core] View item', 1, 0) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.viewResizes', '[core] View resized version(s)', 2, 0) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.viewSource', '[core] View original version', 4, 0) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.viewAll', '[core] View all versions', 7, 2) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.addAlbumItem', '[core] Add sub-album', 8, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.addDataItem', '[core] Add sub-item', 16, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.changeProperties', '[core] Change item properties', 32, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.changePermissions', '[core] Change item permissions', 64, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.move', '[core] Move item', 128, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.changeText', '[core] Change item text', 256, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionSetMap (g_module, g_permission, g_description, g_bits, g_flags) VALUES ('core', 'core.delete', '[core] Delete item', 512, 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'version', '1.0') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryGroup.class)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_Group.g_id
FROM
g2_Group
WHERE
g2_Group.g_groupName = 'All Users'
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): update sequence_id set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Entity (g_id, g_creationTimestamp, g_modificationTimestamp, g_serialNumber, g_entityType) VALUES (1, 1056210302, 1056210302, 1, 'GalleryGroup') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Group (g_groupType, g_groupName, g_id) VALUES (2, 'All Users', 1) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'id.allUserGroup', 1) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_Group.g_id
FROM
g2_Group
WHERE
g2_Group.g_groupName = 'Site Admins'
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): update sequence_id set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Entity (g_id, g_creationTimestamp, g_modificationTimestamp, g_serialNumber, g_entityType) VALUES (2, 1056210302, 1056210302, 1, 'GalleryGroup') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Group (g_groupType, g_groupName, g_id) VALUES (3, 'Site Admins', 2) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'id.adminGroup', 2) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryUser.class)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_User.g_id
FROM
g2_User
WHERE
g2_User.g_userName = 'anonymous'
LIMIT 1 & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): update sequence_id set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Entity (g_id, g_creationTimestamp, g_modificationTimestamp, g_serialNumber, g_entityType) VALUES (3, 1056210302, 1056210302, 1, 'GalleryUser') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_User (g_userName, g_fullName, g_id) VALUES ('anonymous', 'Anonymous', 3) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_UserGroupMap (g_userId, g_groupId) VALUES (3, 1) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'id.anonymousUser', 3) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_UserGroupMap.g_userId,
g2_User.g_userName
FROM
g2_UserGroupMap, g2_User
WHERE
g2_UserGroupMap.g_groupId = 2
AND
g2_UserGroupMap.g_userId = g2_User.g_id
ORDER BY
g2_User.g_userName
LIMIT -1 & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_User.g_id
FROM
g2_User
WHERE
g2_User.g_userName = 'admin'
LIMIT 1 & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): update sequence_id set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Entity (g_id, g_creationTimestamp, g_modificationTimestamp, g_serialNumber, g_entityType) VALUES (4, 1056210302, 1056210302, 1, 'GalleryUser') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_User (g_userName, g_fullName, g_hashedPassword, g_id) VALUES ('admin', 'Gallery Administrator', '17ce6aff0b6c13cc5f2f8ded492c2694', 4) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_UserGroupMap (g_userId, g_groupId) VALUES (4, 1) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_UserGroupMap (g_userId, g_groupId) VALUES (4, 2) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] file_exists(c:\inetpub\wwwroot\gallery2\modules\core/classes/GalleryAlbumItem.class)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
COUNT(g2_ChildEntity.g_id)
FROM
g2_ChildEntity, g2_FileSystemEntity
WHERE
g2_ChildEntity.g_parentId IS NULL
AND
g2_FileSystemEntity.g_pathComponent = 'root'
AND
g2_ChildEntity.g_id && NULL
AND
g2_ChildEntity.g_id = g2_FileSystemEntity.g_id
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): update sequence_id set id=LAST_INSERT_ID(id+1); & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_DerivativePreferencesMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (5, 0, 1, 'thumbnail|200') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_DerivativePreferencesMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (5, 0, 2, 'scale|640') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] file_exists(c:/apps/web/gallerydata\albums\root)
2003-06-21 17:45:02 [<no session id>] mkdir(c:/apps/web/gallerydata\albums\root, 755)
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Entity (g_id, g_creationTimestamp, g_modificationTimestamp, g_serialNumber, g_entityType) VALUES (5, 1056210302, 1056210302, 1, 'GalleryAlbumItem') & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ChildEntity (g_id) VALUES (5) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_FileSystemEntity (g_pathComponent, g_id) VALUES ('root', 5) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_Item (g_canContainChildren, g_description, g_orderBy, g_orderDirection, g_ownerId, g_title, g_viewedSinceTimestamp, g_id) VALUES (1, 'This is the top of your Gallery', 'id', '1', 4, 'Gallery', 1056210302, 5) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ViewCountMap (g_itemId, g_viewCount) VALUES (5, 0) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_PermissionMap.g_itemId,
g2_PermissionMap.g_permission
FROM
g2_PermissionMap
WHERE
g2_PermissionMap.g_itemId = 5
AND
g2_PermissionMap.g_userId = 0
AND
g2_PermissionMap.g_groupId = 1
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionMap (g_itemId, g_userId, g_groupId, g_permission) VALUES (5, 0, 1, 7) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt):
SELECT
g2_PermissionMap.g_itemId,
g2_PermissionMap.g_permission
FROM
g2_PermissionMap
WHERE
g2_PermissionMap.g_itemId = 5
AND
g2_PermissionMap.g_userId = 0
AND
g2_PermissionMap.g_groupId = 2
& <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_PermissionMap (g_itemId, g_userId, g_groupId, g_permission) VALUES (5, 0, 2, 2147483647) & <code></code>
<hr />
2003-06-21 17:45:02 [<no session id>] <hr />
(mysqlt): INSERT INTO g2_ModuleParameterMap (g_moduleName, g_parameterName, g_parameterValue) VALUES ('core', 'id.rootAlbum', 5) & <code></code>
<hr />
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_Session.g_key,
g2_Session.g_value
FROM
g2_Session
WHERE
g2_Session.g_sessionId = 'a8e08b1f5728155fb2a0016933e44eb8'
AND
g2_Session.g_key IN ('core.session.creationTime', 'core.session.lifetime', 'core.session.lastModified')
& <code></code>
<hr />
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_Session.g_key,
g2_Session.g_value
FROM
g2_Session
WHERE
g2_Session.g_sessionId = 'a8e08b1f5728155fb2a0016933e44eb8'
AND
g2_Session.g_key IN ('core.id.activeUser')
& <code></code>
<hr />
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_ModuleMap.g_moduleName,
g2_ModuleMap.g_active
FROM
g2_ModuleMap
& <code></code>
<hr />
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] opendir(c:\inetpub\wwwroot\gallery2/modules\)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\comment)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\comment/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\core)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\debug)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\debug/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\imagemagick)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\imagemagick/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\netpbm)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\netpbm/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] is_dir(c:\inetpub\wwwroot\gallery2/modules\search)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\search/module.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/ShowItem.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/ShowItem.inc)
2003-06-21 17:45:02 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/modules\core/templates/)
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] [1056210303] can't guarantee 5 -- extending!
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/themes\classic/templates/)
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
COUNT(g2_PermissionMap.g_itemId)
FROM
g2_PermissionMap, g2_UserGroupMap
WHERE
g2_PermissionMap.g_itemId = 5
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 = 1
GROUP BY
g2_PermissionMap.g_itemId
& <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_ViewCountMap.g_viewCount
FROM
g2_ViewCountMap
WHERE
g2_ViewCountMap.g_itemId = 5
& <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): UPDATE g2_ViewCountMap SET g_viewCount=1 WHERE g_itemId=5 & <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] file_exists(c:\inetpub\wwwroot\gallery2/layouts\classic/templates/)
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_parentId, COUNT(DISTINCT(g2_ChildEntity.g_id))
FROM
g2_ChildEntity, g2_UserGroupMap, g2_PermissionMap
WHERE
( g2_ChildEntity.g_parentId = 5 )
AND
g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 & 0
GROUP BY
g2_ChildEntity.g_parentId
& <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] Array
(
[limit] => Array
(
[count] => 9
[offset] => 0
)
)
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_ChildEntity.g_id
FROM
g2_ChildEntity, g2_UserGroupMap, g2_PermissionMap
WHERE
g2_ChildEntity.g_parentId = 5
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
AND
g2_PermissionMap.g_permission & 1 & 0
AND
g2_PermissionMap.g_itemId = g2_ChildEntity.g_id
GROUP BY
g2_ChildEntity.g_id
LIMIT 9 & <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_PermissionMap.g_itemId,
BIT_OR(g2_PermissionMap.g_permission)
FROM
g2_PermissionMap, g2_UserGroupMap
WHERE
g2_PermissionMap.g_itemId IN (5)
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
GROUP BY
g2_PermissionMap.g_itemId
& <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_PermissionMap.g_itemId,
BIT_OR(g2_PermissionMap.g_permission)
FROM
g2_PermissionMap, g2_UserGroupMap
WHERE
g2_PermissionMap.g_itemId IN (NULL)
AND
(g2_PermissionMap.g_userId = 3
OR
(g2_UserGroupMap.g_userId = 3
AND
g2_PermissionMap.g_groupId = g2_UserGroupMap.g_groupId))
GROUP BY
g2_PermissionMap.g_itemId
& <code></code>
<hr />
2003-06-21 17:45:03 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt):
SELECT
g2_UserGroupMap.g_userId
FROM
g2_UserGroupMap
WHERE
g2_UserGroupMap.g_userId = 3
AND
g2_UserGroupMap.g_groupId = 2
LIMIT 1 & <code></code>
<hr />
2003-06-21 17:45:04 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('a8e08b1f5728155fb2a0016933e44eb8', 'core.session.creationTime', 1056210302) & <code></code>
<hr />
2003-06-21 17:45:04 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('a8e08b1f5728155fb2a0016933e44eb8', 'core.session.lastModified', 1056210304) & <code></code>
<hr />
2003-06-21 17:45:04 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): INSERT INTO g2_Session (g_sessionId, g_key, g_value) VALUES ('a8e08b1f5728155fb2a0016933e44eb8', 'core.id.activeUser', 3) & <code></code>
<hr />
2003-06-21 17:45:04 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): COMMIT & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />
2003-06-21 17:45:04 [a8e08b1f5728155fb2a0016933e44eb8] <hr />
(mysqlt): ROLLBACK & <code></code>
<hr />
<hr />
(mysqlt): SET AUTOCOMMIT=1 & <code></code>
<hr />