HTMLBlob problem in 1.1

[leonkelly]

Hi there,

I'm currently running CMSMS 1.1 on Apache, PHP4, MySQL4. With sites on two different servers I'm getting the same problem.

When adding a new HTMLBlob on save I just get a blank screen, but the content is added to the database. On edit, I cannot save any changes - again, I get a blank screen after clicking 'Save'.

In debug mode I get these errors when editing an existing blob:

Code: Select all

(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>
(mysql): SELECT * FROM cms_userplugins<br>
 Error (0): <br>
(mysql): SELECT * FROM cms_modules ORDER BY module_name<br>
 Error (0): <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 WHERE ug.user_id = '1'<br>
 Error (0): <br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
 Error (0): <br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_id = '10'<br>
 Error (0): <br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
 Error (0): <br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
 Error (0): <br>
(mysql): SELECT content_id FROM cms_additional_users WHERE user_id = '1'<br>
 Error (0): <br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>
(mysql): SELECT user_id, username FROM cms_users ORDER BY username<br>
 Error (0): <br>
(mysql): SELECT user_id, username FROM cms_users WHERE user_id <> '1' ORDER BY username<br>
 Error (0): <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>
(mysql): SELECT sitepref_value from cms_siteprefs WHERE sitepref_name = 'TinyMCE_mapi_pref_live_templateid'<br>
 Error (0): <br>
(mysql): INSERT INTO cms_siteprefs (sitepref_name, sitepref_value) VALUES ('TinyMCE_mapi_pref_live_templateid', '17')<br>
 Error (0): <br>
(mysql): SELECT sitepref_value from cms_siteprefs WHERE sitepref_name = 'TinyMCE_mapi_pref_live_textareas'<br>
 Error (0): <br>
(mysql): INSERT INTO cms_siteprefs (sitepref_name, sitepref_value) VALUES ('TinyMCE_mapi_pref_live_textareas', 'content')<br>
 Error (0): <br>

The installations seemed fine and everything else is working perfectly. I have the Archive Manager module installed, but that's the only other modification.

Appreciate any help or advice!

Leon

[Loopy]

Don't know if you found a solution to this but I had the same problem and all I did was uninstall Archiver and things work fine.