View Full Version : Unlimited categories
December 19th, 2007, 02:53 AM
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..
December 19th, 2007, 06:14 AM
It should work fine only limitations within the software are your server limitations.
December 26th, 2007, 08:10 AM
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.
December 26th, 2007, 09:43 AM
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.
January 11th, 2008, 03:21 PM
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 ?
January 11th, 2008, 03:44 PM
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';
January 12th, 2008, 07:34 AM
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)
- 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 ?
January 12th, 2008, 12:41 PM
text field has no limit.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.