global content blocks not showing

[grudz]

hi,

I am using CMS MLE 1.6.3 with apache 2.0 and PHP 5.

I have added some GBC but they do not appear in my admin panel, i know they are there because I can see them in my phpmyadmin database as well as if i try to add another with the the same name, it says that it already exists. Does anybody know why it doesnt show in my admin?

Thank you very much

[grudz]

is anybody having the same issue, even if i try to call it out into my website, it gives me a "string(66) "Smarty error: unable to read resource:" error

thanx

[grudz]

has anybody figured out this issue, ive been going crazy trying to find a solution

[Peciura]

Only solution i can think of is to reupload "/admin" folder to your server. Export all GCB table and than import it.

Once i remember i didin't noticed line "First Previous  Page 1 of 2 Next Last" on top right corner of the page. 

[grudz]

thanx for the tip, but it still hasn't solved my problem.

can you give me how your htmlblobs table looks like? is it something like this

Code: Select all

	           

                htmlblob_id	 htmlblob_name	 html	 owner	 create_date	     modified_date	 html_en	 html_fr
Edit	 Delete	7	         test	                NULL	 1	     2009-09-18 14:35:3  2009-09-18 14:35:36    test	 test

[Peciura]

In your case it should look like

Code: Select all

CREATE TABLE IF NOT EXISTS `cms_htmlblobs` (
  `htmlblob_id` int(11) NOT NULL DEFAULT '0',
  `htmlblob_name` varchar(255) DEFAULT NULL,
  `html` text,
  `html_en` text,
  `html_fr` text,
  `owner` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`htmlblob_id`),
  KEY `htmlblob_name` (`htmlblob_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

edit: added " `html_en` text,  `html_fr` text,"

[grudz]

thank you for your reply, however, I still do not see it in my admin panel.

[alby]

thank you for your reply, however, I still do not see it in my admin panel.

Have you tried to enable debug in config.php and look your server logs?

Alby

[grudz]

hey alby,

im not much of a coder, but these are the errors i received after i enabled the debug

Code: Select all

Notice: Undefined index: path in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php on line 233

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php on line 236

Notice: Undefined index: en_US in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php on line 245

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 174

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 177

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 178

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 181

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php:233) in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/lib/classes/class.admintheme.inc.php on line 186


Debug: (0.00010500000000002) - (1272720)

loading smarty

Debug: (0.005001) - (1709296)

loading adodb

Debug: (0.009872) - (1847976)

loading page functions

Debug: (0.015633) - (2134320)

loading content functions

Debug: (0.018825) - (2450120)

loading pageinfo functions

Debug: (0.0205) - (2543032)

loading translation functions

Debug: (0.021819) - (2570008)

loading events functions

Debug: (0.023615) - (2700968)

loading php4 entity decode functions

Debug: (0.026178) - (3030112)

done loading files

Debug: (0.050947) - (4164136)

<br>
(mysql): SET NAMES 'utf8'<br>
 Error (0): <br>

Debug: (0.052295) - (4192576)

<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>

Debug: (0.065186) - (4344592)

<br>
(mysql): SELECT * FROM cms_userplugins<br>
 Error (0): <br>

Debug: (0.150556) - (5420816)

<br>
(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name<br>
 Error (0): <br>

Debug display of 'End of include':(0.225584) - (11228272)
Debug: (0.225742) - (11118728)

Session found.  Moving on...

Debug: (0.232582) - (11777704)

Session found.  Moving on...

Debug: (0.233421) - (11784504)

<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.233629) - (11787488)

Session found.  Moving on...

Debug: (0.236725) - (11952296)

Session found.  Moving on...

Debug: (0.241741) - (12073200)

<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
                     WHERE ug.user_id = '1' AND ug.group_id = 1<br>
 Error (0): <br>

Debug: (0.245703) - (12078304)

<br>
(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<br>
 Error (0): <br>

Debug: (0.251888) - (12246368)

Session found.  Moving on...

Debug: (0.255261) - (12269152)

Session found.  Moving on...

Debug: (0.259462) - (12295584)

Session found.  Moving on...

Debug: (0.262188) - (12314952)

Session found.  Moving on...

Debug: (0.264975) - (12353752)

Session found.  Moving on...

Debug: (0.268052) - (12367744)

Session found.  Moving on...

Debug: (0.272302) - (12394472)

Session found.  Moving on...

Debug: (0.275521) - (12414808)

Session found.  Moving on...

Debug: (0.283017) - (12500376)

Session found.  Moving on...

Debug: (0.285308) - (12510024)

Session found.  Moving on...

Debug: (0.28818) - (12517552)

Session found.  Moving on...

Debug: (0.293455) - (12647792)

Session found.  Moving on...

Debug: (0.296205) - (12656104)

Session found.  Moving on...

Debug: (0.304344) - (12818112)

<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.305159) - (12819936)

<br>
(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.305989) - (12820432)

<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)<br>
 Error (0): <br>

Debug: (0.306618) - (12820648)

<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
 Error (0): <br>

Debug: (0.307076) - (12820984)

<br>
(mysql): SELECT user_id,content_id FROM cms_additional_users<br>
 Error (0): <br>

Debug: (0.311982) - (12969264)

Session found.  Moving on...

Debug: (0.313898) - (12970496)

<br>
(mysql): SELECT count(news_id) FROM cms_module_news n
                   WHERE status != 'published'
                     AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2009-09-24 20:32:32')) <br>
 Error (0): <br>

Debug: (0.315563) - (12970784)

<br>
(mysql): SELECT version from cms_version<br>
 Error (0): <br>

Debug: (0.321205) - (13015400)

<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>

Debug: (0.321446) - (12954616)

Session found.  Moving on...

Debug: (0.322176) - (12955368)

<br>
(mysql): SELECT html_en, html_, htmlblob_id, htmlblob_name, owner, modified_date FROM cms_htmlblobs ORDER BY htmlblob_name<br>
 Error (1054): Unknown column 'html_' in 'field list'<br>

so from my limited coding knowledge, all i have to do is go in my DB and change the "html" column in cms_htmlblobs to "html_"?

is that going to cause any other problems?

and what about the "headers already sent?" what does that mean?

[Peciura]

To fix  "Notice: Undefined index: path in /mnt/w0002/d01/s46/b02e2ac4/www/tillemont.com/include.php on line 233" 
insert "$pu_root_url['path'] = (empty( $pu_root_url['path'])) ?'/':$pu_root_url['path'];"
just above line
"$cookie_path = rtrim($pu_root_url['path'], '/').'/';" in "tillemont.com/include.php". (function "parse_url" doesn't initiate array member if it is empty ).

"Notice: Undefined index: en_US" tells me your mle configuration is not complete (config_lang.php from previous CMSms version ?), Check your 'en_US' settings in config_lang.php, or better visit "Site Admin » Global Settings » MLE settings" and "Site Admin » Global Settings » MLE languages".

[grudz]

I dont understand what i have to look for to solve the language error, when i enabled the debugging, this is what I got on the global settings page:

I did a complete new install for this version, so I did not take any old config_lang files

Code: Select all

Debug: (3.599999999998E-5) - (1462672)

loading smarty

Debug: (0.00717) - (1899264)

loading adodb

Debug: (0.011507) - (2037896)

loading page functions

Debug: (0.01577) - (2324472)

loading content functions

Debug: (0.019485) - (2640184)

loading pageinfo functions

Debug: (0.021969) - (2733128)

loading translation functions

Debug: (0.023911) - (2760112)

loading events functions

Debug: (0.025966) - (2891048)

loading php4 entity decode functions

Debug: (0.029214) - (3220184)

done loading files

Debug: (0.054388) - (4354320)

<br>
(mysql): SET NAMES 'utf8'<br>
 Error (0): <br>

Debug: (0.055896) - (4382800)

<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>

Debug: (0.065193) - (4534632)

<br>
(mysql): SELECT * FROM cms_userplugins<br>
 Error (0): <br>

Debug: (0.131801) - (5611224)

<br>
(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name<br>
 Error (0): <br>

Debug display of 'End of include':(0.205918) - (11418864)
Debug: (0.206065) - (11308360)

Session found.  Moving on...

Debug: (0.206108) - (11308472)

Session found.  Moving on...

Debug: (0.210367) - (11411712)

<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
                     WHERE ug.user_id = '1' AND ug.group_id = 1<br>
 Error (0): <br>

Debug: (0.214015) - (11416720)

<br>
(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<br>
 Error (0): <br>

Debug: (0.217539) - (11440536)

<br>
(mysql): SELECT * FROM cms_templates ORDER BY template_name<br>
 Error (0): <br>

Debug: (0.224933) - (12109792)

Session found.  Moving on...

Debug: (0.225789) - (12116568)

<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.226039) - (12118784)

Session found.  Moving on...

Debug: (0.228913) - (12283336)

Session found.  Moving on...

Debug: (0.233811) - (12456192)

Session found.  Moving on...

Debug: (0.236419) - (12478672)

Session found.  Moving on...

Debug: (0.239967) - (12504928)

Session found.  Moving on...

Debug: (0.242647) - (12524056)

Session found.  Moving on...

Debug: (0.245108) - (12559560)

Session found.  Moving on...

Debug: (0.247328) - (12573696)

Session found.  Moving on...

Debug: (0.250811) - (12600704)

Session found.  Moving on...

Debug: (0.253416) - (12620920)

Session found.  Moving on...

Debug: (0.260473) - (12703776)

Session found.  Moving on...

Debug: (0.263261) - (12711944)

Session found.  Moving on...

Debug: (0.265734) - (12719472)

Session found.  Moving on...

Debug: (0.270812) - (12847352)

Session found.  Moving on...

Debug: (0.272882) - (12854872)

Session found.  Moving on...

Debug: (0.280201) - (13016744)

<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.281211) - (13018440)

<br>
(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'<br>
 Error (0): <br>

Debug: (0.282406) - (13019048)

<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)<br>
 Error (0): <br>

Debug: (0.283488) - (13019264)

<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
 Error (0): <br>

Debug: (0.284309) - (13019600)

<br>
(mysql): SELECT user_id,content_id FROM cms_additional_users<br>
 Error (0): <br>

Debug: (0.289128) - (13168224)

Session found.  Moving on...

Debug: (0.292594) - (13169440)

<br>
(mysql): SELECT count(news_id) FROM cms_module_news n
                   WHERE status != 'published'
                     AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2009-09-26 18:48:35')) <br>
 Error (0): <br>

Debug: (0.293938) - (13169728)

<br>
(mysql): SELECT version from cms_version<br>
 Error (0): <br>

Debug: (0.297876) - (13210784)

<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>

Debug: (0.309098) - (13402136)

<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template FROM cms_templates WHERE default_template = 1<br>
 Error (0): <br>

Debug: (0.310619) - (13416416)

<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template FROM cms_templates WHERE default_template = 1<br>
 Error (0): <br>

Debug: (0.342848) - (14704464)

<br>
(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<br>
 Error (0): <br>

[Peciura]

Download file "tillemont.com/include.php" with ftp client to your local PC. Open it and scroll to line 233 insert new code line

Code: Select all

$pu_root_url['path'] = (empty( $pu_root_url['path'])) ?'/':$pu_root_url['path'];

between lines

Code: Select all

$pu_root_url = parse_url($config['root_url']);

and

Code: Select all

$cookie_path = rtrim($pu_root_url['path'], '/').'/';

[grudz]

Hey,

I was able to make that change before, however, the one I did not understand was

"Notice: Undefined index: en_US" tells me your mle configuration is not complete (config_lang.php from previous CMSms version ?), Check your 'en_US' settings in config_lang.php, or better visit "Site Admin » Global Settings » MLE settings" and "Site Admin » Global Settings » MLE languages".

[Peciura]

Check picture below. Also post content of config_lang.php to forum.

[grudz]

here is the content of my config_lang.php

thank you

array(
'locale_cms' => 'LOCALE LANGUAGE IN CMSMS', //MANDATORY One valid CMSMS locale or near to
'block' => 'DATABASE KEY', //MANDATORY AND UNIQUE In general 2 chars same of 'parent'
'parent' => 'PARENT LANGUAGE', //OPTIONAL 2 chars parent language, if you have others set to 5 WITH DASH, ex: en-au
'flag' => 'HTML IMG TAG FOR LOCALE FLAG', //MANDATORY ABSOLUTE URL PATH
'text' => 'NATIVE LANGUAGE', //OPTIONAL Use for lang plugin if you don't use flags icon
'locale' => 'SERVER LOCALE', //OPTIONAL Set for specific locale server if different from 'locale_cms'
),
*******/

$hls = array(
'eng' => array(
'locale_cms'=>'en_US',
'block'=>'en',
'parent'=>'en',
'flag'=>'',
'text'=>'English',
'locale'=>'en_US.UTF-8'
),
'fra' => array(
'locale_cms'=>'fr_FR',
'block'=>'fr',
'parent'=>'fr',
'flag'=>'',
'text'=>'Français (French)',
'locale'=>'fr_FR.UTF-8'
),
);
?>