CMS Made Simple Forums

I used MLE 1.5.2 on a test page to play a little around and get familiar with it.
In this page I created a global content block for currency exchange rates and a global content block for a footer.

A few days ago I created another page on another domain and copied the global content blocks to this page. Now the content either does not appear or is shown as code.
What did I do wrong?

Play page: http://thaiboss.de/EUM/index.php?page=currency-exchange-rates&hl=en_US
New Page:http://www.expat-und-mehr.de/index.php?page=waehrungsrechner&hl=en_US[url]]]http://www.expat-und-mehr.de/index.php?page=waehrungsrechner&hl=en_US[url][/url]l

By the way, when I created the bock for the currency the first time, I had to refresh my page to get rid of smarty error messages.

Partially solved.
The problem seemed to be caused by WYSIWYG.
When I switched off WYSIWYG and copied the page came up with the content.
The smarty error still occurs and disappears with a refresh.

But now a different problem came up.
Saving the global content in diufferent languages causes mistakes. In english the block is saved correctly, in a differnt language (e.g. German) it will be saved only partially.

TeXnik wrote: Partially solved.
The problem seemed to be caused by WYSIWYG.
When I switched off WYSIWYG and copied the page came up with the content.
The smarty error still occurs and disappears with a refresh.

But now a different problem came up.
Saving the global content in diufferent languages causes mistakes. In english the block is saved correctly, in a differnt language (e.g. German) it will be saved only partially.

When you have logic code, you must toggle WYSIWYG.

Check if your DB has UTF8 charset (I use utf8_unicode_ci)

Alby

The DB is set to : utf8_general_ci

When saving the global content in a second language only the first two lines will be saved and the rest truncated.

Right now I cleared all the different languages and set "force mle default" in GLobal Settings to avoid problems.

TeXnik wrote: When saving the global content in a second language only the first two lines will be saved and the rest truncated.

Check your type for html* field, must be TEXT type (maybe you have VARCHAR or TINYTEXT)

Alby

The fields in htmlblob (html_de etc.) had been set to TEXT.

No change. What I do not understand is, where the difference comes from. I set up this page identical to the other one, using exactly the same procedure.

Shall I delete the content of the database and copy the content of the other one?

TeXnik wrote: The fields in htmlblob (html_de etc.) had been set to TEXT.

No change. What I do not understand is, where the difference comes from. I set up this page identical to the other one, using exactly the same procedure.

Shall I delete the content of the database and copy the content of the other one?

Active debug in config.php and look for INSERT/UPDATE sql query if all ok

Alby

Generated in 0.720647 seconds by CMS Made Simple using 48 SQL queries and 16458584 bytes of memory (peak memory usage was 16907984
Debug: (0.016089) - (968440)
loading smarty
Debug: (0.021002) - (1388024)
loading adodb
Debug: (0.024097) - (1528792)
loading page functions
Debug: (0.027504) - (1791664)
loading content functions
Debug: (0.030978) - (2124456)
loading pageinfo functions
Debug: (0.03234) - (2182296)
loading translation functions
Debug: (0.033392) - (2212272)
loading events functions
Debug: (0.035287) - (2345840)
loading php4 entity decode functions
Debug: (0.037722) - (2677344)
done loading files
Debug: (0.055345) - (3813280)

(mysql): SET NAMES 'utf8'
Error (0):
Debug: (0.057484) - (3830504)

(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Error (0):
Debug: (0.064763) - (3978400)

(mysql): SELECT * FROM cms_userplugins
Error (0):
Debug: (0.07612) - (4715264)

(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 AND active = 1 ORDER by module_name
Error (0):
Debug display of 'End of include':(0.18966) - (12807096)
Debug display of 'Load Content Operations':(0.189884) - (12736888)
Debug display of 'End Load Content Operations':(0.198184) - (13440888)
Debug: (0.198766) - (13443648)

(mysql): SELECT content_id FROM cms_content WHERE default_content = 1
Error (0):
Debug: (0.199736) - (13450704)

(mysql): SELECT c.content_name_de, c.content_name_en, c.menu_text_de, c.menu_text_en,  c.content_id, c.content_alias, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by, t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE (c.content_alias = '15' OR c.content_id = '15') AND c.active = 1
Error (0):
Debug: (0.200198) - (13456840)

(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c
Error (0):
Debug display of 'Start Loading Hierarchy Manager':(0.20059) - (13458552)
Debug display of 'starting tree':(0.200632) - (13458552)
Debug: (0.204389) - (13670064)
file needs loading
Debug: (0.205719) - (13703584)

(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy
Error (0):
Debug display of 'ending tree':(0.210159) - (14073184)
Debug display of 'End Loading Hierarchy Manager':(0.210205) - (14068880)
Debug: (0.21024) - (14068880)
start findNodeByTag
Debug: (0.21029) - (14068880)
end findNodeByTag
Debug: (0.234278) - (14261848)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '20'
Error (0):
Debug: (0.253104) - (15948208)

(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.253622) - (15949664)

(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.254023) - (15949856)

(mysql): SELECT userid FROM cms_module_feusers_loggedin WHERE sessionid='089794adb8b97c7a1bb775f8b314a263'
Error (0):
Debug: (0.254627) - (15951288)

(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.255117) - (15951952)

(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.25552) - (15952128)

(mysql): SELECT userid FROM cms_module_feusers_loggedin WHERE sessionid='089794adb8b97c7a1bb775f8b314a263'
Error (0):
Debug: (0.256121) - (15952328)

(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.256513) - (15953192)

(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.257116) - (15953368)

(mysql): SELECT userid FROM cms_module_feusers_loggedin WHERE sessionid='089794adb8b97c7a1bb775f8b314a263'
Error (0):
Debug: (0.257617) - (15953584)

(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid=0
Error (0):
Debug: (0.258217) - (15954440)

(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.25866) - (15955536)

(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1236697793
Error (0):
Debug: (0.259116) - (15955712)

(mysql): SELECT userid FROM cms_module_feusers_loggedin WHERE sessionid='089794adb8b97c7a1bb775f8b314a263'
Error (0):
Debug: (0.26148) - (15997064)

(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
Error (0):
Debug: (0.359804) - (16354544)

(mysql): SELECT DISTINCT A.css_id,A.media_type,B.assoc_order
                      FROM cms_css A, cms_css_assoc B
                    WHERE A.css_id = B.assoc_css_id
                      AND B.assoc_type = 'template'
                      AND B.assoc_to_id = '20'
                    ORDER BY B.assoc_order
Error (0):
Debug: (0.576092) - (16413928)

(mysql): update cms_module_visitorstats_seq set id=LAST_INSERT_ID(id+1);
Error (0):
Debug: (0.577025) - (16415832)

(mysql): INSERT INTO cms_module_visitorstats VALUES (294,'2009-03-10 15:39:53','98.24.129.55','/','','cpe-098-024-129-055.carolina.res.rr.com','Opera/9.63 (Windows NT 5.1; U; de) Presto/2.1.1','0')
Error (0):
Debug: (0.577717) - (16362272)

(mysql): SELECT * FROM cms_content WHERE content_id = '15'
Error (0):
Debug display of 'Start of Menu Manager Display':(0.579965) - (16450712)
Debug: (0.580127) - (16452600)
load properties called
Debug: (0.580694) - (16454848)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'
Error (0):
Debug: (0.581086) - (16456616)
load properties called
Debug: (0.581643) - (16458120)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '62'
Error (0):
Debug: (0.582018) - (16461320)
load properties called
Debug: (0.582588) - (16462800)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '60'
Error (0):
Debug: (0.583398) - (16464872)

(mysql): SELECT * FROM cms_content WHERE content_id = '61'
Error (0):
Debug: (0.583655) - (16475672)
load from data is loading properties
Debug: (0.583697) - (16475856)
load properties called
Debug: (0.584342) - (16479256)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '61'
Error (0):
Debug: (0.584676) - (16483360)
load properties called
Debug: (0.585363) - (16483360)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '59'
Error (0):
Debug: (0.585751) - (16489880)
load properties called
Debug: (0.586327) - (16489880)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '63'
Error (0):
Debug: (0.58672) - (16490344)
load properties called
Debug: (0.587421) - (16491952)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '64'
Error (0):
Debug: (0.587823) - (16492760)
load properties called
Debug: (0.588458) - (16494568)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '51'
Error (0):
Debug: (0.589385) - (16497672)

(mysql): SELECT * FROM cms_content WHERE content_id = '52'
Error (0):
Debug: (0.589658) - (16512016)
load from data is loading properties
Debug: (0.589699) - (16512200)
load properties called
Debug: (0.59032) - (16515648)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '52'
Error (0):
Debug: (0.59338) - (16642688)

(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'Aura-I menu'
Error (0):
Debug: (0.594067) - (16644560)

(mysql): SELECT module_name,template_name,modified_date
                            FROM cms_module_templates
Error (0):
Debug display of 'End of Menu Manager Display':(0.627492) - (16648904)
Debug: (0.627809) - (16592344)
start findNodeByTag
Debug: (0.627869) - (16592440)
end findNodeByTag
Debug: (0.650089) - (16552104)

(mysql): SELECT * FROM cms_content WHERE content_id = '15'
Error (0):
Debug display of 'Start of Menu Manager Display':(0.651886) - (16638784)
Debug: (0.65413) - (16694480)

(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'Aura-I menu'
Error (0):
Debug display of 'End of Menu Manager Display':(0.688884) - (16653768)
Debug: (0.689498) - (16596184)
start global_content_get_template
Debug: (0.694026) - (16745952)

(mysql): SELECT html_de, html_en,  htmlblob_id, htmlblob_name, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'
Error (0):
Debug: (0.694235) - (16748568)
end global_content_get_template
Debug: (0.694291) - (16748568)
start global_content_get_timestamp
Debug: (0.694948) - (16749176)

(mysql): SELECT html_de, html_en,  htmlblob_id, htmlblob_name, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'
Error (0):
Debug: (0.695117) - (16750104)
end global_content_get_timestamp
Debug: (0.718208) - (16865176)

(mysql): update cms_module_stat_logstrings_seq set id=LAST_INSERT_ID(id+1);
Error (0):
Debug: (0.718861) - (16866368)

(mysql): INSERT INTO cms_module_stat_logstrings (id,time,info) VALUES (1220,1236699593,'[98.24.129.55] Ignoring visitor because of ignore Admin-IP-list (98.24.129.55)')
Error (0):
Debug: (0.719397) - (16866800)

(mysql): update cms_module_stat_logstrings_seq set id=LAST_INSERT_ID(id+1);
Error (0):
Debug: (0.719947) - (16867000)

(mysql): INSERT INTO cms_module_stat_logstrings (id,time,info) VALUES (1221,1236699593,'')
Error (0):

This is the result shown on the page, but I get now this error messages:
Notice: Undefined index: installed in /...../expat-und-mehr.de/index.php on line 332 (line 332 is: if ($gCms->modules[$key]['installed'] == true &&)

and

Notice: Undefined index: ucwords in /...../expat-und-mehr.de/plugins/function.current_date.php on line 27

TeXnik wrote: Generated in 0.720647 seconds by CMS Made Simple using 48 SQL queries and 16458584 bytes of memory (peak memory

I don't see any INSERT/UPDATE to cms_htmlblobs ..

Alby

I made an entire new installation (several times ) until I got it working.

Finally working was to empty the database and import the tables from the one which was working, emptying the content and import the content from a backup.