[SOLVED] Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Hilfe zur Installation
Post Reply
User avatar
pawi
Forum Members
Forum Members
Posts: 15
Joined: Wed Jun 23, 2010 8:20 am

[SOLVED] Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by pawi »

Hallo!

Ich hatte nach einem Update (ich weiß leider nicht mehr, wie niedrig die vorhergehende Version war, ich glaube von 1.6.1) auf 1.9.1 das allseits bekannte Sonderzeichenproblem -> Umlaute waren alle verhauen. Also habe ich die Sonderzeichen in Notepad++ ersetzt und eine komplett neue Datenbank angelegt, mit korrigierten Sonderzeichen. Da ich mit "Finden und Ersetzen" korrigiert habe, ist an der sonstigen Struktur der DB nichts verändert worden.

Es hat alles soweit gut funktioniert, allerdings fehlen jetzt meine Globalen Inhaltsblöcke - sind aber definitiv in der Datenbank vorhanden. Neue anlegen kann ich auch nicht. Ich bekomme die nicht aussagekräftige Meldung
Beim Speichern des globalen Inhaltsblocks ist ein Fehler aufgetreten.
An den CHMOD-Rechten hat sich nichts verändert.
In einem ähnlichen Post hatte es mit den Spracheinstellungen der MLEdition zu tun
http://forum.cmsmadesimple.org/index.php?topic=36673.15

ich habe jedoch keine mehrsprachige Seite..

Hat jemand eine Ahnung, was der Fehler sein könnte?

Danke schonmal!
Pawi


//edit: in zukunft werde ich auch über http://www.mysqldumper.de/ meine DB sichern :)
Last edited by compufairy on Mon Dec 27, 2010 12:24 pm, edited 1 time in total.
NaN

Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by NaN »

Schalte mal den Debug Modus ein ($config['debug'] = true; in der config.php).
Und dann schau mal was beim Anzeigen/Speichern von globalen Inhaltsblöcken für Informationen ausgegeben werden.
User avatar
pawi
Forum Members
Forum Members
Posts: 15
Joined: Wed Jun 23, 2010 8:20 am

Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by pawi »

Danke!
Das hier spuckt die Global Content Seite dann aus:

Code: Select all

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'


kannst du das deuten? Ich versteh nur Bahnhof :)

pawi
User avatar
pawi
Forum Members
Forum Members
Posts: 15
Joined: Wed Jun 23, 2010 8:20 am

Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by pawi »

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.
Last edited by pawi on Thu Dec 02, 2010 1:50 pm, edited 1 time in total.
User avatar
pawi
Forum Members
Forum Members
Posts: 15
Joined: Wed Jun 23, 2010 8:20 am

Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by pawi »

Ohjeeee...

es funktionieren nicht nur die Globalen Inhaltsblöcke nicht, auch die Inhalte der Seite lassen sich nicht aktualisieren. Wenn ich in die Seitenbearbeitung gehe und auf "anwenden" klicke, passiert überhaupt nichts.

Der Witz ist: anscheinend werden meine Änderungen irgendwo hingespeichert, jedoch nicht im Frontend angezeigt. Wenn ich nämlich meine Änderungen mit "Absenden" statt "anwenden" bestätige und die Seitenbearbeitung nochmal aufrufe, sind sie im WYSYWYG-Eduitor da. Im Frontend wird jedoch der alte Eintrag angezeigt.

Ich hab auch schon überprüft, ob es tatsächlich derselbe Contentblock ist im Template.. das stimmt alles. Warum funktioniert das nur nicht? Kann es irgendwas mit den Rechten zu tun haben? Ich habe die index.php und include.php auf 777 gesetzt, ohne Erfolg. Der Ordner /admin hat 755 durchgängig.

Ich bin gerade am Verzweifeln und bereue das Update :( ich hoffe, jemand kann mir helfen.

Danke!
pawi
nicmare
Power Poster
Power Poster
Posts: 1150
Joined: Sat Aug 25, 2007 9:55 am
Location: Berlin

Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by nicmare »

User avatar
pawi
Forum Members
Forum Members
Posts: 15
Joined: Wed Jun 23, 2010 8:20 am

Re: [SOLVED] Globale Inhaltsblöcke nach Update auf 1.9.1 weg

Post by pawi »

Danke!
Mit einem Update auf 1.9.2. haben sich alle Probleme in Luft aufgelöst...
Last edited by compufairy on Mon Dec 27, 2010 12:24 pm, edited 1 time in total.
Post Reply

Return to “Installation und Einstellungen”