[MKDoc-users] Trouble moving pages
Kevin Morris
kevin_morris@becta.org.uk
Mon, 4 Mar 2002 13:54:09 -0000
Donald
If you look in the error, you will see the problem occured due to a
duplicate. u cant have 2 entries with the same uri. best just to delete
the page with nothing on, then do the move again. that should work fine.
Regards
Kevin Morris
Web Maintenance Officer
Becta
Email: kevin_morris@becta.org.uk
> -----Original Message-----
> From: Donald Blackstock [SMTP:donald.blackstock@casmir.net]
> Sent: 04 March 2002 13:46
> To: mkdoc-users@lists.webarch.co.uk
> Subject: [MKDoc-users] Trouble moving pages
>
> 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')
>
>
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
Becta
www.mimesweeper.com
**********************************************************************