HTMLBlob problem in 1.1
Posted: Tue Sep 11, 2007 6:21 am
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:
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
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>
Appreciate any help or advice!
Leon