Help! Too many items in profile field- SQL issue

CALTRADE posted 18th of May 2008 in Community Voice. 1 comment.

This is an issue that stopped my development in 6.0, and now looks like it is a problem in 6.1 as well.

I have an international business site and I need a field in the profiles where members can select multiple countries where they want to do business.   I tried linking this to the predefined values table "country" in the profile fields builder but when I do, I get this database error:

Mysql error:
Too many strings for column Countries and SET

I then tried to sneak this in by making a new predefined table called "countries" and adding the countries one by one- but after a certain number - I think around 80, I get the exact same thing. 

Does anyone know any way around this?  i.e. is there some SQL setting I could change?  I really, really need this so any help would be appreciated.



Please login to post a comment.
Contact Microsoft. It is a SQL limitation and Boonex can't change it for you.
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.