I made an update from some 1.6x version to 1.9.1 and this caused various problems
i used some wrong encoding in the database backup and had problems with the special characters. I replaced them in notepad++ and left the rest untouched.
Everything looks normal, clean and fine but 2 major things don't work:
- My global content blocks simply don't appear in the backend although they exist in the database. If I still use them in my old templates of course I get smarty errors.
Adding global content is not possible, debug says:
CMS Made Simple™ 1.9.1 "Toopua"
Debug: (6.7E-5) - (usage: 1169344) - (peak: 1223504)
loading smarty
Debug: (0.010582) - (usage: 1670792) - (peak: 1695096)
loading adodb
Debug: (0.014898) - (usage: 1837048) - (peak: 1903032)
loading page functions
Debug: (0.023234) - (usage: 2184200) - (peak: 2291920)
loading content functions
Debug: (0.030598) - (usage: 2555128) - (peak: 2581904)
loading translation functions
Debug: (0.034109) - (usage: 2680784) - (peak: 2734912)
loading events functions
Debug: (0.03756) - (usage: 2831264) - (peak: 2969992)
loading php4 entity decode functions
Debug: (0.045108) - (usage: 3213784) - (peak: 3516848)
done loading files
Debug: (0.074527) - (usage: 4495128) - (peak: 4515248)
(mysql): SET NAMES 'utf8'
Debug: (0.075714) - (usage: 4535696) - (peak: 4556664)
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Debug: (0.084956) - (usage: 4697720) - (peak: 4767992)
(mysql): SELECT * FROM cms_userplugins
Debug display of 'Loading Modules':(0.08694) - (usage: 4763912) - (peak: 4810600)
Debug: (0.101118) - (usage: 5498648) - (peak: 5543584)
(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name
Debug display of 'Load Content Operations':(0.109251) - (usage: 5906688) - (peak: 5948328)
Debug display of 'End Load Content Operations':(0.129022) - (usage: 6969296) - (peak: 7005128)
Debug: (0.150842) - (usage: 7132720) - (peak: 7158680)
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'
Debug display of 'Instantiate: CGExtensions':(0.186264) - (usage: 7560192) - (peak: 8278056)
Debug display of 'Instantiate: CMSMailer':(0.197564) - (usage: 8103880) - (peak: 8278056)
Debug display of 'Instantiate: CustomContent':(0.201781) - (usage: 8345000) - (peak: 8423432)
Debug display of 'Instantiate: FileManager':(0.208688) - (usage: 8707584) - (peak: 8806496)
Debug display of 'Instantiate: FormBuilder':(0.215366) - (usage: 9080648) - (peak: 9149584)
Debug display of 'Instantiate: FrontEndUsers':(0.258527) - (usage: 11446888) - (peak: 11508472)
Debug display of 'Instantiate: MenuManager':(0.263094) - (usage: 11699048) - (peak: 11756000)
Debug display of 'Instantiate: ModuleManager':(0.270979) - (usage: 12110688) - (peak: 12165600)
Debug display of 'Instantiate: News':(0.278006) - (usage: 12508384) - (peak: 12562192)
Debug display of 'Instantiate: nuSOAP':(0.280558) - (usage: 12646944) - (peak: 12701344)
Debug display of 'Instantiate: Printing':(0.283384) - (usage: 12821240) - (peak: 12875512)
Debug display of 'Instantiate: Search':(0.291743) - (usage: 13272424) - (peak: 13330888)
Debug display of 'Instantiate: ThemeManager':(0.29468) - (usage: 13423296) - (peak: 13476192)
Debug display of 'Instantiate: TinyMCE':(0.300796) - (usage: 13769744) - (peak: 13821616)
Debug display of 'End of include':(0.301337) - (usage: 13769392) - (peak: 13850888)
Debug: (0.303264) - (usage: 13723072) - (peak: 13878264)
Session found. Moving on...
Debug: (0.319468) - (usage: 14491776) - (peak: 14665872)
Session found. Moving on...
Debug: (0.319714) - (usage: 14492800) - (peak: 14665872)
Session found. Moving on...
Debug: (0.319841) - (usage: 14492616) - (peak: 14665872)
before theme load
Debug: (0.323987) - (usage: 14694496) - (peak: 14746752)
(mysql): SELECT content_id FROM cms_content WHERE default_content = 1
Debug: (0.326399) - (usage: 14745648) - (peak: 14811080)
(mysql): SELECT * FROM cms_content WHERE content_id = '79'
Debug: (0.33706) - (usage: 15228984) - (peak: 15287000)
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1
Debug: (0.337771) - (usage: 15230560) - (peak: 15318472)
(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.417552) - (usage: 16121600) - (peak: 16207152)
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'
Debug: (0.418161) - (usage: 16126488) - (peak: 16238136)
(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'
Debug: (0.418622) - (usage: 16124768) - (peak: 16240664)
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)
Debug: (0.419245) - (usage: 16124752) - (peak: 16241664)
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'
Debug: (0.420037) - (usage: 16130088) - (peak: 16242008)
(mysql): SELECT user_id,content_id FROM cms_additional_users
Debug: (0.421898) - (usage: 16128248) - (peak: 16243824)
after theme load
Debug: (0.422157) - (usage: 16129424) - (peak: 16246760)
before populate admin navigation
Debug: (0.422292) - (usage: 16129896) - (peak: 16246760)
before menu items
Debug: (0.431029) - (usage: 16212896) - (peak: 16269056)
after menu items
Debug: (0.432161) - (usage: 16217072) - (peak: 16323720)
before syste modules
Debug: (0.433074) - (usage: 16232352) - (peak: 16364736)
before module menu items
Debug: (0.433847) - (usage: 16238424) - (peak: 16366304)
after module menu items
Debug: (0.440717) - (usage: 16289696) - (peak: 16403248)
after populate admin navigation
Debug: (0.440875) - (usage: 16290048) - (peak: 16444344)
before theme-y stuff
Debug: (0.442952) - (usage: 16290400) - (peak: 16444504)
after theme-y stuff
Debug: (0.446784) - (usage: 16307688) - (peak: 16446104)
(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:24:40'))
Debug: (0.453501) - (usage: 16516520) - (peak: 16683104)
before notifications
Debug: (0.454143) - (usage: 16518456) - (peak: 16686360)
after notifications
Debug: (0.45457) - (usage: 16522688) - (peak: 16686648)
(mysql): SELECT version from cms_version
Debug: (0.458586) - (usage: 16610456) - (peak: 16743256)
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title
Debug: (0.459348) - (usage: 16524480) - (peak: 16763472)
Session found. Moving on...
Debug: (0.460063) - (usage: 16529136) - (peak: 16763472)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date, use_wysiwyg, description FROM cms_htmlblobs ORDER BY htmlblob_name
Error (1054): Unknown column 'use_wysiwyg' in 'field list'
- my second problem is: if I edit the content part of a page in the backend there is no change in the frontend. Editing the templates works just fine but all my existing content seems to be frozen. I checked all CHMOD settings in the admin folder and index.php and it seems they have all rights to work but they don't... if I edit the content in the WYSIWYG window and confirm my changes they seem to be saved somewhere because if I re-open the page edit menu the new text is there. The frontend simply doesn't change.
Does anyone have an idea how I can fix this?
Thank you for any help!
pawi
