Und das hier, wenn ich einen neuen Block anlegen möchte:
Code: Select all
CMS Made Simple™ 1.9.1 "Toopua"
Debug: (4.0E-5) - (usage: 1198920) - (peak: 1253184)
loading smarty
Debug: (0.009537) - (usage: 1700376) - (peak: 1731448)
loading adodb
Debug: (0.013266) - (usage: 1866576) - (peak: 1932592)
loading page functions
Debug: (0.020409) - (usage: 2213736) - (peak: 2351432)
loading content functions
Debug: (0.026993) - (usage: 2584544) - (peak: 2611392)
loading translation functions
Debug: (0.030004) - (usage: 2710216) - (peak: 2756400)
loading events functions
Debug: (0.033057) - (usage: 2860656) - (peak: 2999464)
loading php4 entity decode functions
Debug: (0.039276) - (usage: 3243176) - (peak: 3546192)
done loading files
Debug: (0.059733) - (usage: 4524520) - (peak: 4544560)
(mysql): SET NAMES 'utf8'
Debug: (0.060741) - (usage: 4567000) - (peak: 4585976)
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Debug: (0.069076) - (usage: 4728968) - (peak: 4794392)
(mysql): SELECT * FROM cms_userplugins
Debug display of 'Loading Modules':(0.070971) - (usage: 4797592) - (peak: 4843736)
Debug: (0.083909) - (usage: 5532072) - (peak: 5576736)
(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name
Debug display of 'Load Content Operations':(0.091111) - (usage: 5940040) - (peak: 5981408)
Debug display of 'End Load Content Operations':(0.108669) - (usage: 7002768) - (peak: 7038600)
Debug: (0.130189) - (usage: 7166104) - (peak: 7191672)
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'
Debug display of 'Instantiate: CGExtensions':(0.16263) - (usage: 7593496) - (peak: 8311336)
Debug display of 'Instantiate: CMSMailer':(0.173824) - (usage: 8137264) - (peak: 8311336)
Debug display of 'Instantiate: CustomContent':(0.17791) - (usage: 8378344) - (peak: 8455864)
Debug display of 'Instantiate: FileManager':(0.183985) - (usage: 8740920) - (peak: 8838976)
Debug display of 'Instantiate: FormBuilder':(0.190008) - (usage: 9114016) - (peak: 9181560)
Debug display of 'Instantiate: FrontEndUsers':(0.228916) - (usage: 11480408) - (peak: 11540672)
Debug display of 'Instantiate: MenuManager':(0.232999) - (usage: 11732608) - (peak: 11788720)
Debug display of 'Instantiate: ModuleManager':(0.240047) - (usage: 12144320) - (peak: 12198392)
Debug display of 'Instantiate: News':(0.2462) - (usage: 12541928) - (peak: 12595112)
Debug display of 'Instantiate: nuSOAP':(0.248515) - (usage: 12680448) - (peak: 12734368)
Debug display of 'Instantiate: Printing':(0.251064) - (usage: 12854800) - (peak: 12908648)
Debug display of 'Instantiate: Search':(0.25871) - (usage: 13305928) - (peak: 13363792)
Debug display of 'Instantiate: ThemeManager':(0.261279) - (usage: 13456640) - (peak: 13509216)
Debug display of 'Instantiate: TinyMCE':(0.266751) - (usage: 13802912) - (peak: 13854608)
Debug display of 'End of include':(0.267305) - (usage: 13802560) - (peak: 13883880)
Debug: (0.26984) - (usage: 13784544) - (peak: 13911280)
Session found. Moving on...
Debug: (0.270061) - (usage: 13786344) - (peak: 13911280)
Session found. Moving on...
Debug: (0.273726) - (usage: 13929944) - (peak: 13997152)
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1
Debug: (0.274408) - (usage: 13931448) - (peak: 14026984)
(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 INNER JOIN cms_groups gr ON gr.group_id = ug.group_id WHERE ug.user_id = '1' AND gr.active = 1
Debug: (0.281755) - (usage: 14230344) - (peak: 14316784)
(mysql): SELECT htmlblob_id from cms_htmlblobs WHERE htmlblob_name = 'test'
Debug: (0.283917) - (usage: 14278272) - (peak: 14342272)
(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
Debug: (0.308836) - (usage: 14299464) - (peak: 14373240)
(mysql): update cms_htmlblobs_seq set id=LAST_INSERT_ID(id+1);
Debug: (0.309734) - (usage: 14306080) - (peak: 14396896)
(mysql): INSERT INTO cms_htmlblobs (htmlblob_id, htmlblob_name, html, owner, use_wysiwyg, description, create_date, modified_date) VALUES (10,'test','test','1',1,'','2010-12-02 14:29:04','2010-12-02 14:29:04')
Error (1054): Unknown column 'use_wysiwyg' in 'field list'
Debug: (0.32374) - (usage: 15064792) - (peak: 15358960)
Session found. Moving on...
Debug: (0.323972) - (usage: 15065560) - (peak: 15358960)
Session found. Moving on...
Debug: (0.324101) - (usage: 15065248) - (peak: 15358960)
before theme load
Debug: (0.328122) - (usage: 15266824) - (peak: 15358960)
(mysql): SELECT content_id FROM cms_content WHERE default_content = 1
Debug: (0.330282) - (usage: 15317992) - (peak: 15382848)
(mysql): SELECT * FROM cms_content WHERE content_id = '79'
Debug: (0.411195) - (usage: 16381376) - (peak: 16532856)
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'
Debug: (0.411809) - (usage: 16386288) - (peak: 16532856)
(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'
Debug: (0.412263) - (usage: 16384568) - (peak: 16532856)
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)
Debug: (0.412893) - (usage: 16384552) - (peak: 16532856)
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'
Debug: (0.413687) - (usage: 16389888) - (peak: 16532856)
(mysql): SELECT user_id,content_id FROM cms_additional_users
Debug: (0.415446) - (usage: 16388040) - (peak: 16532856)
after theme load
Debug: (0.415678) - (usage: 16389216) - (peak: 16532856)
before populate admin navigation
Debug: (0.415814) - (usage: 16389688) - (peak: 16532856)
before menu items
Debug: (0.424324) - (usage: 16472672) - (peak: 16540232)
after menu items
Debug: (0.425327) - (usage: 16476848) - (peak: 16592520)
before syste modules
Debug: (0.426201) - (usage: 16492128) - (peak: 16633536)
before module menu items
Debug: (0.42698) - (usage: 16498200) - (peak: 16634920)
after module menu items
Debug: (0.433504) - (usage: 16550184) - (peak: 16670608)
after populate admin navigation
Debug: (0.433637) - (usage: 16550536) - (peak: 16711624)
before theme-y stuff
Debug: (0.435659) - (usage: 16550888) - (peak: 16711624)
after theme-y stuff
Debug: (0.439671) - (usage: 16568320) - (peak: 16712224)
(mysql): SELECT count(news_id) FROM cms_module_news n
WHERE status != 'published'
AND (( IFNULL(end_time, '1970-01-01 01:00:01') = '1970-01-01 01:00:01') OR (end_time > '2010-12-02 14:29:04'))
Debug: (0.445548) - (usage: 16776920) - (peak: 16940640)
before notifications
Debug: (0.446175) - (usage: 16778856) - (peak: 16946800)
after notifications
Debug: (0.446616) - (usage: 16783072) - (peak: 16947088)
(mysql): SELECT version from cms_version
Debug: (0.450503) - (usage: 16870752) - (peak: 17004248)
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title
Debug: (0.453481) - (usage: 16855776) - (peak: 17024464)
(mysql): SELECT group_id, group_name, active FROM cms_groups ORDER BY group_id
Debug: (0.454454) - (usage: 16863008) - (peak: 17024464)
(mysql): SELECT user_id, username FROM cms_users WHERE user_id <> '1' ORDER BY username
//Edit:
Also ich habe mal die original Datenbank (also die mit fehlerhaften Sonderzeichen) verglichen mit der neuen. Der betreffende Bereich beginnt mit der Zeile
Code: Select all
INSERT INTO `cms_htmlblobs` (`htmlblob_id`, `htmlblob_name`, `html`, `owner`, `create_date`, `modified_date`) VALUES
und ich kann in den folgenden Zeilen, die die Inhaltsblöcke in HTML beschreiben, außer ersetzten Sonderzeichen überhaupt keinen Unterschied erkennen.
Interessant ist, dass wenn ich die alte Datenbank mit dem CMS verknüpfe, alle Global Content Blöcke wieder da sind. Das heißt, es ist auch beim Update nichts kaputtgegangen oder so. Dafür aber eben alle Sonderzeichen kaputt.