[MKDoc-users] Trouble moving pages
Donald Blackstock
donald.blackstock@casmir.net
Mon, 4 Mar 2002 13:45:40 -0000
Hello
I am having bother with the "move" command.
I made a contact-us page under the index page then, being mixed up, put a
contact-details page under that. The contact-details has all the
information so I just wanted to move it up the hierarchy and then I could
delete contact-us.
In the contact-details page, clicked on "move" from the toolbar. It said
"select new parent", I chose the index page and was met with the message
below.
What am I doing wrong?
Donald
A software error has occurred:
------------------------------
Dump:
-----
$VAR1 = bless( {
'code' => 'RUNTIME_ERROR',
'info' => 'DBD::mysql::db do failed: Duplicate entry
\'/contact-details/\' for key 2 at ../lib/sql/MySQL.pm line 304, <FP> line
30369.
'
}, 'lib::Exception' );
A software error has occurred:
------------------------------
Dump:
-----
$VAR1 = bless( {
'code' => 'RUNTIME_ERROR',
'info' => 'DBD::mysql::db do failed: Duplicate entry
\'/contact-details/\' for key 2 at ../lib/sql/MySQL.pm line 304, <FP> line
30369.
'
}, 'lib::Exception' );
SQL:
----
SELECT *
FROM Document
WHERE (Full_Path = '/contact-details/contact-details/')
SELECT *
FROM Redirect
WHERE (Old_Path = '/contact-details/contact-details/')
SELECT *
FROM Document
WHERE (Full_Path = '/contact-details/contact-details/')
SELECT *
FROM Session
WHERE (ID = 'XXBXLMUSRQFMVOESHXEOAAOMRDDPLZQKZSUAESOSCHYKTNFKMJ')
UPDATE Session SET ID =
'XXBXLMUSRQFMVOESHXEOAAOMRDDPLZQKZSUAESOSCHYKTNFKMJ', Last_Time =
'1015249630', Editor_ID = '2', IP = '146.87.156.19' WHERE (ID =
'XXBXLMUSRQFMVOESHXEOAAOMRDDPLZQKZSUAESOSCHYKTNFKMJ')
SELECT *
FROM Editor
WHERE (ID = '2')
DELETE FROM Session WHERE (Last_Time < '1015242430')
SELECT *
FROM Document
WHERE (Full_Path = '/contact-details/contact-details/')
SELECT *
FROM Base_Document
WHERE (Editor_ID = '2')
SELECT *
FROM Document
WHERE (ID = '21')
SELECT *
FROM Document
WHERE (ID = '1')
SELECT *
FROM Document
WHERE (Full_Path = '/contact-details/contact-details/')
SELECT *
FROM Document
WHERE (ID = '12')
SELECT *
FROM Document
WHERE (ID = '1')
SELECT *
FROM Document
WHERE (ID = '1')
SELECT *
FROM Document
WHERE (Full_Path LIKE '/contact-details/contact-details/_%')
SELECT count(*)
FROM Document
WHERE (Parent_ID = '1')
SELECT *
FROM Document
WHERE (ID = '12')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Description')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Order_By')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Body')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Lang')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Full_Path')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Sibling_Position')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Name')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Keywords')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Editor_Last_Modified_ID')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Title')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Date_Created')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Cache_Control')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Parent_ID')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Sort_By')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Editor_Created_ID')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Template')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name = 'ID')
DELETE FROM Document_Index WHERE (Record_ID = '12') AND (Column_Name =
'Date_Last_Modified')
SELECT *
FROM Document
WHERE (ID = '12')
DELETE FROM Document_Index WHERE (ID = '12')
UPDATE Document SET Description = 'Contact details', Order_By = '0', Lang =
'en', Body = '<block id=\"flo_block_1\"
type=\"text\">\nPhone\r\n\r\naddress\r\n\r\nemail\r\n\r\ncharity
number\r\n\r\n\n</block>\n<block id=\"flo_block_2\" type=\"link\">\n<a
href=\"http://www.bbc.co.uk\" title=\"it is the bbc\">bbc</a>\n</block>',
Full_Path = '/contact-details/', Sibling_Position = '5', Source = NULL, Name
= 'contact-details', Keywords = 'Contact details', Editor_Last_Modified_ID =
'2', Relation = NULL, Title = 'Contact details', Date_Created = '2002-02-28
14:01:12', Coverage = NULL, Cache_Control = '10', Parent_ID = '1', Publisher
= '', Sort_By = 'Title', ID = '12', Template = 'default_inline_links',
Editor_Created_ID = '2', Rights = '', Date_Last_Modified = '2002-03-04
13:41:44' WHERE (ID = '12')