[MKDoc-users] Trouble moving pages

adam moran adam@mkdoc.com
Mon, 04 Mar 2002 13:59:28 +0000


hi donald

> What am I doing wrong?

nothing - it's our fault - jean-michel is looking at it now 

adam

Donald Blackstock wrote:
> 
> 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')

-- 
Adam Moran - Contracts Manager
http://webarchitects.co.uk 
http://mkdoc.com http://webarch.co.uk
mailto:adam@webarchitects.co.uk