Skip to end of metadata
Go to start of metadata

I want to use Community Bubbles with Japanese language. (Confluence v3.0.2)
But I found serious problem of multi byte encoding with Community Bubbles v1.5.2.

When I change Japanese news title, this news will be changed page automatically.
After that, access this strange page will cause serious System Error. (Only recover by full index rebuild)
I can't find this problem with English news title and disable Community Bubbles plugin.

Here is this problem's database log (OS_PROPERTYENTRY has bad com.adaptavist.bubbles.forum.FORUM_TOPIC_PAGE info)

INSERT INTO CONTENT VALUES(720900,'BLOGPOST','test45\u30a6\u30a3',4,'admin','2009-10-16 02:29:48.663000000','admin','2009-10-16 02:35:21.012000000','',NULL,'current',557057,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM CONTENT WHERE CONTENTID=720900
INSERT INTO CONTENT VALUES(720900,'BLOGPOST','test45',4,'admin','2009-10-16 02:29:48.663000000','admin','2009-10-16 02:35:21.012000000','',NULL,'current',557057,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO CONTENT VALUES(720904,'BLOGPOST','test45',4,'admin','2009-10-16 02:29:48.663000000','admin','2009-10-16 02:35:21.012000000','',720900,'current',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO BODYCONTENT VALUES(753671,'test4',720904)
INSERT INTO INDEXQUEUEENTRIES VALUES(786453,'2009-10-16 02:38:38.553000000',27,'com.atlassian.confluence.pages.BlogPost-720904')
INSERT INTO INDEXQUEUEENTRIES VALUES(786454,'2009-10-16 02:38:38.553000000',27,'com.atlassian.confluence.pages.BlogPost-720900')
INSERT INTO INDEXQUEUEENTRIES VALUES(786455,'2009-10-16 02:38:38.553000000',3,'com.atlassian.confluence.pages.BlogPost-720900')
INSERT INTO INDEXQUEUEENTRIES VALUES(786456,'2009-10-16 02:38:38.553000000',29,'com.atlassian.confluence.pages.BlogPost-720900')
DELETE FROM CONTENT WHERE CONTENTID=720900
INSERT INTO CONTENT VALUES(720900,'BLOGPOST','test45\u30a6\u30a3',5,'admin','2009-10-16 02:29:48.663000000','admin','2009-10-16 02:38:38.552000000','',NULL,'current',557057,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
COMMIT
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
INSERT INTO OS_PROPERTYENTRY VALUES('confluence_ContentEntityObject',720900,'com.adaptavist.bubbles.forum.FORUM_TOPIC_PAGE',5,FALSE,0.0E0,'false','',0,0,NULL)
COMMIT

Sincerely, Kenta

  • No labels