after creating the 15. mixed listing field i get an Mysql error
anyone any solution ? experiance same problem ?
Printable View
after creating the 15. mixed listing field i get an Mysql error
anyone any solution ? experiance same problem ?
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?
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 :D
why is there a limitation ?
Hello Mustafa,
You can change type of new fields. Go to ftp://includes>>classes>>admin>>rlFields.class.php
find method: createField
find VARCHAR({$info['Values']}) or VARCHAR({$new_length}) or VARCHAR( 100 ) and change to TEXT
and then you can add as many fields as you need.
Quote:
Originally Posted by Viktor
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
I have the same problem. How did you solve the problem?
Here's how I got on the resourcesQuote:
Originally Posted by Srdjan Petrovic
Attachment 4928
Attachment 4929
Attachment 4930
Attachment 4931
Attachment 4932
Your old code in file ftp://includes>>classes>>admin>>rlFields.class.php method createField:Quote:
Originally Posted by Srdjan Petrovic
new code:PHP Code:Only registered members can view the code.
PHP Code:Only registered members can view the code.
This doesn't help. It's not a solution