multiple categories to user problem

[burtav]

Hello

my Hesk2.3 is working fine but a problem apears when I try to add a new user (no admin) since we have 200 categories into HESK I tried to add each of the 200 categories to the non admin user , and seems to be added

but if you see again the user profile , it seems only to recognize 88 of the categories only and the other are disabled.


I cant place that user as admin since he can erase tickets or rename I need to torce the properties of that user.


appreciate your help in advance.


regards


Humberto

[steve]

The Categories field in the Users table is set to varchar(255). Meaning this field can contain no more than 255 characters.

You will need to change the varchar length to 1500 for this field in your database, that should be enough characters to cover your 200 categories and leave you room for a few more categories in the future.

[Klemen]

Actually, the varchar type may be limited to max 255 chars. You will need to change MySQL database field type to "TEXT".

[steve]

I agree that changing the field type to "TEXT" makes more sense.

However, the effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size 65,535 bytes, (which is shared among all columns)

If you use utf8 you could have up to 21,844 in that row.

[Klemen]

Correct, if you have MySQL 5.0.3 or later you can set VARCHAR to a higher value. For backwards-compatibility use TEXT instead.