+ Reply to Thread
Results 1 to 7 of 7

Thread: Add a field - MYSQL ERROR!

  1. #1
    Senior Member
    Join Date
    Jan 2021
    Location
    Everywhere on world
    Posts
    111

    Question Add a field - MYSQL ERROR!

    Hallo,

    I will add a field in Listing fields and get always MYSQL ERROR. What ca I do?

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138

  3. #3
    Senior Member
    Join Date
    Jan 2021
    Location
    Everywhere on world
    Posts
    111
    Hello Rudi,

    I opend ftp://includes>>classes>>admin>>rlFields.class.php

    and found

    PHP Code:
    Only registered members can view the code
    then I changed it to this

    PHP Code:
    Only registered members can view the code
    but MYSQL ERROR ist still there. No chance to add a new field.

  4. #4
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    You should also follow the instructions from this post:

    Quote Originally Posted by Viktor View Post
    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?

  5. #5
    Senior Member
    Join Date
    Jan 2021
    Location
    Everywhere on world
    Posts
    111
    I tried also to do this, but there are alot of varchar(255) fields and I do not know which field is the right???

  6. #6
    Senior Member
    Join Date
    Jan 2021
    Location
    Everywhere on world
    Posts
    111
    It is not possible to create field type text, text area, select or radio button, I get always MYSQI ERROR. But I have no problem to create other field types.

    As a makeshift, I created a Yes/No field, then I changed the field type in the database to select, and it works. But that's no solution!

  7. #7
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    You should decide what VARCHAR field should be modified and how many characters are necessary for it and then decrease the length 255
    Last edited by Rudi; November 23, 2022 at 02:22 AM.

+ Reply to Thread