• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple Netherlands

All times are UTC




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: [SOLVED] Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Thu Dec 02, 2010 12:23 pm 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Jun 23, 2010 8:20 am
Posts: 15
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
Quote:
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.

Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Thu Dec 02, 2010 12:29 pm 
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.


Top
   
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Thu Dec 02, 2010 1:26 pm 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Jun 23, 2010 8:20 am
Posts: 15
Danke!
Das hier spuckt die Global Content Seite dann aus:

Code:
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


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Thu Dec 02, 2010 1:29 pm 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Jun 23, 2010 8:20 am
Posts: 15
Und das hier, wenn ich einen neuen Block anlegen möchte:

Code:
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:
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.

Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Fri Dec 17, 2010 9:19 am 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Jun 23, 2010 8:20 am
Posts: 15
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


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Fri Dec 17, 2010 2:47 pm 
Offline
Power Poster
Power Poster
User avatar

Joined: Sat Aug 25, 2007 9:55 am
Posts: 1150
Location: Berlin
versuchs mal im deutschen cmsmadesimple forum


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: [SOLVED] Globale Inhaltsblöcke nach Update auf 1.9.1 weg
PostPosted: Mon Dec 20, 2010 6:05 pm 
Offline
Forum Members
Forum Members
User avatar

Joined: Wed Jun 23, 2010 8:20 am
Posts: 15
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.

Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
A2 Hosting