after creating the 15. mixed listing field i get an Mysql error
anyone any solution ? experiance same problem ?
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?
Viktor,
Flynax technical department,
Best wishes.
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.
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.
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.
I have the same problem. How did you solve the problem?
Here's how I got on the resources
cp69-cpanelhosting-rs-localhost-petravka_oglasi-phpMyAdmin-5-2-1.png
cp69-cpanelhosting-rs-localhost-petravka_oglasi-fl_listings-phpMyAdmin-5-2-1.png
Flynax-Admin-Panel-
cp69-cpanelhosting-rs-localhost-petravka_oglasi-fl_listings-phpMyAdmin-5-2-1 (1).png
cp69-cpanelhosting-rs-localhost-petravka_oglasi-fl_listings-phpMyAdmin-5-2-1 (2).png
Last edited by Srdjan Petrovic; February 11, 2024 at 01:27 PM.
This doesn't help. It's not a solution