I am inputting all the cities for each state, so it's been going fine until I start putting in cities for California, in alphabetical order I get to about mid-way of "m" and when I save, all the fields I put in vanish. I don't think it's a php memory limit because mine is set to max. It's really frustrating because I'm copying and pasting each city and town and then after an hour only to have it all wiped out. I save after every 50 entries in case of the login booting me so it's not that.

Any idea what is causing this? Is there a limit on the amount of extra fields for drop downs that one can put in?

:S

I don't know what is the problem with you, but I think that my approach can void this problem.

In this tutorial: www.joomreem.com/how-ro-joomla/item/46-how-to-create-country-list-dropdown-field-in-k2.html

I have used a CSV file and converted it inot JSON format, then it will be very easy to save this JSON data into the extra fields table, this way you will save time and effort, and maybe you will not find this problem happen agian.

Thanks for that

I had a look, and I will try it by replacing the countries with the cities instead. The country list is very short compared to the cities... California for example has about 1300 cities I need to enter. I think Extra Fields drop down crashes when I get to approximately about 700 entries.

Alternatively I might have to make 3 drop down boxes, such as:

California A - G
California H - N
California O - Z

Which would be about 433 entries each. Still, it would be interesting to know if there's a limit on the entries one can put into a drop down box, probably something like 755?

Thanks
Arthur

Hi Arthur

According to MySQL documentations, TEXT types can 64K of data, while LONGTEXT can hold 4GB of data, therefore this can cause a problem while entering such large number of cities.

I suggest to change the `value` type of the k2_extra_fields table from TEXT to LONGTEXT.

Thanks Muhamed, I think that is probably a good solution, I will try this tomorrow and let you know how it goes! B)

Hi Mohamed - it worked perfectly!
Thank you so much - you saved me a lot of pain :silly:

Great :)

have you changed the 'value' data type or used the other method described in the tutorial?

Hi
I forgot to reply - yes, it was by changing the DB table entry to LONGTEXT - just helped someone else with your advice and pointed them to this thread.
Thanks again!
B)