PhotoPost Community - View Single Post - categories table: ugno* fields too short!

tektsu · August 13th, 2006, 05:52 PM

I have PhotoPost integrated with VBulletin3. In VB3, I have a large number of usergroups, and in Photopost, I have some categories which should not be seen by people in a majority of user groups.

It hasn't happened yet, but the problem I see coming up is that the ugno* fields in the categories table are varchar(255), and soon that will not be large enough to hold the complete lists of usergroup ids that need to be there.

On my test system, I have changed these 5 fields to text fields, and everything seems to work ok. Is this a good fix, or is that likely to cause problems somewhere down the line?

Thanks

August 13th, 2006, 05:52 PM	#1 (permalink)
tektsu Junior Member Verified Customer Join Date: Jul 2005 Posts: 9	*categories table: ugno fields too short!** I have PhotoPost integrated with VBulletin3. In VB3, I have a large number of usergroups, and in Photopost, I have some categories which should not be seen by people in a majority of user groups. It hasn't happened yet, but the problem I see coming up is that the ugno* fields in the categories table are varchar(255), and soon that will not be large enough to hold the complete lists of usergroup ids that need to be there. On my test system, I have changed these 5 fields to text fields, and everything seems to work ok. Is this a good fix, or is that likely to cause problems somewhere down the line? Thanks