Mixed listing field = Mysql error

[Viktor]

Hello Mustafa,

You have exceeded limit of length. Read here about error: https://dev.mysql.com/doc/mysql-resl...unt-limit.html
I suggest you open phpMyadmin -> table: fl_listings
and change some fields with type varchar(255) to 'text'
how many fields do you want to add more?

[Mustafa ilker Yonel]

thanks for the help i will try it!

how many i would like to add ? no idea right now we will see, we have a big plan

why is there a limitation ?

[Chris Brown]

Hello Mustafa,

You have exceeded limit of length. Read here about error: https://dev.mysql.com/doc/mysql-resl...unt-limit.html
I suggest you open phpMyadmin -> table: fl_listings
and change some fields with type varchar(255) to 'text'
how many fields do you want to add more?

Hi Viktor

So after adding a new listing type last night and more fields I hit a brick wall with a Mysql error when trying to add new fields. What exactly do I need to change in database (maybe a screenshot would help)

Most of my fields are dropdown and mixed mainly so I can add those fields in the filter

The mixed fields are number values which range from between 1 - 4 numbers in length.

Will changing Varcher(255) to text affect the ability to use those fields in the filter