tag:help-archives.hannonhill.com,2010-02-09:/discussions/bug-reports/2694-bulk-change-phantom-pageCascade CMS: Discussion 2016-11-14T15:10:23Ztag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-18T19:29:23Z2015-08-18T19:29:23ZBulk Change phantom page<div><p>Hi there,</p>
<p>Let's see if we can get some more information about that asset
that is appearing there. When you have a moment, can you or your
DBA execute the following query and attach the results
here?:<br></p>
<pre>
<code>select id, name, cachePath, isCurrentVersion, isWorkingCopy, isRecycled from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'</code>
</pre>
Thanks!</div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T14:42:19Z2016-02-03T19:30:28ZBulk Change phantom page<div><pre>
<code>+----------------------------------+------------+---------------------------------+------------------+---------------+------------+
| id | name | cachePath | isCurrentVersion | isWorkingCopy | isRecycled |
+----------------------------------+------------+---------------------------------+------------------+---------------+------------+
| b07fe6b9956aa0783236eb661037f6cb | News Story | news/stories/2015/06/News Story | 0 | 0 | 0 |
+----------------------------------+------------+---------------------------------+------------------+---------------+------------+
1 row in set (0.00 sec)</code>
</pre></div>shopmyestag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T14:57:45Z2015-08-19T14:57:45ZBulk Change phantom page<div><p>Interesting. OK, I guess at this point I'll need to see some of
the other fields since I wasn't expecting that output. Can you run
this instead?:<br></p>
<pre>
<code>select * from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'</code>
</pre>
Sorry for not having you run that the first time. I was just trying
to make the output more easy to read by having the main columns I
was interested in being outputted.
<p>I'd also like for you to run this query:<br></p>
<pre>
<code>select * from cxml_foldercontent where nextVersionId = 'b07fe6b9956aa0783236eb661037f6cb' or prevVersionId = 'b07fe6b9956aa0783236eb661037f6cb'</code>
</pre>
and let us know the results.
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:15:27Z2016-02-03T19:30:28ZBulk Change phantom page<div><p>This one looks way uglier ;)</p>
<pre>
<code>+-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
| assetType | id | name | cachePath
| parentFolderId | metadataId
| lockId | relativeOrder | isRecycled | permissionsId |
metadataSetId | displayName | author | title
| keywords | summary | teaser
| description | startDate | endDate |
reviewDate | expirationFolderId | expirationNoticeSent |
firstExpirationWarningSent | secondExpirationWarningSent | workflowId |
workflowComment | isCurrentVersion | nextVersionId | prevVersionId |
versionDate | originalCopyId | workingCopyId | isWorkingCopy |
lastDatePublished | shouldBePublished | lastPublishedBy | shouldBeIndexed |
xmlId | blockType | blockIndexedFolderId | blockDepthOfIndex |
blockIndexTypesBitmask | blockIndexContentBitmask | blockIndexOtherBitmask
| blockSortOption | blockMaxRenderedEntities | blockFeedURL |
blockIncludePageXML | maintainAbsoluteLinks | fileBlobId |
fileRewriteFileContents | folderPublishMergeFolderId | folderIsRoot |
structuredDataId | structuredDataDefinitionId |
pageConfigurationSetId | pageStructuredDataVersion | templateTargetId |
templateStylesheetId | symlinkLink | referenceBlockId | referenceFileId |
referenceFolderId | referencePageId | referenceStylesheetId |
referenceSymlinkId | referenceTemplateId | recycleRecordId | byteLength |
draftOriginalId | draftUserId | contentTypeId |
blockIndexedContentTypeId | blockSortOrder | indexBlockType | siteId
| folderWorkflowInheritDefs | folderWorkflowRequire |
blockTwitterAccountName | blockTwitterSearchString | blockTwitterQueryType
| blockTwitterDefaultStyle | blockTwitterExcludeJquery |
draftAssetFactoryId |
+-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
| PAG | b07fe6b9956aa0783236eb661037f6cb | News Story |
news/stories/2015/06/News Story | a04f945c956aa0783236eb66e61548d4 |
b07fe6b9956aa0783236eb66bf471b10 | NULL | 234881024 | 0 |
NULL | NULL | | | Union College and
the Lincoln Assassination | | | Profound and Pognant:
Union College Connection to the Civil War Era | | 1434945600000
| NULL | NULL | NULL | 0 |
0 | 0 | NULL |
| 0 | NULL | NULL | NULL |
NULL | NULL | 0 | NULL |
1 | NULL | 1 | NULL | NULL | NULL
| NULL | 2147483647 |
2147483647 | 0 | 1 |
0 | NULL | 0 | 0 | NULL
| NULL | NULL | 0
| b0810a75956aa0783236eb66921741f0 | NULL | NULL
| 2 | NULL | NULL
| NULL | NULL | NULL | NULL
| NULL | NULL | NULL | NULL
| NULL | 0 |
b07fe6b9956aa0783236eb661037f6cb | georgek | NULL | NULL
| 1 | NULL |
3999f49e956aa05200c85bbb4fad5038 | 1 |
1 | NULL | NULL | NULL
| 0 | 0 |
856a06fc956aa0520003c37ee3ea4e35 |
+-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
1 row in set (0.01 sec)</code>
</pre>
<p>And the second query returned no results.</p>
<p>Shawn Shopmyer</p>
<p>Systems Administrator</p>
<p>Union College</p>
<p>Schenectady, NY 12308</p>
<p>phone: 518.388.6312</p>
<p>email: <a href="mailto:shopmyes@union.edu">shopmyes@union.edu</a></p></div>shopmyestag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:20:01Z2015-08-19T15:20:01ZBulk Change phantom page<div><p>Ha, that's what I was afraid of. Maybe try the <code>\G</code>
option at the end of the query?:<br></p>
<pre>
<code>select * from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'\G</code>
</pre></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:26:16Z2016-02-03T19:30:28ZBulk Change phantom page<div><p>You're my new best friend, that's fantastic:</p>
<p>*************************** 1. row
***************************</p>
<pre>
<code> assetType: PAG
id: b07fe6b9956aa0783236eb661037f6cb
name: News Story
cachePath: news/stories/2015/06/News Story
parentFolderId: a04f945c956aa0783236eb66e61548d4
metadataId: b07fe6b9956aa0783236eb66bf471b10
lockId: NULL
relativeOrder: 234881024
isRecycled: 0
permissionsId: NULL
metadataSetId: NULL
displayName:
author:
title: Union College and the Lincoln Assassination
keywords:
summary:
teaser: Profound and Pognant: Union College Connection</code>
</pre>
<p>to the Civil War Era</p>
<pre>
<code> description:
startDate: 1434945600000
endDate: NULL
reviewDate: NULL
expirationFolderId: NULL
expirationNoticeSent: 0</code>
</pre>
<p>firstExpirationWarningSent: 0</p>
<p>secondExpirationWarningSent: 0</p>
<pre>
<code> workflowId: NULL
workflowComment:
isCurrentVersion: 0
nextVersionId: NULL
prevVersionId: NULL
versionDate: NULL
originalCopyId: NULL
workingCopyId: NULL
isWorkingCopy: 0
lastDatePublished: NULL
shouldBePublished: 1
lastPublishedBy: NULL
shouldBeIndexed: 1
xmlId: NULL
blockType: NULL
blockIndexedFolderId: NULL
blockDepthOfIndex: NULL
blockIndexTypesBitmask: 2147483647</code>
</pre>
<p>blockIndexContentBitmask: 2147483647</p>
<pre>
<code> blockIndexOtherBitmask: 0
blockSortOption: 1</code>
</pre>
<p>blockMaxRenderedEntities: 0</p>
<pre>
<code> blockFeedURL: NULL
blockIncludePageXML: 0
maintainAbsoluteLinks: 0
fileBlobId: NULL
fileRewriteFileContents: NULL</code>
</pre>
<p>folderPublishMergeFolderId: NULL</p>
<pre>
<code> folderIsRoot: 0
structuredDataId: b0810a75956aa0783236eb66921741f0</code>
</pre>
<p>structuredDataDefinitionId: NULL</p>
<pre>
<code> pageConfigurationSetId: NULL</code>
</pre>
<p>pageStructuredDataVersion: 2</p>
<pre>
<code> templateTargetId: NULL
templateStylesheetId: NULL
symlinkLink: NULL
referenceBlockId: NULL
referenceFileId: NULL
referenceFolderId: NULL
referencePageId: NULL
referenceStylesheetId: NULL
referenceSymlinkId: NULL
referenceTemplateId: NULL
recycleRecordId: NULL
byteLength: 0
draftOriginalId: b07fe6b9956aa0783236eb661037f6cb
draftUserId: georgek
contentTypeId: NULL</code>
</pre>
<p>blockIndexedContentTypeId: NULL</p>
<pre>
<code> blockSortOrder: 1
indexBlockType: NULL
siteId: 3999f49e956aa05200c85bbb4fad5038</code>
</pre>
<p>folderWorkflowInheritDefs: 1</p>
<pre>
<code> folderWorkflowRequire: 1
blockTwitterAccountName: NULL</code>
</pre>
<p>blockTwitterSearchString: NULL</p>
<pre>
<code> blockTwitterQueryType: NULL</code>
</pre>
<p>blockTwitterDefaultStyle: 0</p>
<p>blockTwitterExcludeJquery: 0</p>
<pre>
<code> draftAssetFactoryId: 856a06fc956aa0520003c37ee3ea4e35</code>
</pre>
<p>1 row in set (0.00 sec)</p>
<p>ERROR:</p>
<p>No query specified</p>
<p>I don't know why I got the error at the end though.</p>
<p>Shawn Shopmyer</p>
<p>Systems Administrator</p>
<p>Union College</p>
<p>Schenectady, NY 12308</p>
<p>phone: 518.388.6312</p>
<p>email: <a href="mailto:shopmyes@union.edu">shopmyes@union.edu</a></p></div>shopmyestag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:36:32Z2015-08-19T15:36:32ZBulk Change phantom page<div><p>Awesome. Thanks, Shawn! OK, it looks like that particular Page
is a Draft from the user <code>georgek</code>. Drafts shouldn't be
appearing in that interface, so I'm filing a bug report to have us
address this. I'll attach it to this issue shortly.</p>
<p>In the meantime, you can simply ignore that asset (by unchecking
it prior to performing your Bulk Change) - or - you can have that
User delete the Draft or merge the changes into the current
version.</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:39:05Z2015-08-19T15:39:05ZBulk Change phantom page<div><p>OK, I went ahead and filed an issue for this which I've attached
to this ticket. You'll see it on the right-hand side of the
discussion with a state of 'open'. When we have addressed the
issue, that state will change to 'closed' or 'resolved'. At that
point you can keep an eye out on our Release Notes for any new
versions we make available to see if that bug fix was added.</p>
<p>Thanks for the report and let me know if you all have any
additional questions!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/376934902015-08-19T15:52:57Z2015-08-19T15:52:57ZBulk Change phantom page<div><p>Thank you, Tim and Shawn, for helping me troubleshoot this. I'll
look for the fix in an upcoming release and let
<code>georgek</code> know about his draft in the meantime.</p>
<p>Erik</p></div>espanae