Problems with CMSMS after upgrade

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Problems with CMSMS after upgrade

Post by djkirstyjay »

I have recently upgraded CMSMS to 1.4.1 Spring Garden on my site www.armadasur.com and am having problems with the news module.

Whenever I try to add a news article, I get the following error.
DEBUG: SQL = INSERT INTO cms_module_news (news_id, news_category_id, news_title, news_data, summary, status, news_date, start_time, end_time, create_date, modified_date,author_id,news_extra) VALUES (22,'1','Testing','

test
','','published','2008-09-07 17:02:49','2008-09-07 17:02:49',NULL,'2008-09-07 17:03:08','2008-09-07 17:03:08','1','')
Duplicate entry '22' for key 1
Can anyone give me any advice?

I cannot remember what I upgraded it from, as I did it few weeks ago, got the error and left it alone for a while, as I was busy with other stuff which I needed to get done, however it was quite a few levels back... I *think* as far back as 1.1.1, but can't be certain.

Thanks in advance!

Kirsty
Jean le Chauve

Re: Problems with CMSMS after upgrade

Post by Jean le Chauve »

Take a look into your BD : Duplicate entry '22' for key 1
You are trying insert a news_id(22) who exist into your cms_module_news.
Perhaps can you delete that news and try again.
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

I was wondering why it did it though! However... I backed up the news part of the database and unistalled it, then installed the latest version of news, imported the news again and now it's working fine... however, there's a new problem :

I can edit existing pages fine, but when I go to add one, it says it's worked and the new page has added, but the new page isn't there? ???
alby

Re: Problems with CMSMS after upgrade

Post by alby »

djkirstyjay wrote: I was wondering why it did it though! However... I backed up the news part of the database and unistalled it, then installed the latest version of news, imported the news again and now it's working fine... however, there's a new problem :

I can edit existing pages fine, but when I go to add one, it says it's worked and the new page has added, but the new page isn't there? ???
Check in DB if you have "news_extra" field in module_news table

Alby
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

This isn't a problem with the news now... this is with the main pages. Would that be effected by news_extra?

I have the following News tables in the DB :

cms_module_news
cms_module_news_categories
cms_module_news_categories_seq
cms_module_news_fielddefs
cms_module_news_fieldvals
cms_module_news_seq

and the following tables in the ENTIRE DB :

cms_additional_htmlblob_users
cms_additional_htmlblob_users_seq
cms_additional_users
cms_additional_users_seq
cms_adminlog
cms_admin_bookmarks
cms_admin_bookmarks_seq
cms_admin_recent_pages
cms_admin_recent_pages_seq
cms_content
cms_content_props
cms_content_props_seq
cms_content_seq
cms_crossref
cms_css
cms_css_assoc
cms_css_seq
cms_events
cms_events_seq
cms_event_handlers
cms_event_handler_seq
cms_groups
cms_groups_seq
cms_group_perms
cms_group_perms_seq
cms_htmlblobs
cms_htmlblobs_seq
cms_modules
cms_module_album_albums
cms_module_album_albums_seq
cms_module_album_categories
cms_module_album_categories_seq
cms_module_album_category_listings
cms_module_album_category_listings_seq
cms_module_album_pictures
cms_module_album_pictures_seq
cms_module_banners
cms_module_banners_categories
cms_module_banners_categories_seq
cms_module_banners_hits
cms_module_banners_seq
cms_module_bookmarks
cms_module_bookmarks_categories
cms_module_bookmarks_categories_seq
cms_module_bookmarks_seq
cms_module_bookmarks_to_categories
cms_module_calendar_categories
cms_module_calendar_categories_seq
cms_module_calendar_events
cms_module_calendar_events_seq
cms_module_calendar_events_to_categories
cms_module_comments
cms_module_comments_seq
cms_module_deps
cms_module_fb_field
cms_module_fb_field_opt
cms_module_fb_field_opt_seq
cms_module_fb_field_seq
cms_module_fb_flock
cms_module_fb_form
cms_module_fb_form_attr
cms_module_fb_form_attr_seq
cms_module_fb_form_seq
cms_module_fb_ip_log
cms_module_fb_ip_log_seq
cms_module_fb_resp
cms_module_fb_resp_attr
cms_module_fb_resp_attr_seq
cms_module_fb_resp_seq
cms_module_fb_resp_val
cms_module_fb_resp_val_seq
cms_module_feusers_belongs
cms_module_feusers_dropdowns
cms_module_feusers_grouppropmap
cms_module_feusers_groups
cms_module_feusers_groups_seq
cms_module_feusers_history
cms_module_feusers_loggedin
cms_module_feusers_propdefn
cms_module_feusers_properties
cms_module_feusers_properties_seq
cms_module_feusers_tempcode
cms_module_feusers_users
cms_module_feusers_users_seq
cms_module_news
cms_module_news_categories
cms_module_news_categories_seq
cms_module_news_fielddefs
cms_module_news_fieldvals
cms_module_news_seq
cms_module_pollblocked
cms_module_polloptions
cms_module_polloptions_seq
cms_module_polls
cms_module_polls_seq
cms_module_search_index
cms_module_search_items
cms_module_search_items_seq
cms_module_search_words
cms_module_selfreg_properties
cms_module_selfreg_properties_seq
cms_module_selfreg_users
cms_module_selfreg_users_seq
cms_module_templates
cms_pages_seq
cms_permissions
cms_permissions_seq
cms_siteprefs
cms_templates
cms_templates_seq
cms_userplugins
cms_userplugins_seq
cms_userprefs
cms_users
cms_users_seq
cms_user_groups
cms_version
alby

Re: Problems with CMSMS after upgrade

Post by alby »

djkirstyjay wrote: This isn't a problem with the news now... this is with the main pages. Would that be effected by news_extra?
No, sorry my mistake ......
active debug in config.php and look server logs also when you save a new page

Alby
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

EEK! It don't look good!!!

Code: Select all

Debug is on. Redirecting disabled... Please click this link to continue.
http://www.armadasur.com/content/admin/listcontent.php?message=contentadded

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )

DELETE FROM cms_content_props WHERE content_id = ? AND prop_name = ?

INSERT INTO cms_content_props ( content_id, type, prop_name, param1, param2, param3, content, modified_date ) VALUES ( ?,?,?,'','','',?,'2008-09-08 08:04:43' )
Debug: (2.2000000000022E-05) - (777180)

loading smarty

Debug: (0.009942) - (1036160)

loading adodb

Debug: (0.014054) - (1116756)

loading page functions

Debug: (0.020397) - (1258240)

loading content functions

Debug: (0.026579) - (1459996)

loading pageinfo functions

Debug: (0.027925) - (1488052)

loading translation functions

Debug: (0.028989) - (1505772)

loading events functions

Debug: (0.031914) - (1587328)

loading php4 entity decode functions

Debug: (0.038045) - (1789900)

done loading files

Debug: (0.066705) - (2482200)

<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>

Debug: (0.073219) - (2558240)

<br>
(mysql): SELECT * FROM cms_userplugins<br>
 Error (0): <br>

Debug: (0.139021) - (3239224)

<br>
(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name<br>
 Error (0): <br>

Debug display of 'End of include':(0.321842) - (8914076)
Debug: (0.322004) - (8873708)

Session found.  Moving on...

Debug: (0.322081) - (8873752)

Session found.  Moving on...

Debug: (0.343098) - (9501608)

Session found.  Moving on...

Debug: (0.343921) - (9505224)

<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.34431) - (9506468)

Session found.  Moving on...

Debug: (0.347435) - (9602228)

Session found.  Moving on...

Debug: (0.351843) - (9676948)

<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
                     WHERE ug.user_id = '1' AND ug.group_id = 1<br>
 Error (0): <br>

Debug: (0.352541) - (9678900)

<br>
(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '1'<br>
 Error (0): <br>

Debug: (0.353221) - (9689208)

Session found.  Moving on...

Debug: (0.35515) - (9698580)

Session found.  Moving on...

Debug: (0.362335) - (9754028)

Session found.  Moving on...

Debug: (0.364072) - (9772436)

Session found.  Moving on...

Debug: (0.364475) - (9772764)

Session found.  Moving on...

Debug: (0.364899) - (9773416)

Session found.  Moving on...

Debug: (0.3723) - (9856964)

Session found.  Moving on...

Debug: (0.385534) - (9913384)

Session found.  Moving on...

Debug: (0.386656) - (9913432)

Session found.  Moving on...

Debug: (0.388378) - (9926944)

Session found.  Moving on...

Debug: (0.390003) - (9938912)

Session found.  Moving on...

Debug: (0.391213) - (9939772)

Session found.  Moving on...

Debug: (0.392927) - (9949240)

Session found.  Moving on...

Debug: (0.393449) - (9949656)

Session found.  Moving on...

Debug: (0.393906) - (9950292)

Session found.  Moving on...

Debug: (0.396051) - (9972644)

Session found.  Moving on...

Debug: (0.397459) - (9980356)

Session found.  Moving on...

Debug: (0.39953) - (9999260)

Session found.  Moving on...

Debug: (0.40526) - (10075136)

<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.406181) - (10076588)

<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
 Error (0): <br>

Debug: (0.408754) - (10080080)

<br>
(mysql): SELECT user_id,content_id FROM cms_additional_users<br>
 Error (0): <br>

Debug: (0.423344) - (10193840)

<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>

Debug display of 'Load Content Operations':(0.424064) - (10183032)
Debug display of 'End Load Content Operations':(0.437231) - (10595564)
Debug: (0.446262) - (10819176)

<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '15'<br>
 Error (0): <br>

Debug: (0.446808) - (10822596)

load properties called

Debug: (0.44749) - (10824376)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = -1<br>
 Error (0): <br>

Debug: (0.447674) - (10824804)

setpropertyvalue called

Debug: (0.44776) - (10824804)

setpropertyvalue called

Debug: (0.44783) - (10824804)

setpropertyvalue called

Debug: (0.447899) - (10824804)

setpropertyvalue called

djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

and more...

Code: Select all

Debug: (0.447967) - (10824804)

setpropertyvalue called

Debug: (0.448035) - (10824804)

setpropertyvalue called

Debug: (0.448164) - (10824804)

setpropertyvalue called

Debug: (0.453129) - (10848468)

<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'test'<br>
 Error (0): <br>

Debug: (0.456429) - (10844700)

<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'test'<br>
 Error (0): <br>

Debug: (0.458782) - (10868008)

<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC<br>
 Error (0): <br>

Debug: (0.460162) - (10873452)

<br>
(mysql): SELECT max(item_order) as new_order FROM cms_content WHERE parent_id = '-1'<br>
 Error (0): <br>

Debug: (0.481055) - (10874392)

<br>
(mysql): update cms_content_seq set id=LAST_INSERT_ID(id+1);<br>
 Error (0): <br>

Debug: (0.482496) - (10878024)

<br>
(mysql): INSERT INTO cms_content (content_id, content_name, content_alias, type, owner_id, parent_id, template_id, item_order, hierarchy, id_hierarchy, active, default_content, show_in_menu, cachable, menu_text, markup, metadata, titleattribute, accesskey, tabindex, last_modified_by, create_date, modified_date) VALUES (0,'test','test','content','1','-1','15',13,'','',1,0,1,1,'test','html','','','','','1','2008-09-08 08:04:43','2008-09-08 08:04:43')<br>
 Error (1062): Duplicate entry '0' for key 1<br>

Debug: (0.482641) - (10877416)

save from 1147

Debug: (0.485397) - (10877184)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'content_en'<br>
 Error (0): <br>

Debug: (0.486421) - (10879372)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','content_en','','','','<p>test page</p>','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.487817) - (10878912)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'target'<br>
 Error (0): <br>

Debug: (0.488804) - (10880668)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','target','','','','','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.489971) - (10880140)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'pagedata'<br>
 Error (0): <br>

Debug: (0.496193) - (10881672)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','pagedata','','','','','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.497422) - (10881132)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'extra1'<br>
 Error (0): <br>

Debug: (0.498294) - (10882644)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','extra1','','','','','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.501629) - (10882116)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'extra2'<br>
 Error (0): <br>

Debug: (0.502448) - (10883628)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','extra2','','','','','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.503785) - (10883096)

<br>
(mysql): DELETE FROM cms_content_props WHERE content_id = 0 AND prop_name = 'extra3'<br>
 Error (0): <br>

Debug: (0.504905) - (10884608)

<br>
(mysql): 
        INSERT INTO cms_content_props 
        (
          content_id, 
          type, 
          prop_name, 
          param1, 
          param2, 
          param3, 
          content,
          modified_date
        ) 
          VALUES 
        (
          0,'string','extra3','','','','','2008-09-08 08:04:43'
        )
      <br>
 Error (0): <br>

Debug: (0.521775) - (10884392)

<br>
(mysql): DELETE FROM cms_crossref WHERE parent_id = 0 AND parent_type = 'content'<br>
 Error (0): <br>

Debug: (0.522507) - (10884040)

calling module Search from event ContentEditPost

Debug: (0.537245) - (10884460)

<br>
(mysql): SELECT id FROM cms_module_search_items WHERE
                  extra_attr = 'template' AND content_id = '15' LIMIT 1<br>
 Error (0): <br>

Debug: (0.537457) - (10884796)

properties called

Debug: (0.539191) - (10885508)

<br>
(mysql): DELETE FROM cms_module_search_items WHERE module_name='Search' AND content_id=0 AND extra_attr='content'<br>
 Error (0): <br>

Debug: (0.571117) - (10885728)

<br>
(mysql): DELETE FROM cms_module_search_index WHERE item_id NOT IN (SELECT id FROM cms_module_search_items)<br>
 Error (0): <br>

Debug: (0.575623) - (10891460)

<br>
(mysql): SELECT id FROM cms_module_search_items WHERE module_name='Search' AND content_id=0 AND extra_attr='content'<br>
 Error (0): <br>

Debug: (0.58904) - (10892532)

<br>
(mysql): update cms_module_search_items_seq set id=LAST_INSERT_ID(id+1);<br>
 Error (0): <br>

Debug: (0.590429) - (10893088)

<br>
(mysql): INSERT INTO cms_module_search_items (id, module_name, content_id, extra_attr, expires) VALUES (78,'Search',0,'content',NULL)<br>
 Error (0): <br>

Debug: (0.593322) - (10893028)

<br>
(mysql): INSERT INTO cms_module_search_index (item_id, word, count) VALUES (78,'test',5)<br>
 Error (0): <br>

Debug: (0.594181) - (10893284)

<br>
(mysql): INSERT INTO cms_module_search_index (item_id, word, count) VALUES (78,'page',1)<br>
 Error (0): <br>

Debug: (0.595125) - (10888052)

<br>
(mysql): SELECT content_id FROM cms_content<br>
 Error (0): <br>

Debug: (0.597244) - (10889472)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '0'<br>
 Error (0): <br>

Debug: (0.59825) - (10890452)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'<br>
 Error (0): <br>

Debug: (0.599997) - (10891224)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '0'<br>
 Error (0): <br>

Debug: (0.600257) - (10891424)

Number of elements: 4
Array
(
    [0] => 00004.00003
    [1] => 44.0
    [2] => content_en,extra1,extra2,extra3,pagedata,target,url
    [3] => 0
)

Debug: (0.60314) - (10892840)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00004.00003', id_hierarchy = '44.0', hierarchy_path = 'sponsors/malibu-park', prop_names = 'content_en,extra1,extra2,extra3,pagedata,target,url' WHERE content_id = '0'<br>
 Error (0): <br>

Debug: (0.604234) - (10891228)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '30'<br>
 Error (0): <br>

Debug: (0.605704) - (10891728)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '30'<br>
 Error (0): <br>

Debug: (0.60589) - (10891956)

Number of elements: 4
Array
(
    [0] => 00001
    [1] => 30
    [2] => content_en,bottom
    [3] => 30
)

Debug: (0.606845) - (10893028)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00001', id_hierarchy = '30', hierarchy_path = 'as_test', prop_names = 'content_en,bottom' WHERE content_id = '30'<br>
 Error (0): <br>

Debug: (0.608097) - (10892324)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '32'<br>
 Error (0): <br>

Debug: (0.609408) - (10892740)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '32'<br>
 Error (0): <br>

Debug: (0.60958) - (10892988)

Number of elements: 4
Array
(
    [0] => 00002
    [1] => 32
    [2] => content_en
    [3] => 32
)

Debug: (0.610549) - (10893972)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00002', id_hierarchy = '32', hierarchy_path = 'about_us', prop_names = 'content_en' WHERE content_id = '32'<br>
 Error (0): <br>

Debug: (0.611611) - (10893448)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '33'<br>
 Error (0): <br>

Debug: (0.612872) - (10893716)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '32'<br>
 Error (0): <br>

Debug: (0.614267) - (10894056)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '33'<br>
 Error (0): <br>

Debug: (0.614444) - (10894256)

Number of elements: 4
Array
(
    [0] => 00002.00001
    [1] => 32.33
    [2] => content_en
    [3] => 33
)

Debug: (0.616209) - (10895508)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00002.00001', id_hierarchy = '32.33', hierarchy_path = 'about_us/armada_sur', prop_names = 'content_en' WHERE content_id = '33'<br>
 Error (0): <br>

Debug: (0.617485) - (10894856)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '34'<br>
 Error (0): <br>

Debug: (0.619246) - (10895064)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '32'<br>
 Error (0): <br>

Debug: (0.621222) - (10895404)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '34'<br>
 Error (0): <br>

Debug: (0.621402) - (10895592)

Number of elements: 4
Array
(
    [0] => 00002.00002
    [1] => 32.34
    [2] => content_en
    [3] => 34
)

Debug: (0.622299) - (10896672)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00002.00002', id_hierarchy = '32.34', hierarchy_path = 'about_us/members', prop_names = 'content_en' WHERE content_id = '34'<br>
 Error (0): <br>

Debug: (0.623106) - (10896248)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.624339) - (10896456)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.624715) - (10896644)

Number of elements: 4
Array
(
    [0] => 00003
    [1] => 35
    [2] => content_en
    [3] => 35
)

Debug: (0.62556) - (10897544)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003', id_hierarchy = '35', hierarchy_path = 'CDT', prop_names = 'content_en' WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.626738) - (10897176)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '36'<br>
 Error (0): <br>

Debug: (0.627479) - (10897384)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.628719) - (10897592)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '36'<br>
 Error (0): <br>

Debug: (0.628904) - (10897780)

Number of elements: 4
Array
(
    [0] => 00003.00004
    [1] => 35.36
    [2] => target,url
    [3] => 36
)

Debug: (0.629913) - (10898780)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00004', id_hierarchy = '35.36', hierarchy_path = 'CDT/', prop_names = 'target,url' WHERE content_id = '36'<br>
 Error (0): <br>

Debug: (0.631005) - (10898376)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '37'<br>
 Error (0): <br>

Debug: (0.63185) - (10898584)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.633088) - (10898792)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '37'<br>
 Error (0): <br>

Debug: (0.633285) - (10898980)

Number of elements: 4
Array
(


    [0] => 00003.00001
    [1] => 35.37
    [2] => content_en,bottom
    [3] => 37
)

Debug: (0.6341) - (10899980)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00001', id_hierarchy = '35.37', hierarchy_path = 'CDT/news', prop_names = 'content_en,bottom' WHERE content_id = '37'<br>
 Error (0): <br>

Debug: (0.634958) - (10899556)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '38'<br>
 Error (0): <br>

Debug: (0.637232) - (10899764)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.638698) - (10899972)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '38'<br>
 Error (0): <br>

Debug: (0.638901) - (10900176)

Number of elements: 4
Array
(
    [0] => 00003.00005
    [1] => 35.38
    [2] => url,target,content_en
    [3] => 38
)

Debug: (0.639613) - (10901244)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00005', id_hierarchy = '35.38', hierarchy_path = 'CDT/listen_live', prop_names = 'url,target,content_en' WHERE content_id = '38'<br>
 Error (0): <br>

Debug: (0.640404) - (10900824)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '39'<br>
 Error (0): <br>

Debug: (0.641101) - (10901544)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.642429) - (10901804)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '39'<br>
 Error (0): <br>

Debug: (0.642625) - (10901996)

Number of elements: 4
Array
(
    [0] => 00003.00003
    [1] => 35.39
    [2] => content_en,target,url
    [3] => 39
)

Debug: (0.643654) - (10903004)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00003', id_hierarchy = '35.39', hierarchy_path = 'CDT/league_table', prop_names = 'content_en,target,url' WHERE content_id = '39'<br>
 Error (0): <br>

Debug: (0.644562) - (10902560)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '40'<br>
 Error (0): <br>

Debug: (0.646108) - (10902816)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.647813) - (10903088)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '40'<br>
 Error (0): <br>

Debug: (0.648037) - (10903276)

Number of elements: 4
Array
(
    [0] => 00003.00002
    [1] => 35.40
    [2] => content_en,extra1,extra2,extra3,pagedata,target
    [3] => 40
)

Debug: (0.648946) - (10904568)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00002', id_hierarchy = '35.40', hierarchy_path = 'CDT/fixtures-results-cd-tenerife-football', prop_names = 'content_en,extra1,extra2,extra3,pagedata,target' WHERE content_id = '40'<br>
 Error (0): <br>

Debug: (0.650264) - (10903952)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '41'<br>
 Error (0): <br>

Debug: (0.650995) - (10904160)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.652499) - (10904512)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '41'<br>
 Error (0): <br>

Debug: (0.652728) - (10904700)

Number of elements: 4
Array
(
    [0] => 00003.00006
    [1] => 35.41
    [2] => content_en,extra1,extra2,extra3,pagedata,target
    [3] => 41
)

Debug: (0.653603) - (10905888)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00006', id_hierarchy = '35.41', hierarchy_path = 'CDT/the_team', prop_names = 'content_en,extra1,extra2,extra3,pagedata,target' WHERE content_id = '41'<br>
 Error (0): <br>

Debug: (0.655205) - (10905356)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '42'<br>
 Error (0): <br>

Debug: (0.65606) - (10905564)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.65793) - (10905880)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '42'<br>
 Error (0): <br>

Debug: (0.658158) - (10906080)

Number of elements: 4
Array
(
    [0] => 00003.00007
    [1] => 35.42
    [2] => content_en,extra1,extra2,extra3,pagedata,target
    [3] => 42
)

Debug: (0.659235) - (10907208)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00007', id_hierarchy = '35.42', hierarchy_path = 'CDT/the_manager', prop_names = 'content_en,extra1,extra2,extra3,pagedata,target' WHERE content_id = '42'<br>
 Error (0): <br>

Debug: (0.660483) - (10906676)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '43'<br>
 Error (0): <br>

Debug: (0.66147) - (10906884)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '35'<br>
 Error (0): <br>

Debug: (0.66303) - (10907340)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '43'<br>
 Error (0): <br>

Debug: (0.663221) - (10907528)

Number of elements: 4
Array
(
    [0] => 00003.00008
    [1] => 35.43
    [2] => url,target
    [3] => 43
)

Debug: (0.66455) - (10908424)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00003.00008', id_hierarchy = '35.43', hierarchy_path = 'CDT/buy-tickets', prop_names = 'url,target' WHERE content_id = '43'<br>
 Error (0): <br>

Debug: (0.666836) - (10908000)

<br>
(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'<br>
 Error (0): <br>

Debug: (0.669021) - (10908208)

<br>
(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '44'<br>
 Error (0): <br>

Debug: (0.676195) - (10908436)

Number of elements: 4
Array
(
    [0] => 00004
    [1] => 44
    [2] => content_en
    [3] => 44
)

Debug: (0.677305) - (10909324)

<br>
(mysql): UPDATE cms_content SET hierarchy = '00004', id_hierarchy = '44', hierarchy_path = 'sponsors', prop_names = 'content_en' WHERE content_id = '44'<br>
 Error (0): <br>

djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

Debug: (0.679683) - (10908944)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '45'
Error (0):

Debug: (0.680986) - (10909152)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'
Error (0):

Debug: (0.682658) - (10909484)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '45'
Error (0):

Debug: (0.682883) - (10909672)

Number of elements: 4
Array
(
    [0] => 00004.00005
    [1] => 44.45
    [2] => target,url
    [3] => 45
)

Debug: (0.683934) - (10910728)


(mysql): UPDATE cms_content SET hierarchy = '00004.00005', id_hierarchy = '44.45', hierarchy_path = 'sponsors/', prop_names = 'target,url' WHERE content_id = '45'
Error (0):

Debug: (0.714443) - (10910308)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '46'
Error (0):

Debug: (0.716465) - (10910516)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'
Error (0):

Debug: (0.71816) - (10910724)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '46'
Error (0):

Debug: (0.718379) - (10910912)

Number of elements: 4
Array
(
    [0] => 00004.00004
    [1] => 44.46
    [2] => url,target
    [3] => 46
)

Debug: (0.721798) - (10911936)


(mysql): UPDATE cms_content SET hierarchy = '00004.00004', id_hierarchy = '44.46', hierarchy_path = 'sponsors/', prop_names = 'url,target' WHERE content_id = '46'
Error (0):

Debug: (0.813212) - (10911516)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '47'
Error (0):

Debug: (0.81433) - (10911724)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'
Error (0):

Debug: (0.816213) - (10911932)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '47'
Error (0):

Debug: (0.816401) - (10912120)

Number of elements: 4
Array
(
    [0] => 00004.00001

    [1] => 44.47
    [2] => url,target
    [3] => 47
)

Debug: (0.817359) - (10913120)


(mysql): UPDATE cms_content SET hierarchy = '00004.00001', id_hierarchy = '44.47', hierarchy_path = 'sponsors/', prop_names = 'url,target' WHERE content_id = '47'
Error (0):

Debug: (0.818447) - (10912700)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '48'
Error (0):

Debug: (0.819176) - (10912908)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'
Error (0):

Debug: (0.821164) - (10913116)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '48'
Error (0):

Debug: (0.821357) - (10913304)

Number of elements: 4
Array
(
    [0] => 00004.00002
    [1] => 44.48
    [2] => content_en,target,url
    [3] => 48
)

Debug: (0.822489) - (10914440)


(mysql): UPDATE cms_content SET hierarchy = '00004.00002', id_hierarchy = '44.48', hierarchy_path = 'sponsors/tenerife-football-store', prop_names = 'content_en,target,url' WHERE content_id = '48'
Error (0):

Debug: (0.823579) - (10913932)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '49'
Error (0):

Debug: (0.82467) - (10914140)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '44'
Error (0):

Debug: (0.826801) - (10914348)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '49'
Error (0):

Debug: (0.826995) - (10914536)

Number of elements: 4
Array
(
    [0] => 00004.00006
    [1] => 44.49
    [2] => content_en
    [3] => 49
)

Debug: (0.828044) - (10915492)


(mysql): UPDATE cms_content SET hierarchy = '00004.00006', id_hierarchy = '44.49', hierarchy_path = 'sponsors/sponsor_us', prop_names = 'content_en' WHERE content_id = '49'
Error (0):

Debug: (0.829247) - (10915076)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.830912) - (10915284)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '50'
Error (0):

Debug: (0.831083) - (10915472)

Number of elements: 4
Array
(
    [0] => 00005
    [1] => 50
    [2] => content_en
    [3] => 50
)

Debug: (0.83214) - (10916424)


(mysql): UPDATE cms_content SET hierarchy = '00005', id_hierarchy = '50', hierarchy_path = 'galleries', prop_names = 'content_en' WHERE content_id = '50'
Error (0):

Debug: (0.833238) - (10916032)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '51'
Error (0):

Debug: (0.8339) - (10916240)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.835348) - (10916552)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '51'
Error (0):

Debug: (0.835527) - (10916740)

Number of elements: 4
Array
(
    [0] => 00005.00006
    [1] => 50.51
    [2] => target,url
    [3] => 51
)

Debug: (0.836521) - (10917792)


(mysql): UPDATE cms_content SET hierarchy = '00005.00006', id_hierarchy = '50.51', hierarchy_path = 'galleries/', prop_names = 'target,url' WHERE content_id = '51'
Error (0):

Debug: (0.837367) - (10917368)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '52'
Error (0):

Debug: (0.838574) - (10917576)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.840571) - (10917784)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '52'
Error (0):

Debug: (0.840783) - (10917972)

Number of elements: 4
Array
(
    [0] => 00005.00005
    [1] => 50.52
    [2] => url,target
    [3] => 52
)

Debug: (0.841779) - (10918980)


(mysql): UPDATE cms_content SET hierarchy = '00005.00005', id_hierarchy = '50.52', hierarchy_path = 'galleries/', prop_names = 'url,target' WHERE content_id = '52'
Error (0):

Debug: (0.842671) - (10918556)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '53'
Error (0):

Debug: (0.843885) - (10918764)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.845116) - (10918972)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '53'
Error (0):

Debug: (0.845332) - (10919160)

Number of elements: 4
Array
(
    [0] => 00005.00004
    [1] => 50.53
    [2] => target,url
    [3] => 53
)

Debug: (0.846309) - (10920188)


(mysql): UPDATE cms_content SET hierarchy = '00005.00004', id_hierarchy = '50.53', hierarchy_path = 'galleries/', prop_names = 'target,url' WHERE content_id = '53'
Error (0):

Debug: (0.847247) - (10919764)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '54'
Error (0):

Debug: (0.848188) - (10919972)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.915641) - (10920180)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '54'
Error (0):

Debug: (0.915969) - (10920368)

Number of elements: 4
Array
(
    [0] => 00005.00003
    [1] => 50.54
    [2] => url,target
    [3] => 54
)

Debug: (0.918091) - (10921372)


(mysql): UPDATE cms_content SET hierarchy = '00005.00003', id_hierarchy = '50.54', hierarchy_path = 'galleries/', prop_names = 'url,target' WHERE content_id = '54'
Error (0):

Debug: (0.980527) - (10920948)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '55'
Error (0):

Debug: (0.981274) - (10921156)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.982529) - (10921364)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '55'
Error (0):

Debug: (0.982742) - (10921552)

Number of elements: 4
Array
(
    [0] => 00005.00002
    [1] => 50.55
    [2] => target,url
    [3] => 55
)

Debug: (0.985679) - (10922556)


(mysql): UPDATE cms_content SET hierarchy = '00005.00002', id_hierarchy = '50.55', hierarchy_path = 'galleries/', prop_names = 'target,url' WHERE content_id = '55'
Error (0):

Debug: (0.986909) - (10922132)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '56'
Error (0):

Debug: (0.987629) - (10922340)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (0.988937) - (10922548)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '56'
Error (0):

Debug: (0.989148) - (10922736)

Number of elements: 4
Array
(
    [0] => 00005.00001
    [1] => 50.56
    [2] => target,url
    [3] => 56
)
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

Debug: (0.99354) - (10923740)


(mysql): UPDATE cms_content SET hierarchy = '00005.00001', id_hierarchy = '50.56', hierarchy_path = 'galleries/', prop_names = 'target,url' WHERE content_id = '56'
Error (0):

Debug: (0.994643) - (10923316)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '57'
Error (0):

Debug: (1.002521) - (10923524)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '57'
Error (0):

Debug: (1.002731) - (10923712)

Number of elements: 4
Array
(
    [0] => 00006
    [1] => 57
    [2] => content_en
    [3] => 57
)

Debug: (1.003982) - (10924624)


(mysql): UPDATE cms_content SET hierarchy = '00006', id_hierarchy = '57', hierarchy_path = 'songs_vocab', prop_names = 'content_en' WHERE content_id = '57'
Error (0):

Debug: (1.004954) - (10924228)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '58'
Error (0):

Debug: (1.005602) - (10924436)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '57'
Error (0):

Debug: (1.006877) - (10924644)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '58'
Error (0):

Debug: (1.007096) - (10924832)

Number of elements: 4
Array
(
    [0] => 00006.00001
    [1] => 57.58
    [2] => target,url
    [3] => 58
)

Debug: (1.00784) - (10925892)


(mysql): UPDATE cms_content SET hierarchy = '00006.00001', id_hierarchy = '57.58', hierarchy_path = 'songs_vocab/', prop_names = 'target,url' WHERE content_id = '58'
Error (0):

Debug: (1.008726) - (10925460)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '59'
Error (0):

Debug: (1.009491) - (10925668)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '57'
Error (0):

Debug: (1.012687) - (10925876)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '59'
Error (0):

Debug: (1.012905) - (10926064)

Number of elements: 4
Array
(
    [0] => 00006.00002
    [1] => 57.59
    [2] => target,url
    [3] => 59
)

Debug: (1.01419) - (10927080)


(mysql): UPDATE cms_content SET hierarchy = '00006.00002', id_hierarchy = '57.59', hierarchy_path = 'songs_vocab/', prop_names = 'target,url' WHERE content_id = '59'
Error (0):

Debug: (1.015023) - (10926648)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '60'
Error (0):

Debug: (1.015754) - (10926856)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '57'
Error (0):

Debug: (1.017468) - (10927064)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '60'
Error (0):

Debug: (1.017716) - (10927252)

Number of elements: 4
Array
(
    [0] => 00006.00003
    [1] => 57.60
    [2] => target,url
    [3] => 60
)

Debug: (1.018644) - (10928296)


(mysql): UPDATE cms_content SET hierarchy = '00006.00003', id_hierarchy = '57.60', hierarchy_path = 'songs_vocab/', prop_names = 'target,url' WHERE content_id = '60'
Error (0):

Debug: (1.019592) - (10927864)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.020681) - (10928072)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '61'
Error (0):

Debug: (1.02086) - (10928260)

Number of elements: 4
Array
(
    [0] => 00007
    [1] => 61
    [2] => content_en
    [3] => 61
)

Debug: (1.021789) - (10929176)


(mysql): UPDATE cms_content SET hierarchy = '00007', id_hierarchy = '61', hierarchy_path = 'fun_stuff', prop_names = 'content_en' WHERE content_id = '61'
Error (0):

Debug: (1.022634) - (10928776)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '62'
Error (0):

Debug: (1.025504) - (10928984)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.027118) - (10929192)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '62'
Error (0):

Debug: (1.027707) - (10929380)

Number of elements: 4
Array
(
    [0] => 00007.00001
    [1] => 61.62
    [2] => content_en
    [3] => 62
)

Debug: (1.029748) - (10930416)


(mysql): UPDATE cms_content SET hierarchy = '00007.00001', id_hierarchy = '61.62', hierarchy_path = 'fun_stuff/wallpaper', prop_names = 'content_en' WHERE content_id = '62'
Error (0):

Debug: (1.033245) - (10930000)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '63'
Error (0):

Debug: (1.035998) - (10930208)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.037103) - (10930416)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '63'
Error (0):

Debug: (1.037288) - (10930604)

Number of elements: 4
Array
(
    [0] => 00007.00002
    [1] => 61.63
    [2] => content_en
    [3] => 63
)

Debug: (1.038275) - (10931660)


(mysql): UPDATE cms_content SET hierarchy = '00007.00002', id_hierarchy = '61.63', hierarchy_path = 'fun_stuff/screensaver', prop_names = 'content_en' WHERE content_id = '63'
Error (0):

Debug: (1.039494) - (10931212)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '64'
Error (0):

Debug: (1.040493) - (10931420)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '64'
Error (0):

Debug: (1.040672) - (10931608)

Number of elements: 4
Array
(
    [0] => 00008
    [1] => 64
    [2] => content_en
    [3] => 64
)

Debug: (1.041422) - (10932580)


(mysql): UPDATE cms_content SET hierarchy = '00008', id_hierarchy = '64', hierarchy_path = 'contact_us', prop_names = 'content_en' WHERE content_id = '64'
Error (0):

Debug: (1.042415) - (10932172)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '65'
Error (0):

Debug: (1.043044) - (10932380)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '64'
Error (0):

Debug: (1.043999) - (10932588)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '65'
Error (0):

Debug: (1.044193) - (10932776)

Number of elements: 4
Array
(
    [0] => 00008.00001
    [1] => 64.65
    [2] => target,url
    [3] => 65
)

Debug: (1.0449) - (10934828)


(mysql): UPDATE cms_content SET hierarchy = '00008.00001', id_hierarchy = '64.65', hierarchy_path = 'contact_us/', prop_names = 'target,url' WHERE content_id = '65'
Error (0):

Debug: (1.045924) - (10934404)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '66'
Error (0):

Debug: (1.046677) - (10934612)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '64'
Error (0):

Debug: (1.047616) - (10934820)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '66'
Error (0):

Debug: (1.047804) - (10935008)

Number of elements: 4
Array
(
    [0] => 00008.00002
    [1] => 64.66
    [2] => target,url
    [3] => 66
)

Debug: (1.050263) - (10936012)


(mysql): UPDATE cms_content SET hierarchy = '00008.00002', id_hierarchy = '64.66', hierarchy_path = 'contact_us/', prop_names = 'target,url' WHERE content_id = '66'
Error (0):

Debug: (1.051358) - (10935588)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '67'
Error (0):

Debug: (1.052216) - (10935796)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '64'
Error (0):

Debug: (1.053736) - (10936004)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '67'
Error (0):

Debug: (1.053942) - (10936192)

Number of elements: 4
Array
(
    [0] => 00008.00003
    [1] => 64.67
    [2] => content_en
    [3] => 67
)

Debug: (1.054716) - (10937176)


(mysql): UPDATE cms_content SET hierarchy = '00008.00003', id_hierarchy = '64.67', hierarchy_path = 'contact_us/email_us', prop_names = 'content_en' WHERE content_id = '67'
Error (0):

Debug: (1.055682) - (10936740)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.056887) - (10936948)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '68'
Error (0):

Debug: (1.057117) - (10937136)

Number of elements: 4
Array
(
    [0] => 00009
    [1] => 68
    [2] => content_en
    [3] => 68
)

Debug: (1.059472) - (10938084)


(mysql): UPDATE cms_content SET hierarchy = '00009', id_hierarchy = '68', hierarchy_path = 'links', prop_names = 'content_en' WHERE content_id = '68'
Error (0):

Debug: (1.060461) - (10937692)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.061242) - (10937900)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.063149) - (10938108)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '69'
Error (0):

Debug: (1.063327) - (10938296)

Number of elements: 4
Array
(
    [0] => 00009.00001
    [1] => 68.69
    [2] =>
    [3] => 69
)

Debug: (1.064095) - (10939236)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001', id_hierarchy = '68.69', hierarchy_path = 'links/footy_links', prop_names = '' WHERE content_id = '69'
Error (0):

Debug: (1.065087) - (10938848)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '70'
Error (0):

Debug: (1.065815) - (10939056)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.07193) - (10939296)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '70'
Error (0):

Debug: (1.072131) - (10939484)

Number of elements: 4
Array
(
    [0] => 00009.00002
    [1] => 68.70
    [2] =>
    [3] => 70
)

Debug: (1.073052) - (10940500)


(mysql): UPDATE cms_content SET hierarchy = '00009.00002', id_hierarchy = '68.70', hierarchy_path = 'links/useful_links', prop_names = '' WHERE content_id = '70'
Error (0):

Debug: (1.074022) - (10940084)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '71'
Error (0):

Debug: (1.074699) - (10940292)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.075899) - (10940524)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '71'
Error (0):

Debug: (1.076056) - (10940712)

Number of elements: 4
Array
(
    [0] => 00009.00003
    [1] => 68.71
    [2] =>
    [3] => 71
)

Debug: (1.079635) - (10941688)


(mysql): UPDATE cms_content SET hierarchy = '00009.00003', id_hierarchy = '68.71', hierarchy_path = 'links/funny_links', prop_names = '' WHERE content_id = '71'
Error (0):

Debug: (1.112336) - (10941300)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.113026) - (10941508)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.114508) - (10941716)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '72'
Error (0):

Debug: (1.114689) - (10941904)

Number of elements: 4
Array
(
    [0] => 00009.00004
    [1] => 68.72
    [2] =>
    [3] => 72
)

Debug: (1.115545) - (10942916)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004', id_hierarchy = '68.72', hierarchy_path = 'links/flights_accommodation', prop_names = '' WHERE content_id = '72'
Error (0):

Debug: (1.116614) - (10942480)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '73'
Error (0):

Debug: (1.117951) - (10942688)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.129966) - (10942896)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.131755) - (10943136)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '73'
Error (0):

Debug: (1.131981) - (10943324)

Number of elements: 4
Array
(
    [0] => 00009.00001.00002
    [1] => 68.69.73
    [2] => target,url
    [3] => 73
)

Debug: (1.132906) - (10944448)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001.00002', id_hierarchy = '68.69.73', hierarchy_path = 'links/footy_links/', prop_names = 'target,url' WHERE content_id = '73'
Error (0):

Debug: (1.133978) - (10944004)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '74'
Error (0):

Debug: (1.134822) - (10944212)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.136745) - (10944420)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.138049) - (10944628)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '74'
Error (0):

Debug: (1.138281) - (10944816)

Number of elements: 4
Array
(
    [0] => 00009.00001.00001
    [1] => 68.69.74
    [2] => target,url
    [3] => 74
)

Debug: (1.139397) - (10945952)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001.00001', id_hierarchy = '68.69.74', hierarchy_path = 'links/footy_links/', prop_names = 'target,url' WHERE content_id = '74'
Error (0):

Debug: (1.140416) - (10945508)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '75'
Error (0):

Debug: (1.141391) - (10945716)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.142402) - (10945924)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

Debug: (1.143678) - (10946132)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '75'
Error (0):

Debug: (1.143906) - (10946320)

Number of elements: 4
Array
(
    [0] => 00009.00001.00003
    [1] => 68.69.75
    [2] => target,url
    [3] => 75
)

Debug: (1.145167) - (10947496)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001.00003', id_hierarchy = '68.69.75', hierarchy_path = 'links/footy_links/', prop_names = 'target,url' WHERE content_id = '75'
Error (0):

Debug: (1.146183) - (10947052)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '76'
Error (0):

Debug: (1.146871) - (10947260)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.14746) - (10947468)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):


Debug: (1.148571) - (10947676)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '76'
Error (0):

Debug: (1.148761) - (10947864)

Number of elements: 4
Array
(
    [0] => 00009.00001.00004
    [1] => 68.69.76
    [2] => target,url
    [3] => 76
)

Debug: (1.149533) - (10949004)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001.00004', id_hierarchy = '68.69.76', hierarchy_path = 'links/footy_links/', prop_names = 'target,url' WHERE content_id = '76'
Error (0):

Debug: (1.150369) - (10948544)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '77'
Error (0):

Debug: (1.150963) - (10948752)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '69'
Error (0):

Debug: (1.151788) - (10948960)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.152937) - (10949168)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '77'
Error (0):

Debug: (1.153148) - (10949356)

Number of elements: 4
Array
(
    [0] => 00009.00001.00005
    [1] => 68.69.77
    [2] => target,url
    [3] => 77
)

Debug: (1.153834) - (10950532)


(mysql): UPDATE cms_content SET hierarchy = '00009.00001.00005', id_hierarchy = '68.69.77', hierarchy_path = 'links/footy_links/', prop_names = 'target,url' WHERE content_id = '77'
Error (0):

Debug: (1.15464) - (10950088)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '78'
Error (0):

Debug: (1.155552) - (10950296)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '70'
Error (0):

Debug: (1.156219) - (10950504)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.157256) - (10950712)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '78'
Error (0):

Debug: (1.157438) - (10950900)

Number of elements: 4
Array
(
    [0] => 00009.00002.00001
    [1] => 68.70.78
    [2] => target,url
    [3] => 78
)

Debug: (1.158963) - (10952056)


(mysql): UPDATE cms_content SET hierarchy = '00009.00002.00001', id_hierarchy = '68.70.78', hierarchy_path = 'links/useful_links/', prop_names = 'target,url' WHERE content_id = '78'
Error (0):

Debug: (1.159789) - (10951580)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '79'
Error (0):

Debug: (1.160479) - (10951788)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '70'
Error (0):

Debug: (1.161077) - (10951996)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.162273) - (10952228)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '79'
Error (0):

Debug: (1.162459) - (10952416)

Number of elements: 4
Array
(
    [0] => 00009.00002.00003
    [1] => 68.70.79
    [2] => target,url
    [3] => 79
)

Debug: (1.163566) - (10953532)


(mysql): UPDATE cms_content SET hierarchy = '00009.00002.00003', id_hierarchy = '68.70.79', hierarchy_path = 'links/useful_links/', prop_names = 'target,url' WHERE content_id = '79'
Error (0):

Debug: (1.164471) - (10953076)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '80'
Error (0):

Debug: (1.165085) - (10953284)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '70'
Error (0):

Debug: (1.165915) - (10953492)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.166999) - (10953700)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '80'
Error (0):

Debug: (1.167192) - (10953888)

Number of elements: 4
Array
(
    [0] => 00009.00002.00002
    [1] => 68.70.80
    [2] => target,url
    [3] => 80
)

Debug: (1.167961) - (10954964)


(mysql): UPDATE cms_content SET hierarchy = '00009.00002.00002', id_hierarchy = '68.70.80', hierarchy_path = 'links/useful_links/', prop_names = 'target,url' WHERE content_id = '80'
Error (0):

Debug: (1.168747) - (10954508)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '81'
Error (0):

Debug: (1.169464) - (10954716)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '71'
Error (0):

Debug: (1.170069) - (10954924)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.171078) - (10955132)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '81'
Error (0):

Debug: (1.171265) - (10955320)

Number of elements: 4
Array
(
    [0] => 00009.00003.00001
    [1] => 68.71.81
    [2] => target,url
    [3] => 81
)

Debug: (1.171945) - (10956400)


(mysql): UPDATE cms_content SET hierarchy = '00009.00003.00001', id_hierarchy = '68.71.81', hierarchy_path = 'links/funny_links/', prop_names = 'target,url' WHERE content_id = '81'
Error (0):

Debug: (1.172753) - (10955940)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '82'
Error (0):

Debug: (1.173452) - (10956148)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '71'
Error (0):

Debug: (1.174058) - (10956356)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.175108) - (10956564)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '82'
Error (0):

Debug: (1.175297) - (10956752)

Number of elements: 4
Array
(
    [0] => 00009.00003.00002
    [1] => 68.71.82
    [2] => target,url
    [3] => 82
)

Debug: (1.176062) - (10957880)


(mysql): UPDATE cms_content SET hierarchy = '00009.00003.00002', id_hierarchy = '68.71.82', hierarchy_path = 'links/funny_links/', prop_names = 'target,url' WHERE content_id = '82'
Error (0):

Debug: (1.176923) - (10957436)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '83'
Error (0):

Debug: (1.177804) - (10957644)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.178888) - (10957900)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '83'
Error (0):

Debug: (1.179062) - (10958088)

Number of elements: 4
Array
(
    [0] => 00007.00003
    [1] => 61.83
    [2] => content_en
    [3] => 83
)

Debug: (1.179869) - (10959340)


(mysql): UPDATE cms_content SET hierarchy = '00007.00003', id_hierarchy = '61.83', hierarchy_path = 'fun_stuff/games', prop_names = 'content_en' WHERE content_id = '83'
Error (0):

Debug: (1.180635) - (10958916)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '84'
Error (0):

Debug: (1.181305) - (10959124)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '83'
Error (0):

Debug: (1.181942) - (10959372)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.183064) - (10959580)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '84'
Error (0):

Debug: (1.18325) - (10959768)

Number of elements: 4
Array
(
    [0] => 00007.00003.00001
    [1] => 61.83.84
    [2] => target,url
    [3] => 84
)

Debug: (1.183928) - (10961292)


(mysql): UPDATE cms_content SET hierarchy = '00007.00003.00001', id_hierarchy = '61.83.84', hierarchy_path = 'fun_stuff/games/', prop_names = 'target,url' WHERE content_id = '84'
Error (0):

Debug: (1.184925) - (10960848)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '85'
Error (0):

Debug: (1.185563) - (10961056)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '83'
Error (0):

Debug: (1.186192) - (10961264)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.187226) - (10961472)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '85'
Error (0):

Debug: (1.187412) - (10961660)

Number of elements: 4
Array
(
    [0] => 00007.00003.00002
    [1] => 61.83.85
    [2] => target,url
    [3] => 85
)

Debug: (1.188192) - (10963072)


(mysql): UPDATE cms_content SET hierarchy = '00007.00003.00002', id_hierarchy = '61.83.85', hierarchy_path = 'fun_stuff/games/', prop_names = 'target,url' WHERE content_id = '85'
Error (0):

Debug: (1.189108) - (10962628)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '86'
Error (0):

Debug: (1.189681) - (10962836)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '83'
Error (0):

Debug: (1.190294) - (10963044)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '61'
Error (0):

Debug: (1.191564) - (10963252)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '86'
Error (0):

Debug: (1.191753) - (10963440)

Number of elements: 4
Array
(
    [0] => 00007.00003.00003
    [1] => 61.83.86
    [2] => target,url
    [3] => 86
)

Debug: (1.192432) - (10964964)


(mysql): UPDATE cms_content SET hierarchy = '00007.00003.00003', id_hierarchy = '61.83.86', hierarchy_path = 'fun_stuff/games/', prop_names = 'target,url' WHERE content_id = '86'
Error (0):

Debug: (1.193313) - (10964504)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '87'
Error (0):

Debug: (1.195998) - (10964712)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.196693) - (10964920)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.197811) - (10965128)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '87'
Error (0):

Debug: (1.197998) - (10965356)

Number of elements: 4
Array
(
    [0] => 00009.00004.00002
    [1] => 68.72.87
    [2] => target,url
    [3] => 87
)

Debug: (1.198691) - (10966820)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00002', id_hierarchy = '68.72.87', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '87'
Error (0):

Debug: (1.2007) - (10966324)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '88'
Error (0):

Debug: (1.201442) - (10966532)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.202039) - (10966740)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.203112) - (10966948)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '88'
Error (0):

Debug: (1.2033) - (10967136)

Number of elements: 4
Array
(
    [0] => 00009.00004.00003
    [1] => 68.72.88
    [2] => target,url
    [3] => 88
)

Debug: (1.204054) - (10968604)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00003', id_hierarchy = '68.72.88', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '88'
Error (0):

Debug: (1.204946) - (10968108)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '89'
Error (0):

Debug: (1.205548) - (10968316)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.206173) - (10968524)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.207203) - (10968732)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '89'
Error (0):

Debug: (1.207396) - (10968924)

Number of elements: 4
Array
(
    [0] => 00009.00004.00004
    [1] => 68.72.89
    [2] => target,url
    [3] => 89
)

Debug: (1.20821) - (10970364)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00004', id_hierarchy = '68.72.89', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '89'
Error (0):

Debug: (1.209029) - (10969864)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '90'
Error (0):

Debug: (1.209688) - (10970072)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.210283) - (10970280)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.211433) - (10970488)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '90'
Error (0):

Debug: (1.211617) - (10970680)

Number of elements: 4
Array
(
    [0] => 00009.00004.00001
    [1] => 68.72.90
    [2] => target,url
    [3] => 90
)
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

Debug: (1.212286) - (10972164)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00001', id_hierarchy = '68.72.90', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '90'
Error (0):

Debug: (1.213111) - (10971668)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '91'
Error (0):

Debug: (1.214185) - (10971876)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.214782) - (10972084)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.215843) - (10972292)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '91'
Error (0):

Debug: (1.216307) - (10972484)

Number of elements: 4
Array
(
    [0] => 00009.00004.00005
    [1] => 68.72.91
    [2] => target,url
    [3] => 91
)

Debug: (1.21727) - (10973968)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00005', id_hierarchy = '68.72.91', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '91'
Error (0):

Debug: (1.2181) - (10973468)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '92'
Error (0):

Debug: (1.218785) - (10973676)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.2194) - (10973884)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.220857) - (10974092)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '92'
Error (0):

Debug: (1.221059) - (10974284)

Number of elements: 4
Array
(
    [0] => 00009.00004.00006
    [1] => 68.72.92
    [2] => target,url
    [3] => 92
)

Debug: (1.221756) - (10975768)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00006', id_hierarchy = '68.72.92', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '92'
Error (0):

Debug: (1.222574) - (10975272)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '93'
Error (0):

Debug: (1.223554) - (10975480)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.224156) - (10975688)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.225216) - (10975896)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '93'
Error (0):

Debug: (1.2254) - (10976088)

Number of elements: 4
Array
(
    [0] => 00009.00004.00007
    [1] => 68.72.93
    [2] => target,url
    [3] => 93
)

Debug: (1.226204) - (10977572)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00007', id_hierarchy = '68.72.93', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '93'
Error (0):

Debug: (1.227041) - (10977076)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '94'
Error (0):

Debug: (1.227664) - (10977284)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '72'
Error (0):

Debug: (1.22827) - (10977492)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '68'
Error (0):

Debug: (1.2294) - (10977772)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '94'
Error (0):

Debug: (1.229583) - (10977964)

Number of elements: 4
Array
(
    [0] => 00009.00004.00008
    [1] => 68.72.94
    [2] => target,url
    [3] => 94
)

Debug: (1.23027) - (10979464)


(mysql): UPDATE cms_content SET hierarchy = '00009.00004.00008', id_hierarchy = '68.72.94', hierarchy_path = 'links/flights_accommodation/', prop_names = 'target,url' WHERE content_id = '94'
Error (0):

Debug: (1.231085) - (10978964)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '95'
Error (0):

Debug: (1.232243) - (10979312)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '95'
Error (0):

Debug: (1.232418) - (10979500)

Number of elements: 4
Array
(
    [0] => 00010
    [1] => 95
    [2] => content_en
    [3] => 95
)

Debug: (1.233727) - (10980620)


(mysql): UPDATE cms_content SET hierarchy = '00010', id_hierarchy = '95', hierarchy_path = 'buy_stuff', prop_names = 'content_en' WHERE content_id = '95'
Error (0):

Debug: (1.234777) - (10980228)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '96'
Error (0):

Debug: (1.235418) - (10980436)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '95'
Error (0):

Debug: (1.23662) - (10980716)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '96'
Error (0):

Debug: (1.236809) - (10980904)

Number of elements: 4
Array
(
    [0] => 00010.00001
    [1] => 95.96
    [2] => target,url
    [3] => 96
)

Debug: (1.237553) - (10982400)


(mysql): UPDATE cms_content SET hierarchy = '00010.00001', id_hierarchy = '95.96', hierarchy_path = 'buy_stuff/tickets', prop_names = 'target,url' WHERE content_id = '96'
Error (0):

Debug: (1.238392) - (10981964)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '97'
Error (0):

Debug: (1.23916) - (10982172)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '95'
Error (0):

Debug: (1.240293) - (10982452)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '97'
Error (0):

Debug: (1.240496) - (10982640)

Number of elements: 4
Array
(
    [0] => 00010.00002
    [1] => 95.97
    [2] => target,url
    [3] => 97
)

Debug: (1.241261) - (10984028)


(mysql): UPDATE cms_content SET hierarchy = '00010.00002', id_hierarchy = '95.97', hierarchy_path = 'buy_stuff/membership-2', prop_names = 'target,url' WHERE content_id = '97'
Error (0):

Debug: (1.242076) - (10983580)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '98'
Error (0):

Debug: (1.243027) - (10983788)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '95'
Error (0):

Debug: (1.244163) - (10984068)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '98'
Error (0):

Debug: (1.244351) - (10984256)

Number of elements: 4
Array
(
    [0] => 00010.00003
    [1] => 95.98
    [2] => target,url
    [3] => 98
)

Debug: (1.244986) - (10985492)


(mysql): UPDATE cms_content SET hierarchy = '00010.00003', id_hierarchy = '95.98', hierarchy_path = 'buy_stuff/', prop_names = 'target,url' WHERE content_id = '98'
Error (0):

Debug: (1.245836) - (10985068)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '99'
Error (0):

Debug: (1.24653) - (10985276)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '95'
Error (0):

Debug: (1.247764) - (10985552)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '99'
Error (0):

Debug: (1.247969) - (10985740)

Number of elements: 4
Array
(
    [0] => 00010.00004
    [1] => 95.99
    [2] => target,url
    [3] => 99
)

Debug: (1.248761) - (10987144)


(mysql): UPDATE cms_content SET hierarchy = '00010.00004', id_hierarchy = '95.99', hierarchy_path = 'buy_stuff/armada-sur-shop', prop_names = 'target,url' WHERE content_id = '99'
Error (0):

Debug: (1.2497) - (10986684)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '101'
Error (0):

Debug: (1.250922) - (10986892)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '101'
Error (0):

Debug: (1.251098) - (10987192)

Number of elements: 4
Array
(
    [0] => 00011
    [1] => 101
    [2] => content_en
    [3] => 101
)

Debug: (1.251844) - (10988356)


(mysql): UPDATE cms_content SET hierarchy = '00011', id_hierarchy = '101', hierarchy_path = 'members_area_registration', prop_names = 'content_en' WHERE content_id = '101'
Error (0):

Debug: (1.252729) - (10987920)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '102'
Error (0):

Debug: (1.253934) - (10988132)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '102'
Error (0):

Debug: (1.254112) - (10988320)

Number of elements: 4
Array
(
    [0] => 00012
    [1] => 102
    [2] => content_en
    [3] => 102
)

Debug: (1.255148) - (10989540)


(mysql): UPDATE cms_content SET hierarchy = '00012', id_hierarchy = '102', hierarchy_path = 'members_area', prop_names = 'content_en' WHERE content_id = '102'
Error (0):

Debug: (1.255935) - (10989116)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '105'
Error (0):

Debug: (1.256645) - (10989336)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '102'
Error (0):

Debug: (1.257748) - (10989608)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '105'
Error (0):

Debug: (1.258066) - (10989796)

Number of elements: 4
Array
(
    [0] => 00012.00001
    [1] => 102.105
    [2] => content_en
    [3] => 105
)

Debug: (1.258925) - (10991196)


(mysql): UPDATE cms_content SET hierarchy = '00012.00001', id_hierarchy = '102.105', hierarchy_path = 'members_area/trip_bookings', prop_names = 'content_en' WHERE content_id = '105'
Error (0):

Debug: (1.259771) - (10990724)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '106'
Error (0):

Debug: (1.260674) - (10990936)


(mysql): SELECT item_order, parent_id, content_alias FROM cms_content WHERE content_id = '50'
Error (0):

Debug: (1.261838) - (10991144)


(mysql): SELECT prop_name FROM cms_content_props WHERE content_id = '106'
Error (0):

Debug: (1.262019) - (10991332)

Number of elements: 4
Array
(
    [0] => 00005.00007

    [1] => 50.106
    [2] => target,url
    [3] => 106
)

Debug: (1.262807) - (10992696)


(mysql): UPDATE cms_content SET hierarchy = '00005.00007', id_hierarchy = '50.106', hierarchy_path = 'galleries/', prop_names = 'target,url' WHERE content_id = '106'
Error (0):

Debug: (1.317251) - (10992912)


(mysql): INSERT INTO cms_adminlog (timestamp, user_id, username, item_id, item_name, action) VALUES (1220875484,'1','admin',0,'test','Added Content')
Error (0):
djkirstyjay
Forum Members
Forum Members
Posts: 206
Joined: Tue Oct 25, 2005 4:50 pm

Re: Problems with CMSMS after upgrade

Post by djkirstyjay »

And all that was just to add a page with 'test' in it! Sorry I couldn't post it all in one post... but it exceeded the limit MANY times over!
Post Reply

Return to “CMSMS Core”