Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

OrgGroupName in group_ table is appended with repetitive information which causes Data truncation

Description

Steps to take:
1. Create a new regular organization and an organization site.
2. Navigate to Manage Site from action button.
3. Uncheck "Enable propagation of changes from the site template" in Details tab.
4. Navigate to Staging tab, then click Save.
Observer the group_ table in database, we will notice that every time we click Save, the name will be appended with classPK + _ORGANIZATION_NAME_DELIMETER related information until we get Data truncation. Please refer to the attached picture.

The log is:
02:46:35,554 ERROR [JDBCExceptionReporter:75] Data truncation: Data too long for column 'name' at row 1

Environment

Tomcate 6.0 + MySQL 5.6 + GIT ID:afc7e5200242e4db563be2e32eb2755c3172bc91

Attachments

1

Activity

Show:

Luyang Tan June 12, 2012 at 6:59 PM

PASSED Manual Testing following the steps in Vincent's comment.

Fixed on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x CE GIT ID: 96dcbd7533474a152418ef049185d92ebcc4b9f6.

The name is normal, it doesn't increase.

Michael Saechang May 30, 2012 at 3:53 PM

Thank you Luyang for testing. Closing as 'Fixed'.

Luyang Tan May 29, 2012 at 7:50 PM

PASSED Manual Testing following the steps in Vincent's comment.

Reproduced on:
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: bd0ac55267f6511e477cdd37d797a10417a48f3e.

I can see the so long name as the attached picture shown.

Fixed on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 3a0ff22feb0ded7a56bd193b4f584f3e404455e5.
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 998ca41343827d2cc22bf11175e754f241dc7230.

The name is normal, it doesn't increase.

Michael Saechang May 29, 2012 at 2:11 PM

Committed on:
Portal 6.2.x GIT ID: 0ab6c8b3071e46becd7b54e09db18a694a21707a.

Vincent Liu May 27, 2012 at 11:35 PM

The issue happens every time when we update an organization site. So the steps can be simplified by these:
1. Create an organization site.
2. Navigate to Site Settings and then click Save.

Fixed

Details

Assignee

Reporter

Labels

Branch Version/s

6.1.x

Backported to Branch

Committed

Git Pull Request

Components

Fix versions

Affects versions

Priority

Zendesk Support

Created March 26, 2012 at 8:00 PM
Updated June 24, 2023 at 4:00 PM
Resolved October 3, 2012 at 3:44 PM
Loading...