Hi everyone,
Please help to advise on how to increase Question text lenght of Appraisal 360 Feedback which cap at 255 characters.
If increase to 500 around, is there any precaution to be aware.
Many Thanks,
Anuchit
Totara Learn Open Discussions
Appraisal - Manage Feedback - Content - Question text length > 255
Appraisal - Manage Feedback - Content - Question text length > 255
Re: Appraisal - Manage Feedback - Content - Question text length > 255
Hi Anuchit
It is possible to add a long text box that increases the amount of characters possible to input.
There is a problem below that can occur if using MySQL there are the following restrictions on field sizes.
The Barracuda format is required for using some of the Advanced Features in Totara.
We recommend all sites running their MySQL database using Antelope convert to Barracuda.
The Antelope format has a limitation of 10 text columns per table, and only supports compact and redundant row formats for backward compatibility reasons.
If you are using any of the following features then you may experience Database errors should the information require a table structure with more than 10 text columns:
- Course/Activity backup and restore. Creates tables to facilitate the restoration based upon the content of the backup.
- Appraisals. Creates tables for appraisals, the number and type of questions may lead to more than 10 text columns being required.
- Feedback 360. Same requirements as appraisals.
If you are running Antelope and hit the restrictions imposed by it you will receive a DML Exception from Totara.
regards
Re: Appraisal - Manage Feedback - Content - Question text length > 255
Hi Craig,
Many Thanks for your explanation and help.
I decide to find other method to fulfill this long text requirement to avoid any future issue.
best regards,
Anuchit