Unable to Change Site Logo in Confluence
Symptoms
When trying to upload a logo, an error message appears on the page that states 'There were errors uploading this logo. There is more information in the logs.'
Example:
The following appears in the atlassian-confluence.log
:
2014-10-03 23:34:12,198 ERROR [http-bio-443-exec-15] [confluence.plugins.lookandfeel.EditSiteLogoAction] doUpload
There were errors uploading this logo. There is more information in the logs. -- url: /admin/sitelogo/upload.action
| userName: amit.rajwani | referer: https://confluence.transerainc.com/admin/sitelogo/view-sitelogo.action |
action: upload java.lang.IllegalArgumentException: Content must not be null
Diagnosis
This query will return an empty set (nothing) if there is nothing defined for the global description:
select * from CONTENT where contenttype = 'GLOBALDESCRIPTION';
Cause
The database has no content for the global description so Confluence is referencing a NULL value.
Resolution
Run the following on your Confluence database to insert a placeholder for the global description:
INSERT INTO CONTENT (CONTENTID,CONTENTTYPE,TITLE,VERSION,CREATOR,CREATIONDATE,LASTMODIFIER,LASTMODDATE,VERSIONCOMMENT,PREVVER,CONTENT_STATUS,
SPACEID,CHILD_POSITION,PARENTID,MESSAGEID,PLUGINKEY,PLUGINVER,PARENTCCID,PAGEID,DRAFTPAGEID,DRAFTSPACEKEY,DRAFTTYPE,DRAFTPAGEVERSION,
PARENTCOMMENTID,USERNAME) VALUES (999999,'GLOBALDESCRIPTION',NULL,1,NULL,'2009-01-01 00:00:00',NULL,'2009-01-01 00:00:00',NULL,NULL,
'current',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
Please Note: The above script was written in MySQL format. Please adjust the script to match your database type
- The contentid in the example is set to 999999. This can be adjusted as long as it is a unique content id in your database. Please set it to any number high enough to be unique.