Page 1 of 1
Problems with CMSMS after upgrade
Posted: Sun Sep 07, 2008 9:08 pm
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
Re: Problems with CMSMS after upgrade
Posted: Sun Sep 07, 2008 9:48 pm
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.
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 11:05 am
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?
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 11:08 am
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
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 11:21 am
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
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 11:40 am
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
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:06 pm
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
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:08 pm
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>
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:09 pm
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
)
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:09 pm
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):
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:10 pm
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
)
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:10 pm
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):
Re: Problems with CMSMS after upgrade
Posted: Mon Sep 08, 2008 12:11 pm
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!