Add a field - MYSQL ERROR!

Hallo,

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

Hello,

See this thread: https://forum.flynax.com/showthread....ighlight=field

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.

You should also follow the instructions from this post:

Quote:

---

Originally Posted by Viktor

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?

---

I tried also to do this, but there are alot of varchar(255) fields and I do not know which field is the right???

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!

You should decide what VARCHAR field should be modified and how many characters are necessary for it and then decrease the length 255