Unlimited categories

[crewstart]

I work with a lot of categories: I have 1200 categories right now and will add a lot in the future. Can I be sure there will be no problems? Right now it works like a charm..

Thanks,

Paul

[Chuck S]

It should work fine only limitations within the software are your server limitations.

[crewstart]

I am asking because when I go to our admin, the left navigation shows up immediately, and everything is working fine as well, but the statistics part does stay white for seconds (sometimes over 6 seconds)

This used to be ok.

We have 70 users 1400 categories 10.000 photos.

Thanks,

Paul

[Chuck S]

well the largest part of the stats page for loading I would imagine if there is any slowdowns is the stat of your data directory where it scans to see your actual diskspace. If that continues to be an issue I can tell you how to remove the stat to grab the actual true data storage stats.

[crewstart]

Chuck: we have a serious problem! We now have 99 usergroups. When we add a usergroup, we set authorisation in such a way that the usergroup can only post in a certain category. This results in the number of the usergroup added to several fields in the pp_categories table, e.g. ugnoupload. However, this field is varchar(255) and full .....

Can you please help us how to deal with this ?

thanks!

[Chuck S]

Okay this thread is about unlimited categories not usergroups and thats your issue. Yes those fields can only be 255 characters. You can try altering the table field to a text field but thats slower somewhat. Issue these queries in your mysql database

ALTER TABLE pp_categories CHANGE ugnoview ugnoview TEXT default 'NULL';
ALTER TABLE pp_categories CHANGE ugnoupload ugnoupload TEXT default 'NULL';
ALTER TABLE pp_categories CHANGE ugnopost ugnopost TEXT default 'NULL';
ALTER TABLE pp_categories CHANGE ugnovote ugnovote TEXT default 'NULL';
ALTER TABLE pp_categories CHANGE ugnoanno ugnoanno TEXT default 'NULL';

[crewstart]

Chuck: we are now testing with:
ALTER TABLE pp_categories CHANGE ugnoview ugnoview TEXT;
ALTER TABLE pp_categories CHANGE ugnoupload ugnoupload TEXT;
ALTER TABLE pp_categories CHANGE ugnopost ugnopost TEXT;
ALTER TABLE pp_categories CHANGE ugnovote ugnovote TEXT;
ALTER TABLE pp_categories CHANGE ugnoanno ugnoanno TEXT;

(default is not valid syntax)

Questions:
- what is the maximum lenght for this TEXT field ?
- if we continue to add usergroups, will this cause new problems in the future and/or slow down the system ?

thanks!

[Chuck S]

text field has no limit.