+ Reply to Thread
Results 1 to 9 of 9

Thread: Mixed listing field = Mysql error

  1. #1

    Mixed listing field = Mysql error

    after creating the 15. mixed listing field i get an Mysql error

    anyone any solution ? experiance same problem ?

  2. #2
    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?
    Viktor,
    Flynax technical department,
    Best wishes.

  3. #3
    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 ?
    Last edited by Mustafa ilker Yonel; September 24, 2017 at 06:14 PM.

  4. #4
    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.
    Viktor,
    Flynax technical department,
    Best wishes.

  5. #5
    Quote Originally Posted by Viktor View Post
    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
    Last edited by Chris Brown; December 28, 2021 at 09:01 AM.
    New Site: CameraSpecs https://bit.ly/3G4uYA6

    Old Site: MotorAdsUk

  6. #6
    I have the same problem. How did you solve the problem?

  7. #7

  8. #8
    Quote Originally Posted by Srdjan Petrovic View Post
    I have the same problem. How did you solve the problem?
    Your old code in file ftp://includes>>classes>>admin>>rlFields.class.php method createField:

    PHP Code:
    Only registered members can view the code
    new code:
    PHP Code:
    Only registered members can view the code
    Viktor,
    Flynax technical department,
    Best wishes.

  9. #9
    This doesn't help. It's not a solution

+ Reply to Thread